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

Create/drop table fails on Columnstore

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 6.1.1
    • N/A
    • N/A
    • None

    Description

      Create table fails with below error:
      Error Code: 1815
      Internal error: CAL0009: (2)Create table failed due to WE: Error updating calpontsys.systable: a BRM Begin copy error.

      Drop table fails with below error:
      Error Code: 1815
      Internal error: CAL0009: Error in dropping table from systables.

      -----------------------------------------------------------

      Able to reproduce and issue is affecting create/drop for any table:

      USE dm_temp;
      CREATE TABLE bug
      (
      a INT
      ) ENGINE=Columnstore;
      2 queries executed, 1 success, 1 errors, 0 warnings
      Query: use dm_temp
      0 row(s) affected
      Execution Time : 0.002 sec
      Transfer Time : 0 sec
      Total Time : 0.002 sec
      -----------------------------------------------------------
      Query: Create table bug ( a int) ENGINE=Columnstore
      Error Code: 1815
      Internal error: CAL0009: (2)Create table failed due to WE: Error updating calpontsys.systable: a BRM Begin copy error.
      Execution Time : 0 sec
      Transfer Time : 0 sec
      Total Time : 1.180 sec

      USE dm_fait;
      DROP TABLE fait_ra_temp;
      2 queries executed, 1 success, 1 errors, 0 warnings
      Query: use dm_fait
      0 row(s) affected
      Execution Time : 0.002 sec
      Transfer Time : 0 sec
      Total Time : 0.003 sec
      -----------------------------------------------------------
      Query: DROP TABLE fait_ra_temp
      Error Code: 1815
      Internal error: CAL0009: Error in dropping table from systables.
      Execution Time : 0 sec
      Transfer Time : 0 sec
      Total Time : 0.199 sec
      in both cases the error message mentions "systables"

      from debug.log
      Oct 8 06:13:59 pixid-csx2 ddlpackageproc[4772]: 59.036919 |459|89631|0| D 23 CAL0041: Start SQL statement: DROP TABLE `dm_fait`.`fait_ra_temp`;|dm_fait|
      Oct 8 06:13:59 pixid-csx2 ddlpackageproc[4772]: 59.132245 |459|89631|0| D 23 CAL0042: End SQL statement
      Oct 8 06:13:59 pixid-csx2 ddlpackageproc[4772]: 59.133153 |0|0|0| E 23 CAL0009: Error in dropping table from systables.
      ...
      Oct 8 08:07:06 pixid-csx2 ddlpackageproc[4772]: 06.458682 |53185|89640|0| D 23 CAL0041: Start SQL statement: CREATE TABLE bug#012(#012a INT#012) ENGINE=Columnstore;|dm_temp|
      Oct 8 08:07:07 pixid-csx2 ddlpackageproc[4772]: 07.489148 |53185|89640|0| D 23 CAL0042: End SQL statement
      Oct 8 08:07:07 pixid-csx2 ddlpackageproc[4772]: 07.490066 |0|0|0| E 23 CAL0009: (2)Create table failed due to WE: Error updating calpontsys.systable: a BRM Begin copy error.
      Oct 8 08:07:28 pixid-csx2 ddlpackageproc[4772]: 28.601530 |53185|89641|0| D 23 CAL0041: Start SQL statement: CREATE TABLE bug ( a INT ) ENGINE=Columnstore;|dm_temp|

      Attachments

        1. Columnstore.xml
          20 kB
          Sandhya Balakrishnan

        Activity

          People

            Unassigned Unassigned
            sandhyabalakrishnan Sandhya Balakrishnan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.