[MCOL-5216] Columnstore Install succeeds but cannot be used when mysql user was created prior to install Created: 2022-09-09  Updated: 2023-09-27

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 6.4.4-dompe
Fix Version/s: Icebox

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

Attachments: Zip Archive columnstore.logs.zip    

 Description   

Run the useradd -m mysql command before install:

useradd -m mysql
 
apt -y install mariadb-server mariadb-backup* socat mariadb-plugin-columnstore

After install completes, all commands that would use the columnstore engine fail. Examples:

root@cs00:~$ mariadb -ABNe "select * from calpontsys.systable;"
 
ERROR 1815 (HY000) at line 1: Internal error: pColStep: BRM lookup error. Could not get extents for OID 1001
 
root@cs00:~$ mariadb -ABNe "create schema t; create table t.test (col1 varchar(10)) engine=columnstore;"
 
ERROR 1815 (HY000) at line 1: Internal error: CAL0009: Error occured when calling makeJobList
 
root@cs00:~$

Tested on:
10.6.8-4-MariaDB-enterprise-log / Columnstore_version 6.4.4


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