-
Type: Question
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: 4.4.13
-
Component/s: None
-
Environment:Ubuntu - AWS hosting
Hello,
I'm trying to run Repair command after server crash - but getting WT_NOTFOUND error, I do not have any recent backup and 11 GB data is there.
Kindly let me know best way to restore the database.
{ "t": { "$date": "2022-03-20T13:45:26.959-06:00" }, "s": "I", "c": "NETWORK", "id": 4915701, "ctx": "main", "msg": "Initialized wire specification", "attr": { "spec": { "incomingExternalClient": { "minWireVersion": 0, "maxWireVersion": 13 }, "incomingInternalClient": { "minWireVersion": 0, "maxWireVersion": 13 }, "outgoing": { "minWireVersion": 0, "maxWireVersion": 13 }, "isInternalClient": true } } }{ "t": { "$date": "2022-03-20T13:45:26.964-06:00" }, "s": "I", "c": "CONTROL", "id": 23285, "ctx": "main", "msg": "Automatically disabling TLS 1.0, to force-enable TLS 1.0 specify --sslDisabledProtocols 'none'" }{ "t": { "$date": "2022-03-20T13:45:26.972-06:00" }, "s": "W", "c": "ASIO", "id": 22601, "ctx": "main", "msg": "No TransportLayer configured during NetworkInterface startup" }{ "t": { "$date": "2022-03-20T13:45:26.973-06:00" }, "s": "I", "c": "NETWORK", "id": 4648602, "ctx": "main", "msg": "Implicit TCP FastOpen in use." }{ "t": { "$date": "2022-03-20T13:45:26.976-06:00" }, "s": "W", "c": "ASIO", "id": 22601, "ctx": "main", "msg": "No TransportLayer configured during NetworkInterface startup" }{ "t": { "$date": "2022-03-20T13:45:26.976-06:00" }, "s": "I", "c": "REPL", "id": 5123008, "ctx": "main", "msg": "Successfully registered PrimaryOnlyService", "attr": { "service": "TenantMigrationDonorService", "ns": "config.tenantMigrationDonors" } }{ "t": { "$date": "2022-03-20T13:45:26.977-06:00" }, "s": "I", "c": "REPL", "id": 5123008, "ctx": "main", "msg": "Successfully registered PrimaryOnlyService", "attr": { "service": "TenantMigrationRecipientService", "ns": "config.tenantMigrationRecipients" } }{ "t": { "$date": "2022-03-20T13:45:26.978-06:00" }, "s": "I", "c": "CONTROL", "id": 5945603, "ctx": "main", "msg": "Multi threading initialized" }{ "t": { "$date": "2022-03-20T13:45:26.982-06:00" }, "s": "I", "c": "CONTROL", "id": 4615611, "ctx": "initandlisten", "msg": "MongoDB starting", "attr": { "pid": 14924, "port": 27017, "dbPath": "C:/Users/ADMIN/backuphikardb/mongodb", "architecture": "64-bit", "host": "DESKTOP-48VEHET" } }{ "t": { "$date": "2022-03-20T13:45:26.982-06:00" }, "s": "I", "c": "CONTROL", "id": 23398, "ctx": "initandlisten", "msg": "Target operating system minimum version", "attr": { "targetMinOS": "Windows 7/Windows Server 2008 R2" } }{ "t": { "$date": "2022-03-20T13:45:26.988-06:00" }, "s": "I", "c": "CONTROL", "id": 23403, "ctx": "initandlisten", "msg": "Build Info", "attr": { "buildInfo": { "version": "5.0.6", "gitVersion": "212a8dbb47f07427dae194a9c75baec1d81d9259", "modules": [ ], "allocator": "tcmalloc", "environment": { "distmod": "windows", "distarch": "x86_64", "target_arch": "x86_64" } } } }{ "t": { "$date": "2022-03-20T13:45:26.990-06:00" }, "s": "I", "c": "CONTROL", "id": 51765, "ctx": "initandlisten", "msg": "Operating System", "attr": { "os": { "name": "Microsoft Windows 10", "version": "10.0 (build 19044)" } } }{ "t": { "$date": "2022-03-20T13:45:26.991-06:00" }, "s": "I", "c": "CONTROL", "id": 21951, "ctx": "initandlisten", "msg": "Options set by command line", "attr": { "options": { "repair": true, "storage": { "dbPath": "C:\\Users\\ADMIN\\backuphikardb\\mongodb" } } } }{ "t": { "$date": "2022-03-20T13:45:27.006-06:00" }, "s": "I", "c": "STORAGE", "id": 22270, "ctx": "initandlisten", "msg": "Storage engine to use detected by data files", "attr": { "dbpath": "C:/Users/ADMIN/backuphikardb/mongodb", "storageEngine": "wiredTiger" } }{ "t": { "$date": "2022-03-20T13:45:27.007-06:00" }, "s": "I", "c": "STORAGE", "id": 22315, "ctx": "initandlisten", "msg": "Opening WiredTiger", "attr": { "config": "create,cache_size=3529M,session_max=33000,eviction=(threads_min=4,threads_max=4),config_base=false,statistics=(fast),log=(enabled=true,archive=true,path=journal,compressor=snappy),builtin_extension_config=(zstd=(compression_level=6)),file_manager=(close_idle_time=600,close_scan_interval=10,close_handle_minimum=250),statistics_log=(wait=0),verbose=[recovery_progress,checkpoint_progress,compact_progress]," } }{ "t": { "$date": "2022-03-20T13:45:27.052-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:52459][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 456 through 457" } }{ "t": { "$date": "2022-03-20T13:45:27.412-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:412789][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 457 through 457" } }{ "t": { "$date": "2022-03-20T13:45:27.518-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:517771][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_ALL] Main recovery loop: starting at 456/256 to 457/256" } }{ "t": { "$date": "2022-03-20T13:45:27.687-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:686773][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 456 through 457" } }{ "t": { "$date": "2022-03-20T13:45:27.800-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:799776][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 457 through 457" } }{ "t": { "$date": "2022-03-20T13:45:27.885-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:884832][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_ALL] Set global recovery timestamp: (0, 0)" } }{ "t": { "$date": "2022-03-20T13:45:27.885-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:885773][14924:140715253912912], txn-recover: [WT_VERB_RECOVERY_ALL] Set global oldest timestamp: (0, 0)" } }{ "t": { "$date": "2022-03-20T13:45:27.901-06:00" }, "s": "I", "c": "STORAGE", "id": 22430, "ctx": "initandlisten", "msg": "WiredTiger message", "attr": { "message": "[1647805527:900786][14924:140715253912912], WT_SESSION.checkpoint: [WT_VERB_CHECKPOINT_PROGRESS] saving checkpoint snapshot min: 1, snapshot max: 1 snapshot count: 0, oldest timestamp: (0, 0) , meta checkpoint timestamp: (0, 0) base write gen: 39644794" } }{ "t": { "$date": "2022-03-20T13:45:27.916-06:00" }, "s": "I", "c": "STORAGE", "id": 4795906, "ctx": "initandlisten", "msg": "WiredTiger opened", "attr": { "durationMillis": 908 } }{ "t": { "$date": "2022-03-20T13:45:27.917-06:00" }, "s": "I", "c": "RECOVERY", "id": 23987, "ctx": "initandlisten", "msg": "WiredTiger recoveryTimestamp", "attr": { "recoveryTimestamp": { "$timestamp": { "t": 0, "i": 0 } } } }{ "t": { "$date": "2022-03-20T13:45:27.920-06:00" }, "s": "I", "c": "STORAGE", "id": 22316, "ctx": "initandlisten", "msg": "Repairing size cache" }{ "t": { "$date": "2022-03-20T13:45:27.930-06:00" }, "s": "I", "c": "STORAGE", "id": 22327, "ctx": "initandlisten", "msg": "Verify succeeded. Not salvaging.", "attr": { "uri": "table:sizeStorer" } }{ "t": { "$date": "2022-03-20T13:45:27.934-06:00" }, "s": "I", "c": "STORAGE", "id": 22246, "ctx": "initandlisten", "msg": "Repairing catalog metadata" }{ "t": { "$date": "2022-03-20T13:45:27.934-06:00" }, "s": "W", "c": "STORAGE", "id": 22350, "ctx": "initandlisten", "msg": "Data file is missing. Attempting to drop and re-create the collection.", "attr": { "uri": "table:_mdb_catalog" } }{ "t": { "$date": "2022-03-20T13:45:27.942-06:00" }, "s": "W", "c": "STORAGE", "id": 22353, "ctx": "initandlisten", "msg": "Rebuilding ident", "attr": { "ident": "_mdb_catalog" } }{ "t": { "$date": "2022-03-20T13:45:27.943-06:00" }, "s": "E", "c": "STORAGE", "id": 22435, "ctx": "initandlisten", "msg": "WiredTiger error", "attr": { "error": -31803, "message": "[1647805527:943075][14924:140715253912912], file:WiredTiger.wt, WT_CURSOR.search: int __cdecl __schema_source_config(struct __wt_session_impl *,struct __wt_cursor *,const char *,const char **), 50: metadata information for source configuration \"file:_mdb_catalog.wt\" not found: WT_NOTFOUND: item not found" } }{ "t": { "$date": "2022-03-20T13:45:27.943-06:00" }, "s": "E", "c": "STORAGE", "id": 22357, "ctx": "initandlisten", "msg": "Rebuilding ident failed: failed to get metadata", "attr": { "uri": "table:_mdb_catalog", "error": { "code": 4, "codeName": "NoSuchKey", "errmsg": "Unable to find metadata for table:_mdb_catalog" } } }{ "t": { "$date": "2022-03-20T13:45:27.945-06:00" }, "s": "F", "c": "-", "id": 23095, "ctx": "initandlisten", "msg": "Fatal assertion", "attr": { "msgid": 50926, "error": "NoSuchKey: Unable to find metadata for table:_mdb_catalog", "file": "src\\mongo\\db\\storage\\storage_engine_impl.cpp", "line": 122 } }{ "t": { "$date": "2022-03-20T13:45:27.951-06:00" }, "s": "F", "c": "-", "id": 23096, "ctx": "initandlisten", "msg": "\n\n***aborting after fassert() failure\n\n" }