On Wed, Jun 11, 2003 at 05:22:50PM +0530, Mithun Bhattacharya wrote: > I am frequently getting errors as given below on my slave server. > > ------------------------------------------------- > 030605 3:27:19 Slave: did not get the expected error running query > from master - expected: 'Got error %d from table handler' > (1030), got 'no error' (0) > 030605 3:27:19 Slave: error running query 'delete from > page_cache_2003_06_04 where FILEKEY = '0'' > 030605 3:27:19 Error running query, slave aborted. Fix the problem, > and re-start the slave thread with "mysqladmin start-slave". We stopped > at log 'ebldb05p2-bin.630' position 354859069 > 030605 3:27:19 Slave thread exiting, replication stopped in log > 'ebldb05p2-bin.630' at position 354859069 > ------------------------------------------------- > 030610 3:17:02 Slave: did not get the expected error running query > from master - expected: 'Got error %d from table handler' > (1030), got 'no error' (0) > 030610 3:17:02 Slave: error running query 'delete from > page_cache_2003_06_09 where FILEKEY = '0'' > 030610 3:17:02 Error running query, slave aborted. Fix the problem, > and re-start the slave thread with "mysqladmin start-slave". We stopped > at log 'ebldb05p2-bin.654' position 189278930 > 030610 3:17:02 Slave thread exiting, replication stopped in log > 'ebldb05p2-bin.654' at position 189278930 > ------------------------------------------------- > > I can successfully run the SQL on the slave manually and it obviously > has run successfully on the master.
Why is that obvious? It's telling you that the slave expected to get an error but didn't. Those expectations come from the master's binlog. I'd repair the table on the master, since it's likely in some sort of trouble. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 9 days, processed 310,309,685 queries (378/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
