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
|
Attachments
Activity
maradb_0.7z
maradb_1.7z maradb_2.7z maradb_3.7z maradb_4.7z
Okay, sorry it's a little late, there's been some delays looking for these files.I found the error while running on a 5 node mariadb cluster, this is the log file and all the files inside the data folder at that time.
CunDi Fang Hi, could you please provide full error log and show create table for test7, thank you.