Skip to:

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

Node leaves PXC cluster when running concurrent CREATE USER with password_history option

Description

Issue: node leave PXC cluster while running concurrent CREATE USER IF NOT EXISTS when using password_history option

 

Test Case:

Strat 3 node cluster (using dbdeployer in test) 

Tested with PXC 8.0.28, Issue not reproducible in PXC 5.7.38 as there is no password_history option in 5.7

my.cnf 

node1 : node1 on  -  port    25002 (25002)

node2 : node2 on  -  port    25003 (25003)
node3 : node3 on  -  port    25004 (25004)

Run CREATE USER IF NOT EXISTS on all 3 nodes same time, use the following script to reproduce the issue.

Output:

 

node3 exit from cluster due to data inconsistency.

 

 

 

Environment

None

AFFECTED CS IDs

CS0029487

Smart Checklist

Activity

Eleonora Zinchenko December 14, 2022 at 4:29 PM

Hi,

Verified with PXC 8.0.30 focal package. Issue is not reproduced.

Kamil Holubicki September 12, 2022 at 12:37 PM
Edited

An easier way to reproduce:

  1. 2-node cluster

  2. log in to node-1 and paste

Result: node-2 leaves the cluster.

Done

Details

Assignee

Reporter

Needs Review

Yes

Fix versions

Affects versions

Priority

Smart Checklist

Created August 23, 2022 at 9:52 AM
Updated March 6, 2024 at 8:52 PM
Resolved September 13, 2022 at 6:33 AM