-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Tools
-
None
-
ALL
I want to restore a 10GB collection to a db. So I use mongorestore to do this.
mongorestore -d aricareRealtimeDB aircareRealtimeDB/
After a long time:
2016-03-08T15:36:51.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:36:54.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:36:57.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:00.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:03.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:06.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:09.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:12.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:15.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:18.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:21.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:24.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:27.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:30.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:33.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:36.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:39.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:42.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:45.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:48.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:51.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:54.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:37:57.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:00.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:03.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:06.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:09.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:12.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:15.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:18.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:21.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:24.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:27.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:30.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:33.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:36.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:39.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:42.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:45.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:48.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:51.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:54.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:38:57.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:39:00.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:39:03.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:39:06.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:39:09.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:39:12.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%) 2016-03-08T15:39:15.888+0800 [........................] arcareRealtimeDB.equipment.rtdata 6.8 MB/10.8 GB (0.1%)
Not restoring at all. I don't know what happened.
Here is my config:
# cat /etc/mongod.conf systemLog: destination: file path: "/var/log/mongodb/mongod.log" logAppend: true logRotate: reopen storage: journal: enabled: true dbPath: "/mnt/mongodb_wt" engine: wiredTiger wiredTiger.engineConfig.cacheSizeGB: 1 operationProfiling: slowOpThresholdMs: 500 mode: off replication.replSetName: shifudaoRs
And here is the db.currentOP() output:
shifudaoRs:PRIMARY> db.currentOp() { "inprog" : [ { "desc" : "conn236063", "threadId" : "0x2ee55ba0", "connectionId" : 236063, "opid" : 85475446, "active" : true, "secs_running" : 1324, "microsecs_running" : NumberLong(1324206791), "op" : "query", "ns" : "arcareRealtimeDB.$cmd", "query" : { "$msg" : "query not recording (too large)" }, "client" : "127.0.0.1:56287", "msg" : "waiting for write concern", "numYields" : 0, "locks" : { }, "waitingForLock" : false, "lockStats" : { "Global" : { "acquireCount" : { "r" : NumberLong(1011), "w" : NumberLong(1011) } }, "Database" : { "acquireCount" : { "w" : NumberLong(1010), "W" : NumberLong(1) } }, "Collection" : { "acquireCount" : { "w" : NumberLong(8), "W" : NumberLong(1) } }, "oplog" : { "acquireCount" : { "w" : NumberLong(1001) } } } }, { "desc" : "conn236039", "threadId" : "0x321941a0", "connectionId" : 236039, "opid" : 85463785, "active" : true, "secs_running" : 1644, "microsecs_running" : NumberLong(1644883225), "op" : "query", "ns" : "rcareRealtimeDB.$cmd", "query" : { "$msg" : "query not recording (too large)" }, "client" : "127.0.0.1:56000", "msg" : "waiting for write concern", "numYields" : 0, "locks" : { }, "waitingForLock" : false, "lockStats" : { "Global" : { "acquireCount" : { "r" : NumberLong(1011), "w" : NumberLong(1011) } }, "Database" : { "acquireCount" : { "w" : NumberLong(1010), "W" : NumberLong(1) } }, "Collection" : { "acquireCount" : { "w" : NumberLong(8), "W" : NumberLong(1) } }, "oplog" : { "acquireCount" : { "w" : NumberLong(1001) } } } }, { "desc" : "conn235999", "threadId" : "0x215f3a80", "connectionId" : 235999, "opid" : 85443542, "active" : true, "secs_running" : 2241, "microsecs_running" : NumberLong("2241782158"), "op" : "query", "ns" : "aircareRealtimeDB.$cmd", "query" : { "$msg" : "query not recording (too large)" }, "client" : "127.0.0.1:53000", "msg" : "waiting for write concern", "numYields" : 0, "locks" : { }, "waitingForLock" : false, "lockStats" : { "Global" : { "acquireCount" : { "r" : NumberLong(1010), "w" : NumberLong(1010) } }, "Database" : { "acquireCount" : { "w" : NumberLong(1010) }, "acquireWaitCount" : { "w" : NumberLong(3) }, "timeAcquiringMicros" : { "w" : NumberLong(236) } }, "Collection" : { "acquireCount" : { "w" : NumberLong(10) } }, "oplog" : { "acquireCount" : { "w" : NumberLong(1000) } } } }, { "desc" : "conn235808", "threadId" : "0x3069d6c0", "connectionId" : 235808, "opid" : 85358646, "active" : true, "secs_running" : 4935, "microsecs_running" : NumberLong("4935759787"), "op" : "query", "ns" : "aircareRealtimeDB.$cmd", "query" : { "$msg" : "query not recording (too large)" }, "client" : "127.0.0.1:53013", "msg" : "waiting for write concern", "numYields" : 0, "locks" : { }, "waitingForLock" : false, "lockStats" : { "Global" : { "acquireCount" : { "r" : NumberLong(1010), "w" : NumberLong(1010) } }, "Database" : { "acquireCount" : { "w" : NumberLong(1010) }, "acquireWaitCount" : { "w" : NumberLong(3) }, "timeAcquiringMicros" : { "w" : NumberLong(236) } }, "Collection" : { "acquireCount" : { "w" : NumberLong(10) } }, "oplog" : { "acquireCount" : { "w" : NumberLong(1000) } } } } ] }