Skip to content

Instantly share code, notes, and snippets.

@skippy
Created April 1, 2010 08:17
Show Gist options
  • Save skippy/351548 to your computer and use it in GitHub Desktop.
Save skippy/351548 to your computer and use it in GitHub Desktop.
Thu Apr 1 08:03:54 runQuery: mapp-staging.entries{ orig_relative_time: new Date(1263657120000), owner_id: 22, owner_type: "Place::Visit", value: 83.0 }
Thu Apr 1 08:03:54 query mapp-staging.entries ntoreturn:1 reslen:289 nreturned:1 1ms
Thu Apr 1 08:03:54 runQuery: mapp-staging.entries{ orig_relative_time: new Date(1263646920000), owner_id: 22, owner_type: "Place::Visit", value: 119.0 }
Thu Apr 1 08:03:54 query mapp-staging.entries ntoreturn:1 reslen:289 nreturned:1 1ms
Thu Apr 1 08:03:54 runQuery: mapp-staging.entries{ orig_relative_time: new Date(1263639900000), owner_id: 22, owner_type: "Place::Visit", value: 129.0 }
Thu Apr 1 08:03:54 query mapp-staging.entries ntoreturn:1 reslen:289 nreturned:1 1ms
Thu Apr 1 08:03:54 runQuery: mapp-staging.entries{ orig_relative_time: new Date(1263627420000), owner_id: 22, owner_type: "Place::Visit", value: 107.0 }
Thu Apr 1 08:03:54 query mapp-staging.entries ntoreturn:1 reslen:289 nreturned:1 1ms
Thu Apr 1 08:03:54 runQuery: mapp-staging.downloads{ owner_id: 22, owner_type: "Place::Visit" }
Thu Apr 1 08:03:54 query mapp-staging.downloads ntoreturn:1 reslen:345 nreturned:1 0ms
Thu Apr 1 08:03:55 getmore local.oplog.$main cid:3272836936778887933 ntoreturn:0 query: { ts: { $gte: new Date(5455046827462098945) } } bytes:20 nreturned:0 0ms
Thu Apr 1 08:03:55 getmore local.oplog.$main cid:3272836936778887933 ntoreturn:0 query: { ts: { $gte: new Date(5455046827462098945) } } bytes:20 nreturned:0 0ms
Thu Apr 1 08:03:57 getmore local.oplog.$main cid:3272836936778887933 ntoreturn:0 query: { ts: { $gte: new Date(5455046827462098945) } } bytes:20 nreturned:0 0ms
Thu Apr 1 08:03:57 getmore local.oplog.$main cid:3272836936778887933 ntoreturn:0 query: { ts: { $gte: new Date(5455046827462098945) } } bytes:20 nreturned:0 0ms
Thu Apr 1 08:03:59 getmore local.oplog.$main cid:3272836936778887933 ntoreturn:0 query: { ts: { $gte: new Date(5455046827462098945) } } bytes:20 nreturned:0 0ms
Thu Apr 1 08:03:59 getmore local.oplog.$main cid:3272836936778887933 ntoreturn:0 query: { ts: { $gte: new Date(5455046827462098945) } } bytes:20 nreturned:0 0ms
in rails, it is hanging right on the mapp-staging.downloads, and here is what is printed to my rails log (with more verbosity on my app's part)
FIND ONE: {:owner_id=>22, :owner_type=>"Place::Visit"} -------- {:sort=>nil, :limit=>0, :skip=>1, :fields=>nil} -- downloads
MONGODB mapp-staging.downloads.find({:owner_id=>22, :owner_type=>"Place::Visit"}, {}).skip(1).limit(-1)
@skippy
Copy link
Author

skippy commented Apr 1, 2010

commands from the db run while locking:

db.serverStatus()
{
"uptime" : 8170,
"localTime" : "Thu Apr 01 2010 08:24:06 GMT+0000 (UTC)",
"globalLock" : {
"totalTime" : 8169363425,
"lockTime" : 210879,
"ratio" : 0.000025813394389416577
},
"mem" : {
"resident" : 38,
"virtual" : 1460,
"supported" : true,
"mapped" : 1312
},
"connections" : {
"current" : 3,
"available" : 19997
},
"extra_info" : {
"note" : "fields vary by platform",
"heap_usage_bytes" : 990800,
"page_faults" : 2
},
"indexCounters" : {
"btree" : {
"accesses" : 1,
"hits" : 1,
"misses" : 0,
"resets" : 0,
"missRatio" : 0
}
},
"backgroundFlushing" : {
"flushes" : 898,
"total_ms" : 5970,
"average_ms" : 6.648106904231626,
"last_ms" : 7,
"last_finished" : "Thu Apr 01 2010 08:23:58 GMT+0000 (UTC)"
},
"repl" : {
"ismaster" : 1,
"msg" : "not paired"
},
"opcounters" : {
"insert" : 18,
"query" : 2112,
"update" : 16,
"delete" : 0,
"getmore" : 9823,
"command" : 30
},
"asserts" : {
"regular" : 0,
"warning" : 0,
"msg" : 0,
"user" : 0,
"rollovers" : 0
},
"ok" : 1
}
db.getPrevError()
{ "err" : null, "n" : 0, "nPrev" : -1, "ok" : 1 }
db.currentOp()
{ "inprog" : [ ] }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment