[SERVER-23032] Help Me!!! My DB can't connect it & repair command was stop more 1hours Created: 09/Mar/16  Updated: 14/Apr/16  Resolved: 10/Mar/16

Status: Closed
Project: Core Server
Component/s: WiredTiger
Affects Version/s: 3.3.2
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: raylynn Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

WINDOWS 2008 R2


Issue Links:
Duplicate
is duplicated by SERVER-23031 Help Me!!! My DB can't connect it & ... Closed
Participants:

 Description   

Today,I executing reIndex() function to running. I saw is to slow. when I restart the server. this

DB cannot stop. then I shutdown it and to restart.
But cannot connect again.

I search any help in network, use --repair command to repair my DB.
this it running 3hours, but stay here is so long time. I guess somethimg is problem.

this is my log:

2016-03-10T03:21:47.184+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
581700
2016-03-10T03:21:49.123+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
581800
2016-03-10T03:21:50.762+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
581900
2016-03-10T03:21:52.996+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582000
2016-03-10T03:21:54.767+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582100
2016-03-10T03:21:56.760+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582200
2016-03-10T03:21:58.778+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582300
2016-03-10T03:22:00.783+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582400
2016-03-10T03:22:03.243+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582500
2016-03-10T03:22:05.582+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582600
2016-03-10T03:22:08.099+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582700
2016-03-10T03:22:09.799+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582800
2016-03-10T03:22:12.045+0800 I STORAGE  [initandlisten] WiredTiger progress WT_SESSION.verify 
 
582900
2016-03-10T03:27:35.662+0800 I STORAGE  [initandlisten] Verify succeeded on uri table:collection-
 
30-392147248946254211. Not salvaging.
2016-03-10T03:27:38.342+0800 I INDEX    [initandlisten] build index on: wxwdb.w_trade_aliexpress 
 
properties: { v: 1, key: { _id: 1 }, name: "_id_", ns: "wxwdb.w_trade_aliexpress" }
2016-03-10T03:27:38.343+0800 I INDEX    [initandlisten] 	 building index using bulk method
2016-03-10T03:27:38.503+0800 I INDEX    [initandlisten] build index on: wxwdb.w_trade_aliexpress 
 
properties: { v: 1, key: { uid: -1.0, infor.id: -1.0 }, name: "uid_-1_infor.id_-1", ns: 
 
"wxwdb.w_trade_aliexpress", background: true }
2016-03-10T03:27:38.503+0800 I INDEX    [initandlisten] 	 building index using bulk method
2016-03-10T03:27:38.629+0800 I INDEX    [initandlisten] build index on: wxwdb.w_trade_aliexpress 
 
properties: { v: 1, key: { uid: 1.0, exts.eval.evaluatetime: -1.0 }, name: 
 
"uid_1_exts.eval.evaluatetime_-1", ns: "wxwdb.w_trade_aliexpress", background: true }
2016-03-10T03:27:38.629+0800 I INDEX    [initandlisten] 	 building index using bulk method
2016-03-10T03:27:38.670+0800 I INDEX    [initandlisten] build index on: wxwdb.w_trade_aliexpress 
 
properties: { v: 1, key: { uid: -1.0, infor.orderStatus: 1.0, exts.post_his.unpostids: 1.0, 
 
infor.gmtModified: -1.0, exts.dvy_sign.issigned: 1.0, infor.issueInfo.issueStatus: 1.0 }, name: 
 
"posting2", ns: "wxwdb.w_trade_aliexpress", background: true }
2016-03-10T03:27:38.670+0800 I INDEX    [initandlisten] 	 building index using bulk method

this log show building index,maybe it building my reIndex() stop at that.Can I delete this file

"index-xxxxxx.wt", and connect it ?
How can I do???



 Comments   
Comment by raylynn [ 10/Mar/16 ]

Dear Ramon Fernandez,thank you for answer my question.

I use repair well done.is so long time just.

ray

Comment by Ramon Fernandez Marina [ 10/Mar/16 ]

tianwei02, it appears your mongod is rebuilding indexes as you requested. You may want to take a look at the --noIndexBuildRetry command line option, that may help.

Please note that the SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag, where your question will reach a larger audience. A question like this involving more discussion would be best posted on the mongodb-user group. See also our Technical Support page for additional support resources.

Regards,
Ramón.

Generated at Thu Feb 08 04:02:09 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.