|
A breakdown in slave talking is occurring on Server 3. I see these as significant indicators: 061101 17:47:48 [Note] Error reading
relay log event: slave SQL thread was killed 061102 10:19:05 [Note] Slave: received end packet from server, apparent master shutdown: 061102 10:19:05 [Note] Slave I/O
thread: Failed reading log event, reconnecting to retry, log 'interps2-bin.000009' position 291 These Server 3 events are about 13 minutes after Server 2 comes up.
They do not seem to refer to the same “log” file or thread times. Explore the Evolving Web www.2.0websites.com Paul Yurt, Publisher paul(@)2.0websites.com 480-585-0007 -----Original Message----- On Thu, 2 Nov 2006, P Yurt wrote: > David > What do you see in the log files? I guess you mean the error logs? Server 2: [EMAIL PROTECTED] data]# tail interps2.err 061102 10:06:20 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 061102 10:06:20 mysqld ended 061102 10:06:21 mysqld started 061102 10:06:22 InnoDB: Started; log sequence number 0 43665 061102 10:06:22 [Note] /usr/local/mysql/bin/mysqld: ready for
connections. Version: '5.0.17-standard-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) 061102 10:06:22 [Note] Slave SQL thread initialized, starting
replication in log 'interps1-bin.000004' at position 32153, relay log './interps2-relay-bin.000027' position: 8470 061102 10:06:27 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'interps1-bin.000004' at position 32153 Server 3: [EMAIL PROTECTED] ~]$ sudo tail /usr/local/mysql/data/mintz.err 061101 17:47:27 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'interps2-bin.000007' at position 98 061101 17:47:48 [Note] Slave I/O thread killed while reading event 061101 17:47:48 [Note] Slave I/O thread exiting, read up to log 'interps2-bin.000009', position 98 061101 17:47:48 [Note] Error reading relay log event: slave SQL thread
was killed 061101 17:48:55 [Note] Slave SQL thread initialized, starting
replication in log 'interps2-bin.000009' at position 98, relay log './mintz-relay-bin.000001' position: 4 061101 17:48:55 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'interps2-bin.000009' at position 98 061102 10:19:05 [Note] Slave: received end packet from server, apparent master shutdown: 061102 10:19:05 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'interps2-bin.000009' position 291 061102 10:19:05 [ERROR] Slave I/O thread: error reconnecting to master '[EMAIL PROTECTED]:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400 061102 10:20:05 [Note] Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'interps2-bin.000009' at position 291 --- David Mintz http://davidmintz.org/ En Nueva York el tránsito de la belleza a la desolación sucede siempre expeditivamente, de máxima eficiencia hubiera aconsejado la supresión de gradaciones intermedias. -- Antonio Muñoz Molina, Ventanas de Manhattan _______________________________________________ http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in http://www.nyphp.org/show_participation.php |
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
