Description:
The tests "rpl_semi_sync" and "rpl_semi_sync_event" fail on AIX due to server crashes:
=====
rpl.rpl_semi_sync 'row' [ retry-fail ]
Test ended at YYYY-MM-DD HH:MM:SS
CURRENT_TEST: rpl.rpl_semi_sync
mysqltest: At line NNN: query 'create table t1 (a int) engine=$engine_type' failed: 2013: Lost connection to M
ySQL server during query
The result from queries just before the failure was:
< snip >
rpl_semi_sync_master_enabled OFF
[ enable semi-sync on master ]
set global rpl_semi_sync_master_enabled = 1;
show variables like 'rpl_semi_sync_master_enabled';
Variable_name Value
rpl_semi_sync_master_enabled ON
[ status of semi-sync on master should be ON even without any semi-sync slaves ]
show status like 'Rpl_semi_sync_master_clients';
Variable_name Value
Rpl_semi_sync_master_clients 0
show status like 'Rpl_semi_sync_master_status';
Variable_name Value
Rpl_semi_sync_master_status ON
show status like 'Rpl_semi_sync_master_yes_tx';
Variable_name Value
Rpl_semi_sync_master_yes_tx 0
#
# BUG#45672 Semisync repl: ActiveTranx:insert_tranx_node: transaction node allocation failed
# BUG#45673 Semisynch reports correct operation even if no slave is connected
#
More results from queries before failure can be found in /PATH/mysql-test/var/log/rpl_semi_sync.log
- saving '/PATH/mysql-test/var/log/rpl.rpl_semi_sync-row/' to '/PATH/mysql-test/var/log/rpl.rpl_semi_sync-row
/'
=====
=====
rpl.rpl_semi_sync_event 'row' [ retry-fail ]
Test ended at YYYY-MM-DD HH:MM:SS
CURRENT_TEST: rpl.rpl_semi_sync_event
mysqltest: At line NNN: query 'CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f varchar(8)) ENGIN
E=$engine_type' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
include/stop_slave.inc
include/start_slave.inc
SET GLOBAL event_scheduler = ON;
- saving '/PATH/mysql-test/var/log/rpl.rpl_semi_sync_event-row/' to '/PATH/mysql-test/var/log/rpl.rpl_semi_sy
nc_event-row/'
=====
Similar failures for the other modes "stmt" and "mix".
I have not seen these crashes in 5.5.0.
How to repeat:
Run the test suite on AIX.
Description: The tests "rpl_semi_sync" and "rpl_semi_sync_event" fail on AIX due to server crashes: ===== rpl.rpl_semi_sync 'row' [ retry-fail ] Test ended at YYYY-MM-DD HH:MM:SS CURRENT_TEST: rpl.rpl_semi_sync mysqltest: At line NNN: query 'create table t1 (a int) engine=$engine_type' failed: 2013: Lost connection to M ySQL server during query The result from queries just before the failure was: < snip > rpl_semi_sync_master_enabled OFF [ enable semi-sync on master ] set global rpl_semi_sync_master_enabled = 1; show variables like 'rpl_semi_sync_master_enabled'; Variable_name Value rpl_semi_sync_master_enabled ON [ status of semi-sync on master should be ON even without any semi-sync slaves ] show status like 'Rpl_semi_sync_master_clients'; Variable_name Value Rpl_semi_sync_master_clients 0 show status like 'Rpl_semi_sync_master_status'; Variable_name Value Rpl_semi_sync_master_status ON show status like 'Rpl_semi_sync_master_yes_tx'; Variable_name Value Rpl_semi_sync_master_yes_tx 0 # # BUG#45672 Semisync repl: ActiveTranx:insert_tranx_node: transaction node allocation failed # BUG#45673 Semisynch reports correct operation even if no slave is connected # More results from queries before failure can be found in /PATH/mysql-test/var/log/rpl_semi_sync.log - saving '/PATH/mysql-test/var/log/rpl.rpl_semi_sync-row/' to '/PATH/mysql-test/var/log/rpl.rpl_semi_sync-row /' ===== ===== rpl.rpl_semi_sync_event 'row' [ retry-fail ] Test ended at YYYY-MM-DD HH:MM:SS CURRENT_TEST: rpl.rpl_semi_sync_event mysqltest: At line NNN: query 'CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f varchar(8)) ENGIN E=$engine_type' failed: 2013: Lost connection to MySQL server during query The result from queries just before the failure was: stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; include/stop_slave.inc include/start_slave.inc SET GLOBAL event_scheduler = ON; - saving '/PATH/mysql-test/var/log/rpl.rpl_semi_sync_event-row/' to '/PATH/mysql-test/var/log/rpl.rpl_semi_sy nc_event-row/' ===== Similar failures for the other modes "stmt" and "mix". I have not seen these crashes in 5.5.0. How to repeat: Run the test suite on AIX.