Bug #18546 ndb_resore seg faults on hp3750-64bit

• Submitted: 27 Mar 2006 15:57
• Modified: 19 Jun 2006 7:15
• Reporter: Tomas Ulin
• Status: Can't repeat
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: 5.1.8 bk src
• OS: HP/UX (hpux11.00 64-bit)
• Assigned to: Stewart Smith
• CPU Architecture: Any

[27 Mar 2006 15:57] Tomas Ulin

Description:
94797: ndb_dd_backuprestore           [ fail ]
94798: 
94799: Errors are (from /usr/local/mysqldev/hp3750-64bit/test/mysql-5.1.8-beta-hpux11.00-hppa2.0w-64bit/mysql-test/var/log/mysqltest-time) :
94800: sh: 6825 Bus error(coredump)
94801: mysqltest: In included file "./include/ndb_restore_master.inc": At line 6: command "$NDB_TOOLS_DIR/ndb_restore --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT" -p 8 -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT" failed
94802: (the last lines may be the most important ones)
94803: Result from queries before failure can be found in r/ndb_dd_backuprestore.log
94804: 

95736: rpl_ndb_dd_advance             [ fail ]
95737: 
95738: Errors are (from /usr/local/mysqldev/hp3750-64bit/test/mysql-5.1.8-beta-hpux11.00-hppa2.0w-64bit/mysql-test/var/log/mysqltest-time) :
95739: sh: 15249 Bus error(coredump)
95740: mysqltest: In included file "./include/ndb_restore_slave_eoption.inc": At line 6: command "$NDB_TOOLS_DIR/ndb_restore --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT_SLAVE" -p 8 -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT" failed
95741: (the last lines may be the most important ones)
95742: Result from queries before failure can be found in r/rpl_ndb_dd_advance.log
95743: 

How to repeat:
see above

[28 Mar 2006 16:10] Tomas Ulin

boiled down to a blob issue, the following test case fails.  Exchanging TEXT to VARBINARY(255), makes it work ok

-- source include/have_ndb.inc

--disable_warnings
DROP TABLE IF EXISTS test.t2;
--enable_warnings

CREATE TABLE test.t2 (pk1 INT NOT NULL KEY, c2 TEXT NOT NULL) ENGINE=NDB;

INSERT INTO test.t2 VALUES (1, "x");

-- source include/ndb_backup.inc

DROP TABLE test.t2;

-- source include/ndb_restore_master.inc

[19 Jun 2006 7:15] Stewart Smith

Test is passing on pushbuild 5.1 on HPUX

[15 Nov 2006 12:53] Vasil Dimov

Hi Tomas,

Can you apply the patches included in Bug#24331 and see if they fix your problem?
Maybe it is the same issue.