0

I was dropping a user on master. But that didn't execute on Slave. Instead its broken the replication.

  • GTID enabled Parallel
  • replication enabled.

On Master:

Binlog-do-db: prod_db
binlog-ignore-db: mysql

On slave:

replicate-ignore-db: mysql

Error:

Worker 48 failed executing transaction '' at master log mysql-bin.002980, end_log_pos 448844064; Error 'Operation DROP USER failed for 'appi'@'10.0.0.10'' on query. Default database: ''. Query: 'drop user 'appi'@'10.0.0.10''

Retrieved_Gtid_Set: c924545b-a3e3-11e8-8a39-42010a280410:1-6798729399


    Executed_Gtid_Set: 26e8b1bf-a4ca-11e8-b64f-42010a280415:1-56,
        c924545b-a3e3-11e8-8a39-42010a280410:1-6789350755:6789350757-6789490840:6789490842-6789490901:6795994381:6796336449-6796336451:6796734964:6796760916:6796785072

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.