Skip to content

Instantly share code, notes, and snippets.

@cablehead

cablehead/db.currentOp only jobs not waiting for lock.json

Created April 27, 2012 23:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cablehead/2514315 to your computer and use it in GitHub Desktop.
Save cablehead/2514315 to your computer and use it in GitHub Desktop.
Download ZIP
mongo lock up on service restart
Raw
db.currentOp only jobs not waiting for lock.json
{
"opid" : 922414160,
"active" : true,
"waitingForLock" : false,
"secs_running" : 6,
"op" : "query",
"ns" : "",
"query" : {
"writebacklisten" : ObjectId("4f9204fb36dcde4b00f48481")
},
"client" : "10.194.227.159:50542",
"desc" : "conn",
"threadId" : "0x7eb18aad8700",
"connectionId" : 5630315,
"numYields" : 0
},
and
{
"opid" : 922413127,
"active" : true,
"lockType" : "write",
"waitingForLock" : false,
"secs_running" : 106,
"op" : "query",
"ns" : "chalk-bump-f49",
"query" : {
"$eval" : function cf__9_anon() {
return ObjectId();
},
"args" : [ ]
},
"client" : "10.194.227.159:43111",
"desc" : "conn",
"threadId" : "0x7eaa7c0fe700",
"connectionId" : 7447116,
"numYields" : 0
},
Raw
db.currentOp: only jobs not waiting for lock.json
{
"opid" : 922414160,
"active" : true,
"waitingForLock" : false,
"secs_running" : 6,
"op" : "query",
"ns" : "",
"query" : {
"writebacklisten" : ObjectId("4f9204fb36dcde4b00f48481")
},
"client" : "10.194.227.159:50542",
"desc" : "conn",
"threadId" : "0x7eb18aad8700",
"connectionId" : 5630315,
"numYields" : 0
},
and
{
"opid" : 922413142,
"active" : false,
"lockType" : "write",
"waitingForLock" : true,
"op" : "insert",
"ns" : "",
"query" : {
},
"client" : "10.194.227.159:52586",
"desc" : "conn",
"threadId" : "0x7ea275471700",
"connectionId" : 8831441,
"numYields" : 0
},
Raw
mongostat - end of lockup.txt
0 0 0 0 0 8 0 242g 486g 9.06g 0 0 0 104|264 103|264 762b 89k 556 simperium1 M 23:22:58
0 0 0 0 0 7 0 242g 486g 9.06g 0 0 0 104|264 103|264 518b 89k 555 simperium1 M 23:22:59
0 0 0 0 0 8 0 242g 486g 9.06g 0 0 0 104|266 103|266 762b 89k 555 simperium1 M 23:23:00
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
0 0 0 0 0 6 0 242g 486g 9.06g 0 0 0 104|266 103|266 460b 89k 553 simperium1 M 23:23:01
0 1 0 0 0 9 0 242g 486g 9.06g 0 0 0 105|266 104|266 860b 92k 554 simperium1 M 23:23:02
0 0 0 0 0 4 1 242g 486g 9.06g 0 0 0 105|266 104|266 266b 5k 550 simperium1 M 23:23:03
0 1 0 0 0 10 0 242g 486g 9.06g 0 0 0 106|266 105|266 878b 91k 551 simperium1 M 23:23:04
0 0 0 0 0 12 0 242g 486g 9.06g 0 0 0 106|266 105|266 832b 93k 551 simperium1 M 23:23:05
0 0 0 0 0 8 0 242g 486g 9.06g 0 0 0 106|266 105|266 762b 90k 550 simperium1 M 23:23:06
0 0 0 0 0 6 0 242g 486g 9.06g 0 0 0 106|266 105|266 460b 90k 548 simperium1 M 23:23:07
142 6 1 0 0 152 0 242g 485g 9.06g 0 2.88e+04 0 5|275 5|275 38k 148k 454 simperium1 M 23:23:08
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 5|275 5|275 376b 64k 454 simperium1 M 23:23:09
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 5|275 5|275 568b 5k 453 simperium1 M 23:23:10
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 5|276 5|276 460b 67k 453 simperium1 M 23:23:11
0 0 0 0 0 8 0 242g 485g 9.06g 0 0 0 6|276 5|276 762b 67k 451 simperium1 M 23:23:12
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 6|276 5|276 460b 67k 450 simperium1 M 23:23:13
0 0 0 0 0 8 0 242g 485g 9.06g 0 0 0 6|276 5|276 762b 67k 448 simperium1 M 23:23:14
0 1 0 0 0 14 0 242g 485g 9.06g 0 0 0 7|276 6|276 948b 71k 450 simperium1 M 23:23:15
0 0 0 0 0 8 0 242g 485g 9.06g 0 0 0 7|277 6|277 762b 67k 447 simperium1 M 23:23:16
0 1 0 0 0 8 0 242g 485g 9.06g 0 0 0 8|277 7|277 576b 68k 448 simperium1 M 23:23:17
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 8|277 7|277 682b 67k 449 simperium1 M 23:23:18
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 8|277 7|277 386b 7k 447 simperium1 M 23:23:19
0 0 0 0 0 8 0 242g 485g 9.06g 0 0 0 8|277 7|277 762b 68k 447 simperium1 M 23:23:20
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
0 0 0 0 0 6 0 242g 485g 9.06g 0 0 0 8|277 7|277 398b 66k 446 simperium1 M 23:23:21
0 0 0 0 0 7 0 242g 485g 9.06g 0 0 0 8|277 7|277 762b 68k 445 simperium1 M 23:23:22
0 0 0 0 0 7 0 242g 485g 9.06g 0 0 0 8|277 7|277 460b 67k 440 simperium1 M 23:23:23
0 4 0 0 0 16 0 242g 485g 9.06g 0 0 0 12|277 11|277 1k 72k 446 simperium1 M 23:23:24
688 426 38 0 0 831 0 242g 485g 9.07g 9 1.7e+03 0 21|138 23|138 248k 498k 432 simperium1 M 23:23:25
495 499 22 0 0 587 0 242g 485g 9.07g 22 32.5 0 53|68 53|69 242k 305k 436 simperium1 M 23:23:26
276 1297 58 0 0 461 0 242g 485g 9.11g 27 40.5 0 64|8 65|9 371k 1m 437 simperium1 M 23:23:27
65 843 11 0 0 126 0 242g 485g 9.11g 12 52.7 0 72|21 73|21 137k 357k 436 simperium1 M 23:23:28
181 778 32 0 0 359 0 242g 485g 9.07g 19 22 0 4|0 4|1 264k 4m 436 simperium1 M 23:23:30
89 1124 15 0 0 178 0 242g 485g 9.05g 14 23.6 0 0|0 0|0 175k 491k 436 simperium1 M 23:23:31
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
47 855 5 0 0 82 0 242g 485g 9.05g 0 0.6 0 0|0 0|0 111k 324k 436 simperium1 M 23:23:32
16 932 3 0 1 36 0 242g 485g 9.05g 2 0.7 0 0|0 0|0 106k 595k 436 simperium1 M 23:23:33
50 1032 9 0 0 94 0 242g 485g 9.05g 3 1.2 0 0|0 0|0 136k 389k 436 simperium1 M 23:23:34
50 946 4 0 2 83 0 242g 485g 9.06g 6 8.8 0 0|0 0|0 121k 4m 436 simperium1 M 23:23:35
16 754 4 0 5 49 0 242g 485g 9.06g 5 0.4 0 0|0 0|0 92k 283k 436 simperium1 M 23:23:36
77 1093 6 0 54 125 0 242g 485g 9.05g 5 14.5 0 10|2 11|2 144k 427k 436 simperium1 M 23:23:37
59 918 6 0 47 93 0 242g 485g 9.05g 4 3.9 0 0|0 1|0 125k 363k 436 simperium1 M 23:23:38
44 696 4 0 13 78 0 242g 485g 9.06g 11 4.4 0 37|3 38|3 91k 301k 436 simperium1 M 23:23:39
178 1018 11 0 40 231 0 242g 485g 9.05g 13 9.3 0 10|6 11|6 179k 4m 436 simperium1 M 23:23:40
191 775 21 0 26 305 0 242g 485g 9.06g 18 14.6 0 4|1 6|1 191k 437k 436 simperium1 M 23:23:41
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
116 570 9 0 3 175 0 242g 485g 9.05g 8 6.3 0 0|0 0|0 113k 339k 436 simperium1 M 23:23:42
Raw
mongostat - start of lockup.txt
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
16 346 23 0 37 115 0 242g 486g 9.06g 0 1 0 0|0 0|0 82k 696k 561 simperium1 M 23:16:44
13 291 89 0 69 184 0 242g 486g 9.08g 6 9.1 0 0|0 1|0 102k 4m 557 simperium1 M 23:16:45
6 281 13 0 16 77 0 242g 486g 9.06g 2 1.6 0 5|1 6|1 74k 704k 559 simperium1 M 23:16:46
23 123 10 0 13 58 0 242g 486g 9.06g 26 0.9 0 4|2 5|2 38k 621k 557 simperium1 M 23:16:47
20 298 19 0 30 95 0 242g 486g 9.06g 11 11.8 0 0|0 1|0 76k 556k 557 simperium1 M 23:16:48
17 290 12 0 25 95 0 242g 486g 9.07g 1 1.7 0 0|0 1|0 62k 531k 562 simperium1 M 23:16:49
14 361 43 0 49 130 0 242g 486g 9.06g 4 3.8 0 0|0 1|0 110k 5m 565 simperium1 M 23:16:50
12 340 42 0 42 119 0 242g 486g 9.06g 0 1.1 0 0|0 1|0 101k 903k 561 simperium1 M 23:16:51
12 283 34 0 38 102 0 242g 486g 9.06g 4 3.7 0 0|0 1|0 77k 608k 559 simperium1 M 23:16:52
9 269 23 0 29 87 0 242g 486g 9.06g 1 1.8 0 0|0 1|0 94k 690k 559 simperium1 M 23:16:53
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
12 250 17 0 22 95 0 242g 486g 9.06g 2 5.9 0 0|0 1|0 108k 732k 558 simperium1 M 23:16:54
9 288 80 0 54 171 0 242g 486g 9.08g 9 10.6 0 0|0 2|0 168k 6m 563 simperium1 M 23:16:55
24 311 25 0 41 125 0 242g 486g 9.09g 1 0.6 0 0|0 1|0 79k 732k 562 simperium1 M 23:16:56
13 318 25 0 30 109 0 242g 486g 9.08g 1 0.8 0 0|0 2|0 78k 665k 561 simperium1 M 23:16:57
27 291 29 0 35 133 0 242g 486g 9.06g 5 5.9 0 0|0 1|0 88k 561k 559 simperium1 M 23:16:58
15 285 33 0 42 120 0 242g 486g 9.06g 0 1 0 0|0 1|0 82k 716k 563 simperium1 M 23:16:59
8 320 30 0 35 107 0 242g 486g 9.06g 1 1 0 0|0 1|0 85k 645k 563 simperium1 M 23:17:00
19 286 21 0 35 106 0 242g 486g 9.06g 0 0.6 0 0|0 1|0 93k 4m 558 simperium1 M 23:17:01
4 237 8 0 9 62 0 242g 486g 9.06g 26 1.8 0 5|2 6|2 47k 376k 559 simperium1 M 23:17:02
14 168 14 0 11 54 0 242g 486g 9.06g 27 3.2 0 3|2 5|2 41k 170k 561 simperium1 M 23:17:03
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
13 178 22 0 21 88 0 242g 486g 9.06g 21 11 0 0|0 1|0 102k 706k 558 simperium1 M 23:17:04
7 395 42 0 37 118 0 242g 486g 9.07g 4 1.3 0 0|0 1|0 193k 5m 561 simperium1 M 23:17:05
19 471 85 0 76 178 1 242g 486g 9.08g 8 3.6 0 8|1 9|1 137k 1m 561 simperium1 M 23:17:06
4 201 9 0 10 43 0 242g 486g 9.05g 23 1.4 0 0|0 2|0 40k 718k 566 simperium1 M 23:17:07
101 431 42 0 65 301 0 242g 486g 9.06g 19 9.1 0 0|0 0|0 171k 604k 561 simperium1 M 23:17:08
8 492 60 0 47 114 0 242g 486g 9.05g 0 1.5 0 0|0 1|0 112k 905k 574 simperium1 M 23:17:09
1 238 46 0 39 87 0 242g 486g 9.06g 0 0.3 0 21|2 21|3 80k 940k 560 simperium1 M 23:17:10
0 15 0 0 0 6 0 242g 486g 9.06g 0 0 0 38|4 37|4 398b 14k 560 simperium1 M 23:17:11
0 12 0 0 0 7 0 242g 486g 9.06g 0 0 0 50|4 49|4 700b 18k 560 simperium1 M 23:17:12
0 16 0 0 0 6 0 242g 486g 9.06g 0 0 0 67|4 66|4 398b 21k 560 simperium1 M 23:17:13
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
0 10 0 0 0 8 0 242g 486g 9.06g 0 0 0 78|5 77|5 700b 25k 560 simperium1 M 23:17:14
0 11 0 0 0 11 0 242g 486g 9.06g 0 0 0 90|5 89|5 690b 31k 561 simperium1 M 23:17:15
0 9 1 0 0 6 0 242g 486g 9.06g 0 0 0 99|6 98|6 564b 4k 560 simperium1 M 23:17:16
0 17 0 0 0 5 0 242g 486g 9.06g 0 0 0 116|7 115|7 398b 31k 560 simperium1 M 23:17:17
0 14 0 0 0 7 0 242g 486g 9.06g 0 0 0 130|7 129|7 700b 36k 560 simperium1 M 23:17:18
0 11 0 0 0 6 0 242g 486g 9.06g 0 0 0 141|7 140|7 456b 39k 560 simperium1 M 23:17:19
0 10 0 0 0 7 0 242g 486g 9.06g 0 0 0 151|8 150|8 700b 44k 560 simperium1 M 23:17:20
0 11 0 0 0 7 0 242g 486g 9.06g 0 0 0 164|8 163|8 398b 46k 560 simperium1 M 23:17:21
0 10 0 0 0 7 0 242g 486g 9.06g 0 0 0 174|8 173|8 700b 49k 560 simperium1 M 23:17:22
0 9 0 0 0 6 0 242g 486g 9.06g 0 0 0 183|9 182|9 549b 52k 560 simperium1 M 23:17:23
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
0 10 0 0 0 6 0 242g 486g 9.06g 0 0 0 193|9 192|9 549b 56k 560 simperium1 M 23:17:24
0 14 0 0 0 12 0 242g 486g 9.06g 0 0 0 207|9 206|9 921b 62k 560 simperium1 M 23:17:25
0 10 0 0 0 5 0 242g 486g 9.06g 0 0 0 217|9 216|9 469b 61k 561 simperium1 M 23:17:26
0 1 0 0 0 6 0 242g 486g 9.06g 0 0 0 219|10 218|10 506b 4k 560 simperium1 M 23:17:27
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment