Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
22.08.4, 23.02.2
-
None
-
2023-12, 2024-1
Description
Build tested: 22.08.4, as well as the latest in develop
engine: 15f65eff157f8fce48c0dfb30548dc787b259eb2
server: d3049350bb5c61340f5a7518b155d3c9dacdcb33
buildNo: 6257
The TRUNCATE command fails after PrimProc is restarted on single-node setup,
or on the primary node of a multi-node cluster. If PrimProc was restarted on slave node, TRUNCATE would still succeed.
MariaDB [mytest]> truncate lineitem;
|
ERROR 1815 (HY000): Internal error: CAL0009: Truncate table failed: MCS-2045: At least one PrimProc closed the connection unexpectedly.
|
Repeating the TRUNCATE command would continue to return error, unless a create table command has been processed.
MariaDB [mytest]> truncate lineitem;
|
ERROR 1815 (HY000): Internal error: CAL0009: Truncate table failed: MCS-2045: At least one PrimProc closed the connection unexpectedly.
|
MariaDB [mytest]> create table t1 (c1 int) engine=columnstore;
|
Query OK, 0 rows affected (0.085 sec)
|
|
MariaDB [mytest]> truncate lineitem;
|
Query OK, 0 rows affected (0.089 sec)
|
Build tested:
23.02.3
develop branch
engine: a90535e1a7ffefa0e5ae808fdd0d38d30cffc017
server: 805750b3a90ed4aecbf475025e63674aaab7f7f7
buildNo: 7829
systemctl restart mcs-primproc
[rocky8:root@rocky8~]# mariadb mytest
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 22
Server version: 10.6.13-8-MariaDB MariaDB Server
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;
ERROR 1815 (HY000): Internal error: CAL0009: Truncate table failed: MCS-2045: At least one PrimProc closed the connection unexpectedly.
Truncate table after "mcs cluster restart" works fine.