Hi, I will try to answer this since Russ is not in the office at the moment.<br><br><div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
How big/small are these files? </blockquote><div><br> 4MB in average <br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Anything interesting/noisy in the
<br>mogilefsd error logs?</blockquote><div><br>Looks all good. Occasional there are timeouts:<br>" :: [monitor(11947)] Timeout contacting machine <a href="http://10.0.10.24">10.0.10.24</a> for dev 47: took 2.00 seconds out of 2 allowed"
<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Does the mogilefs-server "make test" pass for you?</blockquote><div>
<br>"All tests successful, 3 tests skipped."</div>On the nodes the test skips the Db tests and it complains about not finding the mogadm executable. Nothing crucial I guess.<br><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Which MySQL server version?</blockquote><div><br> mysql> SELECT version();<br>+------------+<br>| version() |<br>+------------+<br>| 5.0.37-log | <br>+------------+<br><br>Cheers,<br>Mischa<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Wed, 20 Jun 2007, Russell Garrett wrote:<br><br>> OK, so I totally wiped the file_to_replicate table. We have 3 nodes<br>> online with sufficient space. I start the replicate thread and this happens:<br>><br>> mysql> select * from file_on where fid = 2534860;
<br>> +---------+-------+<br>> | fid | devid |<br>> +---------+-------+<br>> | 2534860 | 54 |<br>> | 2534860 | 64 |<br>> | 2534860 | 73 |<br>> | 2534860 | 74 |<br>> +---------+-------+
<br>> 4 rows in set (0.00 sec)<br>><br>> ...30 seconds later:<br>><br>> mysql> select * from file_on where fid = 2534860;<br>> +---------+-------+<br>> | fid | devid |<br>> +---------+-------+
<br>> | 2534860 | 54 |<br>> | 2534860 | 55 |<br>> | 2534860 | 56 |<br>> | 2534860 | 57 |<br>> | 2534860 | 58 |<br>> | 2534860 | 59 |<br>> | 2534860 | 60 |<br>> | 2534860 | 61 |
<br>> | 2534860 | 62 |<br>> | 2534860 | 63 |<br>> | 2534860 | 64 |<br>> | 2534860 | 65 |<br>> | 2534860 | 66 |<br>> | 2534860 | 67 |<br>> | 2534860 | 68 |<br>> | 2534860 | 69 |
<br>> | 2534860 | 70 |<br>> | 2534860 | 71 |<br>> | 2534860 | 72 |<br>> | 2534860 | 73 |<br>> | 2534860 | 74 |<br>> | 2534860 | 75 |<br>> | 2534860 | 76 |<br>> | 2534860 | 77 |
<br>> | 2534860 | 78 |<br>> | 2534860 | 79 |<br>> +---------+-------+<br>> 26 rows in set (0.00 sec)<br>><br>><br>> Riddle me that one...<br>><br>> Russ Garrett<br>> <a href="http://Last.fm">
Last.fm</a> Ltd.<br>> <a href="mailto:russ@last.fm">russ@last.fm</a><br>><br>><br></blockquote></div><br>