[MCOL-151] Columnstore engine not available after reboot Created: 2016-06-20  Updated: 2023-10-26  Resolved: 2016-07-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: None
Fix Version/s: 1.0.2

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: David Hill (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

After I reboot my box with columnstore 1.0.1 RPM installed I start columnstore with the /etc/init.d/mysql-Columnstore script

I then connect to the database:
[justin@eschaton1 init.d]$ /usr/local/mariadb/columnstore/mysql/bin/mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.10-MariaDB-log Columnstore 1.0-1

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

SHOW ENGINES does not find COLUMNSTORE or INFINIDB.

Can't create COLUMNSTORE tables:
MariaDB [test]> create table lost(c1 int) engine=columnstore;
ERROR 1286 (42000): Unknown storage engine 'columnstore'

 Comments   
Comment by David Hill (Inactive) [ 2016-07-13 ]

not a bug, operate error. You don't start columnstore with this service:

from comments:

start columnstore with the /etc/init.d/mysql-Columnstore script

It worked in my testing

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