Toolserver:Admin:Fix broken replication

From mediawiki.org
Jump to navigation Jump to search
Wikimedia Community Logo-Toolserver.svg

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

When replication breaks, use SHOW SLAVE STATUS\G to find the error. Fix whatever caused it, then restart replication: STOP SLAVE; START SLAVE;.

If the error is Lock wait timeout, it means a running query blocked the replication thread. After restarting replication, check that it's actually replicating. If not, find and kill the query that's blocking it.

Category:Admin:Database