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:
None 
Category:MySQL Server: Backup Severity:S1 (Critical)
Version:6.0 OS:Any
Assigned to: Hema Sridharan CPU Architecture:Any
Tags: experimental, PB, test faliure
Triage: Triaged: D3 (Medium)

[22 Jan 2010 8:16] Alexander Nozdrin
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
[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)