[MCOL-5352] Truncate table failed after PrimProc restarted Created: 2022-12-14 Updated: 2024-02-07 |
|
| Status: | In Progress |
| Project: | MariaDB ColumnStore |
| Component/s: | DMLProc |
| Affects Version/s: | 22.08.4 |
| Fix Version/s: | 23.10 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Denis Khalikov |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Sprint: | 2023-12 | ||||||||
| Description |
|
Build tested: 22.08.4, as well as the latest in develop engine: 15f65eff157f8fce48c0dfb30548dc787b259eb2 The TRUNCATE command fails after PrimProc is restarted on single-node setup,
Repeating the TRUNCATE command would continue to return error, unless a create table command has been processed.
|
| Comments |
| Comment by Daniel Lee (Inactive) [ 2023-05-24 ] |
|
Build tested: 23.02.3 systemctl restart mcs-primproc [rocky8:root@rocky8~]# mariadb mytest Welcome to the MariaDB monitor. Commands end with ; or \g. Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [mytest]> truncate lineitem; Truncate table after "mcs cluster restart" works fine. |
| Comment by Roman [ 2024-01-17 ] |
|
After a discussion with leonid.fedorov we came to a conclusion that the problem is caused by TCP socket in DML/DDLProc that stuck when one of PP in a cluster restarts.
|