Replication Craziness

[Russell Garrett]

OK, so I totally wiped the file_to_replicate table. We have 3 nodes 
online with sufficient space. I start the replicate thread and this happens:

mysql> select * from file_on where fid = 2534860;
+---------+-------+
| fid     | devid |
+---------+-------+
| 2534860 |    54 |
| 2534860 |    64 |
| 2534860 |    73 |
| 2534860 |    74 |
+---------+-------+
4 rows in set (0.00 sec)

...30 seconds later:

mysql> select * from file_on where fid = 2534860;
+---------+-------+
| fid     | devid |
+---------+-------+
| 2534860 |    54 |
| 2534860 |    55 |
| 2534860 |    56 |
| 2534860 |    57 |
| 2534860 |    58 |
| 2534860 |    59 |
| 2534860 |    60 |
| 2534860 |    61 |
| 2534860 |    62 |
| 2534860 |    63 |
| 2534860 |    64 |
| 2534860 |    65 |
| 2534860 |    66 |
| 2534860 |    67 |
| 2534860 |    68 |
| 2534860 |    69 |
| 2534860 |    70 |
| 2534860 |    71 |
| 2534860 |    72 |
| 2534860 |    73 |
| 2534860 |    74 |
| 2534860 |    75 |
| 2534860 |    76 |
| 2534860 |    77 |
| 2534860 |    78 |
| 2534860 |    79 |
+---------+-------+
26 rows in set (0.00 sec)


Riddle me that one...

Russ Garrett
Last.fm Ltd.
russ at last.fm