On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote:
> I have a slave server and a master server both running 3.23.38.
>
> Every once in a while the slave stops updating:
>
> | 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 |
[snip]
> Why is this happening and what can be done to prevent it from happening.
Hard to say. Was there actually a problem on the master? Did the
slave work fine once you set the skip counter?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 33,533,446 queries (109/sec. avg)
---------------------------------------------------------------------
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
