List:Cluster« Previous MessageNext Message »
From:Doran Smestad Date:June 1 2012 4:08pm
Subject:MySQL Cluster shuts down during a simple Create Table
View as plain text  
Hello all,

I am in the process of upgrading my current database to allow for reliability and
scalability.  In attempts to test out MySQL cluster before switching the entire 
production website over, I am using a couple servers to run a 4 node configuration.   My
goal is for testing for compatibility with the application.  If that is successful, i'll
get more servers connected to the cluster to properly fulfill the reliability aspects.

My Setup:   2 servers with Dual Xeon processors and over 100GB of RAM.  Each running
FreeBSD 9  with mysql-5.5.22 ndb-7.2.6  compiled from source.

Server 1
	Node #50 - ndb_mgmd
	Node #100 - mysqld
	Node #1  - ndbmtd
Server 2
	Node #2  - ndbmtd


I can get the cluster up and running, and tables going in NDB, but as soon as I create
more than 20 tables,  or so the cluster gets a forced shutdown.

As a test, I ran the query:   create table test01 (id int(11) AUTO_INCREMENT NOT
NULL,primary key (id))ENGINE=ndbcluster 
After you create the 21st table or so, the database does a forced shutdown.


this is the error from  my ndbd datadir's log  ( "ndbmtd_data/ndb_1_out.log" )
------
...
...
/home/mvoorhis/comp/mysql-cluster-gpl-7.2.6/storage/ndb/src/kernel/vm/DynArr256.cpp:683:
require((false)) failed

2012-06-01 11:29:16 [ndbd] INFO     -- Received signal 6. Running error handler.
2012-06-01 11:29:16 [ndbd] INFO     -- Signal 6 received; Abort trap: 6
2012-06-01 11:29:16 [ndbd] INFO     --
/home/mvoorhis/comp/mysql-cluster-gpl-7.2.6/storage/ndb/src/kernel/ndbd.cpp
2012-06-01 11:29:16 [ndbd] INFO     -- Error handler signal shutting down system
2012-06-01 11:29:16 [ndbd] INFO     -- Error handler shutdown completed - exiting
2012-06-01 11:29:17 [ndbd] ALERT    -- Node 1: Forced node shutdown completed. Initiated
by signal 6. Caused by error 6000: 'Error OS signal received(Internal error, programming
error or missing error message, please report a bug). Temporary error, restart node'.
-------


and the error from the cluster log:
-------
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 1: Started (mysql-5.5.22 ndb-7.2.6)
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 2: Started (mysql-5.5.22 ndb-7.2.6)
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 2: Node 50: API mysql-5.5.22 ndb-7.2.6
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 1: Node 50: API mysql-5.5.22 ndb-7.2.6
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 1: Communication to Node 100 opened
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 2: Prepare arbitrator node 50
[ticket=0782000100492643]
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 1: Node 100 Connected
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 1: Node 100: API mysql-5.5.22 ndb-7.2.6
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 1: Started arbitrator node 50
[ticket=0782000100492643]
2012-06-01 11:27:56 [MgmtSrvr] INFO     -- Node 2: Communication to Node 100 opened
2012-06-01 11:27:57 [MgmtSrvr] INFO     -- Node 2: Node 100 Connected
2012-06-01 11:27:57 [MgmtSrvr] INFO     -- Node 2: Node 100: API mysql-5.5.22 ndb-7.2.6
2012-06-01 11:29:16 [MgmtSrvr] ALERT    -- Node 50: Node 1 Disconnected
2012-06-01 11:29:16 [MgmtSrvr] ALERT    -- Node 50: Node 2 Disconnected
2012-06-01 11:29:17 [MgmtSrvr] ALERT    -- Node 2: Forced node shutdown completed.
Initiated by signal 6. Caused by error 6000: 'Error OS signal received(Internal error,
programming error or missing error message, please report a bug). Temporary error,
restart node'.
2012-06-01 11:29:18 [MgmtSrvr] ALERT    -- Node 1: Forced node shutdown completed.
Initiated by signal 6. Caused by error 6000: 'Error OS signal received(Internal error,
programming error or missing error message, please report a bug). Temporary error,
restart node'.
-------



I've attached my config.ini for the cluster, and the mysqld.cnf for mysqld.   Can anyone
give me some pointers as to what's wrong, or perhaps what the error in DynArr256.cpp is
caused by?

Thank you for you time,
Doran



--
Doran Smestad
WPI - CS Major
ASSISTments Developer
doransmestad@stripped
doransmestad@stripped


Attachment: [text/html]
Attachment: [application/octet-stream] config.ini
Attachment: [text/html]
Attachment: [application/octet-stream] mysqld.cnf
Attachment: [text/html]
Attachment: [text/html]
Thread
MySQL Cluster shuts down during a simple Create TableDoran Smestad1 Jun
  • Re: MySQL Cluster shuts down during a simple Create TableDoran Smestad12 Jun
    • Re: MySQL Cluster shuts down during a simple Create TableStewart Smith12 Jun