Bug #28744 Test: Test suite "rpl" is not fit for release-build testing
Submitted: 29 May 2007 12:27 Modified: 20 Aug 2007 15:06
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.19-beta OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any

[29 May 2007 12:27] Joerg Bruehe
Description:
There is *no* platform on which even one of the tests in the "rpl" suite passes.

Found during the build of version 5.1.19-beta:

1) The result file is bound to a "debug" build of 5.1.16,
this restriction must be lifted:

-------------------------------------------------------
*** /PATH/mysql-test/suite/rpl/r/rpl_innodb_mixed_ddl.result
--- /PATH/mysql-test/suite/rpl/r/rpl_innodb_mixed_ddl.reject
***************
*** 138,144
  ******************** SHOW BINLOG EVENTS ********************
  show binlog events from 1;
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
! master-bin.000001     #       Format_desc     1       #       Server ver: 5.1.16-beta-debug-log, Binlog ver: 4
  master-bin.000001     #       Query   1       #       DROP DATABASE IF EXISTS test_rpl
  master-bin.000001     #       Query   1       #       DROP DATABASE IF EXISTS test_rpl_1
  master-bin.000001     #       Query   1       #       CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_
ci
--- 138,144
  ******************** SHOW BINLOG EVENTS ********************
  show binlog events from 1;
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
! master-bin.000001     #       Format_desc     1       #       Server ver: 5.1.19-beta-log, Binlog ver: 4
  master-bin.000001     #       Query   1       #       DROP DATABASE IF EXISTS test_rpl
  master-bin.000001     #       Query   1       #       DROP DATABASE IF EXISTS test_rpl_1
  master-bin.000001     #       Query   1       #       CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_
ci
-------------------------------------------------------

2) Server has crashed / is not restarted / ... ?  for the next test:

=====
Errors are (from /PATH/mysqltest-time) :
mysqltest: In included file "./suite/rpl/include/rpl_mixed_check_event.inc": At line 11: failed in 'select master_pos_wait(
'master-bin.000001', 11972)': 2006: MySQL server has gone away
(the last lines may be the most important ones)
=====
(occurred on most all platforms except the below ones)

=====
Errors are (from /PATH/mysqltest-time) :
mysqltest: In included file "./suite/rpl/include/rpl_mixed_check_event.inc": At line 11: failed in 'select master_pos_wait(
'master-bin.000001', 11972)': 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)
=====
OS X x86, PPC(32);
HP-UX 11.11 (HP-PA) both 32 + 64 bit;
Solaris 10 x86 + x86_64

How to repeat:
Found while running the test suite in release builds.

Suggested fix:
For 1), if the version output is needed to check the correct working,
then ensure that exactly the current version gets replaced in the log
by some fixed string ("CURRENT" ?).
[1 Aug 2007 10:53] 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/31949

ChangeSet@1.2548, 2007-08-01 14:52:10+04:00, skozlov@mysql.com +3 -0
  Fix for Bug#28744, bug#29363
[14 Aug 2007 7:33] Rafal Somla
Good to push.
[18 Aug 2007 0:15] Bugs System
Pushed into 5.1.22-beta
[20 Aug 2007 15:06] Paul DuBois
Test suite change. No changelog entry needed.
[23 Aug 2007 15:10] 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/32973

ChangeSet@1.2571, 2007-08-23 16:31:21+04:00, skozlov@mysql.com +4 -0
  Bug#28744, Bug#29363
[4 Sep 2007 17:11] Bugs System
Pushed into 5.1.23-beta