Problem starting data node

Thread: Problem starting data node

Search this list only Search all lists
Problem starting data node
	2006-05-31 06:32:40
hi all, i have 4 test machines.. 2 machines contains 1 data node each... 1 machine for management node and the other SQL node..... the machine's power-strip was accidentally pulled out... after that 1 of the data node wont start.. Initially I started the ID=3 with ndbd only.. unfortunately it didnt work.. i did a start with "--initial" and still doesn't work... any idea how to make this work? ============================= Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 192.168.6.201 (Version: 5.0.21, Nodegroup: 0, Master) id=3 (not connected, accepting connect from 192.168.6.202) [ndb_mgmd(MGM)] 1 node(s) id=1 192.168.6.200 (Version: 5.0.21) [mysqld(API)] 2 node(s) id=4 192.168.6.40 (Version: 5.0.21) id=5 192.168.6.200 (Version: 5.0.21) ============================= Management LOG ===================== 2006-05-31 14:13:21 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 192.168.6.202, m_reserved_nodes 000000000000003a. 2006-05-31 14:13:21 [MgmSrvr] INFO -- Node 1: Node 3 Connected 2006-05-31 14:13:21 [MgmSrvr] INFO -- Node 3: Communication to Node 2 opened 2006-05-31 14:13:21 [MgmSrvr] INFO -- Node 3: Waiting 30 sec for nodes 0000000000000004 to connect, nodes [ all: 000000000000000c connected: 0000000000000008 no-wait: 0000000000000000 ] 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: Node 2 Connected 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 2: Node 3 Connected 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: CM_REGCONF president = 2, own Node = 3, our dynamic id = 6 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 2: Node 3: API version 5.0.21 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: Node 2: API version 5.0.21 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: Start phase 1 completed 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: Receive arbitrator node 1 [ticket=08ce00058489ae06] 2006-05-31 14:13:22 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 freed, m_reserved_nodes 0000000000000032. 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: Start phase 2 completed (node restart) 2006-05-31 14:13:22 [MgmSrvr] INFO -- Node 3: Start phase 3 completed (node restart) 2006-05-31 14:13:24 [MgmSrvr] INFO -- Node 3: Start phase 4 completed (node restart) 2006-05-31 14:13:25 [MgmSrvr] INFO -- Node 1: Node 3 Connected 2006-05-31 14:13:25 [MgmSrvr] ALERT -- Node 2: Node 3 Disconnected 2006-05-31 14:13:25 [MgmSrvr] INFO -- Node 2: Communication to Node 3 closed 2006-05-31 14:13:25 [MgmSrvr] ALERT -- Node 2: Network partitioning - arbitration required 2006-05-31 14:13:25 [MgmSrvr] INFO -- Node 2: President restarts arbitration thread [state=7] 2006-05-31 14:13:25 [MgmSrvr] ALERT -- Node 2: Arbitration won - positive reply from node 1 2006-05-31 14:13:25 [MgmSrvr] ALERT -- Node 3: Forced node shutdown completed. Occured during startphase 5. Initiated by signal 0. Caused by error 2310: 'Error while reading the REDO log(Ndbd file system inconsistency error, please report a bug). Ndbd file system error, restart node initial'. 2006-05-31 14:13:26 [MgmSrvr] INFO -- Node 2: Started arbitrator node 1 [ticket=08ce000689188360] 2006-05-31 14:13:29 [MgmSrvr] INFO -- Node 2: Communication to Node 3 opened thanks, -- MySQL Cluster Mailing List For list archives: http://lists.mysql.com /cluster To unsubscribe: http://list s.mysql.com/cluster?unsub=bondyahoo.com

Problem starting data node
	2006-05-31 12:01:23
Hi JM, JM wrote: > hi all, > > i have 4 test machines.. 2 machines contains 1 data node each... 1 machine > for management node and the other SQL node..... the machine's power-strip was > accidentally pulled out... after that 1 of the data node wont start.. > > > Initially I started the ID=3 with ndbd only.. unfortunately it didnt work.. > i did a start with "--initial" and still doesn't work... You got 'error 2310' also after doing an '--initial'? Best regards, Geert -- Geert Vanderkelen, Support Engineer MySQL GmbH, Germany, www.mysql.com -- MySQL Cluster Mailing List For list archives: http://lists.mysql.com /cluster To unsubscribe: http://list s.mysql.com/cluster?unsub=bondyahoo.com

