Bug #29363 rpl.rpl_innodb_mixed_* test failures
Submitted: 26 Jun 2007 17:03 Modified: 4 Sep 2007 20:06
Reporter: Magnus Blaudd
Status: Closed
Category:Server: Tests Severity:S3 (Non-critical)
Version:5.1.20 OS:Any
Assigned to: Serge Kozlov Target Version:5.1.22

[26 Jun 2007 17:03] Magnus Blaudd 
Description:
The two test already in suite "rpl" fails

rpl.rpl_innodb_mixed_ddl       [ fail ]

Errors are (from
/data/msvensson/mysql/wl3933/my51-wl3933-new2/mysql-test/var/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:
-------------------------------------------------------
***
/data/msvensson/mysql/wl3933/my51-wl3933-new2/mysql-test/suite/rpl/r/rpl_innodb_mixed_ddl.result
   Thu Feb  8 12:01:33 2007
---
/data/msvensson/mysql/wl3933/my51-wl3933-new2/mysql-test/suite/rpl/r/rpl_innodb_mixed_ddl.reject
   Tue Jun 26 17:51:50 2007
***************
*** 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.20-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
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

rpl.rpl_innodb_mixed_dml       [ fail ]

Errors are (from
/data/msvensson/mysql/wl3933/my51-wl3933-new2/mysql-test/var/log/mysqltest-time) :
mysqltest: In included file "./suite/rpl/include/rpl_mixed_dml.inc": At line 54: query
'LOAD DATA INFILE '../../suite/rpl/data/rpl_mixed.dat' INTO TABLE t1 FIELDS TERMINATED BY
'|' ' failed: 1290: The MySQL server is running with the --secure-file-priv option so it
cannot execute this statement
(the last lines may be the most important ones)

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

How to repeat:
Run ./mtr --do-test=rpl_innob_mixed
[29 Jun 2007 19:09] 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/29970

ChangeSet@1.2546, 2007-06-29 21:09:00+04:00, skozlov@mysql.com +6 -0
  Bug#29363
[21 Jul 2007 1:45] Bugs System 
Pushed into 5.1.21-beta
[14 Aug 2007 9:33] Rafal Somla 
This patch fixes the first problem with rpl_innodb_mixed_ddl test but not the second one
with rpl_innodb_mixed_dml test. However, there is another patch for BUG#28744 which fixes
the second problem.

Good to push.
[18 Aug 2007 2:15] Bugs System 
Pushed into 5.1.22-beta
[4 Sep 2007 19:11] Bugs System 
Pushed into 5.1.23-beta
[4 Sep 2007 20:06] Paul DuBois 
Test suite change. No changelog entry needed.
[27 Nov 2007 11:51] Bugs System 
Pushed into 5.1.23-rc
[27 Nov 2007 11:53] Bugs System 
Pushed into 6.0.4-alpha