Description:
A number of rpl_* tests fail on hpux11
Here are the sample of the test suite output
binlog_stm_binlog [ fail ]
Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/binlog_stm_binlog.result Fri Jun 16 23:56:49 2006
--- r/binlog_stm_binlog.reject Sat Jun 17 03:03:36 2006
***************
*** 141,147 ****
master-bin.000001 # Query 1 # use `test`; insert into t1 values(2 + 4)
master-bin.000001 # Query 1 # use `test`; insert into t1 values(1 + 4)
master-bin.000001 # Xid 1 # COMMIT /* xid= */
- master-bin.000001 # Rotate 1 # master-bin.000002;pos=4
show binlog events in 'master-bin.000002' from 102;
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000002 # Query 1 # use `test`; drop table t1
--- 141,146 ----
-------------------------------------------------------
rpl_ndb_log [ fail ]
Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: In included file "./extra/rpl_tests/rpl_log.test": At line 82: could not sync with master ('select master_pos_wait('master-bin.000002', 198)' returned NULL)
(the last lines may be the most important ones)
Result from queries before failure can be found in r/rpl_ndb_log.log
Killing Possible Leftover Processes
rpl_rotate_logs [ fail ]
Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl_rotate_logs.result Fri Jun 16 23:56:49 2006
--- r/rpl_rotate_logs.reject Sat Jun 17 04:44:56 2006
***************
*** 27,34 ****
flush logs;
show binary logs;
Log_name File_size
! master-bin.000001 596
! master-bin.000002 367
master-bin.000003 102
create table t3 select * from temp_table;
select * from t3;
--- 27,34 ----
flush logs;
show binary logs;
Log_name File_size
! master-bin.000001 552
! master-bin.000002 323
master-bin.000003 102
create table t3 select * from temp_table;
select * from t3;
***************
*** 43,54 ****
purge master logs to 'master-bin.000002';
show master logs;
Log_name File_size
! master-bin.000002 367
master-bin.000003 411
purge binary logs to 'master-bin.000002';
show binary logs;
Log_name File_size
! master-bin.000002 367
master-bin.000003 411
purge master logs before now();
show binary logs;
--- 43,54 ----
purge master logs to 'master-bin.000002';
show master logs;
Log_name File_size
! master-bin.000002 323
master-bin.000003 411
purge binary logs to 'master-bin.000002';
show binary logs;
Log_name File_size
! master-bin.000002 323
master-bin.000003 411
purge master logs before now();
show binary logs;
***************
*** 74,81 ****
create table t4 select * from temp_table;
show binary logs;
Log_name File_size
! master-bin.000003 4189
! master-bin.000004 4194
master-bin.000005 2036
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
--- 74,81 ----
create table t4 select * from temp_table;
show binary logs;
Log_name File_size
! master-bin.000003 4145
! master-bin.000004 4150
master-bin.000005 2036
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
-------------------------------------------------------
rpl_sporadic_master [ fail ]
Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: At line 23: could not sync with master ('select master_pos_wait('master-bin.000002', 334)' returned NULL)
(the last lines may be the most important ones)
Result from queries before failure can be found in r/rpl_sporadic_master.log
Killing Possible Leftover Processes
Restoring snapshot of databases
rpl_stm_log [ fail ]
Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: In included file "./extra/rpl_tests/rpl_log.test": At line 82: could not sync with master ('select master_pos_wait('master-bin.000002', 201)' returned NULL)
(the last lines may be the most important ones)
Result from queries before failure can be found in r/rpl_stm_log.log
Killing Possible Leftover Processes
How to repeat:
run the test suite on hpux
Description: A number of rpl_* tests fail on hpux11 Here are the sample of the test suite output binlog_stm_binlog [ fail ] Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) : mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/binlog_stm_binlog.result Fri Jun 16 23:56:49 2006 --- r/binlog_stm_binlog.reject Sat Jun 17 03:03:36 2006 *************** *** 141,147 **** master-bin.000001 # Query 1 # use `test`; insert into t1 values(2 + 4) master-bin.000001 # Query 1 # use `test`; insert into t1 values(1 + 4) master-bin.000001 # Xid 1 # COMMIT /* xid= */ - master-bin.000001 # Rotate 1 # master-bin.000002;pos=4 show binlog events in 'master-bin.000002' from 102; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Query 1 # use `test`; drop table t1 --- 141,146 ---- ------------------------------------------------------- rpl_ndb_log [ fail ] Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) : mysqltest: In included file "./extra/rpl_tests/rpl_log.test": At line 82: could not sync with master ('select master_pos_wait('master-bin.000002', 198)' returned NULL) (the last lines may be the most important ones) Result from queries before failure can be found in r/rpl_ndb_log.log Killing Possible Leftover Processes rpl_rotate_logs [ fail ] Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) : mysqltest: Result content mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- *** r/rpl_rotate_logs.result Fri Jun 16 23:56:49 2006 --- r/rpl_rotate_logs.reject Sat Jun 17 04:44:56 2006 *************** *** 27,34 **** flush logs; show binary logs; Log_name File_size ! master-bin.000001 596 ! master-bin.000002 367 master-bin.000003 102 create table t3 select * from temp_table; select * from t3; --- 27,34 ---- flush logs; show binary logs; Log_name File_size ! master-bin.000001 552 ! master-bin.000002 323 master-bin.000003 102 create table t3 select * from temp_table; select * from t3; *************** *** 43,54 **** purge master logs to 'master-bin.000002'; show master logs; Log_name File_size ! master-bin.000002 367 master-bin.000003 411 purge binary logs to 'master-bin.000002'; show binary logs; Log_name File_size ! master-bin.000002 367 master-bin.000003 411 purge master logs before now(); show binary logs; --- 43,54 ---- purge master logs to 'master-bin.000002'; show master logs; Log_name File_size ! master-bin.000002 323 master-bin.000003 411 purge binary logs to 'master-bin.000002'; show binary logs; Log_name File_size ! master-bin.000002 323 master-bin.000003 411 purge master logs before now(); show binary logs; *************** *** 74,81 **** create table t4 select * from temp_table; show binary logs; Log_name File_size ! master-bin.000003 4189 ! master-bin.000004 4194 master-bin.000005 2036 show master status; File Position Binlog_Do_DB Binlog_Ignore_DB --- 74,81 ---- create table t4 select * from temp_table; show binary logs; Log_name File_size ! master-bin.000003 4145 ! master-bin.000004 4150 master-bin.000005 2036 show master status; File Position Binlog_Do_DB Binlog_Ignore_DB ------------------------------------------------------- rpl_sporadic_master [ fail ] Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) : mysqltest: At line 23: could not sync with master ('select master_pos_wait('master-bin.000002', 334)' returned NULL) (the last lines may be the most important ones) Result from queries before failure can be found in r/rpl_sporadic_master.log Killing Possible Leftover Processes Restoring snapshot of databases rpl_stm_log [ fail ] Errors are (from /home/pshbuild/pb/mysql-5.1/serg@serg.mylan-20060616223020/mysql-5.1.12-beta-pb1161/mysql-test/var-n_stm-5/log/mysqltest-time) : mysqltest: In included file "./extra/rpl_tests/rpl_log.test": At line 82: could not sync with master ('select master_pos_wait('master-bin.000002', 201)' returned NULL) (the last lines may be the most important ones) Result from queries before failure can be found in r/rpl_stm_log.log Killing Possible Leftover Processes How to repeat: run the test suite on hpux