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

Mongos cannot do slaveOk queries when primary is down

    • ALL

      Issue Status as of January 8th, 2014

      ISSUE SUMMARY
      New sharded connections may fail to connect if any shard has no available primary for an extended period.

      This issue is part of 4 related issues which impact cluster availability when there is no primary available for a shard. See SERVER-7246, SERVER-5625, SERVER-11971 and SERVER-12041 for more details.

      USER IMPACT
      When any replica set in a sharded cluster has no available primary, new connections may fail to perform secondary reads due to an initial heuristic shard version check, or initial authorization check.

      It is present in versions of MongoDB prior to and including v2.4.8.

      SOLUTION
      Ignore failures of initial version check during connection and allow authorization against secondaries (primary is preferred when available).

      In v2.4.9 only (this is set by default in v2.6.0 and later), it is necessary to use the following two startup parameters for mongos:

      --setParameter ignoreInitialVersionFailure=true
      --setParameter authOnPrimaryOnly=false
      

      These parameters can also be set on a MongoS after launch with the following commands

      db.adminCommand({setParameter:1,ignoreInitialVersionFailure:true})
      db.adminCommand({setParameter:1,authOnPrimaryOnly:false})
      

      WORKAROUNDS
      There is no direct work around. You should ensure that your replica sets in sharded clusters have enough redundancy. You should ensure you have robust and fault tolerant underlying architectures (network, WAN hosting, etc).

      PATCHES
      Production release v2.4.9 contains the fix for this issue, and production release v2.6.0 will contain the fix as well.

      Original Description

      This issue is fixed, but depending on the type of connectivity issue between a mongos and the down primary, connection and query performance can be severely degraded in this scenario.

      Results of testing different primary down scenarios latencies:

      With killed processes, but functioning network:
      First query average is 3 secs
      Final average is 2 secs

      With iptables DROP:
      First query average is 428 sec
      Final average is 254 sec

      With iptables REJECT:
      First query average is 473 sec
      Final average is 255 sec

        1. slaveok_memberchange.js
          2 kB
        2. slaveOk_no_pri.js
          0.8 kB

            Assignee:
            greg_10gen Greg Studer
            Reporter:
            randolph@mongodb.com Randolph Tan
            Votes:
            6 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated:
              Resolved: