Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5352

Truncate table failed after PrimProc restarted

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 22.08.4, 23.02.2
    • 23.10.2
    • DMLProc
    • 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)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-2074 ProcMon restarted causing DDL/DMLProc to re-init and system going into read-only mode

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5338 BRM_savesB_journal not found -timeout ?

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5339 DDLProc[xx]: Could not connect to pmX_WriteEngineServer: Connection refused

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MCOL-6613 Backport MCOL-5352 to 23.02: first DDL/DML after a PrimProc restart fails once with MCS-2045

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              denis0x0D Denis Khalikov (Inactive)
              dleeyh Daniel Lee (Inactive)
              Leonid Fedorov Leonid Fedorov
              Kirill Perov Kirill Perov (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.