Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-27864

SlaveOK reads against SCCC config server fail with error "all servers down/unreachable when querying"

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 3.2.13
    • Affects Version/s: 3.2.10
    • Component/s: Sharding
    • Labels:
      None
    • Fully Compatible
    • ALL
    • Sharding 2017-03-27

      Performing 'SlaveOK' reads against an SCCC config server fails with the following error:

      mongos> use config;
      switched to db config
      mongos> db.getMongo().setReadPref('secondaryPreferred')
      mongos> db.chunks.count()
      2017-02-03T14:26:42.603-0500 E QUERY    [thread1] Error: count failed: {
              "code" : 6,
              "ok" : 0,
              "errmsg" : "all servers down/unreachable when querying: kaloianmdesktop:20002,kaloianmdesktop:20003,kaloianmdesktop:20004"
      } :
      _getErrorWithCode@src/mongo/shell/utils.js:25:13
      DBQuery.prototype.count@src/mongo/shell/query.js:383:11
      DBCollection.prototype.count@src/mongo/shell/collection.js:1700:12
      @(shell):1:1
      

      The reason is explained in this comment.

      These are the errors which show up in the log:

      2017-01-31T07:28:40.004+0000 I NETWORK  [conn4] query on admin.$cmd: { query: "1", help: 1 } failed to: in.dbcfg1.mydomain.com:27019 (10.0.97.139) exception: "query" had the wrong type. Expected Object, found String
      2017-01-31T07:28:40.004+0000 I NETWORK  [conn4] query on admin.$cmd: { query: "1", help: 1 } failed to: in.dbcfg2.mydomain.com:27019 (10.0.97.140) exception: "query" had the wrong type. Expected Object, found String
      2017-01-31T07:28:40.004+0000 I NETWORK  [conn4] query on admin.$cmd: { query: "1", help: 1 } failed to: in.dbcfg3.mydomain.com:27019 (10.0.97.141) exception: "query" had the wrong type. Expected Object, found String
      2017-01-31T07:28:40.004+0000 W NETWORK  [conn4] db exception when initializing on config, current connection state is { state: { conn: "SyncClusterConnection  [in.dbcfg1.mydomain.com:27019 (10.0.97.139),in.dbcfg2.mydomain.com:27019 (10.0.97.140),in.dbcfg3.mydomain.com:27019 (10.0.97.141)]", vinfo: "config:in.dbcfg1.mydomain.com:27019,in.dbcfg2.mydomain.com:27019,in.dbcfg3.mydomain.com:27019", cursor: "(empty)", count: 0, done: false }, retryNext: false, init: false, finish: false, errored: false } :: caused by :: 6 all servers down/unreachable when querying: in.dbcfg1.mydomain.com:27019,in.dbcfg2.mydomain.com:27019,in.dbcfg3.mydomain.com:27019
      

            Assignee:
            randolph@mongodb.com Randolph Tan
            Reporter:
            yonido Yoni Douek
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: