codersofthedark/clean.sh

Last active April 29, 2021 03:47

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/codersofthedark/cceaa52247e69e2ff965.js"></script>
Save codersofthedark/cceaa52247e69e2ff965 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL Replication: 'Duplicate entry for PRIMARY key'

Raw

while [ 1 ]; do if ['mysql -uroot -ppassword -e"show slave status \G;" | grep "Duplicate entry" | wc -l' -eq 2 ] ; then mysql -uroot -ppassword -e"stop slave; set global sql_slave_skip_counter=1; start slave;"; fi; sleep 1; mysql -uroot -ppassword -e"show slave status\G"; done

wheelmanstudio commented Mar 29, 2017

First version of the script works fine. Second commit broke it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment