Skip to content

Instantly share code, notes, and snippets.

@TylerBrock
Created July 4, 2012 17:29
Show Gist options
  • Save TylerBrock/3048467 to your computer and use it in GitHub Desktop.
Save TylerBrock/3048467 to your computer and use it in GitHub Desktop.
MongoDB v2.1.2 fsyncUnlock()
Wed Jul 4 13:23:37 [conn1587] end connection 127.0.0.1:50894 (5 connections now open)
Wed Jul 4 13:23:37 [conn1581] end connection 127.0.0.1:50888 (4 connections now open)
Wed Jul 4 13:23:37 [conn1589] end connection 127.0.0.1:50896 (3 connections now open)
Wed Jul 4 13:23:37 [conn1591] end connection 127.0.0.1:50898 (2 connections now open)
Wed Jul 4 13:23:42 [conn59] CMD fsync: sync:1 lock:1
Wed Jul 4 13:23:43 [fsyncLockWorker] removeJournalFiles
Wed Jul 4 13:23:43 [conn59] db is now locked for snapshotting, no writes allowed. db.fsyncUnlock() to unlock
Wed Jul 4 13:23:43 [conn59] For more info see http://www.mongodb.org/display/DOCS/fsync+Command
Wed Jul 4 13:23:43 [conn59] command admin.$cmd command: { fsync: 1.0, lock: true } ntoreturn:1 keyUpdates:0 locks(micros) W:10958 r:1268 reslen:168 699ms
Wed Jul 4 13:23:44 [conn59] CMD fsync: sync:1 lock:1
Wed Jul 4 13:23:44 [conn59] db is now locked for snapshotting, no writes allowed. db.fsyncUnlock() to unlock
Wed Jul 4 13:23:44 [conn59] For more info see http://www.mongodb.org/display/DOCS/fsync+Command
Wed Jul 4 13:23:45 [conn59] CMD fsync: sync:1 lock:1
Wed Jul 4 13:23:45 [conn59] db is now locked for snapshotting, no writes allowed. db.fsyncUnlock() to unlock
Wed Jul 4 13:23:45 [conn59] For more info see http://www.mongodb.org/display/DOCS/fsync+Command
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50900 #1593 (3 connections now open)
Wed Jul 4 13:23:47 [conn1593] end connection 127.0.0.1:50900 (2 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50901 #1594 (3 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50902 #1595 (4 connections now open)
Wed Jul 4 13:23:47 [conn1595] end connection 127.0.0.1:50902 (3 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50903 #1596 (4 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50904 #1597 (5 connections now open)
Wed Jul 4 13:23:47 [conn1597] end connection 127.0.0.1:50904 (4 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50905 #1598 (5 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50906 #1599 (6 connections now open)
Wed Jul 4 13:23:47 [conn1599] end connection 127.0.0.1:50906 (5 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50907 #1600 (6 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50908 #1601 (7 connections now open)
Wed Jul 4 13:23:47 [conn1601] end connection 127.0.0.1:50908 (6 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50909 #1602 (7 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50910 #1603 (8 connections now open)
Wed Jul 4 13:23:47 [conn1603] end connection 127.0.0.1:50910 (7 connections now open)
Wed Jul 4 13:23:47 [initandlisten] connection accepted from 127.0.0.1:50911 #1604 (8 connections now open)
Wed Jul 4 13:23:48 [initandlisten] connection accepted from 127.0.0.1:50912 #1605 (9 connections now open)
Wed Jul 4 13:23:48 [conn1605] end connection 127.0.0.1:50912 (8 connections now open)
Wed Jul 4 13:23:53 [conn59] command: unlock requested
Wed Jul 4 13:23:54 [fsyncLockWorker] removeJournalFiles
Wed Jul 4 13:24:05 [conn59] command: unlock requested
Wed Jul 4 13:24:05 [fsyncLockWorker] info journal _rotate called inside dbMutex - ok but should be somewhat rare
Wed Jul 4 13:24:05 [fsyncLockWorker] removeJournalFiles
Wed Jul 4 13:24:19 [conn59] command: unlock requested
Wed Jul 4 13:24:19 [conn1596] remove ruby-test-db.test keyUpdates:0 numYields: 4 locks(micros) w:30093 25526ms
Wed Jul 4 13:24:20 [conn1598] info DFM::findAll(): extent 0:2000 was empty, skipping ahead. ns:ruby-test-db.test
Wed Jul 4 13:24:21 [conn1600] getMore: cursorid not found ruby-test-db.test 1234567890
Wed Jul 4 13:24:21 [conn1600] remove ruby-test-db.test keyUpdates:0 numYields: 1 locks(micros) r:1098 w:671365 142ms
Wed Jul 4 13:24:22 [conn1598] end connection 127.0.0.1:50905 (7 connections now open)
Wed Jul 4 13:24:22 [conn1596] end connection 127.0.0.1:50903 (6 connections now open)
Wed Jul 4 13:24:22 [conn1600] end connection 127.0.0.1:50907 (5 connections now open)
Wed Jul 4 13:24:22 [conn1594] end connection 127.0.0.1:50901 (4 connections now open)
Wed Jul 4 13:24:22 [conn1602] end connection 127.0.0.1:50909 (3 connections now open)
Wed Jul 4 13:24:22 [conn1604] end connection 127.0.0.1:50911 (2 connections now open)
> db.runCommand({fsync: 1, lock: true})
{
"info" : "now locked against writes, use db.fsyncUnlock() to unlock",
"seeAlso" : "http://www.mongodb.org/display/DOCS/fsync+Command",
"ok" : 1
}
> db.$cmd.sys.inprog.findOne()
{
"inprog" : [
{
"opid" : 264187,
"active" : false,
"op" : "remove",
"ns" : "",
"query" : {
},
"client" : "127.0.0.1:50507",
"desc" : "conn1212",
"threadId" : "0x102b0a000",
"connectionId" : 1212,
"locks" : {
"^ruby-test-db" : "W"
},
"waitingForLock" : true,
"numYields" : 0,
"lockStatMillis" : {
"timeLocked" : {
},
"timeAcquiring" : {
}
}
},
{
"opid" : 264171,
"active" : false,
"op" : "insert",
"ns" : "",
"query" : {
},
"client" : "127.0.0.1:50483",
"desc" : "conn1208",
"threadId" : "0x104493000",
"connectionId" : 1208,
"locks" : {
"^" : "w",
"^ruby-test-db" : "W"
},
"waitingForLock" : true,
"numYields" : 0,
"lockStatMillis" : {
"timeLocked" : {
"r" : NumberLong(88),
"w" : NumberLong(0)
},
"timeAcquiring" : {
"r" : NumberLong(8),
"w" : NumberLong(0)
}
}
}
],
"fsyncLock" : true,
"info" : "use db.fsyncUnlock() to terminate the fsync write/snapshot lock"
}
> db.fsyncUnlock()
{ "ok" : 1, "info" : "unlock completed" }
> db.$cmd.sys.inprog.findOne()
{
"inprog" : [
{
"opid" : 264200,
"active" : false,
"op" : "insert",
"ns" : "",
"query" : {
},
"client" : "127.0.0.1:50507",
"desc" : "conn1212",
"threadId" : "0x102b0a000",
"connectionId" : 1212,
"locks" : {
"^" : "w",
"^ruby-test-db" : "W"
},
"waitingForLock" : true,
"numYields" : 0,
"lockStatMillis" : {
"timeLocked" : {
"r" : NumberLong(140),
"w" : NumberLong(3262)
},
"timeAcquiring" : {
"r" : NumberLong(37805),
"w" : NumberLong(11516317)
}
}
}
],
"fsyncLock" : true,
"info" : "use db.fsyncUnlock() to terminate the fsync write/snapshot lock"
}
> db.fsyncUnlock()
{ "ok" : 1, "info" : "unlock completed" }
> db.fsyncUnlock()
{ "ok" : 0, "errmsg" : "not locked" }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment