Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Inconsistency Detected when changing session lc_messages variable

Description

PXC node is evicted from the cluster if the locale variable is changed at session level.

Please check the below example:

node1 [localhost:13226] {msandbox} (test) > create table t1 (c1 integer auto_increment primary key, c2 integer); Query OK, 0 rows affected (0.07 sec) node1 [localhost:13226] {msandbox} (test) > SET lc_messages = 'fr_FR'; Query OK, 0 rows affected (0.05 sec) node1 [localhost:13226] {msandbox} (test) > ALTER TABLE t1 MODIFY c2 BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ; ERROR 1075 (42000): Un seul champ automatique est permis et il doit être indexé

 

The error log shows the node was evicted due to an inconsistency:

2023-11-14T22:32:56.680682Z 0 [Note] [MY-000000] [Galera] Member 0(tp-support03.tp.int.percona.com) initiates vote on cd099700-833c-11ee-a43b-aef5f547f5e0:38,9ba6b312fd1dd523:  Un seul champ automatique est permis et il doit être indexé, Error_code: 1075; 2023-11-14T22:32:56.680799Z 0 [Note] [MY-000000] [Galera] Votes over cd099700-833c-11ee-a43b-aef5f547f5e0:38:    9ba6b312fd1dd523:   1/3 Waiting for more votes. 2023-11-14T22:32:56.698219Z 0 [Note] [MY-000000] [Galera] Member 1(tp-support03.tp.int.percona.com) initiates vote on cd099700-833c-11ee-a43b-aef5f547f5e0:38,cd375c83743effd7:  Incorrect table definition; there can be only one auto column and it must be defined as a key, Error_code: 1075; 2023-11-14T22:32:56.698258Z 0 [Note] [MY-000000] [Galera] Votes over cd099700-833c-11ee-a43b-aef5f547f5e0:38:    9ba6b312fd1dd523:   1/3    cd375c83743effd7:   1/3 Waiting for more votes. 2023-11-14T22:32:56.700983Z 0 [Note] [MY-000000] [Galera] Member 2(tp-support03.tp.int.percona.com) initiates vote on cd099700-833c-11ee-a43b-aef5f547f5e0:38,cd375c83743effd7:  Incorrect table definition; there can be only one auto column and it must be defined as a key, Error_code: 1075; 2023-11-14T22:32:56.701027Z 0 [Note] [MY-000000] [Galera] Votes over cd099700-833c-11ee-a43b-aef5f547f5e0:38:    9ba6b312fd1dd523:   1/3    cd375c83743effd7:   2/3 Winner: cd375c83743effd7 2023-11-14T22:32:56.701132Z 23 [ERROR] [MY-000000] [Galera] Inconsistency detected: Inconsistent by consensus on cd099700-833c-11ee-a43b-aef5f547f5e0:38      at galera/src/replicator_smm.cpp:process_apply_error():1469 ... 2023-11-14T22:32:56.702972Z 23 [Note] [MY-000000] [Galera] gcomm: closing backend 2023-11-14T22:32:56.703774Z 23 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(NON_PRIM,cd08ad09-a858,3) memb {     cd08ad09-a858,0     } joined {     } left {     } partitioned {     d362203c-b2ad,0     e7e18faf-8c5b,0     } )

The consistency check should be done based on the error code rather than the error message.

Environment

None

AFFECTED CS IDs

CS0041767

Activity

Venkatesh Prasad November 22, 2023 at 1:18 PM

Kamil Holubicki November 15, 2023 at 7:21 AM

This is the duplicate of https://perconadev.atlassian.net/browse/PXC-4298#icft=PXC-4298 which already has a patch in review. Assigning to .

Done

Details

Assignee

Reporter

Needs QA

Yes

Fix versions

Affects versions

Priority

Smart Checklist

Created November 15, 2023 at 1:06 AM
Updated March 6, 2024 at 8:35 PM
Resolved November 22, 2023 at 1:18 PM