Details
Description
The load was running on a single node in a 3 node cluster. 3 threads were executing DML with only concurrent add and drop column causes inconsistency between the nodes.
2023-11-08 7:16:13 0 [Note] WSREP: Votes over a52d165a-7e06-11ee-bede-afb796da4be7:33835:
f99cf43909114ded: 1/3
Waiting for more votes.
2023-11-08 7:16:13 0 [Note] WSREP: Member 1(node2) initiates vote on a52d165a-7e06-11ee-bede-afb796da4be7:33835,f99cf43909114ded:
2023-11-08 7:16:13 0 [Note] WSREP: Votes over a52d165a-7e06-11ee-bede-afb796da4be7:33835:
f99cf43909114ded: 2/3
Winner: f99cf43909114ded
2023-11-08 7:16:13 7 [Note] WSREP: Got vote request for seqno a52d165a-7e06-11ee-bede-afb796da4be7:33835
2023-11-08 7:16:13 0 [Note] WSREP: Recovering vote result from history: a52d165a-7e06-11ee-bede-afb796da4be7:33835,f99cf43909114ded
To reproduce run pstress with below option. for compling refer pstress
pstress-md --address=127.0.0.1 --user=test --password=testpass --database=pstress --pk-prob=100 --no-enc --threads=3 --no-tbs --undo-tbs-count=0 --no-virtual --no-table-compression --row-format=none --grammar-sql=0 --no-column-compression --only-cl-ddl --add-column=10 --drop-column=10 --no-temp-tables --no-partition-tables --port=$PORT_NODE1 --seconds=20 --seed=08112023
|
Attachments
Issue Links
- is blocked by
-
MDEV-33064 ALTER INPLACE running TOI doesn't abort a DML operation in InnoDB
-
- Closed
-
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Denis Protivensky [ JIRAUSER52676 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.4.32 [ 29300 ] | |
| Affects Version/s | 10.6.15 [ 29013 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Denis Protivensky [ JIRAUSER52676 ] | Julius Goryavsky [ sysprg ] |
| Status | In Progress [ 3 ] | In Testing [ 10301 ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Assignee | Julius Goryavsky [ sysprg ] | Denis Protivensky [ JIRAUSER52676 ] |
| Assignee | Denis Protivensky [ JIRAUSER52676 ] | Julius Goryavsky [ sysprg ] |
| Status | Stalled [ 10000 ] | In Testing [ 10301 ] |
| Link |
This issue relates to |
| Link |
This issue is blocked by |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.5.26 [ 29832 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.6.19 [ 29833 ] | |
| Fix Version/s | 10.11.9 [ 29834 ] | |
| Fix Version/s | 11.1.6 [ 29835 ] | |
| Fix Version/s | 11.2.5 [ 29836 ] | |
| Fix Version/s | 11.4.3 [ 29837 ] |