php - MongoDB Duplicate Documents even after adding unique key -


i have created collection , added unique key 

db.user_services.createindex({"uid":1 , "sid": 1},{unique:true,dropdups: true})

the collection looks "user_services"

{  "_id" : objectid("55068b35f791c7f81000002d"),  "uid" : 15,  "sid" : 1,  "rate" : 5 }, {   "_id" : objectid("55068b35f791c7f81000002f"),  "uid" : 15,  "sid" : 1,  "rate" : 4 }

problem :

am using php driver insert documents same uid , sid , getting inserted.

what want

  1. on mongo shell : add unique key on uid , sid no duplicate documents same uid , sid.
  2. on php side : having mysql "insert (value) on duplicate key update rate=rate+1". whenever try insert document, should inserted if not there else should update rate field of document

congratulations, appear have found bug. happens mongodb 3.0.0 in testing, or @ least not present @ mongodb 2.6.6. bug recorded @ server-17599

note: not "issue" confirmed "by design". dropped option version 3.0.0. still listed in documentation though.

the problem index not being created , errors when attempt create on collection existing duplicates on "compound key" fields. on above, index creation should yield in shell:

{     "createdcollectionautomatically" : false,     "numindexesbefore" : 1,     "errmsg" : "exception: e11000 duplicate key error dup key: { : 15.0, : 1.0 }",     "code" : 11000,     "ok" : 0 }

when there no duplicates present can create index trying , created.

so work around this, first remove duplicates procedure this:

db.events.aggregate([     { "$group": {         "_id": { "uid": "$uid", "sid": "$sid" },         "dups": { "$push": "$_id" },         "count": { "$sum": 1 }     }},     { "$match": { "count": { "$gt": 1 } }} ]).foreach(function(doc) {     doc.dups.shift();     db.events.remove({ "_id": {"$in": doc.dups }}); });  db.events.createindex({"uid":1 , "sid": 1},{unique:true})

then further inserts containing duplicate data not inserted , appropriate error recorded.

the final note here "dropdups" is/was not elegant solution removing duplicate data. want more control demonstrated above.

for second part, rather use .insert() use .update() method. has "upsert" option

$collection->update(     array( "uid" => 1, "sid" => 1 ),     array( '$set' => $somedata ),     array( 'upsert' => true ) );

so "found" documents "modified" , documents not found "inserted". see $setoninsert way create data when document inserted , not when modified.

for specific attempt, correct syntax of .update() 3 arguments. "query", "update" , "options":

$collection->update(     array( "uid" => 1, "sid" => 1 ),     array(         '$set' => array( "field" => "this" ),         '$inc' => array( "counter" => 1 ),         '$setoninsert' => array( "newfield" => "another" )    ),    array( "upsert" => true ) );

none of update operations allowed "access same path" used in update operation in "update" document section.


Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer
Read more

jquery - Responsive Navbar with Sub Navbar -

good day, forgive me nav vocabulary not best. if question confusing apologize. i'm working on navigation bar needs centered on page @ 768px , above. items in nav open (or perhaps toggle) subnav lives directly below. these nav should appear centered on page. i have been able work through responsive portion of nav bar, having main items align vertically , sub nav menu of each item roll out below, , gave them indent separation. working well. however, issue not responsive side, behavior @ width greater 768px. happens toggling menu's sub navigation pushes other main items down page below sub nav. here's code: $(document).ready(function () { //stick in fixed 100% height behind navbar don't wrap $('#slide-nav.navbar-inverse').after($('<div class="inverse" id="navbar-height-col"></div>')); $('#slide-nav.navbar-default').after($('<div id="navbar-height-col"></d
Read more