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; .
-- Mvh Hans Svedåker -- _____________________________________________ Byt Bil Nordic AB, Box 7118, 187 12 Täby Tel: 077 - 131 31 31, Fax: 077 - 131 31 32 E-post: [EMAIL PROTECTED] Web: www.bytbil.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