Problem starting data node
	2006-06-01 05:34:33
no.... it gave me a different error message.. see below.. 2006-06-01 13:25:11 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 192.168.6.202, m_reserved_nodes 000000000000003a. 2006-06-01 13:25:12 [MgmSrvr] INFO -- Node 1: Node 3 Connected 2006-06-01 13:25:12 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 freed, m_reserved_nodes 0000000000000032. 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: Start phase 0 completed 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: Communication to Node 2 opened 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000004 to connect, nodes [ all: 000000000000000c connected: 0000000000000008 no-wait: 0000000000000000 ] 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: Node 2 Connected 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: CM_REGCONF president = 2, own Node = 3, our dynamic id = 7 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: Node 2: API version 5.0.21 2006-06-01 13:25:15 [MgmSrvr] INFO -- Node 3: Start phase 1 completed 2006-06-01 13:25:16 [MgmSrvr] INFO -- Node 3: Start phase 2 completed (initial node restart) 2006-06-01 13:25:16 [MgmSrvr] INFO -- Node 3: Receive arbitrator node 1 [ticket=08ce001e8e0979f1] 2006-06-01 13:25:38 [MgmSrvr] INFO -- Node 3: Start phase 3 completed (initial node restart) 2006-06-01 13:26:02 [MgmSrvr] INFO -- Node 3: Start phase 4 completed (initial node restart) =================== 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 3 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 5 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 7 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 9 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 11 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 13 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 15 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 17 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 19 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 21 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 23 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 25 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 27 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 29 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 31 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 33 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 35 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 37 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 39 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 41 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 43 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 45 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 47 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 49 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 51 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 53 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 55 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 57 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 59 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 61 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 63 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 65 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 67 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 69 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 71 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 73 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 75 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 77 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 79 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 81 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 83 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 85 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 87 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 89 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 91 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 93 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 95 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 97 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 99 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 101 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 103 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 105 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 107 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 109 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 111 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 113 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 115 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 117 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 119 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 121 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 123 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 125 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 127 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 129 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 131 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 133 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 135 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 137 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 139 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 141 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 143 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 145 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 147 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 149 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 151 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 153 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 155 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 157 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 159 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 161 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 163 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 165 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 167 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 169 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 171 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 173 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 175 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 177 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 179 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 181 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 183 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 185 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 187 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 189 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 191 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 193 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 195 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 197 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 199 activated 2006-06-01 13:30:16 [MgmSrvr] INFO -- Node 3: DICT: index 201 activated 2006-06-01 13:31:11 [MgmSrvr] INFO -- Node 1: Node 3 Connected 2006-06-01 13:31:11 [MgmSrvr] ALERT -- Node 3: Forced node shutdown completed. Occured during startphase 5. Initiated by signal 0. Caused by error 2303: 'System error, node killed during node restart by other node(Internal error, programming error or missing error message, please report a bug) On Wednesday 31 May 2006 20:01, Geert Vanderkelen wrote: > Hi JM, > > JM wrote: > > hi all, > > > > i have 4 test machines.. 2 machines contains 1 data node each... 1 > > machine for management node and the other SQL node..... the machine's > > power-strip was accidentally pulled out... after that 1 of the data node > > wont start.. > > > > > > Initially I started the ID=3 with ndbd only.. unfortunately it didnt > > work.. i did a start with "--initial" and still doesn't work... > > You got 'error 2310' also after doing an '--initial'? > > Best regards, > > Geert > > -- > Geert Vanderkelen, Support Engineer > MySQL GmbH, Germany, www.mysql.com -- MySQL Cluster Mailing List For list archives: http://lists.mysql.com /cluster To unsubscribe: http://list s.mysql.com/cluster?unsub=bondyahoo.com

[1-3]

about | contact Other archives ( Real Estate discussion Medical topics )