-----Original Message----- From: Mark Kirkwood [mailto:mar...@paradise.net.nz] Sent: Thursday, August 18, 2005 8:53 PM To: Jonathan Miller Cc: 'Burnett, Stewart'; clus...@lists.mysql.com Subject: Re: Change Cluster Config and connot restoe backup (5.0.10)

Jonathan,

Here are the steps.

(Assuming system setup and have existing backup, can send you all that too if it seems relevant)

Firstly wipe out the cluster:

-----------------------------

$ ndb_mgm -e shutdown $ mysqladmin -u root shutdown $ cd /data0/myndb/5.0; rm -rf *

Then startup and attempt restore:

---------------------------------

$ /usr/local/mysql/5.0/libexec/ndb_mgmd -f /data0/mymgmt/5.0/config.ini $ /usr/local/mysql/5.0/libexec/ndbd $ mysqld_safe --defaults-file=/data0/myclust/5.0/my.cnf --datadir=/data0/myclust/5..0 & $ ndb_restore -r -m -n 2 -b 1 /data0/dump/BACKUP-1-SMAL/ Ndb version in backup files: Version 5.0.10 Configuration error: Could not alloc node id at localhost port 1186: No free node id found for mysqld(API). Segmentation fault (core dumped)

$ gdb ndb_restore ndb_restore.core GNU gdb 6.1.1 [FreeBSD] Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-marcel-freebsd"... Core was generated by `ndb_restore'. Program terminated with signal 11, Segmentation fault. Reading symbols from /lib/libcrypt.so.2...done. Loaded symbols for /lib/libcrypt.so.2 Reading symbols from /usr/lib/libpthread.so.1...done. Loaded symbols for /usr/lib/libpthread.so.1 Reading symbols from /usr/lib/libstdc++.so.4...done. Loaded symbols for /usr/lib/libstdc++.so.4 Reading symbols from /lib/libm.so.3...done. Loaded symbols for /lib/libm.so.3 Reading symbols from /lib/libc.so.5...done. Loaded symbols for /lib/libc.so.5 Reading symbols from /libexec/ld-elf.so.1...done. Loaded symbols for /libexec/ld-elf.so.1 #0 0x0805392b in Ndb::setCatalogName (this=0x0, a_catalog_name=0x80f5d20 "benchw") at Ndb.cpp:1061 1061 theImpl->m_dbname.assign(a_catalog_name); (gdb) bt #0 0x0805392b in Ndb::setCatalogName (this=0x0, a_catalog_name=0x80f5d20 "benchw") at Ndb.cpp:1061 #1 0x0805398a in Ndb::setDatabaseName (this=0x0, a_catalog_name=0x80f5d20 "benchw") at Ndb.cpp:1091 #2 0x0804de53 in BackupRestore::table (this=0x80f4a80, table=@0x8116000) at BaseString.hpp:193 #3 0x0804c513 in main (argc=1, argv=0x80fc234) at Restore.hpp:292 (gdb) q

Configuration:

-------------

$ cat /data0/mymgmt/5.0/config.ini [ndbd default] noofreplicas=1 datamemory=256M indexmemory=64M maxnoofconcurrentoperations=120000 maxnooflocaloperations=120000 maxnooforderedindexes=512

[ndb_mgmd default] datadir=/data0/mymgmt/5.0

[ndb_mgmd] id=1 hostname=localhost

[ndbd] id=2 hostname=localhost datadir=/data0/myndb/5.0

[mysqld] id=4 hostname=localhost

[tcp default] portnumber=2202

Mysql Build Options

-------------------

Freebsd/i386 5.4-RELEASE

CFLAGS='-g -O2 -fno-strength-reduce' \ CXXFLAGS='-g -O2 -fno-rtti -fno-exceptions -felide-constructors \ -fno-strength-reduce' \ ./configure \ --prefix=/usr/local/mysql/5.0 \ --enable-local-infile \ --with-innodb \ --with-ndbcluster \ --with-federated-storage-engine

Jonathan Miller wrote: