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

collection lacks unique index on _id

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Incomplete
    • Icon: Major - P3 Major - P3
    • None
    • 2.6.3
    • MapReduce
    • None

    Description

      while starting up the mongo shell I am getting warnings for four collections which may be a result of a failure few hours back on my primary server. It went down and I had to restart mongo service to bring it back. After doing some research online I figured we can delete this temporary collection created by map reduce.
      But when i do a search for them in the mongo shell I am not able to find any results. So I would like to know if they exist then where can I view them or delete them and if they don't then why am I getting such warnings?

      PFB logs

       [initandlisten] WARNING: the collection 'db.tmp.mr.coll_9363_inc' lacks a unique index on _id. This index is needed for replication to function properly
       [initandlisten]     To fix this, you need to create a unique index on _id. See http://dochub.mongodb.org/core/build-replica-set-indexes
       [initandlisten] WARNING: the collection 'db.tmp.mr.coll_9362_inc' lacks a unique index on _id. This index is needed for replication to function properly
       [initandlisten]     To fix this, you need to create a unique index on _id. See http://dochub.mongodb.org/core/build-replica-set-indexes
       [initandlisten] WARNING: the collection 'db.tmp.mr.coll_9361_inc' lacks a unique index on _id. This index is needed for replication to function properly
       [initandlisten]     To fix this, you need to create a unique index on _id. See http://dochub.mongodb.org/core/build-replica-set-indexes
       [initandlisten] WARNING: the collection 'db.tmp.mr.coll_9364_inc' lacks a unique index on _id. This index is needed for replication to function properly
      [initandlisten]     To fix this, you need to create a unique index on _id. See http://dochub.mongodb.org/core/build-replica-set-indexes

      I tried searching on mongo shell using

      db.system.namespaces.find({name: '/mr/'})

      got no results

      Attachments

        Activity

          People

            ramon.fernandez@mongodb.com Ramon Fernandez Marina
            saurabh.malani@delhivery.com Saurabh Malani
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: