Bug #29363 rpl.rpl_innodb_mixed_* test failures
Submitted: 26 Jun 2007 15:03 Modified: 4 Sep 2007 18:06
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.20 OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any

[26 Jun 2007 15:03] Magnus Blåudd
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 17: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
[20 Jul 2007 23:45] Bugs System
Pushed into 5.1.21-beta
[14 Aug 2007 7: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 0:15] Bugs System
Pushed into 5.1.22-beta
[4 Sep 2007 17:11] Bugs System
Pushed into 5.1.23-beta
[4 Sep 2007 18:06] Paul DuBois
Test suite change. No changelog entry needed.
[27 Nov 2007 10:51] Bugs System
Pushed into 5.1.23-rc
[27 Nov 2007 10:53] Bugs System
Pushed into 6.0.4-alpha