Percona fails to properly stop replication thread if super_read_only=1, autocommit=0 and >=5.6.29
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
Percona 5.6.29-76.2-1 fails to properly stop replication if super_read_only mode is on and session is in autocommit=0 mode. Actually it is stopping thread but also returns error:
```
ERROR 1290 (HY000): The MySQL server is running with the --read-only (super) option so it cannot execute this statement
```
How to reproduce:
1. Setup slave replication
2. Execute `echo 'set global super_read_only=1; set autocommit=0; stop slave sql_thread' | mysql`
Result:
```
ERROR 1290 (HY000) at line 1: The MySQL server is running with the --read-only (super) option so it cannot execute this statement
```
And SQL_THREAD is actually - stopped.
Expect:
No error+stop thread or previous error and sql_thread still running...
tags: | added: super-read-only |
Changed in percona-server: | |
assignee: | nobody → Jericho Rivera (jericho-rivera) |
Some essential settings we use: info_repository = TABLE storage- engine = innodb
```
relay_log_
default-
```