mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-10-31 19:06:14 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/binlog/r/binlog_expire_warnings.result
Sujatha 1ef3207cb8 MDEV-19371: Implement binlog_expire_logs_seconds for purging of binary logs 
Part2: Test scripts
2021-05-10 09:36:40 +05:30

134 lines
8.2 KiB
Text
Raw Permalink Blame History

#### Binary log ENABLED ####
==== Don't set any option ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to zero ====
---- days=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
---- seconds=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to non-zero ====
---- days=2 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=2
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 172800]
include/assert.inc [expire_logs_days shall be 2]
---- seconds=86400 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=86400
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
==== Set both options to zero ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options: one to zero and one to non-zero ====
---- days=1 seconds=0 ----
---- The later seconds=0 will override days.
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
---- seconds=0 days=1 ----
---- The later days=1 will override seconds.
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0 --expire_logs_days=1
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
---- days=0 seconds=86400 ----
---- The later seconds=86400 will override days.
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=86400
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
==== Set both options to non-zero ====
---- days=1 and seconds=172800 ----
---- Since binlog_expire_logs_seconds is set later expire_log_days
---- becomes 2
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=172800
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 172800]
include/assert.inc [expire_logs_days shall be 2]
---- days=1 and seconds=172800 ----
---- Since expire_logs_days is set later binlog_expire_logs_seconds
---- becomes 86400
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=172800 --expire_logs_days=1
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
#### Binary log DISABLED ####
==== Don't set any option ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to zero ====
---- days=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
---- seconds=0 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set one option to non-zero ====
---- days=2 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=2
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 172800]
include/assert.inc [expire_logs_days shall be 2]
---- seconds=86400 ----
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=86400
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
==== Set both options to zero ====
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
==== Set both options: one to zero and one to non-zero ====
---- days=1 seconds=0 ----
---- The later seconds=0 will override days.
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=0
include/assert_grep.inc [There shall be no binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 0]
include/assert.inc [expire_logs_days shall be 0]
---- seconds=0 days=1 ----
---- The later days=1 will override seconds.
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0 --expire_logs_days=1
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
---- days=0 seconds=86400 ----
---- The later seconds=86400 will override days.
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=86400
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
==== Set both options to non-zero ====
---- days=1 and seconds=172800 ----
---- Since binlog_expire_logs_seconds is set later expire_log_days
---- becomes 2
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=172800
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 172800]
include/assert.inc [expire_logs_days shall be 2]
---- days=1 and seconds=172800 ----
---- Since expire_logs_days is set later binlog_expire_logs_seconds
---- becomes 86400
# restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=172800 --expire_logs_days=1
include/assert_grep.inc [There shall be a binlog_off+seconds warning]
include/assert.inc [binlog_expire_logs_seconds shall be 86400]
include/assert.inc [expire_logs_days shall be 1]
Reference in a new issue View git blame Copy permalink