[MCOL-5036] A query on information_schema columnstore table will restart database instance. Created: 2022-03-30  Updated: 2023-07-05

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.2.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Edward Stoever Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

When MariaDB is running, but mariadb-columnstore is not:

systemctl stop mariadb-columnstore;

Now, login to database and query:

mariadb -s
 
MariaDB [(none)]> select * from  information_schema.COLUMNSTORE_TABLES;
 
ERROR 2013 (HY000): Lost connection to server during query
 
MariaDB [(none)]>

Database Error log includes: "[ERROR] mysqld got signal 6"
Same will happen for any of these:

select * from  information_schema.COLUMNSTORE_COLUMNS; 
select * from  information_schema.COLUMNSTORE_TABLES;
 
select * from  information_schema.COLUMNSTORE_FILES;
 
select * from  information_schema.COLUMNSTORE_EXTENTS;

A more graceful error without a restart of mariadb would be better.

 Comments   
Comment by Edward Stoever [ 2022-03-30 ]

Tested on Columnstore_version 6.2.2

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