diff options
author | unknown <msvensson@pilot.blaudden> | 2007-05-24 12:03:55 +0200 |
---|---|---|
committer | unknown <msvensson@pilot.blaudden> | 2007-05-24 12:03:55 +0200 |
commit | 8c7956be3b87f915f1819e24b42711eb24041bec (patch) | |
tree | f44511d652e89e4a12f319cf5b1d531a1d0e6bc8 /mysql-test | |
parent | 3043367e730aecd311813ab70ef58ebacf23dfe2 (diff) | |
parent | f0f783786df532ba900aab6dda5eaf28dbc2f23a (diff) | |
download | mariadb-git-8c7956be3b87f915f1819e24b42711eb24041bec.tar.gz |
Merge pilot.blaudden:/home/msvensson/mysql/bug27438/my50-bug27438
into pilot.blaudden:/home/msvensson/mysql/bug27438/my51-bug27438
mysql-test/r/rpl_rotate_logs.result:
Auto merged
mysql-test/t/rpl_rotate_logs.test:
Auto merged
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/rpl_rotate_logs.result | 5 | ||||
-rw-r--r-- | mysql-test/t/rpl_rotate_logs.test | 15 |
2 files changed, 16 insertions, 4 deletions
diff --git a/mysql-test/r/rpl_rotate_logs.result b/mysql-test/r/rpl_rotate_logs.result index 9adde45f87a..f82a1a69060 100644 --- a/mysql-test/r/rpl_rotate_logs.result +++ b/mysql-test/r/rpl_rotate_logs.result @@ -50,7 +50,10 @@ show binary logs; Log_name File_size master-bin.000002 371 master-bin.000003 415 -purge master logs before now(); +select @time_for_purge:=DATE_ADD(UPDATE_TIME, INTERVAL 1 SECOND) +from information_schema.tables +where TABLE_SCHEMA="test" and TABLE_NAME="t2"; +purge master logs before (@time_for_purge); show binary logs; Log_name File_size master-bin.000003 415 diff --git a/mysql-test/t/rpl_rotate_logs.test b/mysql-test/t/rpl_rotate_logs.test index 027747665a3..37248746c19 100644 --- a/mysql-test/t/rpl_rotate_logs.test +++ b/mysql-test/t/rpl_rotate_logs.test @@ -110,9 +110,18 @@ show master logs; # we just tests if synonyms are accepted purge binary logs to 'master-bin.000002'; show binary logs; -# sleeping 10 seconds or more would make the slave believe connection is down ---real_sleep 1 -purge master logs before now(); + +# Calculate time to use in "purge master logs before" by taking +# last modification time of t2 and adding 1 second +# This is donw in order to handle the case where file system +# time differs from mysqld's time +--disable_result_log +select @time_for_purge:=DATE_ADD(UPDATE_TIME, INTERVAL 1 SECOND) + from information_schema.tables + where TABLE_SCHEMA="test" and TABLE_NAME="t2"; +--enable_result_log + +purge master logs before (@time_for_purge); show binary logs; insert into t2 values (65); sync_slave_with_master; |