Bug #25395 rpl_ndb_dd_basic.test fails randomly on Debian
Submitted: 3 Jan 2007 20:16 Modified: 23 Mar 2007 11:31
Reporter: Ingo Strüwing Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S2 (Serious)
Version:5.1.15 OS:Linux (Debian Sid kernel 2.6.16 PREEMPT)
Assigned to: li zhou CPU Architecture:Any

[3 Jan 2007 20:16] Ingo Strüwing
Description:
rpl_ndb_dd_basic               [ fail ]

Errors are (from /home/mydev/mysql-5.1-axmrg/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 61: could not sync with master ('select master_pos_wait('master-bin.000001', 1287)' returned NULL)
== MASTER ===========================================================
show master status;
File    master-bin.000001
Position        1287
Binlog_Do_DB
Binlog_Ignore_DB
show slave status;
== SLAVE ===========================================================
show master status;
File    slave-bin.000001
Position        908
Binlog_Do_DB
Binlog_Ignore_DB
show slave status;
Slave_IO_State  Waiting for master to send event
Master_Host     127.0.0.1
Master_User     root
Master_Port     10600
Connect_Retry   1
Master_Log_File master-bin.000001
Read_Master_Log_Pos     1287
Relay_Log_File  slave-relay-bin.000003
Relay_Log_Pos   940
Relay_Master_Log_File   master-bin.000001
Slave_IO_Running        Yes
Slave_SQL_Running       No
Replicate_Do_DB
Replicate_Ignore_DB
Replicate_Do_Table
Replicate_Ignore_Table
Replicate_Wild_Do_Table
Replicate_Wild_Ignore_Table
Last_Errno      1005
Last_Error      Error 'Can't create table 'test.t1' (errno: 157)' on query. Default database: 'test'. Query: 'CREATE TABLE t1
(pk1 int not null primary key, b int not null, c int not null)
tablespace ts1 storage disk
engine ndb'
Skip_Counter    0
Exec_Master_Log_Pos     798
Relay_Log_Space 2580
Until_Condition None
Until_Log_File
Until_Log_Pos   0
Master_SSL_Allowed      No
Master_SSL_CA_File
Master_SSL_CA_Path
Master_SSL_Cert
Master_SSL_Cipher
Master_SSL_Key
Seconds_Behind_Master   NULL
(the last lines may be the most important ones)

How to repeat:
BUILD/compile-pentium-debug-max --with-debug=full --prefix="/home/mydev/install-5.1-axmrg"
cd mysql-test
./mysql-test-run.pl --force --skip-innodb  --mysqld=--binlog-format=statement rpl_ndb_dd_basic
[23 Mar 2007 11:31] Ingo Strüwing
I cannot reproduce it any more either. I think "Can't repeat" is a more appropriate status.