Bug #18546 ndb_resore seg faults on hp3750-64bit
Submitted: 27 Mar 2006 17:57 Modified: 19 Jun 2006 9:15
Reporter: Tomas Ulin
Status: Can't repeat
Category:Server: Cluster Severity:S2 (Serious)
Version:5.1.8 bk src OS:HP/UX (hpux11.00 64-bit)
Assigned to: Bugs System Target Version:

[27 Mar 2006 17: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 18: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 9:15] Stewart Smith 
Test is passing on pushbuild 5.1 on HPUX
[15 Nov 2006 13: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.