| Bug #48308 | binlog_auto_increment_bug33029 fails on PB2: "Could not find target..." | ||
|---|---|---|---|
| Submitted: | 26 Oct 2009 12:45 | Modified: | 6 Mar 2010 23:57 |
| Reporter: | Luis Soares | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Replication | Severity: | S3 (Non-critical) |
| Version: | 6.0 codebase | OS: | Solaris |
| Assigned to: | Serge Kozlov | CPU Architecture: | Any |
| Tags: | pb2 | ||
[29 Jan 2010 12:43]
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/98614 3859 Serge Kozlov 2010-01-29 Bug#48308. The error appears if relay file does not exist or index file contains wrong data. So the patch does following 1. Replaced SELECT INTO DUMPFILE by copy_file command (because --secure-file-priv can affect to behavior SELECT INTO DUMPFILE) 2. Check index file before CHANGE MASTER 3. Optimzed condition. added: mysql-test/std_data/bug33029-unix-slave-relay-bin.index mysql-test/std_data/bug33029-win-slave-relay-bin.index modified: mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test
[31 Jan 2010 17:59]
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/98780 3859 Serge Kozlov 2010-01-31 Bug#48308. The reason of bug is file relay-log.info that points to another relay binlog file. For correct behavior of test either the file should not exist or contain proper data. Adding option --relay-log-file-info tells server do not use the file with default name. modified: mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt
[31 Jan 2010 18:21]
Serge Kozlov
My previous suggestions are wrong. Current analyzing of files for passed and failed cases shows following: 1. slave-bin.000001 exist for both 2. slave-bin.index exist for both and contain proper data 3. Failed case has relay-log.info with content: <=============BOF================> ./mysqld-relay-bin.000001 4 0 <=============EOF================> 4. Passed case doesn't have relay-log.info Suggested patch can be implemented in two ways: 1. Update relay-log.info with proper information. 2. Delete relay-log.info if it exists. 3. Tell server to use another file name for this purpose. First two items can not guarantee no failures because that file can be used by server and a modification will fail. The patch implements third way.
[3 Feb 2010 20:38]
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/99159 3862 Serge Kozlov 2010-02-03 Bug#48308. The patch seeks for relay log info file and removes it if it exists. In this case relay-log.info won't affect to CHANGE MASTER. modified: mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test
[5 Feb 2010 12:35]
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/99407 3865 Serge Kozlov 2010-02-05 Bug#48308. 1. Now test use fake_relay_log primitive 2. include/setup_fake_relay_log.inc removes relay log info file if it exists 3. Test moved to rpl suite as rpl_binlog_auto_inc_bug33029.test 4. Updated result file renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[8 Feb 2010 19:40]
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/99626 3865 Serge Kozlov 2010-02-08 Bug#48308. 1. Now test use fake_relay_log primitive 2. Added RESET SLAVE to include/setup_fake_relay_log.inc for removing relay log info file 3. Test moved to rpl suite as rpl_binlog_auto_inc_bug33029.test 4. Updated result file renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[15 Feb 2010 12:21]
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/100369 3865 Serge Kozlov 2010-02-15 Bug#48308. 1. Now test use fake_relay_log primitive 2. Added RESET SLAVE to include/setup_fake_relay_log.inc for removing relay log info file 3. Added RESET SLAVE to include/cleanup_fake_relay_log.inc 4. Test moved to rpl suite as rpl_binlog_auto_inc_bug33029.test 5. Updated result file renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/cleanup_fake_relay_log.inc mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[15 Feb 2010 20:54]
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/100442 2980 Serge Kozlov 2010-02-15 Bug#48308. 1. Now test use fake_relay_log primitive 2. Added RESET SLAVE to include/setup_fake_relay_log.inc for removing relay log info file 3. Added RESET SLAVE to include/cleanup_fake_relay_log.inc 4. Test moved to rpl suite as rpl_binlog_auto_inc_bug33029.test 5. Updated result file renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/cleanup_fake_relay_log.inc mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[15 Feb 2010 21:03]
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/100443 2961 Serge Kozlov 2010-02-16 [merge] Merge for Bug#48308 renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/cleanup_fake_relay_log.inc mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[15 Feb 2010 21:19]
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/100445 2980 Serge Kozlov 2010-02-16 Bug#48308. 1. Now test use fake_relay_log primitive 2. Added RESET SLAVE to include/setup_fake_relay_log.inc for removing relay log info file 3. Added RESET SLAVE to include/cleanup_fake_relay_log.inc 4. Test moved to rpl suite as rpl_binlog_auto_inc_bug33029.test 5. Updated result file renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/cleanup_fake_relay_log.inc mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[15 Feb 2010 21:22]
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/100446 2963 Serge Kozlov 2010-02-16 [merge] Bug#48308. Merge mysql-trunk-bugfixing -> mysql-next-mr-bugfixing renamed: mysql-test/suite/binlog/r/binlog_auto_increment_bug33029.result => mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/binlog/t/binlog_auto_increment_bug33029-master.opt => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029-master.opt mysql-test/suite/binlog/t/binlog_auto_increment_bug33029.test => mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test modified: mysql-test/include/cleanup_fake_relay_log.inc mysql-test/include/setup_fake_relay_log.inc mysql-test/suite/rpl/r/rpl_binlog_auto_inc_bug33029.result mysql-test/suite/rpl/t/rpl_binlog_auto_inc_bug33029.test
[16 Feb 2010 19:37]
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/100548 2980 Serge Kozlov 2010-02-16 Bug#48308. 1. Now test use fake_relay_log primitive 2. Added RESET SLAVE to include/setup_fake_relay_log.inc for removing relay log info file 3. Added RESET SLAVE to include/cleanup_fake_relay_log.inc 4. Test moved to rpl suite as rpl_binlog_auto_inc_bug33029.test 5. Updated result file
[16 Feb 2010 19:43]
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/100550 2963 Serge Kozlov 2010-02-16 [merge] Bug#48308 Merge mysql-trunk-bugfixing -> mysql-next-mr-bugfixing
[16 Feb 2010 19:48]
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/100551 2930 Serge Kozlov 2010-02-16 [merge] Bug#48308 Merge mysql-next-mr-bugfixing -> mysql-6.0-codebase-bugfixing
[19 Feb 2010 19:38]
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/100914 2982 Serge Kozlov 2010-02-19 Bug#48308. Post-fix Removed --remove_file in cleanup procedure
[19 Feb 2010 19:42]
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/100915 2970 Serge Kozlov 2010-02-19 [merge] Bug#48308. Merge mysql-trunk-bugfixing -> mysql-next-mr-bugfixing
[19 Feb 2010 19:46]
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/100916 2937 Serge Kozlov 2010-02-19 [merge] Bug#48308. Merge mysql-next-mr-bugfixing -> mysql-6.0-codebase-bugfixing
[25 Feb 2010 19:47]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100225194420-p60r4u90tszj8q2x) (version source revid:serge.kozlov@sun.com-20100219194410-705mazyallw4gejx) (merge vers: 6.0.14-alpha) (pib:16)
[25 Feb 2010 19:47]
Bugs System
Pushed into 5.5.3-m2 (revid:alik@sun.com-20100225194201-ybqxv77ofcxib3or) (version source revid:serge.kozlov@sun.com-20100219193723-t5e9bvuj71lsnaah) (merge vers: 5.5.3-m2) (pib:16)
[25 Feb 2010 19:49]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100225194305-h49uyjrlfl3mwo60) (version source revid:serge.kozlov@sun.com-20100219194020-u222t8hdt4na6pji) (pib:16)
[25 Feb 2010 20:38]
Paul DuBois
Changes to test cases. No changelog entry needed. Setting report to Need Merge pending push of Celosia to release tree.
[6 Mar 2010 11:07]
Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:alik@sun.com-20100225195857-farb6yvy8x06bylj) (merge vers: 5.5.99-m3) (pib:16)
[6 Mar 2010 23:57]
Paul DuBois
No changelog entry needed.
Description: binlog_auto_increment_bug33029 fails on PB2. Failure details =============== Where Build Test Run Suite Case Mode When mysql-6.0-codebase-bugfixing 618574 binary-max-snv111b-x86_64-tar-gz 618712 loki51 test-max-snv111b-x86_64 618923 loki51 rpl_binlog_row binlog binlog_auto_increment_bug33029 None 2009-10-23 16:49:24 Failure symptom =============== binlog.binlog_auto_increment_bug33029 [ fail ] Test ended at 2009-10-23 18:21:34 CURRENT_TEST: binlog.binlog_auto_increment_bug33029 mysqltest: At line 45: query 'change master to MASTER_HOST='dummy.localdomain', RELAY_LOG_FILE='slave-relay-bin.000001', RELAY_LOG_POS=4' failed: 1380: Failed initializing relay log position: Could not find target log during relay log initialization The result from queries just before the failure was: SET @old_relay_log_purge= @@global.relay_log_purge; - saving '/export/home2/pb2/test/sb_1-873938-1256312255.35/mysql-6.0.14-alpha-solaris11-i386-test/mysql-test/var-rpl_binlog_row/log/binlog.binlog_auto_increment_bug33029/' to '/export/home2/pb2/test/sb_1-873938-1256312255.35/mysql-6.0.14-alpha-solaris11-i386-test/mysql-test/var-rpl_binlog_row/log/binlog.binlog_auto_increment_bug33029/' Retrying test, attempt(2/3)... How to repeat: see: http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2402300 Suggested fix: n/a