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]

Reply via email to