Bug #28346 rpl_ndb_mix_innodb fails on solaris/mac, mysqld slave core
Submitted: 10 May 2007 6:03 Modified: 30 Jun 2007 10:02
Reporter: Tomas Ulin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S1 (Critical)
Version:5.1 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[10 May 2007 6:03] Tomas Ulin
Description:
/mysql-test-run.pl --tmpdir=/tmp/pbtmp-n_mix-100 --vardir=/tmp/var-n_mix-100 --timer --force --mysqld=--thread-stack=300000 --mysqld=--binlog-format=mixed

core on slave

see pushbuild

How to repeat:
.
[6 Jun 2007 2:56] Guangbao Ni
now it fails ang give the followings information:
Errors are (from /export/home/ngb/telco_bug28346/mysql-test/var/log/mysqltest-time) :
mysqltest: In included file "./extra/rpl_tests/rpl_ndb_apply_status.test": At line 149: could not sync with master ('select master_pos_wait('master-bin.000001', 228063)' returned NULL)

and get the following error messages from mysql-test/var/log/slave.err:
070606  6:25:02 [ERROR] Slave: Error in Update_rows event: row application failed,
Error_code: 0
070606  6:25:02 [ERROR] Slave: Error in Update_rows event: error during transaction
 execution on table tpcb.branch, Error_code: 1105
070606  6:25:02 [Warning] Slave: Got error 4350 'Transaction already aborted' from
NDB Error_code: 1296
070606  6:25:02 [Warning] Slave: Unknown error Error_code: 1105
070606  6:25:02 [Warning] Slave: Unknown error Error_code: 1105
070606  6:25:02 [ERROR] Error running query, slave SQL thread aborted. Fix the prob
lem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master
-bin.000001' position 224758
[7 Jun 2007 6:13] Guangbao Ni
there are some messages in slave.err:
070607  9:30:08 [Note] Slave: received end packet from server, apparent master shut
down:
070607  9:30:08 [Note] Slave I/O thread: Failed reading log event, reconnecting to
retry, log 'master-bin.000001' position 1514
070607  9:30:08 [ERROR] Slave I/O thread: error reconnecting to master 'root@127.0.
0.1:9306':                       Error: 'Can't connect to MySQL server on '127.0.0.
1' (146)'  errno: 2003  retry-time: 1  retries: 10
070607  9:30:08 [Note] /export/home/ngb/telco_bug28346/sql/mysqld: Normal shutdown

070607  9:30:08 [Note] Event Scheduler: Purging the queue. 0 events
070607  9:30:08 [Note] Slave I/O thread killed during or after a reconnect done to
recover from failed read
070607  9:30:08 [Note] Slave I/O thread exiting, read up to log 'master-bin.000001'
, position 1514
070607  9:30:08 [Note] Error reading relay log event: slave SQL thread was killed

and it seems that there is no any valuable messages in master.err
[30 Jun 2007 10:02] Tomas Ulin
duplicate with 28123