Debian Codegraph @

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

raw
1 #### Binary log ENABLED ####
2 ==== Don't set any option ====
3 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err
4 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
5 include/assert.inc [binlog_expire_logs_seconds shall be 0]
6 include/assert.inc [expire_logs_days shall be 0]
7 ==== Set one option to zero ====
8 ---- days=0 ----
9 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0
10 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
11 include/assert.inc [binlog_expire_logs_seconds shall be 0]
12 include/assert.inc [expire_logs_days shall be 0]
13 ---- seconds=0 ----
14 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0
15 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
16 include/assert.inc [binlog_expire_logs_seconds shall be 0]
17 include/assert.inc [expire_logs_days shall be 0]
18 ==== Set one option to non-zero ====
19 ---- days=2 ----
20 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=2
21 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
22 include/assert.inc [binlog_expire_logs_seconds shall be 172800]
23 include/assert.inc [expire_logs_days shall be 2]
24 ---- seconds=86400 ----
25 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=86400
26 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
27 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
28 include/assert.inc [expire_logs_days shall be 1]
29 ==== Set both options to zero ====
30 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=0
31 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
32 include/assert.inc [binlog_expire_logs_seconds shall be 0]
33 include/assert.inc [expire_logs_days shall be 0]
34 ==== Set both options: one to zero and one to non-zero ====
35 ---- days=1 seconds=0 ----
36 ---- The later seconds=0 will override days.
37 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=0
38 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
39 include/assert.inc [binlog_expire_logs_seconds shall be 0]
40 include/assert.inc [expire_logs_days shall be 0]
41 ---- seconds=0 days=1 ----
42 ---- The later days=1 will override seconds.
43 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=0 --expire_logs_days=1
44 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
45 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
46 include/assert.inc [expire_logs_days shall be 1]
47 ---- days=0 seconds=86400 ----
48 ---- The later seconds=86400 will override days.
49 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=0 --binlog-expire-logs-seconds=86400
50 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
51 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
52 include/assert.inc [expire_logs_days shall be 1]
53 ==== Set both options to non-zero ====
54 ---- days=1 and seconds=172800 ----
55 ---- Since binlog_expire_logs_seconds is set later expire_log_days
56 ---- becomes 2
57 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --expire_logs_days=1 --binlog-expire-logs-seconds=172800
58 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
59 include/assert.inc [binlog_expire_logs_seconds shall be 172800]
60 include/assert.inc [expire_logs_days shall be 2]
61 ---- days=1 and seconds=172800 ----
62 ---- Since expire_logs_days is set later binlog_expire_logs_seconds
63 ---- becomes 86400
64 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --binlog-expire-logs-seconds=172800 --expire_logs_days=1
65 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
66 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
67 include/assert.inc [expire_logs_days shall be 1]
68 #### Binary log DISABLED ####
69 ==== Don't set any option ====
70 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin
71 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
72 include/assert.inc [binlog_expire_logs_seconds shall be 0]
73 include/assert.inc [expire_logs_days shall be 0]
74 ==== Set one option to zero ====
75 ---- days=0 ----
76 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0
77 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
78 include/assert.inc [binlog_expire_logs_seconds shall be 0]
79 include/assert.inc [expire_logs_days shall be 0]
80 ---- seconds=0 ----
81 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0
82 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
83 include/assert.inc [binlog_expire_logs_seconds shall be 0]
84 include/assert.inc [expire_logs_days shall be 0]
85 ==== Set one option to non-zero ====
86 ---- days=2 ----
87 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=2
88 include/assert_grep.inc [There shall be a binlog_off+seconds warning]
89 include/assert.inc [binlog_expire_logs_seconds shall be 172800]
90 include/assert.inc [expire_logs_days shall be 2]
91 ---- seconds=86400 ----
92 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=86400
93 include/assert_grep.inc [There shall be a binlog_off+seconds warning]
94 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
95 include/assert.inc [expire_logs_days shall be 1]
96 ==== Set both options to zero ====
97 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=0
98 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
99 include/assert.inc [binlog_expire_logs_seconds shall be 0]
100 include/assert.inc [expire_logs_days shall be 0]
101 ==== Set both options: one to zero and one to non-zero ====
102 ---- days=1 seconds=0 ----
103 ---- The later seconds=0 will override days.
104 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=0
105 include/assert_grep.inc [There shall be no binlog_off+seconds warning]
106 include/assert.inc [binlog_expire_logs_seconds shall be 0]
107 include/assert.inc [expire_logs_days shall be 0]
108 ---- seconds=0 days=1 ----
109 ---- The later days=1 will override seconds.
110 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=0 --expire_logs_days=1
111 include/assert_grep.inc [There shall be a binlog_off+seconds warning]
112 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
113 include/assert.inc [expire_logs_days shall be 1]
114 ---- days=0 seconds=86400 ----
115 ---- The later seconds=86400 will override days.
116 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=0 --binlog-expire-logs-seconds=86400
117 include/assert_grep.inc [There shall be a binlog_off+seconds warning]
118 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
119 include/assert.inc [expire_logs_days shall be 1]
120 ==== Set both options to non-zero ====
121 ---- days=1 and seconds=172800 ----
122 ---- Since binlog_expire_logs_seconds is set later expire_log_days
123 ---- becomes 2
124 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --expire_logs_days=1 --binlog-expire-logs-seconds=172800
125 include/assert_grep.inc [There shall be a binlog_off+seconds warning]
126 include/assert.inc [binlog_expire_logs_seconds shall be 172800]
127 include/assert.inc [expire_logs_days shall be 2]
128 ---- days=1 and seconds=172800 ----
129 ---- Since expire_logs_days is set later binlog_expire_logs_seconds
130 ---- becomes 86400
131 # restart: --log-error=MYSQLTEST_VARDIR/tmp/binlog_expire_warnings-output.err --skip-log-bin --binlog-expire-logs-seconds=172800 --expire_logs_days=1
132 include/assert_grep.inc [There shall be a binlog_off+seconds warning]
133 include/assert.inc [binlog_expire_logs_seconds shall be 86400]
134 include/assert.inc [expire_logs_days shall be 1]