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: | |
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
[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