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.
© 2020, Oracle Corporation and/or its affiliates
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.