MTS breaks in after restart
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Sergei Glushchenko | ||
5.6 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
Am able to break multi-threaded slave (SQL thread) in Percona Server 5.6.22-71 with a 1755 error after restarting the server a few times.
Master:
24 schemas (db1, db2.. etc to db24)
Simple bash script inserting an auto-increment value randomly into a different database.
Replica has the following:
master_
relay_log_
slave_parallel_
While running ~100 copies of the attached script to generate insert traffic, I would restart the replica. This will eventually lead to an error similar to the following:
2015-02-11 00:09:17 93614 [Note] Slave I/O thread: connected to master 'replication@
2015-02-11 00:09:17 93614 [Note] Event Scheduler: Loaded 0 events
2015-02-11 00:09:17 93614 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.22-71.0-log' socket: '/var/lib/
2015-02-11 00:09:17 93614 [Note] Slave SQL thread initialized, starting replication in log 'mts1-bin.000001' at position 369721635, relay log '/var/lib/
2015-02-11 00:09:17 7f524f5f7700 InnoDB: Buffer pool(s) load completed at 150211 0:09:17
2015-02-11 00:09:19 93614 [Warning] Slave SQL: injecting ROLLBACK at the end of cold group, Error_code: 0
2015-02-11 00:09:19 93614 [ERROR] Slave SQL: Cannot execute the current event group in the parallel mode. Encountered event Xid, relay-log name /var/lib/
I'm guessing that this merge: https:/
I was unable to reproduce this in MYSQL Community Edition 5.6.22.
Attached is 'generate_
Changed in percona-server: | |
assignee: | nobody → Muhammad Irfan (muhammad-irfan) |
tags: |
added: regression removed: 5.6 |
I tried to reproduce it with no luck. I executed more than 100 copies of attached script and restarted slave in between but no error, slave gets back as normal. Can you please provide my.cnf for master and affected slave please along with error log too from slave server.