Debian Codegraph @

mysql-test/suite/binlog/r/binlog_expire_logs_days_deprecation.result

raw
1 CALL mtr.add_suppression("The option expire_logs_days cannot be used together*");
2 ####
3 #### Case 1:
4 ####
5 #### Case 1.1:
6 # restart:--binlog_expire_logs_seconds=2 --expire_logs_days=1 --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err
7 FLUSH LOGS;
8 FLUSH LOGS;
9 #### Case 1.2:
10 SET GLOBAL expire_logs_days= 10;
11 ERROR HY000: The option expire_logs_days and binlog_expire_logs_seconds cannot be used together. Please use binlog_expire_logs_seconds to set the expire time (expire_logs_days is deprecated)
12 #### Case 1.3:
13 include/assert_grep.inc [Assert that there is a warning at bootstrap for expire_logs_days]
14 #### Case 1.4
15 include/assert.inc [The value of expire_logs_days is not changed.]
16 include/assert.inc [The value of binlog_expire_logs_seconds is not changed.]
17 ####
18 #### Case 2:
19 ####
20 #### Case 2.1:
21 # restart: --expire_logs_days=1 --binlog_expire_logs_seconds=0 --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err
22 FLUSH LOGS;
23 FLUSH LOGS;
24 #### Case 2.2:
25 include/assert_grep.inc [There is no warning at server start when binlog_expire_logs_seconds is not set.]
26 # restart: --expire_logs_days=1 --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err
27 include/assert_grep.inc [There is no warning at server start when binlog_expire_logs_seconds is not set.]
28 #### Case 2.3
29 include/assert.inc [The value of expire_logs_days is not changed.]
30 include/assert.inc [The value of binlog_expire_logs_seconds is changed from default 2592000 to 0 .]
31 ####
32 #### Case 3:
33 ####
34 #### Case 3.1:
35 # restart: --binlog_expire_logs_seconds=5 --expire_logs_days=0 --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err
36 include/assert_grep.inc [There is a no warning at server start for expire_logs_days]
37 # restart: --binlog_expire_logs_seconds=5 --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err
38 include/assert_grep.inc [There is a no warning at server start for expire_logs_days]
39 #### Case 3.2
40 include/assert.inc [The value of expire_logs_days is 0.]
41 include/assert.inc [The value of binlog_expire_logs_seconds is not changed.]
42 ####
43 #### Case 4:
44 ####
45 #### Case 4.1: server start should not purge the file
46 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err --expire_logs_days=0
47 #### Case 4.2: flush logs should not purge the file
48 FLUSH LOGS;
49 FLUSH LOGS;
50 #### Case 4.3
51 include/assert.inc [The value of binlog_expire_logs_seconds is changed to 0.]
52 ####
53 #### Case 5:
54 ####
55 #### Case 5.1
56 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_deprecations-output.err
57 include/assert.inc [The value of expire_logs_days is 0.]
58 include/assert.inc [The value of binlog_expire_logs_seconds is changed to 2592000(30 days).]
59 SET GLOBAL binlog_expire_logs_seconds= 2592000;
60 SET GLOBAL expire_logs_days= 0;
61 Warnings:
62 Warning 1287 '@@expire_logs_days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
63 # restart: