List:Replication« Previous MessageNext Message »
From:Christian Haensel Date:May 22 2007 7:42am
Subject:Slave I/O thread killed while connecting to master
View as plain text  
Good morning,

I am trying to replicate data from Server1 (Master) to Server2 (Slave). I 
have been following the tutorial at 
http://wiki.unixboard.de/index.php/Datenbank-Replikation_mit_MySQL_einrichten 
(german) You can see the my.cnf settings in there, I just edited the 
relevant data (IP, server-id, user, pass and DB-name).

Now all I get is the error (syslog-snap below my post) 
http://wiki.unixboard.de/index.php/Datenbank-Replikation_mit_MySQL_einrichten 
and a few lines more. I have been searching the archives, but can't find any 
relevant answers, as it seems to me.

I am pretty much a mySQL newbie when it comes to mySQL-server 
administration. Any help would be really appreciated.

Best regards,
Chris


syslog - relevant part
----------------------------------------------
May 22 07:33:25 vv032135 mysqld[17770]: 070522  7:33:25 /usr/sbin/mysqld: 
Normal shutdown
May 22 07:33:25 vv032135 mysqld[17770]:
May 22 07:33:25 vv032135 mysqld[17770]: 070522  7:33:25 Slave I/O thread 
killed while connecting to master
May 22 07:33:25 vv032135 mysqld[17770]: 070522  7:33:25 Slave I/O thread 
exiting, read up to log 'FIRST', position 4
May 22 07:33:25 vv032135 mysqld[17770]: 070522  7:33:25 Error reading relay 
log event: slave SQL thread was killed
May 22 07:33:25 vv032135 mysqld[17770]: 070522  7:33:25  InnoDB: Starting 
shutdown...
May 22 07:33:28 vv032135 mysqld[17770]: 070522  7:33:28  InnoDB: Shutdown 
completed
May 22 07:33:28 vv032135 mysqld[17770]: 070522  7:33:28 /usr/sbin/mysqld: 
Shutdown Complete
May 22 07:33:28 vv032135 mysqld[17770]:
May 22 07:33:28 vv032135 mysqld_safe[17842]: ended
May 22 07:33:29 vv032135 mysqld_safe[17898]: started
May 22 07:33:29 vv032135 mysqld[17902]: 070522  7:33:29  InnoDB: Started
May 22 07:33:29 vv032135 mysqld[17902]: /usr/sbin/mysqld: ready for 
connections.
May 22 07:33:29 vv032135 mysqld[17902]: Version: '4.0.24_Debian-10sarge2' 
socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Source distribution
May 22 07:33:29 vv032135 mysqld[17902]: 070522  7:33:29 Slave SQL thread 
initialized, starting replication in log 'FIRST' at position 0, relay log 
'./vv032135-relay-bin.004' position: 4
May 22 07:33:29 vv032135 mysqld[17902]: 070522  7:33:29 Slave I/O thread: 
error connecting to master 'root@<MASTERSERVERIP>': Error: 'Lost connection 
to MySQL server during query'  errno: 2013  retry-time: 60  retries: 86400
------------------------------------------- 

Thread
Slave I/O thread killed while connecting to masterChristian Haensel22 May
  • Re: Slave I/O thread killed while connecting to masterThomas Herzog22 May
    • Re: Slave I/O thread killed while connecting to masterChristian Haensel22 May
      • Re: Slave I/O thread killed while connecting to masterThomas Herzog22 May
        • Re: Slave I/O thread killed while connecting to masterChristian Haensel22 May
          • Re: Slave I/O thread killed while connecting to masterThomas Herzog22 May
            • Re: Slave I/O thread killed while connecting to masterChristian Haensel22 May
              • Re: Slave I/O thread killed while connecting to masterThomas Herzog22 May
                • Re: Slave I/O thread killed while connecting to masterChristian Haensel22 May
                  • Re: Slave I/O thread killed while connecting to masterThomas Herzog22 May
                    • Re: Slave I/O thread killed while connecting to masterChristian Haensel22 May
                      • Re: Slave I/O thread killed while connecting to masterThomas Herzog22 May
                        • Re: Slave I/O thread killed while connecting to masterChristian Haensel22 May
  • Re: Slave I/O thread killed while connecting to masterJoe22 May
  • Re: Slave I/O thread killed while connecting to masterJoe22 May