First off, this is the first time I have done replication in MySQL so the
problem very well may be my fault. I run a simple master / slave setup that
Replicates one database. Replication works for a day or two then for
reasons unknown to me I see this on show slave status, "Last_error: error
'Server shutdown in progress'...” but Uptime on the Master and Slave both
show dates that are older than when the error occurred.
This problem has been occurring for ~ 2 weeks. 3 days ago I moved the
Slave into the same rack as the master so they would be on the same
subnet/switch, but the problem still exists.
I could implement a perl script to just check the replication status, and
take necessary action to restart the slave if the SQL thread is down, but I
was wondering if a more elegant solution existed.
Thanks
James
([EMAIL PROTECTED]) [(none)]> show slave status\G
*************************** 1. row ***************************
Master_Host: Replaced
Master_User: Replaced
Master_Port: Replaced
Connect_retry: 60
Master_Log_File: MASTER-bin.010
Read_Master_Log_Pos: 131845183
Relay_Log_File: SLAVE001-relay-bin.004
Relay_Log_Pos: 257067861
Relay_Master_Log_File: MASTER-bin.010
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_do_db: MASTER
Replicate_ignore_db:
Last_errno: 1053
Last_error: error 'Server shutdown in progress' on query 'UPDATE
LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039''
Skip_counter: 0
Exec_master_log_pos: 108378574
Relay_log_space: 280534474
1 row in set (0.00 sec)
([EMAIL PROTECTED]) [(none)]> select now();
+---------------------+
| now() |
+---------------------+
| 2003-07-18 10:11:27 |
+---------------------+
1 row in set (0.02 sec)
([EMAIL PROTECTED]) [(none)]> start slave;
Query OK, 0 rows affected (36.25 sec)
([EMAIL PROTECTED]) [(none)]> status;
--------------
mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386)
Connection id: 5239
Current database:
Current user: [EMAIL PROTECTED]
SSL: Not in use
Current pager: /usr/bin/less
Using outfile: ''
Server version: 4.0.13
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/replication.sock
Uptime: 3 days 15 hours 26 min 43 sec
Then on my master.
([EMAIL PROTECTED]) [(none)]> status;
--------------
mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386)
Connection id: 71764
Current database:
Current user: [EMAIL PROTECTED]
SSL: Not in use
Current pager: more
Using outfile: ''
Server version: 4.0.13-log
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 16 days 19 hours 7 min 47 sec
Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush
tables: 1 Open tables: 64 Queries per second avg: 36.901
--------------
([EMAIL PROTECTED]) [(none)]> select now();
+---------------------+
| now() |
+---------------------+
| 2003-07-18 10:16:26 |
+---------------------+
1 row in set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
