|
1
by brian
clean slate |
1 |
flush logs;
|
2 |
flush logs;
|
|
3 |
flush logs;
|
|
4 |
show binary logs;
|
|
5 |
Log_name File_size
|
|
6 |
master-bin.000001 #
|
|
7 |
master-bin.000002 #
|
|
8 |
master-bin.000003 #
|
|
9 |
master-bin.000004 #
|
|
10 |
purge binary logs TO 'master-bin.000004';
|
|
11 |
Warnings:
|
|
12 |
Warning 1612 Being purged log MYSQLTEST_VARDIR/log/master-bin.000001 was not found
|
|
13 |
*** must show a list starting from the 'TO' argument of PURGE ***
|
|
14 |
show binary logs;
|
|
15 |
Log_name File_size
|
|
16 |
master-bin.000004 #
|
|
17 |
reset master;
|
|
18 |
flush logs;
|
|
19 |
flush logs;
|
|
20 |
flush logs;
|
|
21 |
*** must be a warning master-bin.000001 was not found ***
|
|
22 |
Warnings:
|
|
23 |
Warning 1612 Being purged log MYSQLTEST_VARDIR/log/master-bin.000001 was not found
|
|
24 |
*** must show one record, of the active binlog, left in the index file after PURGE ***
|
|
25 |
show binary logs;
|
|
26 |
Log_name File_size
|
|
27 |
master-bin.000004 #
|
|
28 |
reset master;
|
|
29 |
flush logs;
|
|
30 |
flush logs;
|
|
31 |
flush logs;
|
|
32 |
purge binary logs TO 'master-bin.000002';
|
|
33 |
ERROR HY000: Fatal error during log purge
|
|
34 |
show warnings;
|
|
35 |
Level Code Message
|
|
36 |
Error 1377 a problem with deleting MYSQLTEST_VARDIR/log/master-bin.000001; consider examining correspondence of your binlog index file to the actual binlog files
|
|
37 |
Error 1377 Fatal error during log purge
|
|
38 |
reset master;
|
|
39 |
End of tests
|