List:Backup« Previous MessageNext Message »
From:Ingo Strüwing Date:September 28 2009 8:44am
Subject:Re: backup.backup_logs fails on total_bytes
View as plain text  
Hi Chuck,

Charles Bell, 25.09.2009 16:59:

> Ingo,
> 
> I was not able to reproduce this problem. Have you tried comparing two
> backup image files (diff) to see what changed?

It is a difference in the MySQL version number.

mysql-6.0-backup         5.4.4-alpha
mysql-6.0-backup-merge   6.0.14-alpha

With 'dd' I constructed an image from the latter one, where I cut the
'4' from the version number and pushed the rest together. The resulting
image had little differences with the former one.

The image header contains the server version numerically and as a
string. This means that the image size depends on the version string
length. We will probably need to repeat that investigation in the future
too, whenever the version string length changes...

I will change the test result to accept the current image size and add a
warning for the next time:

=== modified file 'mysql-test/suite/backup/t/backup_logs.test'
--- mysql-test/suite/backup/t/backup_logs.test  2009-09-15 15:02:17 +0000
+++ mysql-test/suite/backup/t/backup_logs.test  2009-09-28 08:39:31 +0000
@@ -369,8 +369,16 @@ FROM mysql.backup_history WHERE backup_i
 #Show results

 SHOW VARIABLES LIKE 'log_backup_output';
+--echo #
+--echo # Note that the backup image size (total_bytes) changes
+--echo # when the server version string length changes.
+# Suppress statement to keep comment in diff section.
+--disable_query_log
+--replace_regex /[0-9]/#/ /-.*//
+SELECT VERSION();
+--enable_query_log
 --replace_column 1 # 2 # 3 # 4 # 10 # 11 # 12 # 15 # 16 #
 --query_vertical SELECT * FROM mysql.backup_history WHERE backup_id = 500;
 --replace_column 1 # 3 # 4 #
@@ -458,8 +466,16 @@ SET DEBUG_SYNC= 'now WAIT_FOR complete';
 SELECT timediff(now(),@start_restore) > 5;

 #Show results
+--echo #
+--echo # Note that the backup image size (total_bytes) changes
+--echo # when the server version string length changes.
+# Suppress statement to keep comment in diff section.
+--disable_query_log
+--replace_regex /[0-9]/#/ /-.*//
+SELECT VERSION();
+--enable_query_log
 --replace_column 1 # 2 # 3 # 4 # 10 # 11 # 12 # 15 # 16 #
 --query_vertical SELECT * FROM mysql.backup_history WHERE backup_id = 501;


Regards
Ingo
-- 
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder,   Wolfgang Engels,   Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring   HRB München 161028
Thread
backup.backup_logs fails on total_bytesIngo Strüwing22 Sep
  • Re: backup.backup_logs fails on total_bytesRafal Somla22 Sep
    • Re: backup.backup_logs fails on total_bytesIngo Strüwing22 Sep
      • Re: backup.backup_logs fails on total_bytesRafal Somla22 Sep
  • Re: backup.backup_logs fails on total_bytesCharles Bell22 Sep
  • Re: backup.backup_logs fails on total_bytesCharles Bell22 Sep
    • Re: backup.backup_logs fails on total_bytesIngo Strüwing22 Sep
      • Re: backup.backup_logs fails on total_bytesCharles Bell25 Sep
        • Re: backup.backup_logs fails on total_bytesIngo Strüwing25 Sep
        • Re: backup.backup_logs fails on total_bytesIngo Strüwing28 Sep