You have been subscribed to a public bug:
When setting read_only=ON even the super user cannot delete or update
data, though super_read_only=OFF.
This has been tested in Percona Server 5.6.29-76.2-log and
5.6.31-77.0-log:
mysql> select @@version, @@version_comment;
+-----------------+------------------------------------------------------+
| @@version | @@version_comment |
+-----------------+------------------------------------------------------+
| 5.6.31-77.0-log | Percona Server (GPL), Release 77.0, Revision 5c1061c |
+-----------------+------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show variables like '%read_only%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| innodb_read_only | OFF |
| read_only | ON |
| super_read_only | OFF |
| tx_read_only | OFF |
+------------------+-------+
4 rows in set (0.00 sec)
mysql> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost
|
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'*...' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
|
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
mysql> delete from mytable where id=21169806818;
ERROR 1290 (HY000): The MySQL server is running with the --read-only option so
it cannot execute this statement
mysql> set global read_only=off;
Query OK, 0 rows affected (0.00 sec)
mysql> delete from mytable where id=21169806818;
Query OK, 1 row affected (0.00 sec)
** Affects: ubuntu
Importance: Unknown
Status: Unknown
** Affects: percona-server
Importance: Undecided
Status: New
** Affects: percona-server/5.5
Importance: Undecided
Status: New
** Affects: percona-server/5.6
Importance: Undecided
Status: New
** Affects: percona-server/5.7
Importance: Undecided
Status: New
** Tags: upstream
--
Improve diagnostics for non-SUPER DEFINER trigger blocking --read_only=ON
update for a SUPER user
https://bugs.launchpad.net/bugs/1613208
You received this bug notification because you are a member of Ubuntu Bugs,
which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
