MongoDB 4.4 错误 mongorestore can’t drop live oplog while replicating 解决方法 - 主机乐

[dave@www.cndba.cn ~]# mongorestore --username=root --password=root --host=127.0.0.1 --port=27017 --authenticationDatabase admin --drop --oplogReplay /data/mongodb/backup2022-05-31T07:45:21.846+0800preparing collections to restore from2022-05-31T07:45:21.846+0800don't know what to do with file "/data/mongodb/backup/.pbm.init", skipping...2022-05-31T07:45:21.849+0800reading metadata for cndba.ustc from /data/mongodb/backup/cndba/ustc.metadata.json2022-05-31T07:45:21.851+0800reading metadata for config.external_validation_keys from /data/mongodb/backup/config/external_validation_keys.metadata.json2022-05-31T07:45:21.851+0800reading metadata for config.tenantMigrationDonors from /data/mongodb/backup/config/tenantMigrationDonors.metadata.json2022-05-31T07:45:21.852+0800reading metadata for config.tenantMigrationRecipients from /data/mongodb/backup/config/tenantMigrationRecipients.metadata.json2022-05-31T07:45:21.852+0800reading metadata for m201.people from /data/mongodb/backup/m201/people.metadata.json2022-05-31T07:45:21.853+0800reading metadata for m201.restaurants from /data/mongodb/backup/m201/restaurants.metadata.json2022-05-31T07:45:21.854+0800reading metadata for local.oplog.rs from /data/mongodb/backup/local/oplog.rs.metadata.json2022-05-31T07:45:21.857+0800reading metadata for cndba.user from /data/mongodb/backup/cndba/user.metadata.json2022-05-31T07:45:21.867+0800dropping collection m201.restaurants before restoring2022-05-31T07:45:21.867+0800dropping collection m201.people before restoring2022-05-31T07:45:21.871+0800dropping collection local.oplog.rs before restoring2022-05-31T07:45:21.882+0800finished restoring local.oplog.rs (0 documents, 0 failures)2022-05-31T07:45:21.882+0800Failed: local.oplog.rs: error dropping collection: (Location5255000) can't drop live oplog while replicating2022-05-31T07:45:21.882+08000 document(s) restored successfully. 0 document(s) failed to restore.[dave@www.cndba.cn ~]#

[dave@www.cndba.cn backup]# lltotal 4drwxr-xr-x 2 root root 128 May 30 23:17 admindrwxr-xr-x 2 root root92 May 30 23:17 cndbadrwxr-xr-x 2 root root 251 May 30 23:17 configdrwxr-xr-x 2 root root57 May 30 23:42 localdrwxr-xr-x 2 root root 110 May 30 23:17 m201-rw-r--r-- 1 root root 206 May 30 23:17 oplog.bson[dave@www.cndba.cn backup]#

