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 import | Luca Villani | 14 Jul |
