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

Can't Drop/create and select table for Columnstore

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.2.3
    • Icebox
    • N/A
    • None
    • Prod

    Description

      Our customer is trying to drop/create and select from Columnstore database and facing this issue:

      Name : mariadb-columnstore-platform
      Version : 1.2.3

      SELECT * FROM icy_Test.merge_303;
      Error Code: 1815. Internal error: IDB-2006: 'icy_iguana.merge_303' does not exist in Columnstore.
      CREATE TABLE `merge_30` ( `cover_key` int(10) unsigned DEFAULT NULL, `count_num` bigint(20) unsigned DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=latin1 COMMENT='SCHEMA SYNC ONLY'
      Error Code: 1050. Table 'merge_30' already exists
      CREATE TABLE `merge_30` ( `cover_key` int(10) unsigned DEFAULT NULL, `count_num` bigint(20) unsigned DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=latin1
      Error Code: 1050. Table 'merge_30' already exists
      DROP TABLE icy_iguana.merge_30
      Error Code: 1815. Internal error: CAL0009: Drop table failed due to IDB-2006: 'icy_iguana.merge_30' does not exist in Columnstore.
      after several commands, I get these warnings back:
      Level, Code, Message
      'Note', '1051', 'Unknown table \'infinidb_vtable.$vtable_7314339\''
      'Error', '1815', 'Internal error: IDB-2006: \'icy_iguana.merge_30\' does not exist in Columnstore.'
      'Error', '1030', 'Got error 1815 \"Unknown error 1815\" from storage engine Aria'
      then this sequence is interesting:
      SELECT * FROM icy_iguana.merge_30
      Error Code: 1815. Internal error: IDB-2006: 'icy_iguana.merge_30' does not exist in Columnstore.
      DROP TABLE icy_iguana.merge_30
      Error Code: 1815. Internal error: CAL0009: Drop table failed due to IDB-2006: 'icy_iguana.merge_30' does not exist in Columnstore.
      SHOW WARNINGS
      Level, Code, Message
      'Error', '1815', 'Internal error: CAL0009: Drop table failed due to IDB-2006: \'icy_iguana.merge_30\' does not exist in Columnstore. '
      'Warning', '9999', 'CAL0009: Drop table failed due to IDB-2006: \'icy_iguana.merge_30\' does not exist in Columnstore. '
      'Error', '1030', 'Got error 3 \"No such process\" from storage engine Columnstore'
      the 'no such process' error is curious
      

      We tried :

      DROP TABLE icy_iguana.merge_30 RESTRICT;
      

      It works

      But create and select table is keep failing.

      Attachments

        Activity

          People

            Unassigned Unassigned
            sarba Sarba Choudhury (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 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.