Hi
I have a problem with replication and "replace delayed" statements. They generate this error on the slave machine a couple of times every night (When there are high load on the master). Anyone that has any suggestions? Why does this error occur.
Last_errno: 1053
Last_error: query 'REPLACE DELAYED INTO exports_info SET cid=963371,im_id=2040,regno='UPG598',export_type=16' 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 GLOBAL SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; .
This happens when the slave detects that it cannot be 100% sure that the query succeeded on the master. If you think it's ok to run such queries the slave anyway, set slave-skip-error=1053 in my.cnf on the slave
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
