Replication Craziness

[Richard Jones]

On Wednesday 20 June 2007 20:07:57 Brad Fitzpatrick wrote:
> How big/small are these files?  Anything interesting/noisy in the
> mogilefsd error logs?

(Russ is at Glastonbury Festival, so I'll pick this up in the meantime)

All the files are MP3s, averaging 4MB each. 
Nothing interesting showing up in the logs
MySQL server version: 5.0.37-log
make test reports "All tests successful"

I starred at that replication code a bit, but didn't see anything I could 
blame. We're due to install more mogile nodes tomorrow, so i'll add them and 
let the replication run again - see if if behaves differently once we have 3 
new empty nodes online (minreplica count is 3 fwiw). Maybe that will give us 
a clue.



>
> Does the mogilefs-server "make test" pass for you?
>
> Which MySQL server version?
>
> On Wed, 20 Jun 2007, Russell Garrett wrote:
> > 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



-- 
Richard Jones
Last.fm Ltd. | http://www.last.fm/
Office: +44 (0) 207 780 7080