MySQL Forums
Forum List  »  NDB clusters

Forced node shutdown during load of table using ClusterJ mysql-5.5.25 ndb-7.2.7
Posted by: Chris Stillwell
Date: January 04, 2013 12:12PM

Using ClusterJ api to load data and after about a million or so rows the cluster shuts down.
Using mysql cluster 7.2.7 installed.

ndb_error_reporter output can be found at:
https://docs.google.com/open?id=0ByPsQoJxX4VXSEd4THR3OHJxbmM

Here are the last few log entries from when the cluster shuts down.

2013-01-04 12:20:30 [MgmtSrvr] ALERT -- Node 3: Forced node shutdown completed. Caused by error 2301: 'Assertion(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
2013-01-04 12:20:30 [MgmtSrvr] INFO -- Node 2: Local checkpoint 22 started. Keep GCI = 912 oldest restorable GCI = 923
2013-01-04 12:20:30 [MgmtSrvr] ALERT -- Node 2: Node 3 Disconnected
2013-01-04 12:20:34 [MgmtSrvr] INFO -- Node 2: Communication to Node 3 opened
2013-01-04 12:20:34 [MgmtSrvr] INFO -- Node 5: Communication to Node 3 opened
2013-01-04 12:20:34 [MgmtSrvr] INFO -- Node 4: Communication to Node 3 opened
2013-01-04 12:20:34 [MgmtSrvr] INFO -- Node 14: Communication to Node 3 opened
2013-01-04 12:20:39 [MgmtSrvr] INFO -- Node 14: Data usage is 0%(2968 32K pages of total 1424832)
2013-01-04 12:20:39 [MgmtSrvr] INFO -- Node 14: Index usage is 0%(1077 8K pages of total 712576)
2013-01-04 12:20:40 [MgmtSrvr] INFO -- Node 2: Data usage is 0%(3098 32K pages of total 1424832)
2013-01-04 12:20:40 [MgmtSrvr] INFO -- Node 2: Index usage is 0%(1096 8K pages of total 712576)
2013-01-04 12:20:43 [MgmtSrvr] INFO -- Node 2: Local checkpoint 22 completed
2013-01-04 12:20:43 [MgmtSrvr] INFO -- Node 5: Data usage is 0%(2986 32K pages of total 1424832)
2013-01-04 12:20:43 [MgmtSrvr] INFO -- Node 5: Index usage is 0%(1079 8K pages of total 712576)
2013-01-04 12:20:44 [MgmtSrvr] INFO -- Node 4: Data usage is 0%(2987 32K pages of total 1424832)
2013-01-04 12:20:44 [MgmtSrvr] INFO -- Node 4: Index usage is 0%(1079 8K pages of total 712576)
2013-01-04 12:20:44 [MgmtSrvr] INFO -- Node 2: Local checkpoint 23 started. Keep GCI = 924 oldest restorable GCI = 932
2013-01-04 12:20:57 [MgmtSrvr] INFO -- Node 2: Local checkpoint 23 completed
2013-01-04 12:20:58 [MgmtSrvr] INFO -- Node 2: Local checkpoint 24 started. Keep GCI = 935 oldest restorable GCI = 943
2013-01-04 12:21:14 [MgmtSrvr] INFO -- Node 4: Data usage is 0%(3323 32K pages of total 1424832)
2013-01-04 12:21:14 [MgmtSrvr] INFO -- Node 4: Index usage is 0%(1194 8K pages of total 712576)
2013-01-04 12:21:17 [MgmtSrvr] ALERT -- Node 14: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 11.
2013-01-04 12:21:17 [MgmtSrvr] ALERT -- Node 1: Node 14 Disconnected
2013-01-04 12:21:17 [MgmtSrvr] ALERT -- Node 4: Node 14 Disconnected
2013-01-04 12:21:19 [MgmtSrvr] ALERT -- Node 1: Node 2 Disconnected
2013-01-04 12:21:19 [MgmtSrvr] ALERT -- Node 2: Forced node shutdown completed. Caused by error 2301: 'Assertion(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
2013-01-04 12:21:19 [MgmtSrvr] ALERT -- Node 4: Node 2 Disconnected
2013-01-04 12:21:21 [MgmtSrvr] ALERT -- Node 5: Forced node shutdown completed. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
2013-01-04 12:21:21 [MgmtSrvr] ALERT -- Node 4: Node 5 Disconnected
2013-01-04 12:21:21 [MgmtSrvr] ALERT -- Node 1: Node 5 Disconnected
2013-01-04 12:21:31 [MgmtSrvr] ALERT -- Node 4: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.
2013-01-04 12:21:31 [MgmtSrvr] ALERT -- Node 1: Node 4 Disconnected

Options: ReplyQuote


Subject
Views
Written By
Posted
Forced node shutdown during load of table using ClusterJ mysql-5.5.25 ndb-7.2.7
3868
January 04, 2013 12:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.