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
