Description:
Running cid_ndb_dd2.pl causes errors on all mysqld (5) processes that are running:
Errors:
060328 23:16:10 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:22:04 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:22:27 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:22:56 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:23:46 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:24:09 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:24:38 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:25:01 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:25:49 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Table definition has changed, please retry transaction
060328 23:25:49 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Sort aborted
060328 23:26:20 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:26:41 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Got error 155393856 from storage engine
060328 23:26:41 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Sort aborted
060328 23:26:41 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Got error 152729952 from storage engine
060328 23:26:41 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Sort aborted
060328 23:27:11 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:27:34 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:31:50 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:32:15 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:32:44 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:33:07 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:35:17 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:35:41 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:39:35 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:39:58 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:43:01 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:43:24 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:43:52 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:44:18 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060328 23:47:21 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 7
060328 23:47:43 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060329 0:37:48 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE TESTER2.t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 8
060329 0:38:11 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
060329 0:39:31 [ERROR] Could not discover table 'TESTER2.t1' from binlog schema event 'CREATE TABLE TESTER2.t1 (c1 INT, c2 CHAR(4), c3 FLOAT,
c4 DOUBLE, c5 BIT(4), c6 VARCHAR(100), PRIMARY KEY (c1))
TABLESPACE TESTER2_TS STORAGE DISK ENGINE=NDB' from node 8
060329 0:39:54 [ERROR] NDB: DROP DATABASE TESTER2: error Can't drop database 'TESTER2'; database doesn't exist 1008 1 1
How to repeat:
run attached script to cluster with mutipal MySQLD process attached.