Bug #29809 Slave SQL errors in warnings file
Submitted: 15 Jul 2007 10:56 Modified: 4 Aug 2007 4:15
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Mats Kindahl CPU Architecture:Any

[15 Jul 2007 10:56] Ingo Strüwing 
Description:
The following tests report miscellaneous error messages in slave.errr:

rpl_deadlock_innodb
rpl_extraCol_innodb
rpl_extraCol_myisam
rpl_incident
rpl_known_bugs_detection
rpl_loaddata
rpl_loaddata_fatal
rpl_rewrt_db
rpl_rotate_logs
rpl_row_inexist_tbl
rpl_row_tabledefs_2myisam
rpl_row_tabledefs_3innodb
rpl_stm_EE_err2
rpl_stm_mystery22
rpl_ndb_extraCol
rpl_truncate_7ndb

Please check some pushbuild warnings files. One of the biggest files is from pb-valgrind, 'pr' test. A non-empty warnings file stops some scripts so that manual handling is required.

NOTE: I am going to disable these test cases. Please re-enable when the problems are fixed.

How to repeat:
bk clone bk-internal.mysql.com:/home/bk/mysql-5.1 'mysql-5.1-amain'
cd 'mysql-5.1-amain'
BUILD/compile-pentium-debug-max --with-debug=full
cd mysql-test
./mysql-test-run.pl rpl_deadlock_innodb rpl_extraCol_innodb rpl_extraCol_myisam rpl_incident rpl_known_bugs_detection rpl_loaddata rpl_loaddata_fatal rpl_rewrt_db rpl_rotate_logs rpl_row_inexist_tbl rpl_row_tabledefs_2myisam rpl_row_tabledefs_3innodb rpl_stm_EE_err2 rpl_stm_mystery22 rpl_ndb_extraCol rpl_truncate_7ndb
[15 Jul 2007 16:46] Ingo Strüwing 
Added rpl_ssl.

Forgot to mention that some of the tests require statement based binlogging, while others require mixed binlogging.
[16 Jul 2007 14:10] Ingo Strüwing 
Added rpl_auto_increment_11932. Seen on vanilla system.
[26 Jul 2007 14:45] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/31623

ChangeSet@1.2540, 2007-07-26 16:44:57+02:00, mats@kindahl-laptop.dnsalias.net +4 -0
  BUG#29809 (Slave SQL errors in warnings file):
  Adding code to filter out slave SQL errors since these are checked by
  the tests themselves.
[4 Aug 2007 1:18] Bugs System 
Pushed into 5.1.21-beta
[4 Aug 2007 4:15] Paul DuBois 
Test suite change. No changelog needed.