I have a slave server and a master server both running 3.23.38.
Every once in a while the slave stops updating:
mysql> show slave status;
+--------------+-------------+-------------+---------------+---------------+-----------+---------------+-----------------+---------------------+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+
| Master_Host | Master_User | Master_Port | Connect_retry |
Log_File | Pos | Slave_Running | Replicate_do_db |
Replicate_ignore_db | Last_errno |
Last_error
| Skip_counter |
+--------------+-------------+-------------+---------------+---------------+-----------+---------------+-----------------+---------------------+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+
| db1.tias.com | slave | 3306 | 60 |
spode-bin.005 | 912992502 | No |
| | 1158 | Slave: query 'drop table
tias.avtemp' partially completed on the master and was aborted. There is
a chance that your master is inconsistent at this point. If you are sure
that your master is ok, run this query manually on the slave and then
restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; |
0 |
+--------------+-------------+-------------+---------------+---------------+-----------+---------------+-----------------+---------------------+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+
1 row in set (0.00 sec)
Why is this happening and what can be done to prevent it from happening.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