[dave@www.cndba.cn backup]# mongorestore --username=root --password=root --host=127.0.0.1 --port=27017 --authenticationDatabase admin --drop --oplogReplay /data/mongodb/backup2022-05-31T08:43:08.705+0800preparing collections to restore from2022-05-31T08:43:08.705+0800don't know what to do with file "/data/mongodb/backup/.pbm.init", skipping...2022-05-31T08:43:08.707+0800reading metadata for m201.restaurants from /data/mongodb/backup/m201/restaurants.metadata.json2022-05-31T08:43:08.708+0800reading metadata for cndba.user from /data/mongodb/backup/cndba/user.metadata.json2022-05-31T08:43:08.708+0800reading metadata for cndba.ustc from /data/mongodb/backup/cndba/ustc.metadata.json2022-05-31T08:43:08.708+0800reading metadata for config.external_validation_keys from /data/mongodb/backup/config/external_validation_keys.metadata.json2022-05-31T08:43:08.708+0800reading metadata for config.tenantMigrationDonors from /data/mongodb/backup/config/tenantMigrationDonors.metadata.json2022-05-31T08:43:08.708+0800reading metadata for config.tenantMigrationRecipients from /data/mongodb/backup/config/tenantMigrationRecipients.metadata.json2022-05-31T08:43:08.708+0800reading metadata for m201.people from /data/mongodb/backup/m201/people.metadata.json2022-05-31T08:43:08.708+0800dropping collection m201.restaurants before restoring2022-05-31T08:43:08.708+0800dropping collection m201.people before restoring2022-05-31T08:43:08.710+0800dropping collection cndba.user before restoring2022-05-31T08:43:08.710+0800dropping collection cndba.ustc before restoring2022-05-31T08:43:08.757+0800restoring m201.restaurants from /data/mongodb/backup/m201/restaurants.bson2022-05-31T08:43:08.774+0800restoring cndba.user from /data/mongodb/backup/cndba/user.bson2022-05-31T08:43:08.785+0800restoring cndba.ustc from /data/mongodb/backup/cndba/ustc.bson2022-05-31T08:43:08.798+0800restoring m201.people from /data/mongodb/backup/m201/people.bson2022-05-31T08:43:08.864+0800finished restoring cndba.ustc (2 documents, 0 failures)2022-05-31T08:43:08.871+0800dropping collection config.external_validation_keys before restoring2022-05-31T08:43:08.954+0800restoring config.external_validation_keys from /data/mongodb/backup/config/external_validation_keys.bson2022-05-31T08:43:08.964+0800finished restoring config.external_validation_keys (0 documents, 0 failures)2022-05-31T08:43:08.964+0800dropping collection config.tenantMigrationDonors before restoring2022-05-31T08:43:09.083+0800restoring config.tenantMigrationDonors from /data/mongodb/backup/config/tenantMigrationDonors.bson2022-05-31T08:43:09.104+0800finished restoring config.tenantMigrationDonors (0 documents, 0 failures)2022-05-31T08:43:09.104+0800dropping collection config.tenantMigrationRecipients before restoring2022-05-31T08:43:09.195+0800restoring config.tenantMigrationRecipients from /data/mongodb/backup/config/tenantMigrationRecipients.bson2022-05-31T08:43:09.217+0800finished restoring config.tenantMigrationRecipients (0 documents, 0 failures)2022-05-31T08:43:11.710+0800[#.......................]m201.restaurants 8.65MB/173MB (5.0%)2022-05-31T08:43:11.710+0800[############............]cndba.user1.46MB/2.86MB(51.0%)2022-05-31T08:43:11.710+0800[#####################...] m201.people17.0MB/18.7MB(91.2%)2022-05-31T08:43:11.710+08002022-05-31T08:43:12.013+0800[########################]m201.people18.7MB/18.7MB(100.0%)2022-05-31T08:43:12.013+0800finished restoring m201.people (50474 documents, 0 failures)2022-05-31T08:43:13.949+0800[########################]cndba.user2.86MB/2.86MB(100.0%)2022-05-31T08:43:13.949+0800finished restoring cndba.user (100000 documents, 0 failures)2022-05-31T08:43:14.705+0800[##......................]m201.restaurants20.4MB/173MB(11.8%)2022-05-31T08:43:17.706+0800[#####...................]m201.restaurants36.2MB/173MB(20.9%)2022-05-31T08:43:20.706+0800[#######.................]m201.restaurants52.4MB/173MB(30.3%)2022-05-31T08:43:23.707+0800[#########...............]m201.restaurants68.7MB/173MB(39.7%)2022-05-31T08:43:26.706+0800[###########.............]m201.restaurants83.0MB/173MB(48.0%)2022-05-31T08:43:29.706+0800[#############...........]m201.restaurants100MB/173MB(57.8%)2022-05-31T08:43:32.706+0800[################........]m201.restaurants117MB/173MB(67.5%)2022-05-31T08:43:35.705+0800[##################......]m201.restaurants133MB/173MB(77.1%)2022-05-31T08:43:38.705+0800[####################....]m201.restaurants150MB/173MB(86.9%)2022-05-31T08:43:41.706+0800[#######################.]m201.restaurants167MB/173MB(96.6%)2022-05-31T08:43:42.779+0800[########################]m201.restaurants173MB/173MB(100.0%)2022-05-31T08:43:42.779+0800finished restoring m201.restaurants (1000000 documents, 0 failures)2022-05-31T08:43:42.779+0800restoring users from /data/mongodb/backup/admin/system.users.bson2022-05-31T08:43:42.894+0800replaying oplog2022-05-31T08:43:42.895+0800applied 0 oplog entries2022-05-31T08:43:42.895+0800restoring indexes for collection m201.restaurants from metadata2022-05-31T08:43:42.898+0800index: &idx.IndexDocument{Options:primitive.M{"name":"stars_1_cuisine_1", "v":2}, Key:primitive.D{primitive.E{Key:"stars", Value:1}, primitive.E{Key:"cuisine", Value:1}}, PartialFilterExpression:primitive.D(nil)}2022-05-31T08:43:42.898+0800no indexes to restore for collection m201.people2022-05-31T08:43:42.898+0800restoring indexes for collection config.tenantMigrationRecipients from metadata2022-05-31T08:43:42.898+0800index: &idx.IndexDocument{Options:primitive.M{"expireAfterSeconds":0, "name":"TenantMigrationRecipientTTLIndex", "v":2}, Key:primitive.D{primitive.E{Key:"expireAt", Value:1}}, PartialFilterExpression:primitive.D(nil)}2022-05-31T08:43:42.898+0800no indexes to restore for collection cndba.user2022-05-31T08:43:42.898+0800restoring indexes for collection config.external_validation_keys from metadata2022-05-31T08:43:42.898+0800index: &idx.IndexDocument{Options:primitive.M{"expireAfterSeconds":0, "name":"ExternalKeysTTLIndex", "v":2}, Key:primitive.D{primitive.E{Key:"ttlExpiresAt", Value:1}}, PartialFilterExpression:primitive.D(nil)}2022-05-31T08:43:42.899+0800no indexes to restore for collection cndba.ustc2022-05-31T08:43:42.899+0800restoring indexes for collection config.tenantMigrationDonors from metadata2022-05-31T08:43:42.899+0800index: &idx.IndexDocument{Options:primitive.M{"expireAfterSeconds":0, "name":"TenantMigrationDonorTTLIndex", "v":2}, Key:primitive.D{primitive.E{Key:"expireAt", Value:1}}, PartialFilterExpression:primitive.D(nil)}2022-05-31T08:43:48.066+0800Failed: m201.restaurants: error creating indexes for m201.restaurants: createIndex error: connection(127.0.0.1:27017[-4]) socket was unexpectedly closed: EOF2022-05-31T08:43:48.066+08001150476 document(s) restored successfully. 0 document(s) failed to restore.[dave@www.cndba.cn backup]#