WSREP breaks when SET lc_messages = 'nl_NL' is used

General

Escalation

General

Escalation

Description

We're using phpMyAdmin to manage users in our Percona 8 cluster. phpMyAdmin connects to the mysql2 directly.

When we grant access to a user with the phpMyAdmin language set to en_US everything works as expected:

SELECT @@version, @@version_comment 
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 
SET lc_messages = 'en_US' 
SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root' 
SET collation_connection = 'utf8mb4_unicode_ci' 
REVOKE ALL PRIVILEGES ON `somedatabase`.* FROM 'someuser'@'%' 
REVOKE GRANT OPTION ON `somedatabase`.* FROM 'someuser'@'%' 
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON `somedatabase`.* TO 'someuser'@'%'

However, when we set the phpMyAdmin language to nl_NL the replication breaks marking the node as inconsistent:

SELECT @@version, @@version_comment 
SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 
SET lc_messages = 'nl_NL' 
SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root' 
SET collation_connection = 'utf8mb4_unicode_ci' 
REVOKE ALL PRIVILEGES ON `somedatabase`.* FROM 'someuser'@'%' 
REVOKE GRANT OPTION ON `somedatabase`.* FROM 'someuser'@'%' 
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON `somedatabase`.* TO 'someuser'@'%'

MySQL Error log:

2022-11-28T10:52:35.212289Z 0 [Note] [MY-000000] [Galera] Member 2(mysql2) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207303,911b5060ecd91eae:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:52:35.212354Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207303:
   911b5060ecd91eae:   1/3
Waiting for more votes.
2022-11-28T10:52:35.213144Z 0 [Note] [MY-000000] [Galera] Member 0(mysql3) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207303,911b5060ecd91eae:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:52:35.213160Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207303:
   911b5060ecd91eae:   2/3
Winner: 911b5060ecd91eae
2022-11-28T10:52:35.220998Z 0 [Note] [MY-000000] [Galera] Member 1(mysql1) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207304,a688560ee74007f5:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:52:35.221048Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207304:
   a688560ee74007f5:   1/3
Waiting for more votes.
2022-11-28T10:52:35.221100Z 2 [Note] [MY-000000] [Galera] Got vote request for seqno 26434dcf-be23-11eb-b8a8-07ff36f08eec:207304
2022-11-28T10:52:35.221611Z 0 [Note] [MY-000000] [Galera] Member 2(mysql2) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207304,a688560ee74007f5:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:52:35.221631Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207304:
   a688560ee74007f5:   2/3
Winner: a688560ee74007f5
2022-11-28T10:52:35.221685Z 2 [Note] [MY-000000] [Galera] 26434dcf-be23-11eb-b8a8-07ff36f08eec:207304 already voted on. Continue.
2022-11-28T10:53:19.271740Z 0 [Note] [MY-000000] [Galera] Member 0(mysql3) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207307,e3b11ec06d857c00:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:53:19.271789Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207307:
   e3b11ec06d857c00:   1/3
Waiting for more votes.
2022-11-28T10:53:19.271826Z 0 [Note] [MY-000000] [Galera] Member 2(mysql2) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207307,e3b11ec06d857c00:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:53:19.271841Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207307:
   e3b11ec06d857c00:   2/3
Winner: e3b11ec06d857c00
2022-11-28T10:53:19.271855Z 11 [Note] [MY-000000] [Galera] Got vote request for seqno 26434dcf-be23-11eb-b8a8-07ff36f08eec:207307
2022-11-28T10:53:19.271910Z 11 [Note] [MY-000000] [Galera] 26434dcf-be23-11eb-b8a8-07ff36f08eec:207307 already voted on. Continue.
2022-11-28T10:54:04.398512Z 0 [Note] [MY-000000] [Galera] Member 1(mysql1) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309,eb956fdf5c5403b4:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:54:04.398557Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309:
   eb956fdf5c5403b4:   1/3
Waiting for more votes.
2022-11-28T10:54:04.398587Z 0 [Note] [MY-000000] [Galera] Member 2(mysql2) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309,be38172cf9699bd9:  Deze toegang (GRANT) is niet toegekend voor gebruiker 'someuser' op host '%', Error_code: 1141;
2022-11-28T10:54:04.398600Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309:
   be38172cf9699bd9:   1/3
   eb956fdf5c5403b4:   1/3
Waiting for more votes.
2022-11-28T10:54:04.398658Z 15 [Note] [MY-000000] [Galera] Got vote request for seqno 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309
2022-11-28T10:54:04.399922Z 0 [Note] [MY-000000] [Galera] Member 0(mysql3) initiates vote on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309,eb956fdf5c5403b4:  There is no such grant defined for user 'someuser' on host '%', Error_code: 1141;
2022-11-28T10:54:04.399953Z 0 [Note] [MY-000000] [Galera] Votes over 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309:
   be38172cf9699bd9:   1/3
   eb956fdf5c5403b4:   2/3
Winner: eb956fdf5c5403b4
2022-11-28T10:54:04.400014Z 49864 [ERROR] [MY-000000] [Galera] Inconsistency detected: Inconsistent by consensus on 26434dcf-be23-11eb-b8a8-07ff36f08eec:207309
         at galera/src/replicator_smm.cpp:process_apply_error():1440

Environment

Ubuntu 20.04.5 LTS

percona-xtradb-cluster-server:
Installed: 1:8.0.28-19-1.focal
Candidate: 1:8.0.28-19-1.focal

Linked issues

duplicates

PXC-3768

Changing error message language and triggering an error causes node to exit cluster

Activity

Duplicate

Details
Assignee
Unassigned
Reporter
Jelmer Steenhuis
Needs QA
Yes
Affects versions
8.0.28-19 (Q1 2022)
Priority
Medium

Smart Checklist

Created December 5, 2022 at 10:10 AM

Updated March 6, 2024 at 8:48 PM

Resolved March 1, 2023 at 12:54 PM

WSREP breaks when SET lc_messages = 'nl_NL' is used

Description

Environment

Linked issues

duplicates

Activity

Details
Assignee
Unassigned
Reporter
Jelmer Steenhuis
Needs QA
Yes
Affects versions
8.0.28-19 (Q1 2022)
Priority
Medium

Details

Assignee

Reporter

Needs QA

Affects versions

Priority

Smart Checklist

Smart Checklist

Flag notifications

Something's gone wrong

Something's gone wrong

WSREP breaks when SET lc_messages = 'nl_NL' is used

Description

Environment

Linked issues

duplicates

Activity

DetailsAssigneeUnassignedUnassignedReporterJelmer SteenhuisJelmer SteenhuisNeeds QAYesAffects versions8.0.28-19 (Q1 2022)PriorityMedium

Details

Assignee

Reporter

Needs QA

Affects versions

Priority

Smart ChecklistOpen Smart Checklist

Smart Checklist

Flag notifications

Something's gone wrong

Something's gone wrong

Details
Assignee
Unassigned
Reporter
Jelmer Steenhuis
Needs QA
Yes
Affects versions
8.0.28-19 (Q1 2022)
Priority
Medium

Smart Checklist