|
It's not a bug, but update a big document( 1623k ) lead to hang. Everything goes well after that document was removed.
# PRIMARY
|
2015-06-17T16:46:05.104+0800 [conn8494881] update 01i1l2w9vdspol2qhzqvdgkv9zahwu8ovuw29rlokqb2xn8p._Role query: { _id: ObjectId('55652c8be4b0328678ae3bfe') } update: { $set: { updatedAt: new Date(1434530725396) }, $addToSet: { users: { $each: [ { $ref: "_User", $id: ObjectId('558133a5e4b0a83febf20914') } ] } } } nscanned:1 nscannedObjects:1 nMatched:1 nModified:1 keyUpdates:2 numYields:0 locks(micros) w:39710443 39708ms
|
# SECONDARY
|
2015-06-17T16:46:05.545+0800 [repl writer worker 3] warning: log line attempted (1623k) over max size (10k), printing beginning and end ... applying op: { ts: Timestamp 1434530
|
765000|1, h: -7048969912752559951, v: 2, op: "u", ns: "01i1l2w9vdspol2qhzqvdgkv9zahwu8ovuw29rlokqb2xn8p._Role", o2: { _id: ObjectId('55652c8be4b0328678ae3bfe') }, o: { $set: {
|
updatedAt: new Date(1434530725396), users: [ { $ref: "_User", $id: ObjectId('552e2d06e4b0c0794dbf8794') }, { $ref: "_User", $id: ObjectId('55653f6be4b0328678afd776') }, { $ref:
|
"_User", $id: ObjectId('555d78f2e4b06e8bb82e1694') }, { $ref: "_User", $id: ObjectId('5567d78de4b0349d331272f1') }, { $ref: "_User", $id: ObjectId('5567e862e4b0a9a973e720f9')
|
}, { $ref: "_User", $id: ObjectId('5567fa14e4b0349d3314464f') }, { $ref: "_User", $id: ObjectId('5567fa14e4b0349d33144650') }, { $ref: "_User", $id: ObjectId('5567fb9ce4b0349d3
|
31458f9') }, { $ref: "_User", $id: ObjectId('55680549e4b0349d3314dcef') }, { $ref: "_User", $id: ObjectId('556814bee4b0349d33158559') }, { $ref: "_User", $id: ObjectId('552f629
|
de4b060d72a8cc0fa') }, { $ref: "_User", $id: ObjectId('5530c384e4b052897f252102') }, { $ref: "_User", $id: ObjectId('5535e90ce4b07b48cfca4b5b') }, { $ref: "_User", $id: ObjectI
|
d('5538c38ae4b019188efd5d89') }, { $ref: "_User", $id: ObjectId('552d3093e4b00e097d9fa34f') }, { $ref: "_User", $id: ObjectId('5530b437e4b078a906e5cd40') }, { $ref: "_User", $i
|
d: ObjectId('5530b56ce4b05ce8328d192a') }, { $ref: "_User", $id: ObjectId('555aa87de4b032fcf1906a36') }, { $ref: "_User", $id: ObjectId('5530b3b7e4b052897f2441fa') }, { $ref: "
|
_User", $id: ObjectId('555db144e4b0283b38a604c0') }, { $ref: "_User", $id: ObjectId('555e0557e4b0ce84eb23be70') }, { $ref: "_User", $id: ObjectId('552e0fb1e4b0c29c3c986e8b') },
|
{ $ref: "_User", $id: ObjectId('552f5fb7e4b036ba524942e6') }, { $ref: "_User", $id: ObjectId('552e2bcce4b036ba524067ad') }, { $ref: "_User", $id: ObjectId('552e4631e4b060d72a8
|
4065d') }, { $ref: "_User", $id: ObjectId('5530b426e4b0825685cdc3f6') }, { $ref: "_User", $id: ObjectId('5530b4c1e4b0825685cdd5fa') }, { $ref: "_User", $id: ObjectId('5538be1be
|
4b0301dbb0cf021') }, { $ref: "_User", $id: ObjectId('5538be4ce4b0301dbb0cf214') }, { $ref: "_User", $id: ObjectId('5538be6de4b0cafb0a1f3bf7') }, { $ref: "_User", $id: ObjectId(
|
'552f6353e4b060d72a8ccacf') }, { $ref: "_User", $id: ObjectId('5555952fe4b058f8987111d9') }, { $ref: "_User", $id: ObjectId('5556b990e4b0325161229007') }, { $ref: "_User", $id:
|
ObjectId('5556cd8ce4b0325161234751') }, { $ref: "_User", $id: ObjectId('5556d76ee4b058f898786495') }, { $ref: "_User", $id: ObjectId('5556d7bce4b058f89878674b') }, { $ref: "_U
|
ser", $id: ObjectId('552f8aa8e4b060d72a8edaea') }, { $ref: "_User", $id: ObjectId('555950b6e4b0137a4e2bc390') }, { $ref: "_User", $id: ObjectId('555951ace4b0b8cd3b7b1fcb') }, {
|
$ref: "_User", $id: ObjectId('555951e9e4b0764298c72e5b') }, { $ref: "_User", $id: ObjectId('55595270e4b0764298c732c9') }, { $ref: "_User", $id: ObjectId('55595292e4b0764298c73
|
408') }, { $ref: "_User", $id: ObjectId('555953e5e4b0764298c73f23') }, { $ref: "_User", $id: ObjectId('55595610e4b0b8cd3b7b4a23') }, { $ref: "_User", $id: ObjectId('5559587de4b
|
0b8cd3b7b62cb') }, { $ref: "_User", $id: ObjectId('5555c5c2e4b03251611c1aaf') }, { $ref: "_User", $id: ObjectId('552e104be4b036ba523f9fe2') }, { $ref: "_User", $id: ObjectId('5
|
5598bdce4b0b8cd3b7e5752') }, { $ref: "_User", $id: ObjectId('5555b08ce4b0a343c5c19cde') }, { $ref: "_User", $id: ObjectId('5530b5f8e4b05ce8328d2758') }, { $ref: "_User", $id: O
|
bjectId('5559c4d5e4b0764298cb7878 .......... ef: "_User", $id: ObjectId('556d46a2e4b06d91e724891b') }, { $ref: "_User", $id: ObjectId('556c14d5e4b0982c278a5aa1') }, { $ref: "_U
|
ser", $id: ObjectId('55794c64e4b0f9862a219f0d') }, { $ref: "_User", $id: ObjectId('55682061e4b0349d33164cef') }, { $ref: "_User", $id: ObjectId('5566da7fe4b02c6f9035792c') }, {
|
$ref: "_User", $id: ObjectId('55796b01e4b022be6f9ae76c') }, { $ref: "_User", $id: ObjectId('55796ebae4b0283dd00f724e') }, { $ref: "_User", $id: ObjectId('55799f59e4b04876b85fc
|
497') }, { $ref: "_User", $id: ObjectId('5579b91ce4b0283dd01f15ca') }, { $ref: "_User", $id: ObjectId('557a1167e4b018bc3d4c1776') }, { $ref: "_User", $id: ObjectId('557a3c30e4b
|
0283dd02ab9cb') }, { $ref: "_User", $id: ObjectId('557a528ae4b0bcc24ad2fbdd') }, { $ref: "_User", $id: ObjectId('557aaf45e4b04876b8725431') }, { $ref: "_User", $id: ObjectId('5
|
57ab18ce4b052e03140eb3f') }, { $ref: "_User", $id: ObjectId('557bdf8de4b0a83feba70215') }, { $ref: "_User", $id: ObjectId('557bf09ee4b0cc6267b5dcf8') }, { $ref: "_User", $id: O
|
bjectId('557c735ae4b0bd33aa1b7e58') }, { $ref: "_User", $id: ObjectId('557ced21e4b02f9923710e8a') }, { $ref: "_User", $id: ObjectId('557d314fe4b02f992373bbb8') }, { $ref: "_Use
|
r", $id: ObjectId('557d3374e4b042e8c09cff91') }, { $ref: "_User", $id: ObjectId('557d339de4b042e8c09d0236') }, { $ref: "_User", $id: ObjectId('557d37bde4b042e8c09d7ed6') }, { $
|
ref: "_User", $id: ObjectId('557d3fd9e4b035745aa9408f') }, { $ref: "_User", $id: ObjectId('557d74d6e4b0cc6267e99ee9') }, { $ref: "_User", $id: ObjectId('557d96a1e4b007f322aea9f
|
4') }, { $ref: "_User", $id: ObjectId('557dfc56e4b0a83febc4db2c') }, { $ref: "_User", $id: ObjectId('557e3e8be4b035745aba1a67') }, { $ref: "_User", $id: ObjectId('557e67b4e4b0c
|
c626801f5a3') }, { $ref: "_User", $id: ObjectId('557e750ee4b035745abcbd7f') }, { $ref: "_User", $id: ObjectId('557e7868e4b0cc6268042ba3') }, { $ref: "_User", $id: ObjectId('557
|
e7e22e4b035745abd5094') }, { $ref: "_User", $id: ObjectId('557e8bafe4b00c79c4143fc2') }, { $ref: "_User", $id: ObjectId('557e8dc3e4b0a83febcf5573') }, { $ref: "_User", $id: Obj
|
ectId('557e8df6e4b0a573eb62c20d') }, { $ref: "_User", $id: ObjectId('557e8fdee4b0a83febcf7a56') }, { $ref: "_User", $id: ObjectId('557e903ce4b00c79c414c9f4') }, { $ref: "_User"
|
, $id: ObjectId('557e91b2e4b00c79c414fa3d') }, { $ref: "_User", $id: ObjectId('557e9ef8e4b00c79c417026c') }, { $ref: "_User", $id: ObjectId('557ea18ae4b00c79c417687c') }, { $re
|
f: "_User", $id: ObjectId('557f7fd9e4b02f992383a7aa') }, { $ref: "_User", $id: ObjectId('557f9986e4b007f322c429b4') }, { $ref: "_User", $id: ObjectId('557fa29de4b0d02dc2d919e8'
|
) }, { $ref: "_User", $id: ObjectId('557fa2e2e4b0a83febdd86c9') }, { $ref: "_User", $id: ObjectId('557fa32ae4b0d02dc2d92f58') }, { $ref: "_User", $id: ObjectId('557fd1d3e4b019e
|
ef75b6774') }, { $ref: "_User", $id: ObjectId('557fd545e4b0a83febe078c8') }, { $ref: "_User", $id: ObjectId('558041e0e4b0d02dc2f9900e') }, { $ref: "_User", $id: ObjectId('55804
|
2ece4b007f322ce8c59') }, { $ref: "_User", $id: ObjectId('5580d7b4e4b019eef76de640') }, { $ref: "_User", $id: ObjectId('5580e2a7e4b019eef76ecda5') }, { $ref: "_User", $id: Objec
|
tId('55811352e4b0bd33aa51fdd0') }, { $ref: "_User", $id: ObjectId('55811736e4b035745ad3ef61') }, { $ref: "_User", $id: ObjectId('5581247be4b0bd33aa52fb7d') }, { $ref: "_User",
|
$id: ObjectId('5581279be4b0a83febf14d14') }, { $ref: "_User", $id: ObjectId('558133a5e4b0a83febf20914') } ] } } }
|
The maximum BSON document size is 16 megabytes. 1623kb is much less than 16 megabytes, I wonder know why this update query so slow?
|