> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now, I
> believe) and our servers are 2.0.3.

> What makes you think that mongos isn't dispatching these queries to the
> secondaries?

> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now, I
>> believe) and our servers are 2.0.3.

> If I fire 30k requests to the mongos. When watching the mongostat of each
> server, I see that its always the master of each shard that is anwsering
> and none of the secondaries.

> Since all the drivers can see is the mongos to whom it is connected, and
> its SlaveOk setting is set to "true". I assume that it's the mongos that
> did not forward the queries to the replica set with the mention "SlaveOk =
> true".

> On Monday, March 19, 2012 5:34:04 PM UTC-4, Kristina Chodorow wrote:

>> What makes you think that mongos isn't dispatching these queries to the
>> secondaries?

>> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now, I
>>> believe) and our servers are 2.0.3.

> Hmm, can you run mongostat --discover for a few minutes while you do some
> queries and then send its output + mongos log from that time?

> On Tuesday, March 20, 2012 9:54:18 AM UTC-4, Simon T. wrote:

>> If I fire 30k requests to the mongos. When watching the mongostat of each
>> server, I see that its always the master of each shard that is anwsering
>> and none of the secondaries.

>> Since all the drivers can see is the mongos to whom it is connected, and
>> its SlaveOk setting is set to "true". I assume that it's the mongos that
>> did not forward the queries to the replica set with the mention "SlaveOk =
>> true".

>> On Monday, March 19, 2012 5:34:04 PM UTC-4, Kristina Chodorow wrote:

>>> What makes you think that mongos isn't dispatching these queries to the
>>> secondaries?

>>> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now,
>>>> I believe) and our servers are 2.0.3.

> Thanks for your help Kristina.

> Attached to this message is a .tar file with the mongostat -discover
> output and the mongos log.  The test started around 16:07:05 so you can
> scroll down to that part.

> Thank you very much again.

> Simon

> On Tuesday, March 20, 2012 11:23:31 AM UTC-4, Kristina Chodorow wrote:

>> Hmm, can you run mongostat --discover for a few minutes while you do some
>> queries and then send its output + mongos log from that time?

>> On Tuesday, March 20, 2012 9:54:18 AM UTC-4, Simon T. wrote:

>>> If I fire 30k requests to the mongos. When watching the mongostat of
>>> each server, I see that its always the master of each shard that is
>>> anwsering and none of the secondaries.

>>> Since all the drivers can see is the mongos to whom it is connected, and
>>> its SlaveOk setting is set to "true". I assume that it's the mongos that
>>> did not forward the queries to the replica set with the mention "SlaveOk =
>>> true".

>>> On Monday, March 19, 2012 5:34:04 PM UTC-4, Kristina Chodorow wrote:

>>>> What makes you think that mongos isn't dispatching these queries to the
>>>> secondaries?

>>>> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now,
>>>>> I believe) and our servers are 2.0.3.

> By the way, I'm aware of the issue with the server 1 and 3 on shardB.

> On Tuesday, March 20, 2012 12:31:24 PM UTC-4, Simon T. wrote:

>> Thanks for your help Kristina.

>> Attached to this message is a .tar file with the mongostat -discover
>> output and the mongos log.  The test started around 16:07:05 so you can
>> scroll down to that part.

>> Thank you very much again.

>> Simon

>> On Tuesday, March 20, 2012 11:23:31 AM UTC-4, Kristina Chodorow wrote:

>>> Hmm, can you run mongostat --discover for a few minutes while you do
>>> some queries and then send its output + mongos log from that time?

>>> On Tuesday, March 20, 2012 9:54:18 AM UTC-4, Simon T. wrote:

>>>> If I fire 30k requests to the mongos. When watching the mongostat of
>>>> each server, I see that its always the master of each shard that is
>>>> anwsering and none of the secondaries.

>>>> Since all the drivers can see is the mongos to whom it is connected,
>>>> and its SlaveOk setting is set to "true". I assume that it's the mongos
>>>> that did not forward the queries to the replica set with the mention
>>>> "SlaveOk = true".

>>>> On Monday, March 19, 2012 5:34:04 PM UTC-4, Kristina Chodorow wrote:

>>>>> What makes you think that mongos isn't dispatching these queries to
>>>>> the secondaries?

>>>>> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>>>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of
>>>>>> now, I believe) and our servers are 2.0.3.

> Thanks for the info, this is weird and I haven't been able to reproduce.
>  As a sanity check, can you try this in the shell:  

> > // connect to mongos
> > db.getMongo().setSlaveOk()
> > db.collectionYouAreQueryingFromC#.find(/* somequery */).explain()

> ...and send the output?  (Replacing collectionYouAreQueryingFromC# and /*
> somequery */ :) )

> On Tuesday, March 20, 2012 12:35:35 PM UTC-4, Simon T. wrote:

>> By the way, I'm aware of the issue with the server 1 and 3 on shardB.

>> On Tuesday, March 20, 2012 12:31:24 PM UTC-4, Simon T. wrote:

>>> Thanks for your help Kristina.

>>> Attached to this message is a .tar file with the mongostat -discover
>>> output and the mongos log.  The test started around 16:07:05 so you can
>>> scroll down to that part.

>>> Thank you very much again.

>>> Simon

>>> On Tuesday, March 20, 2012 11:23:31 AM UTC-4, Kristina Chodorow wrote:

>>>> Hmm, can you run mongostat --discover for a few minutes while you do
>>>> some queries and then send its output + mongos log from that time?

>>>> On Tuesday, March 20, 2012 9:54:18 AM UTC-4, Simon T. wrote:

>>>>> If I fire 30k requests to the mongos. When watching the mongostat of
>>>>> each server, I see that its always the master of each shard that is
>>>>> anwsering and none of the secondaries.

>>>>> Since all the drivers can see is the mongos to whom it is connected,
>>>>> and its SlaveOk setting is set to "true". I assume that it's the mongos
>>>>> that did not forward the queries to the replica set with the mention
>>>>> "SlaveOk = true".

>>>>> On Monday, March 19, 2012 5:34:04 PM UTC-4, Kristina Chodorow wrote:

>>>>>> What makes you think that mongos isn't dispatching these queries to
>>>>>> the secondaries?

>>>>>> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>>>>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of
>>>>>>> now, I believe) and our servers are 2.0.3.

> On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now, I
>> believe) and our servers are 2.0.3.

