List:Cluster« Previous MessageNext Message »
From:Luca Villani Date:July 14 2004 2:21pm
Subject:Crash during data import
View as plain text  
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?



-- 
Luca Villani                Wireless Solutions spa - DADA group
NOC manager                 Europe HQ, via Castiglione 25 Bologna
http://www.wseurope.com     Tel: +39 051 2966826    Fax: +39 051 2966800
GPG public key available    Mobile: +39 348 5298542 UIN: 76272621

Thread
Crash during data importLuca Villani14 Jul
  • Re: Crash during data importMichael Dykman14 Jul