Timeline for Setting sql_slave_skip_counter is not working on Percona 5.6.24
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 3, 2016 at 12:55 | comment | added | jerichorivera | @KinaanKhanSherwani - I've tested the scenario and mysql skips the error as it should. I don't know what could've caused it not to do so on your side but fwiw it is not recommended to have a master with a higher version than its slaves (ie 5.7 master and 5.6 slaves) | |
| Jul 1, 2016 at 6:29 | comment | added | Kinaan Khan Sherwani | Error 'String 'abcde_abcdefgh_abcd' is too long for user name (should be no longer than 16)' on query. Default database: ''. Query: 'GRANT SELECT ON mydb.* TO 'abcde_abcdefgh_abcd'@'192.168.1.4' IDENTIFIED WITH 'mysql_native_password' AS 'PASSWORD_HASH' | |
| Jun 30, 2016 at 3:56 | comment | added | AnonDude | What was the error ? | |
| Jun 29, 2016 at 10:47 | comment | added | Kinaan Khan Sherwani | also the error remained all the same when I started the slave after setting skip counter. | |
| Jun 25, 2016 at 13:04 | comment | added | Kinaan Khan Sherwani | as mentioned in the question Exec_Master_Log_Pos didn't change | |
| Jun 25, 2016 at 12:40 | history | answered | AnonDude | CC BY-SA 3.0 |