> --
> You received this message because you are subscribed to the Google Groups
> "mongodb-user" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ.

> To post to this group, send email to mongodb-user@googlegroups.com.
> To unsubscribe from this group, send email to
> mongodb-user+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/mongodb-user?hl=en.

> Can you please post the output from these command connected to a mongos:

> use config
> db.shards.find()
> db.printShardingStatus()

> On Mon, Mar 19, 2012 at 5:34 PM, Kristina Chodorow <krist...@10gen.com>
> wrote:
> > What makes you think that mongos isn't dispatching these queries to the
> > secondaries?

> > On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

> >> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now, I
> >> believe) and our servers are 2.0.3.

> > --
> > You received this message because you are subscribed to the Google Groups
> > "mongodb-user" group.
> > To view this discussion on the web visit
> > https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ.

> > To post to this group, send email to mongodb-user@googlegroups.com.
> > To unsubscribe from this group, send email to
> > mongodb-user+unsubscribe@googlegroups.com.
> > For more options, visit this group at
> > http://groups.google.com/group/mongodb-user?hl=en.

> MongoDB shell version: 2.0.3
> connecting to: localhost/admin
> mongos> use config
> switched to db config
> mongos> db.shards.find()
> { "_id" : "sharda", "host" :
> "sharda/osmnga01:27018,osmnga02:27018,osmnga03:27018" }
> { "_id" : "shardb", "host" :
> "shardb/osmngb01:27018,osmngb02:27018,osmngb03:27018" }
> mongos> db.printShardingStatus()
> --- Sharding Status ---
>   sharding version: { "_id" : 1, "version" : 3 }
>   shards:
>         {  "_id" : "sharda",  "host" :
> "sharda/osmnga01:27018,osmnga02:27018,osmnga03:27018" }
>         {  "_id" : "shardb",  "host" :
> "shardb/osmngb01:27018,osmngb02:27018,osmngb03:27018" }
>   databases:
>         {  "_id" : "admin",  "partitioned" : false,  "primary" : "config" }
>         {  "_id" : "test_db",  "partitioned" : true,  "primary" : "sharda"
> }
>         {  "_id" : "hor",  "partitioned" : true,  "primary" : "sharda" }
>         {  "_id" : "load_test",  "partitioned" : true,  "primary" :
> "sharda" }
>                 load_test.loadtest chunks:
>                                 sharda  717
>                                 shardb  717
>                         too many chunks to print, use verbose if you want
> to force print
>         {  "_id" : "lt2",  "partitioned" : true,  "primary" : "shardb" }
>                 lt2.loadtest chunks:
>                                 sharda  11
>                                 shardb  12
>                         too many chunks to print, use verbose if you want
> to force print
>         {  "_id" : "hor-backup1",  "partitioned" : true,  "primary" :
> "sharda" }
>                 hor-backup1.metrics chunks:
>                                 shardb  1
>                                 sharda  2
>                         { "s_UID" : { $minKey : 1 } } -->> { "s_UID" :
> "5380ef37bf19b550" } on : shardb { "t" : 2000, "i" : 0 }
>                         { "s_UID" : "5380ef37bf19b550" } -->> { "s_UID" :
> "e0e9eba1c3d2fc8d" } on : sharda { "t" : 2000, "i" : 1 }
>                         { "s_UID" : "e0e9eba1c3d2fc8d" } -->> { "s_UID" :
> { $maxKey : 1 } } on : sharda { "t" : 1000, "i" : 3 }
>         {  "_id" : "localhost",  "partitioned" : false,  "primary" :
> "shardb" }
>         {  "_id" : "players",  "partitioned" : false,  "primary" :
> "shardb" }

> On Wednesday, March 21, 2012 11:15:24 AM UTC-4, Scott Hernandez wrote:

>> Can you please post the output from these command connected to a mongos:

>> use config
>> db.shards.find()
>> db.printShardingStatus()

>> On Mon, Mar 19, 2012 at 5:34 PM, Kristina Chodorow <krist...@10gen.com>
>> wrote:
>> > What makes you think that mongos isn't dispatching these queries to the
>> > secondaries?

>> > On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>> >> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of now,
>> I
>> >> believe) and our servers are 2.0.3.

>> > --
>> > You received this message because you are subscribed to the Google
>> Groups
>> > "mongodb-user" group.
>> > To view this discussion on the web visit
>> > https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ.

>> > To post to this group, send email to mongodb-user@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > mongodb-user+unsubscribe@googlegroups.com.
>> > For more options, visit this group at
>> > http://groups.google.com/group/mongodb-user?hl=en.

> Hmm... still weird.  Can you up the logLevel of the mongos to 5
> temporarily - this will give us the exact options being used by the query
> as it is dispatched.

> mongo <mongos>
> > use admin
> > db.runCommand({ setParameter : 1, logLevel : 5 })
> // Up
> > db.runCommand({ setParameter : 1, logLevel : 0 })

> Is/was the replica set setup with any hidden nodes?  rs.status()

> If simple, can you replace the 2.0.3 mongos with a 2.0.2 mongos and see if
> there's a change?

> On Wednesday, March 21, 2012 11:29:12 AM UTC-4, Simon T. wrote:

