Description:
Due to http://bugs.mysql.com/15019 the binlog_index table become inconsistent with the number of purge files left.
Many more rows above:
<cut>
| 102 | /space/var/master1.005632 | 1154103 | 9536 | 0 | 8 | 0 |
| 102 | /space/var/master1.005633 | 1154110 | 9358 | 0 | 8 | 0 |
| 102 | /space/var/master1.005634 | 1154117 | 9526 | 0 | 8 | 0 |
| 102 | /space/var/master1.005635 | 1154118 | 1 | 0 | 0 | 0 |
| 419 | /space/var/master1.005635 | 1154124 | 9423 | 0 | 8 | 0 |
| 102 | /space/var/master1.005636 | 1154125 | 1 | 0 | 0 | 0 |
| 419 | /space/var/master1.005636 | 1154131 | 9534 | 0 | 8 | 0 |
| 102 | /space/var/master1.005637 | 1154132 | 1 | 0 | 0 | 0 |
| 419 | /space/var/master1.005637 | 1154139 | 9486 | 0 | 8 | 0 |
| 102 | /space/var/master1.005638 | 1154146 | 9366 | 0 | 8 | 0 |
| 102 | /space/var/master1.005639 | 1154153 | 9497 | 0 | 8 | 0 |
| 102 | /space/var/master1.005640 | 1154160 | 9533 | 0 | 8 | 0 |
| 102 | /space/var/master1.005641 | 1154167 | 9486 | 0 | 8 | 0 |
| 102 | /space/var/master1.005642 | 1154168 | 1 | 0 | 0 | 0 |
| 419 | /space/var/master1.005642 | 1154173 | 9516 | 0 | 8 | 0 |
| 102 | /space/var/master1.005643 | 1154178 | 9478 | 0 | 8 | 0 |
| 102 | /space/var/master1.005644 | 1154179 | 1 | 0 | 0 | 0 |
+----------+---------------------------+---------+---------+---------+---------+-----------+
471 rows in set (0.01 sec)
<cut>
If you look at the directory, you see:
drwx------ 2 ndbdev ndbdev 4096 Nov 2 20:20 BANK
drwx------ 2 ndbdev ndbdev 4096 Nov 2 17:39 cluster_replication
drwx------ 2 ndbdev ndbdev 4096 Nov 8 16:43 hlr
-rw-rw---- 1 ndbdev ndbdev 6 Nov 16 18:28 hostname.pid1
-rw-rw---- 1 ndbdev ndbdev 85983232 Nov 16 19:06 ibdata1
-rw-rw---- 1 ndbdev ndbdev 5242880 Nov 16 19:06 ib_logfile0
-rw-rw---- 1 ndbdev ndbdev 5242880 Nov 16 18:43 ib_logfile1
-rw-rw---- 1 ndbdev ndbdev 154520 Nov 17 04:30 master1.005645
-rw-rw---- 1 ndbdev ndbdev 152275 Nov 17 04:30 master1.005646
-rw-rw---- 1 ndbdev ndbdev 152527 Nov 17 04:30 master1.005647
-rw-rw---- 1 ndbdev ndbdev 152925 Nov 17 04:30 master1.005648
-rw-rw---- 1 ndbdev ndbdev 152410 Nov 17 04:30 master1.005649
-rw-rw---- 1 ndbdev ndbdev 152207 Nov 17 04:30 master1.005650
-rw-rw---- 1 ndbdev ndbdev 154500 Nov 17 04:31 master1.005651
-rw-rw---- 1 ndbdev ndbdev 153680 Nov 17 04:31 master1.005652
-rw-rw---- 1 ndbdev ndbdev 153605 Nov 17 04:31 master1.005653
-rw-rw---- 1 ndbdev ndbdev 154042 Nov 17 04:31 master1.005654
-rw-rw---- 1 ndbdev ndbdev 152727 Nov 17 04:31 master1.005655
-rw-rw---- 1 ndbdev ndbdev 102 Nov 17 04:31 master1.005656
-rw-rw---- 1 ndbdev ndbdev 153260 Nov 17 04:30 master1.1
-rw-rw---- 1 ndbdev ndbdev 101844 Nov 17 04:30 master1.err
-rw-rw---- 1 ndbdev ndbdev 0 Nov 17 01:26 master1.err-old
-rw-rw---- 1 ndbdev ndbdev 744967 Nov 16 16:30 master1.err-old.1
-rw-rw---- 1 ndbdev ndbdev 333 Nov 17 04:31 master1.index
-rw-rw---- 1 ndbdev ndbdev 124604851 Nov 17 04:41 master1.log
drwx------ 2 ndbdev ndbdev 4096 Nov 2 17:38 mysql
drwx------ 2 ndbdev ndbdev 4096 Nov 2 17:38 test
drwx------ 2 ndbdev ndbdev 4096 Nov 16 19:07 TPCB
[root@ndb08 var]#
Notice that /space/var/master1.005632 and other nolonger exists in the directory.
How to repeat:
See http://bugs.mysql.com/15019
