gral
15th August 2007, 05:48
Hello everybody, i have a replicaion server with four replics working on it, in one of them, im receiving the error:
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql-xxxreplic4/mysql.sock' (2)"
All replicas work fine until the afternoon, when a local mysqlserver was installed.
The error in the not working replic is:
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/var/lib/mysql-xxxxreplic4/mysql.sock' port: 3309 Source distribution
070315 18:23:15 [Note] Slave SQL thread initialized, starting replication in log 'hostname-bin.000032' at position 12627482, relay log './rep2-relay-bin.000004' position: 5900799
070315 18:23:15 [Note] Slave I/O thread: connected to master 'rep2@dating.server.com:3306', replication started in log 'hostname-bin.000032' at position 12627482
070320 19:21:27 [ERROR] Slave: received end packet from server, apparent master shutdown:
070320 19:21:27 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hostname-bin.000032' position 16531092
070320 19:21:27 [ERROR] Slave I/O thread: error reconnecting to master 'rep2@dating.server.com:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400
070320 19:22:28 [Note] Slave: connected to master 'rep2@dating.server.com:3306',replication resumed in log 'hostname-bin.000032' at position 16531092
070528 11:55:34 [Warning] Aborted connection 17126 to db: 'unconnected' user: 'admin' host: `xx.xx.xx.xx' (Got an error reading communication packets)
070814 14:04:45 [Note] /usr/libexec/mysqld: Normal shutdown
070814 14:04:45 [ERROR] Slave I/O thread killed while reading event
070814 14:04:45 [ERROR] Slave I/O thread exiting, read up to log 'celestina-bin.000033', position 83471694
070814 14:04:45 [ERROR] Error reading relay log event: slave SQL thread was killed
070814 14:04:46 [Note] /usr/libexec/mysqld: Shutdown complete
070814 14:04:46 mysqld ended
I was reading what this error could be the same server_id in the my.cnf, but in my my.cnf all the replics have the same number and are working ok, and i try use it with the all choice posible.
Other tip is: the replic what is working bad, is taking the same port what was config in the local mysqlserver in the my.cnf
Any suggestion will be very apprecited.
Guille.
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql-xxxreplic4/mysql.sock' (2)"
All replicas work fine until the afternoon, when a local mysqlserver was installed.
The error in the not working replic is:
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/var/lib/mysql-xxxxreplic4/mysql.sock' port: 3309 Source distribution
070315 18:23:15 [Note] Slave SQL thread initialized, starting replication in log 'hostname-bin.000032' at position 12627482, relay log './rep2-relay-bin.000004' position: 5900799
070315 18:23:15 [Note] Slave I/O thread: connected to master 'rep2@dating.server.com:3306', replication started in log 'hostname-bin.000032' at position 12627482
070320 19:21:27 [ERROR] Slave: received end packet from server, apparent master shutdown:
070320 19:21:27 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hostname-bin.000032' position 16531092
070320 19:21:27 [ERROR] Slave I/O thread: error reconnecting to master 'rep2@dating.server.com:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400
070320 19:22:28 [Note] Slave: connected to master 'rep2@dating.server.com:3306',replication resumed in log 'hostname-bin.000032' at position 16531092
070528 11:55:34 [Warning] Aborted connection 17126 to db: 'unconnected' user: 'admin' host: `xx.xx.xx.xx' (Got an error reading communication packets)
070814 14:04:45 [Note] /usr/libexec/mysqld: Normal shutdown
070814 14:04:45 [ERROR] Slave I/O thread killed while reading event
070814 14:04:45 [ERROR] Slave I/O thread exiting, read up to log 'celestina-bin.000033', position 83471694
070814 14:04:45 [ERROR] Error reading relay log event: slave SQL thread was killed
070814 14:04:46 [Note] /usr/libexec/mysqld: Shutdown complete
070814 14:04:46 mysqld ended
I was reading what this error could be the same server_id in the my.cnf, but in my my.cnf all the replics have the same number and are working ok, and i try use it with the all choice posible.
Other tip is: the replic what is working bad, is taking the same port what was config in the local mysqlserver in the my.cnf
Any suggestion will be very apprecited.
Guille.