Bug #40759 backup.backup test fails with wrong validity_point_time on powermacg5
Submitted: 15 Nov 2008 9:26 Modified: 11 Feb 2009 3:20
Reporter: John Embretsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:6.0.9-bzr OS:MacOS (PPC, 64 bit (powermacg5). Build type -max, debug.)
Assigned to: Øystein Grøvlen CPU Architecture:Any
Tags: pushbuild, test failure

[15 Nov 2008 9:26] John Embretsen
Description:
As seen in Pushbuild in mysql-6.0-falcon branch and its sub-branches:

backup.backup                  [ fail ]

--- /Users/henry/pb/bzr_mysql-6.0-falcon/111/mysql-6.0.9-alpha-pb111/mysql-test/suite/backup/r/backup.result	Fri Nov 14 19:59:46 2008
+++ /Users/henry/pb/bzr_mysql-6.0-falcon/111/mysql-6.0.9-alpha-pb111/mysql-test/suite/backup/r/backup.reject	Fri Nov 14 23:44:31 2008
@@ -135,7 +135,7 @@
 SELECT validity_point_time = @vp_time FROM mysql.backup_history
 WHERE backup_id = @bid;
 validity_point_time = @vp_time
-1
+0
 SELECT binlog_file = @vp_file FROM mysql.backup_history
 WHERE backup_id = @bid;
 binlog_file = @vp_file

mysqltest: Result content mismatch

Stopping All Servers
Restoring snapshot of databases

How to repeat:
Run the default test suite(s) using mysql-test-run, using a debug build of mysql-6.0 (including debug_sync support). It might be enough to run only the backup test in the backup suite (not verified at this time).

cd mysql-test

perl ./mysql-test-run.pl --suite=backup backup
[18 Nov 2008 10:13] John Embretsen
For root cause analysis, see Bug#40807 - "Validity point corrupt on restore on powermac platform". Further efforts are probably better placed there, so closing this as duplicate.
[23 Dec 2008 12:48] Øystein Grøvlen
I do not think this is a duplicate of Bug#40807.  I have not been able to make backup test fail on powermac in 100 runs.  However, I observe that the vp_time is wrong as reported in Bug#40807.  However, this test does not test that vp_time is correct, but that it is the same for both backup and restore.

I suggest the backup test is enabled to see if this is still a problem.
[23 Dec 2008 12:55] Øystein Grøvlen
Note that there has been a slight change to the backup test since this was reported.  The failing statement has been combined with a few similar statements into the following:

SELECT validity_point_time = @vp_time, 
       binlog_file = @vp_file, 
       binlog_pos = @vp_pos
FROM mysql.backup_history
WHERE backup_id = @bid; 

Not that I understand how that should make a difference.
[29 Dec 2008 12:07] 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/62403

2745 oystein.grovlen@sun.com	2008-12-29
      BUG#40759 backup.backup test fails with wrong validity_point_time on powermacg5
      
      I am re-enabling the backup test since I have not been able to make it fail in
      100 runs on the powermac platform.  Note also that the statement that failed
      has been changed slightly since this bug was reported.
[29 Dec 2008 13:23] Ingo Strüwing
Approved. No second review required for just re-enabling a test case.
[29 Dec 2008 16:25] Øystein Grøvlen
Patch pushed:
revno: 2745
revision-id: oystein.grovlen@sun.com-20081229120648-nkn432wq0j80hbus
[2 Feb 2009 16:07] Bugs System
Pushed into 6.0.10-alpha (revid:sergefp@mysql.com-20090202090240-dlkxhmc1asrar5rl) (version source revid:sergefp@mysql.com-20090129100938-qvke7a9krg24l8pl) (merge vers: 6.0.10-alpha) (pib:6)
[11 Feb 2009 3:20] Paul DuBois
Test case changes. No changelog entry needed.