| Bug #50536 | backup_ptr.* tests fail in PB | ||
|---|---|---|---|
| Submitted: | 22 Jan 2010 8:16 | Modified: | 25 Feb 2010 1:37 |
| Reporter: | Alexander Nozdrin | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Backup | Severity: | S1 (Critical) |
| Version: | 6.0 | OS: | Any |
| Assigned to: | Hema Sridharan | CPU Architecture: | Any |
| Tags: | experimental, PB, test faliure | ||
[22 Jan 2010 8:17]
Alexander Nozdrin
backup_ptr.* tests marked experimental.
[22 Jan 2010 15:52]
Rafal Somla
A hypothesis. I noticed that e.g., backup_ptr test uses date "2010-01-21" when replaying binlog. For example here (line 286 in test script): --exec $MYSQL_BINLOG --database=ptr --start-datetime="2010-01-21 15:32:22" --stop-datetime="2010-01-21 15:32:24" $MYSQLD_DATADIR/master-bin.000001 |$MYSQL I don't understand this fully, but I guess that this was supposed to be an artificial date chosen "far" in the future and only then test works correctly. But now it is 2010-01-22 and here we are - test started to fail yesterday. So I guess moving the date further into the future could fix this.
[22 Jan 2010 17:16]
Hema Sridharan
I repeat this behavior in backup team trees also. The reason for this test failure is as stated by rafal.
[22 Jan 2010 19: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/97928 2938 Hema Sridharan 2010-01-22 BUG#50536 (backup_ptr* test fails) The test failed because of prefixed date 2010-01-21 which has become past. This patch will fix the failing test and replace the datetime to future date. The test will use this date to binlog recovery of data before and after backup. modified: mysql-test/suite/backup_ptr/r/backup_ptr.result mysql-test/suite/backup_ptr/r/backup_ptr_commits.result mysql-test/suite/backup_ptr/r/backup_ptr_objects.result mysql-test/suite/backup_ptr/t/backup_ptr.test mysql-test/suite/backup_ptr/t/backup_ptr_commits.test mysql-test/suite/backup_ptr/t/backup_ptr_objects.test
[22 Jan 2010 20:12]
Chuck Bell
Approved. Only one reviewer needed.
[22 Jan 2010 20:33]
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/97934 3072 Chuck Bell 2010-01-22 BUG#50536 (backup_ptr* test fails) original changeset: 2938 (mysql-6.0-backup)
[25 Jan 2010 14:47]
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/98060 3845 Chuck Bell 2010-01-25 BUG#50536 (backup_ptr* test fails) The test failed because of prefixed date 2010-01-21 which has become past. This patch will fix the failing test and replace the datetime to future date. The test will use this date to binlog recovery of data before and after backup.
[26 Jan 2010 19:44]
Omer Barnir
triage: setting tag to SRFETURE (test issue in feature tree)
[13 Feb 2010 8:36]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100213083436-9pesg4h55w1mekxc) (version source revid:luis.soares@sun.com-20100211135109-t63avry9fqpgyh78) (merge vers: 6.0.14-alpha) (pib:16)
[13 Feb 2010 17:46]
Paul DuBois
Test case changes. No changelog entry needed.
[20 Feb 2010 9:17]
Bugs System
Pushed into 6.0.14-alpha (revid:ingo.struewing@sun.com-20100218152520-s4v1ld76bif06eqn) (version source revid:ingo.struewing@sun.com-20100122221225-ccgkfpesvrttdlc1) (merge vers: 6.0.14-alpha) (pib:16)
Description: backup_ptr.backup_ptr 'mix' [ fail ] Test ended at 2010-01-22 00:28:06 CURRENT_TEST: backup_ptr.backup_ptr mysqltest: At line 288: query 'SELECT * FROM ptr.t1' failed: 1146: Table 'ptr.t1' doesn't exist backup_ptr.backup_ptr_objects 'row' [ fail ] Test ended at 2010-01-22 00:28:08 CURRENT_TEST: backup_ptr.backup_ptr_objects mysqltest: At line 495: query 'SHOW TRIGGERS FROM ptr_ob1' failed: 1049: Unknown database 'ptr_ob1' backup_ptr.backup_ptr_commits 'stmt' [ fail ] Test ended at 2010-01-22 00:28:19 CURRENT_TEST: backup_ptr.backup_ptr_commits mysqltest: At line 189: query 'SHOW TABLES FROM ptr' failed: 1049: Unknown database 'ptr' How to repeat: http://tinyurl.com/yb9zzcp