MongoDB\Database set ReadPreference not work

[keita1314]

code as this:

>$db = $db->withOptions(array('readPreference' =>new MongoDB\Driver\ReadPreference(MongoDB\Driver\ReadPreference::RP_SECONDARY)));
        var_dump($db);
        $query = array(
            "hash" => $this->hash(),
            "time" => array(
                '$gte' => $start,
                '$lt' => $end
            )
        );
        $option = array(
            "projection" => array(
                "_id" => 0,
                "hash" => 0
            ),
            "sort" => array(
                "time" => 1
            )
        );
        $project = $this->project->hash();
        return $db->{$project}->find($query, $option);

$db set readpreference as secondary via withOptions , and $db var_dump like below:

>object(MongoDB\Database)#16 (6) {
  ["databaseName":"MongoDB\Database":private]=>
  string(9) "xxx"
  ["manager":"MongoDB\Database":private]=>
  object(MongoDB\Driver\Manager)#5 (2) {
    ["uri"]=>
    string(37) "mongodb://%2Ftmp%2Fmongodb-30000.sock"
    ["cluster"]=>
    array(1) {
      [0]=>
      array(10) {
        ["host"]=>
        string(23) "/tmp/mongodb-30000.sock"
        ["port"]=>
        int(27017)
        ["type"]=>
        int(2)
        ["is_primary"]=>
        bool(false)
        ["is_secondary"]=>
        bool(false)
        ["is_arbiter"]=>
        bool(false)
        ["is_hidden"]=>
        bool(false)
        ["is_passive"]=>
        bool(false)
        ["last_is_master"]=>
        array(9) {
          ["ismaster"]=>
          bool(true)
          ["msg"]=>
          string(8) "isdbgrid"
          ["maxBsonObjectSize"]=>
          int(16777216)
          ["maxMessageSizeBytes"]=>
          int(48000000)
          ["maxWriteBatchSize"]=>
          int(1000)
          ["localTime"]=>
          object(MongoDB\BSON\UTCDateTime)#19 (1) {
            ["milliseconds"]=>
            string(13) "1484032841355"
          }
          ["maxWireVersion"]=>
          int(3)
          ["minWireVersion"]=>
          int(0)
          ["ok"]=>
          float(1)
        }
        ["round_trip_time"]=>
        int(2)
      }
    }
  }
  ["readConcern":"MongoDB\Database":private]=>
  object(MongoDB\Driver\ReadConcern)#8 (0) {
  }
  ["readPreference":"MongoDB\Database":private]=>
  object(MongoDB\Driver\ReadPreference)#15 (1) {
    ["mode"]=>
    string(9) "secondary"
  }
  ["typeMap":"MongoDB\Database":private]=>
  array(3) {
    ["root"]=>
    string(5) "array"
    ["document"]=>
    string(5) "array"
    ["array"]=>
    string(5) "array"
  }
  ["writeConcern":"MongoDB\Database":private]=>
  object(MongoDB\Driver\WriteConcern)#10 (0) {
  }
}

driver version is 1.2.1, but all query still on master, $collection->withOptions, find($filter, $option) is also not work but client's uriOptions array("readPreference" => "secondary") is ok, why?

[jmikola]

@keita1314: Was this issue resolved or did you conclude that it was some application error and not actually a driver bug?

How you were able to determine that the query was only being sent to primary servers? Based on "isdbgrid" in the isMaster response within the Manager dump, you're connecting to mongos node. While MongoDB\Driver\Cursor::getServer() can normally be used to determine the server handling to a query, that will also report the mongos node. I expect the read preference would need to be verified by examining query logs (e.g. database profiler) on the secondary servers within the shard cluster.

[keita1314]

@jmikola The problem is my mistake. I misunderstand the usage of ->withOptions, which return a new cloned Object. Not driver bug. It was my application error.Thank you!