>> MongoDB shell version: 2.0.3
>> connecting to: localhost/admin
>> mongos> use config
>> switched to db config
>> mongos> db.shards.find()
>> { "_id" : "sharda", "host" :
>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>> { "_id" : "shardb", "host" :
>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>> mongos> db.printShardingStatus()
>> --- Sharding Status ---
>>   sharding version: { "_id" : 1, "version" : 3 }
>>   shards:
>>         {  "_id" : "sharda",  "host" :
>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>         {  "_id" : "shardb",  "host" :
>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>   databases:
>>         {  "_id" : "admin",  "partitioned" : false,  "primary" : "config"
>> }
>>         {  "_id" : "test_db",  "partitioned" : true,  "primary" :
>> "sharda" }
>>         {  "_id" : "hor",  "partitioned" : true,  "primary" : "sharda" }
>>         {  "_id" : "load_test",  "partitioned" : true,  "primary" :
>> "sharda" }
>>                 load_test.loadtest chunks:
>>                               ​  sharda  717
>>                               ​  shardb  717
>>                         too many chunks to print, use verbose if you want
>> to force print
>>         {  "_id" : "lt2",  "partitioned" : true,  "primary" : "shardb" }
>>                 lt2.loadtest chunks:
>>                               ​  sharda  11
>>                               ​  shardb  12
>>                         too many chunks to print, use verbose if you want
>> to force print
>>         {  "_id" : "hor-backup1",  "partitioned" : true,  "primary" :
>> "sharda" }
>>                 hor-backup1.metrics chunks:
>>                               ​  shardb  1
>>                               ​  sharda  2
>>                         { "s_UID" : { $minKey : 1 } } -->> { "s_UID" :
>> "5380ef37bf19b550" } on : shardb { "t" : 2000, "i" : 0 }
>>                         { "s_UID" : "5380ef37bf19b550" } -->> { "s_UID" :
>> "e0e9eba1c3d2fc8d" } on : sharda { "t" : 2000, "i" : 1 }
>>                         { "s_UID" : "e0e9eba1c3d2fc8d" } -->> { "s_UID" :
>> { $maxKey : 1 } } on : sharda { "t" : 1000, "i" : 3 }
>>         {  "_id" : "localhost",  "partitioned" : false,  "primary" :
>> "shardb" }
>>         {  "_id" : "players",  "partitioned" : false,  "primary" :
>> "shardb" }

>> On Wednesday, March 21, 2012 11:15:24 AM UTC-4, Scott Hernandez wrote:

>>> Can you please post the output from these command connected to a mongos:

>>> use config
>>> db.shards.find()
>>> db.printShardingStatus()

>>> On Mon, Mar 19, 2012 at 5:34 PM, Kristina Chodorow <krist...@10gen.com>
>>> wrote:
>>> > What makes you think that mongos isn't dispatching these queries to the
>>> > secondaries?

>>> > On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>> >> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of
>>> now, I
>>> >> believe) and our servers are 2.0.3.

>>> > --
>>> > You received this message because you are subscribed to the Google
>>> Groups
>>> > "mongodb-user" group.
>>> > To view this discussion on the web visit
>>> > https://groups.google.com/d/​msg/mongodb-user/-/​idzt3ru2LuMJ<https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ>
>>> .

>>> > To post to this group, send email to mongodb-user@googlegroups.com.
>>> > To unsubscribe from this group, send email to
>>> > mongodb-user+unsubscribe@​googlegroups.com<mongodb-user%2Bunsubscribe@googl egroups.com>
>>> .
>>> > For more options, visit this group at
>>> > http://groups.google.com/​group/mongodb-user?hl=en<http://groups.google.com/group/mongodb-user?hl=en>
>>> .

> Hi guys, here is the logs. I've enable it and launch a couple a query.

> A line that caught my attention was:
> Fri Mar 23 13:58:19 [conn380] dbclient_rs getSlave not selecting { addr:
> "osmngb02:27018", isMaster: false, secondary: true, hidden: false, ok:
> false }, not currently okForSecondaryQueries

> Attached is a sample of the log file.

> Tell me what do you think.

> Simon

> On Thursday, March 22, 2012 12:14:42 PM UTC-4, Greg Studer wrote:

>> Hmm... still weird.  Can you up the logLevel of the mongos to 5
>> temporarily - this will give us the exact options being used by the query
>> as it is dispatched.

>> mongo <mongos>
>> > use admin
>> > db.runCommand({ setParameter : 1, logLevel : 5 })
>> // Up
>> > db.runCommand({ setParameter : 1, logLevel : 0 })

>> Is/was the replica set setup with any hidden nodes?  rs.status()

>> If simple, can you replace the 2.0.3 mongos with a 2.0.2 mongos and see
>> if there's a change?

>> On Wednesday, March 21, 2012 11:29:12 AM UTC-4, Simon T. wrote:

>>> MongoDB shell version: 2.0.3
>>> connecting to: localhost/admin
>>> mongos> use config
>>> switched to db config
>>> mongos> db.shards.find()
>>> { "_id" : "sharda", "host" :
>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>> { "_id" : "shardb", "host" :
>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>> mongos> db.printShardingStatus()
>>> --- Sharding Status ---
>>>   sharding version: { "_id" : 1, "version" : 3 }
>>>   shards:
>>>         {  "_id" : "sharda",  "host" :
>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>         {  "_id" : "shardb",  "host" :
>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>   databases:
>>>         {  "_id" : "admin",  "partitioned" : false,  "primary" :
>>> "config" }
>>>         {  "_id" : "test_db",  "partitioned" : true,  "primary" :
>>> "sharda" }
>>>         {  "_id" : "hor",  "partitioned" : true,  "primary" : "sharda" }
>>>         {  "_id" : "load_test",  "partitioned" : true,  "primary" :
>>> "sharda" }
>>>                 load_test.loadtest chunks:
>>>                               ​  sharda  717
>>>                               ​  shardb  717
>>>                         too many chunks to print, use verbose if you
>>> want to force print
>>>         {  "_id" : "lt2",  "partitioned" : true,  "primary" : "shardb" }
>>>                 lt2.loadtest chunks:
>>>                               ​  sharda  11
>>>                               ​  shardb  12
>>>                         too many chunks to print, use verbose if you
>>> want to force print
>>>         {  "_id" : "hor-backup1",  "partitioned" : true,  "primary" :
>>> "sharda" }
>>>                 hor-backup1.metrics chunks:
>>>                               ​  shardb  1
>>>                               ​  sharda  2
>>>                         { "s_UID" : { $minKey : 1 } } -->> { "s_UID" :
>>> "5380ef37bf19b550" } on : shardb { "t" : 2000, "i" : 0 }
>>>                         { "s_UID" : "5380ef37bf19b550" } -->> { "s_UID"
>>> : "e0e9eba1c3d2fc8d" } on : sharda { "t" : 2000, "i" : 1 }
>>>                         { "s_UID" : "e0e9eba1c3d2fc8d" } -->> { "s_UID"
>>> : { $maxKey : 1 } } on : sharda { "t" : 1000, "i" : 3 }
>>>         {  "_id" : "localhost",  "partitioned" : false,  "primary" :
>>> "shardb" }
>>>         {  "_id" : "players",  "partitioned" : false,  "primary" :
>>> "shardb" }

>>> On Wednesday, March 21, 2012 11:15:24 AM UTC-4, Scott Hernandez wrote:

>>>> Can you please post the output from these command connected to a mongos:

>>>> use config
>>>> db.shards.find()
>>>> db.printShardingStatus()

>>>> On Mon, Mar 19, 2012 at 5:34 PM, Kristina Chodorow <krist...@10gen.com>
>>>> wrote:
>>>> > What makes you think that mongos isn't dispatching these queries to
>>>> the
>>>> > secondaries?

>>>> > On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>> >> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of
>>>> now, I
>>>> >> believe) and our servers are 2.0.3.

>>>> > --
>>>> > You received this message because you are subscribed to the Google
>>>> Groups
>>>> > "mongodb-user" group.
>>>> > To view this discussion on the web visit
>>>> > https://groups.google.com/d/​msg/mongodb-user/-/​idzt3ru2LuMJ<https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ>
>>>> .

>>>> > To post to this group, send email to mongodb-user@googlegroups.com.
>>>> > To unsubscribe from this group, send email to
>>>> > mongodb-user+unsubscribe@​googlegroups.com<mongodb-user%2Bunsubscribe@googl egroups.com>
>>>> .
>>>> > For more options, visit this group at
>>>> > http://groups.google.com/​group/mongodb-user?hl=en<http://groups.google.com/group/mongodb-user?hl=en>
>>>> .

> Thanks for the log!  It looks like it's getting back healthy responses
> from the secondaries but not updating that they are healthy.  I'm not sure
> why it's not refreshing the secondaries' health, I've created a bug for it
> you can track: https://jira.mongodb.org/browse/SERVER-5405.

> In the meantime, have you tried restarting the mongos?

> On Friday, March 23, 2012 10:43:43 AM UTC-4, Simon T. wrote:

>> Hi guys, here is the logs. I've enable it and launch a couple a query.

>> A line that caught my attention was:
>> Fri Mar 23 13:58:19 [conn380] dbclient_rs getSlave not selecting { addr:
>> "osmngb02:27018", isMaster: false, secondary: true, hidden: false, ok:
>> false }, not currently okForSecondaryQueries

>> Attached is a sample of the log file.

>> Tell me what do you think.

>> Simon

>> On Thursday, March 22, 2012 12:14:42 PM UTC-4, Greg Studer wrote:

>>> Hmm... still weird.  Can you up the logLevel of the mongos to 5
>>> temporarily - this will give us the exact options being used by the query
>>> as it is dispatched.

>>> mongo <mongos>
>>> > use admin
>>> > db.runCommand({ setParameter : 1, logLevel : 5 })
>>> // Up
>>> > db.runCommand({ setParameter : 1, logLevel : 0 })

>>> Is/was the replica set setup with any hidden nodes?  rs.status()

>>> If simple, can you replace the 2.0.3 mongos with a 2.0.2 mongos and see
>>> if there's a change?

>>> On Wednesday, March 21, 2012 11:29:12 AM UTC-4, Simon T. wrote:

>>>> MongoDB shell version: 2.0.3
>>>> connecting to: localhost/admin
>>>> mongos> use config
>>>> switched to db config
>>>> mongos> db.shards.find()
>>>> { "_id" : "sharda", "host" :
>>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>> { "_id" : "shardb", "host" :
>>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>> mongos> db.printShardingStatus()
>>>> --- Sharding Status ---
>>>>   sharding version: { "_id" : 1, "version" : 3 }
>>>>   shards:
>>>>         {  "_id" : "sharda",  "host" :
>>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>>         {  "_id" : "shardb",  "host" :
>>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>>   databases:
>>>>         {  "_id" : "admin",  "partitioned" : false,  "primary" :
>>>> "config" }
>>>>         {  "_id" : "test_db",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>         {  "_id" : "hor",  "partitioned" : true,  "primary" : "sharda" }
>>>>         {  "_id" : "load_test",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>                 load_test.loadtest chunks:
>>>>                               ​  sharda  717
>>>>                               ​  shardb  717
>>>>                         too many chunks to print, use verbose if you
>>>> want to force print
>>>>         {  "_id" : "lt2",  "partitioned" : true,  "primary" : "shardb" }
>>>>                 lt2.loadtest chunks:
>>>>                               ​  sharda  11
>>>>                               ​  shardb  12
>>>>                         too many chunks to print, use verbose if you
>>>> want to force print
>>>>         {  "_id" : "hor-backup1",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>                 hor-backup1.metrics chunks:
>>>>                               ​  shardb  1
>>>>                               ​  sharda  2
>>>>                         { "s_UID" : { $minKey : 1 } } -->> { "s_UID" :
>>>> "5380ef37bf19b550" } on : shardb { "t" : 2000, "i" : 0 }
>>>>                         { "s_UID" : "5380ef37bf19b550" } -->> { "s_UID"
>>>> : "e0e9eba1c3d2fc8d" } on : sharda { "t" : 2000, "i" : 1 }
>>>>                         { "s_UID" : "e0e9eba1c3d2fc8d" } -->> { "s_UID"
>>>> : { $maxKey : 1 } } on : sharda { "t" : 1000, "i" : 3 }
>>>>         {  "_id" : "localhost",  "partitioned" : false,  "primary" :
>>>> "shardb" }
>>>>         {  "_id" : "players",  "partitioned" : false,  "primary" :
>>>> "shardb" }

>>>> On Wednesday, March 21, 2012 11:15:24 AM UTC-4, Scott Hernandez wrote:

>>>>> Can you please post the output from these command connected to a
>>>>> mongos:

>>>>> use config
>>>>> db.shards.find()
>>>>> db.printShardingStatus()

>>>>> On Mon, Mar 19, 2012 at 5:34 PM, Kristina Chodorow <krist...@10gen.com>
>>>>> wrote:
>>>>> > What makes you think that mongos isn't dispatching these queries to
>>>>> the
>>>>> > secondaries?

>>>>> > On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>>> >> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of
>>>>> now, I
>>>>> >> believe) and our servers are 2.0.3.

>>>>> > --
>>>>> > You received this message because you are subscribed to the Google
>>>>> Groups
>>>>> > "mongodb-user" group.
>>>>> > To view this discussion on the web visit
>>>>> > https://groups.google.com/d/​msg/mongodb-user/-/​idzt3ru2LuMJ<https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ>
>>>>> .

>>>>> > To post to this group, send email to mongodb-user@googlegroups.com.
>>>>> > To unsubscribe from this group, send email to
>>>>> > mongodb-user+unsubscribe@​googlegroups.com<mongodb-user%2Bunsubscribe@googl egroups.com>
>>>>> .
>>>>> > For more options, visit this group at
>>>>> > http://groups.google.com/​group/mongodb-user?hl=en<http://groups.google.com/group/mongodb-user?hl=en>
>>>>> .

> In the meantime, have you tried restarting the mongos?

> On Friday, March 23, 2012 10:43:43 AM UTC-4, Simon T. wrote:

>> Hi guys, here is the logs. I've enable it and launch a couple a query.

>> A line that caught my attention was:
>> Fri Mar 23 13:58:19 [conn380] dbclient_rs getSlave not selecting { addr:
>> "osmngb02:27018", isMaster: false, secondary: true, hidden: false, ok:
>> false }, not currently okForSecondaryQueries

>> Attached is a sample of the log file.

>> Tell me what do you think.

>> Simon

>> On Thursday, March 22, 2012 12:14:42 PM UTC-4, Greg Studer wrote:

>>> Hmm... still weird.  Can you up the logLevel of the mongos to 5
>>> temporarily - this will give us the exact options being used by the query
>>> as it is dispatched.

>>> mongo <mongos>
>>> > use admin
>>> > db.runCommand({ setParameter : 1, logLevel : 5 })
>>> // Up
>>> > db.runCommand({ setParameter : 1, logLevel : 0 })

>>> Is/was the replica set setup with any hidden nodes?  rs.status()

>>> If simple, can you replace the 2.0.3 mongos with a 2.0.2 mongos and see
>>> if there's a change?

>>> On Wednesday, March 21, 2012 11:29:12 AM UTC-4, Simon T. wrote:

>>>> MongoDB shell version: 2.0.3
>>>> connecting to: localhost/admin
>>>> mongos> use config
>>>> switched to db config
>>>> mongos> db.shards.find()
>>>> { "_id" : "sharda", "host" :
>>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>> { "_id" : "shardb", "host" :
>>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>> mongos> db.printShardingStatus()
>>>> --- Sharding Status ---
>>>>   sharding version: { "_id" : 1, "version" : 3 }
>>>>   shards:
>>>>         {  "_id" : "sharda",  "host" :
>>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>>         {  "_id" : "shardb",  "host" :
>>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>>   databases:
>>>>         {  "_id" : "admin",  "partitioned" : false,  "primary" :
>>>> "config" }
>>>>         {  "_id" : "test_db",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>         {  "_id" : "hor",  "partitioned" : true,  "primary" : "sharda" }
>>>>         {  "_id" : "load_test",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>                 load_test.loadtest chunks:
>>>>                               ​  sharda  717
>>>>                               ​  shardb  717
>>>>                         too many chunks to print, use verbose if you
>>>> want to force print
>>>>         {  "_id" : "lt2",  "partitioned" : true,  "primary" : "shardb" }
>>>>                 lt2.loadtest chunks:
>>>>                               ​  sharda  11
>>>>                               ​  shardb  12
>>>>                         too many chunks to print, use verbose if you
>>>> want to force print
>>>>         {  "_id" : "hor-backup1",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>                 hor-backup1.metrics chunks:
>>>>                               ​  shardb  1
>>>>                               ​  sharda  2
>>>>                         { "s_UID" : { $minKey : 1 } } -->> { "s_UID" :
>>>> "5380ef37bf19b550" } on : shardb { "t" : 2000, "i" : 0 }
>>>>                         { "s_UID" : "5380ef37bf19b550" } -->> { "s_UID"
>>>> : "e0e9eba1c3d2fc8d" } on : sharda { "t" : 2000, "i" : 1 }
>>>>                         { "s_UID" : "e0e9eba1c3d2fc8d" } -->> { "s_UID"
>>>> : { $maxKey : 1 } } on : sharda { "t" : 1000, "i" : 3 }
>>>>         {  "_id" : "localhost",  "partitioned" : false,  "primary" :
>>>> "shardb" }
>>>>         {  "_id" : "players",  "partitioned" : false,  "primary" :
>>>> "shardb" }

>>>> On Wednesday, March 21, 2012 11:15:24 AM UTC-4, Scott Hernandez wrote:

>>>>> Can you please post the output from these command connected to a
>>>>> mongos:

>>>>> use config
>>>>> db.shards.find()
>>>>> db.printShardingStatus()

>>>>> On Mon, Mar 19, 2012 at 5:34 PM, Kristina Chodorow <krist...@10gen.com>
>>>>> wrote:
>>>>> > What makes you think that mongos isn't dispatching these queries to
>>>>> the
>>>>> > secondaries?

>>>>> > On Monday, March 19, 2012 4:42:53 PM UTC-4, Simon T. wrote:

>>>>> >> I forgot to mention that I'm using C# drivers 1.3.1 (latest as of
>>>>> now, I
>>>>> >> believe) and our servers are 2.0.3.

>>>>> > --
>>>>> > You received this message because you are subscribed to the Google
>>>>> Groups
>>>>> > "mongodb-user" group.
>>>>> > To view this discussion on the web visit
>>>>> > https://groups.google.com/d/​msg/mongodb-user/-/​idzt3ru2LuMJ<https://groups.google.com/d/msg/mongodb-user/-/idzt3ru2LuMJ>
>>>>> .

>>>>> > To post to this group, send email to mongodb-user@googlegroups.com.
>>>>> > To unsubscribe from this group, send email to
>>>>> > mongodb-user+unsubscribe@​googlegroups.com<mongodb-user%2Bunsubscribe@googl egroups.com>
>>>>> .
>>>>> > For more options, visit this group at
>>>>> > http://groups.google.com/​group/mongodb-user?hl=en<http://groups.google.com/group/mongodb-user?hl=en>
>>>>> .

On Monday, 26 March 2012 16:29:36 UTC+1, Kristina Chodorow wrote:

> Thanks for the log!  It looks like it's getting back healthy responses
> from the secondaries but not updating that they are healthy.  I'm not sure
> why it's not refreshing the secondaries' health, I've created a bug for it
> you can track: https://jira.mongodb.org/browse/SERVER-5405.

> In the meantime, have you tried restarting the mongos?

> On Friday, March 23, 2012 10:43:43 AM UTC-4, Simon T. wrote:

>> Hi guys, here is the logs. I've enable it and launch a couple a query.

>> A line that caught my attention was:
>> Fri Mar 23 13:58:19 [conn380] dbclient_rs getSlave not selecting { addr:
>> "osmngb02:27018", isMaster: false, secondary: true, hidden: false, ok:
>> false }, not currently okForSecondaryQueries

>> Attached is a sample of the log file.

>> Tell me what do you think.

>> Simon

>> On Thursday, March 22, 2012 12:14:42 PM UTC-4, Greg Studer wrote:

>>> Hmm... still weird.  Can you up the logLevel of the mongos to 5
>>> temporarily - this will give us the exact options being used by the query
>>> as it is dispatched.

>>> mongo <mongos>
>>> > use admin
>>> > db.runCommand({ setParameter : 1, logLevel : 5 })
>>> // Up
>>> > db.runCommand({ setParameter : 1, logLevel : 0 })

>>> Is/was the replica set setup with any hidden nodes?  rs.status()

>>> If simple, can you replace the 2.0.3 mongos with a 2.0.2 mongos and see
>>> if there's a change?

>>> On Wednesday, March 21, 2012 11:29:12 AM UTC-4, Simon T. wrote:

>>>> MongoDB shell version: 2.0.3
>>>> connecting to: localhost/admin
>>>> mongos> use config
>>>> switched to db config
>>>> mongos> db.shards.find()
>>>> { "_id" : "sharda", "host" :
>>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>> { "_id" : "shardb", "host" :
>>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>> mongos> db.printShardingStatus()
>>>> --- Sharding Status ---
>>>>   sharding version: { "_id" : 1, "version" : 3 }
>>>>   shards:
>>>>         {  "_id" : "sharda",  "host" :
>>>> "sharda/osmnga01:27018,​osmnga02:27018,osmnga03:27018" }
>>>>         {  "_id" : "shardb",  "host" :
>>>> "shardb/osmngb01:27018,​osmngb02:27018,osmngb03:27018" }
>>>>   databases:
>>>>         {  "_id" : "admin",  "partitioned" : false,  "primary" :
>>>> "config" }
>>>>         {  "_id" : "test_db",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>         {  "_id" : "hor",  "partitioned" : true,  "primary" : "sharda" }
>>>>         {  "_id" : "load_test",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>                 load_test.loadtest chunks:
>>>>                               ​  sharda  717
>>>>                               ​  shardb  717
>>>>                         too many chunks to print, use verbose if you
>>>> want to force print
>>>>         {  "_id" : "lt2",  "partitioned" : true,  "primary" : "shardb" }
>>>>                 lt2.loadtest chunks:
>>>>                               ​  sharda  11
>>>>                               ​  shardb  12
>>>>                         too many chunks to print, use verbose if you
>>>> want to force print
>>>>         {  "_id" : "hor-backup1",  "partitioned" : true,  "primary" :
>>>> "sharda" }
>>>>                 hor-backup1.metrics chunks:
>>>>                               ​  shardb  1
>>>>                               ​  sharda  2
>>>>                         { "s_UID" : { $minKey : 1 } } -->> { "s_UID" :
>>>> "5380ef37bf19b550" } on : shardb { "t" : 2000, "i" : 0 }
>>>>                         { "s_UID" : "5380ef37bf19b550" } -->> { "s_UID"
>>>> :

> I confirm that I've tested it with Java, C# and python drivers.

> On Tuesday, March 27, 2012 9:42:10 AM UTC-4, Simon T. wrote:

>> I confirm that I've tested it with Java, C# and python drivers.

> *Shard A*

> connecting to: localhost:27018/admin
> PRIMARY> rs.status()
> {
>         "set" : "sharda",
>         "date" : ISODate("2012-03-27T14:35:29Z"),
>         "myState" : 1,
>         "members" : [
>                 {
>                         "_id" : 0,
>                         "name" : "osmnga01:27018",
>                         "health" : 1,
>                         "state" : 1,
>                         "stateStr" : "PRIMARY",
>                         "optime" : {
>                                 "t" : 1332858904000,
>                                 "i" : 5
>                         },
>                         "optimeDate" : ISODate("2012-03-27T14:35:04Z"),
>                         "self" : true
>                 },
>                 {
>                         "_id" : 1,
>                         "name" : "osmnga02:27018",
>                         "health" : 1,
>                         "state" : 2,
>                         "stateStr" : "SECONDARY",
>                         "uptime" : 403892,
>                         "optime" : {
>                                 "t" : 1332858904000,
>                                 "i" : 5
>                         },
>                         "optimeDate" : ISODate("2012-03-27T14:35:04Z"),
>                         "lastHeartbeat" : ISODate("2012-03-27T14:35:28Z"),
>                         "pingMs" : 0
>                 },
>                 {
>                         "_id" : 2,
>                         "name" : "osmnga03:27018",
>                         "health" : 1,
>                         "state" : 2,
>                         "stateStr" : "SECONDARY",
>                         "uptime" : 210,
>                         "optime" : {
>                                 "t" : 1332857863000,
>                                 "i" : 1
>                         },
>                         "optimeDate" : ISODate("2012-03-27T14:17:43Z"),
>                         "lastHeartbeat" : ISODate("2012-03-27T14:35:29Z"),
>                         "pingMs" : 23
>                 }
>         ],
>         "ok" : 1
> }
> PRIMARY>
> *ShardB*

> PRIMARY> rs.status()
> {
>         "set" : "shardb",
>         "date" : ISODate("2012-03-27T14:36:48Z"),
>         "myState" : 1,
>         "syncingTo" : "osmngb02:27018",
>         "members" : [
>                 {
>                         "_id" : 0,
>                         "name" : "osmngb01:27018",
>                         "health" : 1,
>                         "state" : 1,
>                         "stateStr" : "PRIMARY",
>                         "optime" : {
>                                 "t" : 1332853220000,
>                                 "i" : 1
>                         },
>                         "optimeDate" : ISODate("2012-03-27T13:00:20Z"),
>                         "self" : true
>                 },
>                 {
>                         "_id" : 1,
>                         "name" : "osmngb02:27018",
>                         "health" : 1,
>                         "state" : 2,
>                         "stateStr" : "SECONDARY",
>                         "uptime" : 86910,
>                         "optime" : {
>                                 "t" : 1332853220000,
>                                 "i" : 1
>                         },
>                         "optimeDate" : ISODate("2012-03-27T13:00:20Z"),
>                         "lastHeartbeat" : ISODate("2012-03-27T14:36:46Z"),
>                         "pingMs" : 0
>                 },
>                 {
>                         "_id" : 2,
>                         "name" : "osmngb03:27018",
>                         "health" : 1,
>                         "state" : 2,
>                         "stateStr" : "SECONDARY",
>                         "uptime" : 86910,
>                         "optime" : {
>                                 "t" : 1332853220000,
>                                 "i" : 1
>                         },
>                         "optimeDate" : ISODate("2012-03-27T13:00:20Z"),
>                         "lastHeartbeat" : ISODate("2012-03-27T14:36:46Z"),
>                         "pingMs" : 0
>                 }
>         ],
>         "ok" : 1
> }
> PRIMARY>

> On Tuesday, 27 March 2012 15:07:40 UTC+1, Kristina Chodorow wrote:

>> Yes, it looks like a bug in mongos, so it won't matter what language you
>> use.  If you connect directly to a replica set primary and run rs.status(),
>> what is the output?

>> On Tuesday, March 27, 2012 9:42:10 AM UTC-4, Simon T. wrote:

>>> I confirm that I've tested it with Java, C# and python drivers.

> Okay, looks fine on that end.  I'd recommend following the ticket.

> On Tuesday, March 27, 2012 10:37:54 AM UTC-4, Tomáš Jelínek wrote:

>> *Shard A*

>> connecting to: localhost:27018/admin
>> PRIMARY> rs.status()
>> {
>>         "set" : "sharda",
>>         "date" : ISODate("2012-03-27T14:35:29Z"),
>>         "myState" : 1,
>>         "members" : [
>>                 {
>>                         "_id" : 0,
>>                         "name" : "osmnga01:27018",
>>                         "health" : 1,
>>                         "state" : 1,
>>                         "stateStr" : "PRIMARY",
>>                         "optime" : {
>>                                 "t" : 1332858904000,
>>                                 "i" : 5
>>                         },
>>                         "optimeDate" : ISODate("2012-03-27T14:35:04Z"),
>>                         "self" : true
>>                 },
>>                 {
>>                         "_id" : 1,
>>                         "name" : "osmnga02:27018",
>>                         "health" : 1,
>>                         "state" : 2,
>>                         "stateStr" : "SECONDARY",
>>                         "uptime" : 403892,
>>                         "optime" : {
>>                                 "t" : 1332858904000,
>>                                 "i" : 5
>>                         },
>>                         "optimeDate" : ISODate("2012-03-27T14:35:04Z"),
>>                         "lastHeartbeat" : ISODate("2012-03-27T14:35:28Z"),
>>                         "pingMs" : 0
>>                 },
>>                 {
>>                         "_id" : 2,
>>                         "name" : "osmnga03:27018",
>>                         "health" : 1,
>>                         "state" : 2,
>>                         "stateStr" : "SECONDARY",
>>                         "uptime" : 210,
>>                         "optime" : {
>>                                 "t" : 1332857863000,
>>                                 "i" : 1
>>                         },
>>                         "optimeDate" : ISODate("2012-03-27T14:17:43Z"),
>>                         "lastHeartbeat" : ISODate("2012-03-27T14:35:29Z"),
>>                         "pingMs" : 23
>>                 }
>>         ],
>>         "ok" : 1
>> }
>> PRIMARY>
>> *ShardB*

>> PRIMARY> rs.status()
>> {
>>         "set" : "shardb",
>>         "date" : ISODate("2012-03-27T14:36:48Z"),
>>         "myState" : 1,
>>         "syncingTo" : "osmngb02:27018",
>>         "members" : [
>>                 {
>>                         "_id" : 0,
>>                         "name" : "osmngb01:27018",
>>                         "health" : 1,
>>                         "state" : 1,
>>                         "stateStr" : "PRIMARY",
>>                         "optime" : {
>>                                 "t" : 1332853220000,
>>                                 "i" : 1
>>                         },
>>                         "optimeDate" : ISODate("2012-03-27T13:00:20Z"),
>>                         "self" : true
>>                 },
>>                 {
>>                         "_id" : 1,
>>                         "name" : "osmngb02:27018",
>>                         "health" : 1,
>>                         "state" : 2,
>>                         "stateStr" : "SECONDARY",
>>                         "uptime" : 86910,
>>                         "optime" : {
>>                                 "t" : 1332853220000,
>>                                 "i" : 1
>>                         },
>>                         "optimeDate" : ISODate("2012-03-27T13:00:20Z"),
>>                         "lastHeartbeat" : ISODate("2012-03-27T14:36:46Z"),
>>                         "pingMs" : 0
>>                 },
>>                 {
>>                         "_id" : 2,
>>                         "name" : "osmngb03:27018",
>>                         "health" : 1,
>>                         "state" : 2,
>>                         "stateStr" : "SECONDARY",
>>                         "uptime" : 86910,
>>                         "optime" : {
>>                                 "t" : 1332853220000,
>>                                 "i" : 1
>>                         },
>>                         "optimeDate" : ISODate("2012-03-27T13:00:20Z"),
>>                         "lastHeartbeat" : ISODate("2012-03-27T14:36:46Z"),
>>                         "pingMs" : 0
>>                 }
>>         ],
>>         "ok" : 1
>> }
>> PRIMARY>

>> On Tuesday, 27 March 2012 15:07:40 UTC+1, Kristina Chodorow wrote:

>>> Yes, it looks like a bug in mongos, so it won't matter what language you
>>> use.  If you connect directly to a replica set primary and run rs.status(),
>>> what is the output?

>>> On Tuesday, March 27, 2012 9:42:10 AM UTC-4, Simon T. wrote:

>>>> I confirm that I've tested it with Java, C# and python drivers.

> The problem is indeed persistent, I never could get the queries to be
> redirected to the secondary while passing by the mongos.

> The scripts are very simple: it is just looping queries. Here is two
> examples that does the same thing, one in java and the other one in C#:

> JAVA:
> try {
> Mongo _mongo = new Mongo("osmngs01", 27017);
> _mongo.setReadPreference(ReadPreference.SECONDARY);
> DB db = _mongo.getDB("AAAAA");
> if (db.authenticate("XXXXXXX", "YYYYYYYY".toCharArray()) == false) {
> String message = String.format("Initialization Error: Failed to
> authenticate to %1$s.", "osmngs01");
> System.out.println(message);
> }

> DBCollection coll = db.getCollection("players");
> for(int i=0;i<10000;i++)
> {
> DBObject player = coll.findOne(new BasicDBObject("s_nintendoID",
> Integer.toString(i)));

> System.out.println("index: " + i + " players: " + player);
> }

> } catch (UnknownHostException ex) {
> String message = String.format("Initialization Error: Host %1$s does not
> exists. Message: %2$s",
> "osmngs01", ex.getMessage());
> System.out.println(message);
> } catch (MongoException ex) {
> String message = String.format("Initialization Error: Cannot connect to
> host %1$s:%2$s. Message: %3$s",
> "osmngs01", 27017, ex.getMessage());
> System.out.println(message);
> }

> AND C#:

> string connectionString = "mongodb://XXXXX:YYYYY@osmngs01/?slaveOk=true";
> MongoServer mongoServer = MongoServer.Create(connectionString);
> MongoDatabase mongoDB = mongoServer.GetDatabase(MONGO_DB);
> MongoCollection<BsonDocument> documents = mongoDB.GetCollection("players");
> Random rndNb = new Random();
> for (int i = 0; i < 15000; i++)
> {
> int iPlayer = rndNb.Next(1, 400000);
> try
> {
> var query = Query.EQ("s_nintendoID", iPlayer.ToString());

> BsonDocument bsonPlayer = documents.FindOne(query);

> }
> catch (Exception exc)
> {
> System.Diagnostics.Debug.WriteLine(exc.Message);
> }
> }

> Simon

> Are you still having this issue? I am struggling to reproduce this bug. Do
> you have a verbose logs of the replicas that corresponds to the same time
> frame with the verbose mongos log that is experiencing this issue?

> On Thursday, March 29, 2012 3:27:40 PM UTC-4, Simon T. wrote:

>> The problem is indeed persistent, I never could get the queries to be
>> redirected to the secondary while passing by the mongos.

>> The scripts are very simple: it is just looping queries. Here is two
>> examples that does the same thing, one in java and the other one in C#:

>> JAVA:
>> try {
>> Mongo _mongo = new Mongo("osmngs01", 27017);
>> _mongo.setReadPreference(ReadPreference.SECONDARY);
>> DB db = _mongo.getDB("AAAAA");
>> if (db.authenticate("XXXXXXX", "YYYYYYYY".toCharArray()) == false) {
>> String message = String.format("Initialization Error: Failed to
>> authenticate to %1$s.", "osmngs01");
>> System.out.println(message);
>> }

>> DBCollection coll = db.getCollection("players");
>> for(int i=0;i<10000;i++)
>> {
>> DBObject player = coll.findOne(new BasicDBObject("s_nintendoID",
>> Integer.toString(i)));

>> System.out.println("index: " + i + " players: " + player);
>> }

>> } catch (UnknownHostException ex) {
>> String message = String.format("Initialization Error: Host %1$s does not
>> exists. Message: %2$s",
>> "osmngs01", ex.getMessage());
>> System.out.println(message);
>> } catch (MongoException ex) {
>> String message = String.format("Initialization Error: Cannot connect to
>> host %1$s:%2$s. Message: %3$s",
>> "osmngs01", 27017, ex.getMessage());
>> System.out.println(message);
>> }

>> AND C#:

>> string connectionString = "mongodb://XXXXX:YYYYY@osmngs01/?slaveOk=true";
>> MongoServer mongoServer = MongoServer.Create(connectionString);
>> MongoDatabase mongoDB = mongoServer.GetDatabase(MONGO_DB);
>> MongoCollection<BsonDocument> documents =
>> mongoDB.GetCollection("players");
>> Random rndNb = new Random();
>> for (int i = 0; i < 15000; i++)
>> {
>> int iPlayer = rndNb.Next(1, 400000);
>> try
>> {
>> var query = Query.EQ("s_nintendoID", iPlayer.ToString());

>> BsonDocument bsonPlayer = documents.FindOne(query);

>> }
>> catch (Exception exc)
>> {
>> System.Diagnostics.Debug.WriteLine(exc.Message);
>> }
>> }

>> Simon

On Wednesday, 4 April 2012 21:40:55 UTC+1, Randolph Tan wrote:

> Are you still having this issue? I am struggling to reproduce this bug. Do
> you have a verbose logs of the replicas that corresponds to the same time
> frame with the verbose mongos log that is experiencing this issue?

> On Thursday, March 29, 2012 3:27:40 PM UTC-4, Simon T. wrote:

>> The problem is indeed persistent, I never could get the queries to be
>> redirected to the secondary while passing by the mongos.

>> The scripts are very simple: it is just looping queries. Here is two
>> examples that does the same thing, one in java and the other one in C#:

>> JAVA:
>> try {
>> Mongo _mongo = new Mongo("osmngs01", 27017);
>> _mongo.setReadPreference(ReadPreference.SECONDARY);
>> DB db = _mongo.getDB("AAAAA");
>> if (db.authenticate("XXXXXXX", "YYYYYYYY".toCharArray()) == false) {
>> String message = String.format("Initialization Error: Failed to
>> authenticate to %1$s.", "osmngs01");
>> System.out.println(message);
>> }

>> DBCollection coll = db.getCollection("players");
>> for(int i=0;i<10000;i++)
>> {
>> DBObject player = coll.findOne(new BasicDBObject("s_nintendoID",
>> Integer.toString(i)));

>> System.out.println("index: " + i + " players: " + player);
>> }

>> } catch (UnknownHostException ex) {
>> String message = String.format("Initialization Error: Host %1$s does not
>> exists. Message: %2$s",
>> "osmngs01", ex.getMessage());
>> System.out.println(message);
>> } catch (MongoException ex) {
>> String message = String.format("Initialization Error: Cannot connect to
>> host %1$s:%2$s. Message: %3$s",
>> "osmngs01", 27017, ex.getMessage());
>> System.out.println(message);
>> }

>> AND C#:

>> string connectionString = "mongodb://XXXXX:YYYYY@osmngs01/?slaveOk=true";
>> MongoServer mongoServer = MongoServer.Create(connectionString);
>> MongoDatabase mongoDB = mongoServer.GetDatabase(MONGO_DB);
>> MongoCollection<BsonDocument> documents =
>> mongoDB.GetCollection("players");
>> Random rndNb = new Random();
>> for (int i = 0; i < 15000; i++)
>> {
>> int iPlayer = rndNb.Next(1, 400000);
>> try
>> {
>> var query = Query.EQ("s_nintendoID", iPlayer.ToString());

>> BsonDocument bsonPlayer = documents.FindOne(query);

>> }
>> catch (Exception exc)
>> {
>> System.Diagnostics.Debug.WriteLine(exc.Message);
>> }
>> }

>> Simon