Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 6th May 2008, 12:50 is offline
Junior Member
Join Date: May 2008
Posts: 4
Thanks: 0
Thanked 1 Time in 1 Post
Default Related: MySQL Master-Master Replication


i have tested this tutorial: Setting Up Master-Master Replication With MySQL 5 On Debian Etch.

I build a local test environment for furter tests with my database. After my 12 day holiday I power on the machine, and nothing, the replication was crashed.

May  6 11:40:04 dev1.lan mysqld[7410]: 080506 11:40:04 [ERROR] Slave I/O thread: error connecting to master 'slave1_user@': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'  errno: 2013  retry-time: 60  retries: 86400
I think this is an error related the binlog age. Im right? Can anybody confirm that?

May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [Note] Slave I/O thread: connected to master 'slave2_user@',  replication started in log 'mysql-bin.000035' at position 98
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
May  6 11:40:12 dev1.lan mysqld[7954]: 080506 11:40:12 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000035', position 98
But the BIG question is, can this occur when I use the replication on my productive systems?
Reply With Quote
Sponsored Links
Old 6th May 2008, 14:22
topdog topdog is offline
Senior Member
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 154 Times in 151 Posts

the binary log on the master is missing thats why.
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql master to master replication question ubutux HOWTO-Related Questions 7 13th March 2009 18:07
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 20:13
mysql master master replication not working SoftDux HOWTO-Related Questions 5 29th March 2007 15:31
Mysql Master Master replication stormrider HOWTO-Related Questions 5 16th February 2007 19:18

All times are GMT +2. The time now is 03:06.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.