Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2.3
-
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.