[MDEV-16778] GGalera Cluster 10.2.15 => 10.2.16, break syncro Created: 2018-07-19  Updated: 2018-08-10  Resolved: 2018-08-10

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.2.16
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Aurélien LEQUOY Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Debian 9.5


 Description   

Upgrade of minor version of MariaDB 10.2.15 => 10.2.16.

in all nodes in 10.2.15 we have :

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '*F044D7108C68CDDDEVG2E00E980FZE9BB4A573E' WITH GRANT OPTION

We upgrade the node in 10.2.16 and it's updated the account debian-sys-maint

apt-get install mariadb-server-10.2, and in 10.2.16 we have now :

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '*F044D7108C68CDDDEVG2E00E980FZE9BB4A573E' WITH GRANT OPTION

and nothing found here about it : https://mariadb.com/kb/en/library/mariadb-10216-changelog/

in 10.3 i checked and we have ALL PRIVILEGES, so it's really a bug.

 Comments   
Comment by Elena Stepanova [ 2018-07-19 ]

I"ve checked that it doesn't happen just upon a regular upgrade from 10.2.15 to 10.2.16, neither with nor without running mysql_upgrade, so the reason is somewhere else.

Also, this list doesn't look like an expansion of ALL PRIVILEGES. It looks exactly like if somebody ran REVOKE CREATE TABLESPACE ON . FROM 'debian-sys-maint'@'localhost'.
Could it have happened?

Comment by Aurélien LEQUOY [ 2018-07-23 ]

the only one thing made between both it's :

  • apt-get install mariadb-server-10.2 (without mysql_upgrade)

i upgraded 6 nodes, it's happen 6 times !

Comment by Aurélien LEQUOY [ 2018-08-10 ]

you can remove this thing, it's was not due new version but the previous one. I am not able to reproduce anymore

Generated at Thu Feb 08 08:31:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.