From: Luca Villani Date: July 14 2004 2:05pm Subject: Crash during data import List-Archive: http://lists.mysql.com/cluster/126 Message-Id: <200407141605.28863.luca.villani@wseurope.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 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