Just for the records: The reason was a misconfiguration in the firewall. The admin had changed the setting in the very moment I upgraded from 4.0 to 4.1 ... that lead me to the assumption broken replication had to do with the upgrade. Took me a while till I found it's firewall problem. Thanks, Stefan
Am Friday 05 March 2004 19:23 schrieb Sasha Pachev: > Stefan Kuhn wrote: > > Hi everybody, > > I have three mysql servers doing a circular replication. They (still) run > > Redhat 7.3. I started with Mysql 3.23, upgraded to 4 and yesterday I > > tried 4.1. I'm using official mysql rpms. Now the replication is broken. > > One server always says "Connecting to master". The error log says: > > 040304 19:11:58 Slave I/O thread: error connecting to master > > '[EMAIL PROTECTED] > > 47.62:3306': Error: 'Lost connection to MySQL server during query' > > errno: 2013 > > retry-time: 60 retries: 86400 > > The server which is supposed to replicate fromt this server says: > > "Waiting for master to send event". The log says: > > 040304 16:47:59 Got fatal error 1236: 'Could not find first log file > > name in binary log index file' from master when reading data from binary > > log The third replication finally seems to work. > > I did not change anything in configuration, passwords etc. It's all the > > same. Something to note: The two servers able to replicate are in the > > same network, the one which makes trouble is in another, firewall > > protected network. Port 3306 is open in both firewalls and it always > > worked. > > Does anybody have any tips? Thanks a lot (I'm really desparate) > > Stefan > > For simplicity, make sure all servers have the same version and start all > together in sync with fresh logs. Newer versions might be confused by the > old logs from the old versions. -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
