[MCOL-4332] Stored Procedures for information schema tables are failing Created: 2020-09-30  Updated: 2023-10-26  Resolved: 2020-09-30

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.5.3
Fix Version/s: 5.4.1

Type: Bug Priority: Trivial
Reporter: Michael Kardell Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: crash
Environment:

RHEL 8.2
Intel(R) Core(TM) i7-8700 CPU @ 3.20GHz, 6 cores/12 threads
SSD disk

MariaDB-columnstore-engine.x86_64 10.5.5-1.el8

mysqld would have been started with the following arguments:
--plugin-load-add=ha_columnstore.so --plugin-maturity=beta --plugin-maturity=gamma --log_error=mariadbd.err --character_set_server=utf8 --max_length_for_sort_data=32000 --max_statement_time=10000

Attachments: File columnstoreSupportReport.columnstore-1.tar.gz    

 Description   

The following stored procedures for information schema tables are failing

call columnstore_info.total_usage(); 
call columnstore_info.table_usage(NULL, NULL); 
call columnstore_info.table_usage('my_schema', 'my_table'); 
call columnstore_info.compression_ratio();

I get the following errors:
ERROR 2006 (HY000): MySQL server has gone away
ERROR 2013 (HY000): Lost connection to MySQL server during query

Please advise.
Generated at Thu Feb 08 02:49:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.