3 messages in com.mysql.lists.clusterCrash during data import
FromSent OnAttachments
Luca Villani14 Jul 2004 07:05 
Luca Villani14 Jul 2004 07:21 
Michael Dykman14 Jul 2004 09:37 
Subject:Crash during data import
From:Luca Villani (luca@wseurope.com)
Date:07/14/2004 07:05:06 AM
List:com.mysql.lists.cluster

Hi all.

I'm testing data import for cluster.

I've done a dump of a working database, with

mysqldump --opt global >global.sql

resultig file has a size of 2463157827 byte.

I try to import it onto a working 2node-2api cluster, but I can load only three table, due to this error:

[root@delfi02 tempo]# /usr/local/mysql/bin/mysql -h delfi01.backplane \

global <global.sql

ERROR 1297 at line 81: Got temporary error 4010 'Node failure caused abort of transaction' from ndbcluster [root@delfi02 tempo]

I can see only this in logfils:

==> cluster.log <== 2004-07-14 15:24:43 [MgmSrvr] INFO -- Node 2: Local checkpoint 3 started. Keep GCI = 27 oldest restorable GCI = 27 2004-07-14 15:32:12 [MgmSrvr] ALERT -- Node 1: Node 3 Disconnected 2004-07-14 15:32:12 [MgmSrvr] INFO -- Lost connection to node 3

==> error.log <== Date/Time: Wednesday 14 July 2004 - 15:32:11 Type of error: error Message: Internal program error (failed ndbrequire) Fault ID: 2341 Problem data: DbtuxCmp.cpp Object of reference: DBTUX (Line: 82) 0x0000000a ProgramName: NDB Kernel ProcessID: 1813 TraceFile: /usr/local/mysqlNDB_TraceFile_2.trace ***EOM***

Date/Time: Wednesday 14 July 2004 - 15:32:11 Type of error: error Message: No message slogan found Fault ID: 0 Problem data: Signal 11 received Object of reference: Main.cpp ProgramName: NDB Kernel ProcessID: 1813 TraceFile: /usr/local/mysqlNDB_TraceFile_3.trace ***EOM***

==> cluster.log <== 2004-07-14 15:32:12 [MgmSrvr] ALERT -- Node 1: Node 2 Disconnected 2004-07-14 15:32:12 [MgmSrvr] INFO -- Lost connection to node 2

The mysqldump's --opt switch implies fast insert statements syntax in resulting dump file, is this syntax well handled by cluster?

Have I some another problems?