Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.19
-
Ubuntu 22.04
Description
Error code 1067: indicates an attempt to set an invalid default value for column6. This could be due to a data type mismatch (e.g., assigning a string default value to an integer column) or non-compliance with a column constraint.
WSREP ignores error: the WSREP layer of the Galera cluster ignored this error and did not prevent the propagation of the DDL operation. This could lead to inconsistent table structures across nodes.
log:
2024-10-26 21:12:56 2 [ERROR] mariadbd: Can't find record in 'test7'
|
2024-10-26 21:12:56 2 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table mytest1.test7; Can't find record in 'test7', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log FIRST, end_log_pos 919, Internal MariaDB error code: 1032
|
2024-10-26 21:12:56 2 [Warning] WSREP: Event 3 Update_rows_v1 apply failed: 137, seqno 157646
|
2024-10-26 21:12:56 0 [Note] WSREP: Member 0(node4) initiates vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,d1c41988d9b35d55: Can't find record in 'test7', Error_code: 1032;
|
2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
|
d1c41988d9b35d55: 1/4
|
Waiting for more votes.
|
2024-10-26 21:12:56 0 [Note] WSREP: Member 2(node2) initiates vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,d1c41988d9b35d55: Can't find record in 'test7', Error_code: 1032;
|
2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
|
d1c41988d9b35d55: 2/4
|
Waiting for more votes.
|
2024-10-26 21:12:56 0 [Note] WSREP: Member 3(node1) responds to vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,0000000000000000: Success
|
2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
|
0000000000000000: 1/4
|
d1c41988d9b35d55: 2/4
|
Waiting for more votes.
|
2024-10-26 21:12:56 0 [Note] WSREP: Member 1(node3) initiates vote on 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646,d1c41988d9b35d55: Can't find record in 'test7', Error_code: 1032;
|
2024-10-26 21:12:56 0 [Note] WSREP: Votes over 26bcca7d-934f-11ef-81ac-6fc1501a64a1:157646:
|
0000000000000000: 1/4
|
d1c41988d9b35d55: 3/4
|
Winner: d1c41988d9b35d55
|
CunDi Fang Hi, could you please provide full error log and show create table for test7, thank you.