[MCOL-3653] Can't Drop/create and select table for Columnstore Created: 2019-12-06  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.2.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Sarba Choudhury (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Environment:

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.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-12-06 ]

Can we please see the statements / error after the DROP TABLE...RESTRICT?

Comment by Isaac Venn (Inactive) [ 2019-12-09 ]

DROP TABLE icy_iguana.merge_30 RESTRICT;

  1. Error Code: 1051. Unknown table 'icy_iguana.merge_30'

SHOW WARNINGS;

  1. Level Code Message
  2. Error 1051 Unknown table 'icy_iguana.merge_30'

CREATE TABLE `merge_30` (
`cover_key` int(10) unsigned DEFAULT NULL,
`count_num` bigint(20) unsigned DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1;

  1. Error Code: 1815. Internal error: CAL0009: Internal create table error for icy_iguana.merge_30 : table already exists (your schema is probably out-of-sync)

SHOW WARNINGS;

  1. Error 1815 Internal error: CAL0009: Internal create table error for icy_iguana.merge_30 : table already exists (your schema is probably out-of-sync)
  2. Warning 9999 CAL0009: Internal create table error for icy_iguana.merge_30 : table already exists (your schema is probably out-of-sync)
  3. Warning 1030 Got error 1 "Operation not permitted" from storage engine Columnstore
Comment by Andrew Hutchings (Inactive) [ 2019-12-10 ]

Can you please provide the output of "select * from calpontsys.systable"?

Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was opened prior to convergence with the server. It may have been rendered obsolete. If this issue still exists in a modern version, please open a new request.

Generated at Thu Feb 08 02:44:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.