| Bug #69455 | test rpl.rpl_deadlock_innodb fails on RedHat 6 | ||
|---|---|---|---|
| Submitted: | 12 Jun 2013 20:05 | Modified: | 26 Nov 2013 9:04 |
| Reporter: | ben harper | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.5.32 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[12 Jun 2013 22:29]
MySQL Verification Team
Thank you for the bug report. Verified on CentOS 6.4 :
rpl.rpl_truncate_3innodb [ pass ] 11701
rpl.rpl_typeconv_innodb [ skipped ] Doesn't support --binlog-format='mixed'
rpl.rpl_deadlock_innodb [ fail ] Found warnings/errors in server log file!
Test ended at 2013-06-12 19:22:49
line
130613 1:22:05 InnoDB: Error: table `mysqld.2`.`#sqla73_5e_1` does not exist in the InnoDB internal
130613 1:22:05 InnoDB: Error: table `mysqld.2`.`#sqla73_e8_1` does not exist in the InnoDB internal
^ Found warnings in /home/miguel/bzr/mysql-5.5/mysql-test/var/log/mysqld.2.err
ok
- saving '/home/miguel/bzr/mysql-5.5/mysql-test/var/log/rpl.rpl_deadlock_innodb/' to '/home/miguel/bzr/mysql-5.5/mysql-test/var/log/rpl.rpl_deadlock_innodb/'
rpl.rpl_relayrotate [ pass ] 31960
rpl.rpl_stm_relay_ign_space [ skipped ] Doesn't support --binlog-format='mixed'
rpl.rpl_skip_error [ pass ] 7441
rpl.rpl_circular_for_4_hosts [ pass ] 174160
rpl.rpl_current_user [ skipped ] Doesn't support --binlog-format='mixed'
rpl.rpl_heartbeat_2slaves [ pass ] 14743
[miguel@tikal mysql-test]$ cat /etc/issue
CentOS release 6.4 (Final)
Kernel \r on an \m
[14 Aug 2013 19:54]
ben harper
This test is also failing in 5.5.33.
[26 Nov 2013 9:04]
Erlend Dahl
A fix for this was pushed in 5.5.35, 5.6.16, 5.7.3. Please open a new bug if a similar issue occurs.
Description: When attempting to build mysql 5.5.32, the rpl.rpl_deadlock_innodb test fails on RedHat 6, but not RedHat 5. I am getting the same error using the mysql community rpms. Here are the entries from build.log: *** rpl.rpl_truncate_3innodb [ pass ] 995 rpl.rpl_typeconv_innodb [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_deadlock_innodb [ fail ] Found warnings/errors in server log file! Test ended at 2013-06-11 12:23:32 line 130611 20:22:53 InnoDB: Error: table `mysqld.2`.`#sql7f56_5e_1` does not exist in the InnoDB internal 130611 20:22:53 InnoDB: Error: table `mysqld.2`.`#sql7f56_e8_1` does not exist in the InnoDB internal ^ Found warnings in /builddir/build/BUILD/mysql-5.5.32/mysql-test/var/log/mysqld.2.err ok - saving '/builddir/build/BUILD/mysql-5.5.32/mysql-test/var/log/rpl.rpl_deadlock_innodb/' to '/builddir/build/BUILD/mysql-5.5.32/mysql-test/var/log/rpl.rpl_deadlock_innodb/' rpl.rpl_relayrotate [ pass ] 5653 rpl.rpl_stm_relay_ign_space [ skipped ] Doesn't support --binlog-format='mixed' rpl.rpl_skip_error [ pass ] 526 *** and from mysqld.2.err: *** CURRENT_TEST: rpl.rpl_deadlock_innodb 130604 22:46:01 [Note] Plugin 'FEDERATED' is disabled. 130604 22:46:01 InnoDB: The InnoDB memory heap is disabled 130604 22:46:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130604 22:46:01 InnoDB: Compressed tables use zlib 1.2.3 130604 22:46:01 InnoDB: Using Linux native AIO 130604 22:46:01 InnoDB: Initializing buffer pool, size = 8.0M 130604 22:46:01 InnoDB: Completed initialization of buffer pool 130604 22:46:01 InnoDB: highest supported file format is Barracuda. 130604 22:46:01 InnoDB: Waiting for the background threads to start 130604 22:46:02 InnoDB: 5.5.32 started; log sequence number 1595675 130604 22:46:02 [Warning] /builddir/build/BUILD/mysql-5.5.32/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 130604 22:46:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 10071 130604 22:46:02 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130604 22:46:02 [Note] Server socket created on IP: '0.0.0.0'. 130604 22:46:02 InnoDB: Error: table `mysqld.2`.`#sql7a43_e8_1` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html 130604 22:46:02 InnoDB: Error: table `mysqld.2`.`#sql7a43_5e_1` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html *** I get the same errors on the mysql community rpms. It is not clear to me if this is an issue with the test itself or functionality within mysql. If it is an issue with the test, I could skip this test when building for RedHat 6. -Ben How to repeat: Run the following command: /usr/share/mysql-test/mysql-test-run.pl --force --retry=0 --ssl --mysqld=--binlog-format=mixed --suite-timeout=720 --testcase-timeout=30