Bug #32713 NDB backup and restore fail (on AIX, 64 bit)
Submitted: 26 Nov 2007 12:10 Modified: 24 Aug 2010 7:38
Reporter: Joerg Bruehe Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.0 OS:IBM AIX (64 bit)
Assigned to: CPU Architecture:Any
Tags: 5.0.51
Triage: Triaged: D3 (Medium)

[26 Nov 2007 12:10] Joerg Bruehe
Description:
In a build using the 5.0.51 (community) sources,
all tests involving backup/restore of NDB fail completely
on AIX 5.2 (64 bit):

=====

ndb_backup_print               [ fail ]

*** /PATH/mysql-test/r/ndb_backup_print.result
--- /PATH/mysql-test/var/log/ndb_backup_print.reject
***************
*** 2,12
  drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10;
  Connected to Management Server at: :
  Waiting for completed, this may take several minutes
! Node : Backup  started from node
! Node : Backup  started from node  completed
!  StartGCP:  StopGCP:
!  #Records:  #LogRecords:
!  Data:  bytes Log:  bytes
  create table t1
  (pk int key
  ,a1 BIT(1), a2 BIT(5), a3 BIT(33), a4 BIT(63), a5 BIT(64)
--- 2,10
  drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10;
  Connected to Management Server at: :
  Waiting for completed, this may take several minutes
! Backup failed
! *  : Could not start backup
! *        Backup abortet due to node failure: Permanent error: Internal error
  create table t1
  (pk int key
  ,a1 BIT(1), a2 BIT(5), a3 BIT(33), a4 BIT(63), a5 BIT(64)
***************
*** 57,64
  );
  Connected to Management Server at: :
  Waiting for completed, this may take several minutes
! Node : Backup  started from node
! Node : Backup  started from node  completed
!  StartGCP:  StopGCP:
!  #Records:  #LogRecords:
!  Data:  bytes Log:  bytes
--- 55,60
  );
  Connected to Management Server at: :
  Waiting for completed, this may take several minutes
! Backup failed
! *  : Could not start backup
! *        Backup abortet due to node failure: Permanent error: Internal error

mysqltest: Result content mismatch

Stopping All Servers

=====

ndb_restore                    [ fail ]

mysqltest: In included file "./include/ndb_backup.inc": At line 5: command "$NDB_MGM --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT" -e "start backup" >> $NDB_TOOLS_OUTPUT" failed

The result from queries just before the failure was:
< snip >
`actcoutpuocttets` bigint(20) unsigned default NULL,
`actinputocctets` bigint(20) unsigned default NULL,
`terminateraste` tinyint(3) unsigned default NULL,
PRIMARY KEY  (`kattjame`,`hunderaaarbagefa`,`hassetistart`,`hassetino`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
INSERT INTO `t9_c` VALUES ('3g4jh8gar2t','joe','q3.net','elredun.com','q3.net','436643316120','436643316939','9134123456896
8','695595699','1.1.1.1','2.2.6.2','3','86989','34','x','x','2012-03-12 18:35:04','2012-12-05 12:35:04',3123123,9569,6565,1
),('4tt45345235','pap','q3plus.qt','q3plus.qt','q3.net','436643316120','436643316939','8956234534568968','5254595969','1.1.
1.1','8.6.2.2','4','86989','34','x','x','2012-03-12 12:55:34','2012-12-05 11:20:04',3223433,3369,9565,2),('4545435545','joh
n','q3.net','q3.net','acne.li','436643316120','436643316939','45345234568968','995696699','1.1.1.1','2.9.9.2','2','86998','
34','x','x','2012-03-12 11:35:03','2012-12-05 08:50:04',8823123,169,3565,3);
create table t10_c (a int auto_increment key) ENGINE=ndbcluster;
insert into t10_c values (1),(2),(3);
insert into t10_c values (10000),(2000),(3000);
create table t1 engine=myisam as select * from t1_c;
create table t2 engine=myisam as select * from t2_c;
create table t3 engine=myisam as select * from t3_c;
create table t4 engine=myisam as select * from t4_c;
create table t5 engine=myisam as select * from t5_c;
create table t6 engine=myisam as select * from t6_c;
create table t7 engine=myisam as select * from t7_c;
create table t8 engine=myisam as select * from t8_c;
create table t9 engine=myisam as select * from t9_c;
create table t10 engine=myisam as select * from t10_c;
exec of '/PATH/bin/ndb_mgm --no-defaults --ndb-connectstring="localhost:12015" -e "start backup" >> /PATH/mysql-test/var/log/ndb_testrun.log' failed, error: 65280, status: 255, errno: 0

More results from queries before failure can be found in /PATH/mysql-test/var/log/ndb_restore.log

Stopping All Servers

=====

ndb_restore_print              [ fail ]

mysqltest: In included file "./include/ndb_backup.inc": At line 5: command "$NDB_MGM --no-defaults --ndb-connectstring="localhost:$NDBCLUSTER_PORT" -e "start backup" >> $NDB_TOOLS_OUTPUT" failed

The result from queries just before the failure was:
< snip >
b2      NULL
c1      NULL
c2      NULL
d1      NULL
d2      NULL
e1      NULL
e2      NULL
f1      NULL
f2      NULL
f3      NULL
g1      NULL
g2      NULL
g3      NULL
hex(h1) NULL
hex(h2) NULL
hex(h3) NULL
hex(i1) NULL
hex(i2) NULL
hex(i3) NULL
exec of '/PATH/bin/ndb_mgm --no-defaults --ndb-connectstring="localhost:12015" -e "start backup" >> /PATH/mysql-test/var/log/ndb_testrun.log' failed, error: 65280, status: 255, errno: 0

More results from queries before failure can be found in /PATH/mysql-test/var/log/ndb_restore_print.log

Stopping All Servers

=====

How to repeat:
Found by running the test suite.