Has anyone ever encountered a problem where replication stops due to a partially completed query on the master? I am currently encountering this problem on my server and was wondering if I need to resync the slave server to the master by copying all the data files to the slave and then restarting replication. Is this my best action?
The error I am receiving is: 040820 14:51:56 Slave: query 'BEGIN' 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; . Error_code: 1158 040820 14:51:56 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'intranet-bin.007' position 16980559 MySql: ready for connections. Thanks for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
