[MCOL-3517] ColumnStore originally installed in CentOS7 on Docker doesn't accept any DML due to the error "(schema.table) does not exist in Columnstore" Created: 2019-09-25  Updated: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: Docker
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Keita Yaegashi Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Host Environment

  • macOS Mojave 10.14.4
  • Docker Desktop Community 2.1.0.3 (38240)

Docker Image Environment

  • CentOS Linux release 7.7.1908 (Core)
  • Server version: 10.3.16-MariaDB-log Columnstore 1.2.5-1

Attachments: HTML File Dockerfile    

 Description   

Overview

I decided to install ColumnStore originally in CentOS7 image Docker officially provides in order to customize my database environment deeply.

However, after the installation, any DML (such as INSERT, SELECT, etc) doesn't work for any created ColumnStore table due to the error:

ERROR 1815 (HY000): Internal error: CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2006: '<schema_name>.<table_name>' does not exist in Columnstore. 

Please tell me if I make any mistakes, or fix it.

Reproduction Step

Place the files somewhere:

Dockerfile
yum.repos.d/mariadb-columnstore-data-adapters.repo
yum.repos.d/mariadb-columnstore-tools.repo
yum.repos.d/mariadb-maxscale.repo
yum.repos.d/mariadb-columnstore-api.repo
yum.repos.d/mariadb-columnstore.repo

where Dockerfile is in the attachment and *.repo files are the same as described in the instruction.

Reproduce like the following:

$ docker build -t sampleteam/sampledb:0.1 .
$ docker run --privileged -d --name sampledb -p 2222:22 -p 3306:3306 sampleteam/sampledb:0.1 /sbin/init
$ vim ~/.ssh/known_hosts  # To remove [127.0.0.1]:2222 if any
$ ssh -p 2222 sample@127.0.0.1
sample@127.0.0.1's password: sample
[sample@66c1bb2d3743 ~]$ mcsmysql -uroot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.3.16-MariaDB-log Columnstore 1.2.5-1
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> CREATE TABLE column_test (id INT(11), value VARCHAR(100)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (2.002 sec)
 
MariaDB [test]> show tables;
+----------------+
| Tables_in_test |
+----------------+
| column_test    |
+----------------+
1 row in set (0.001 sec)
 
MariaDB [test]> show create table column_test\G
*************************** 1. row ***************************
       Table: column_test
Create Table: CREATE TABLE `column_test` (
  `id` int(11) DEFAULT NULL,
  `value` varchar(100) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8
1 row in set (0.001 sec)
 
MariaDB [test]> INSERT INTO column_test VALUES (1, 'test');
ERROR 1815 (HY000): Internal error: CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2006: 'test.column_test' does not exist in Columnstore. 
MariaDB [test]> CREATE DATABASE mytest;
Query OK, 1 row affected (0.003 sec)
 
MariaDB [test]> use mytest;
Database changed
MariaDB [mytest]> CREATE TABLE column_test (id INT(11), value VARCHAR(100)) ENGINE=Columnstore DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.384 sec)
 
MariaDB [mytest]> INSERT INTO column_test VALUES (1, 'test');
ERROR 1815 (HY000): Internal error: CAL0001: dmlprocessor.cpp PackageHandler::run() package type 0 IDB-2006: 'mytest.column_test' does not exist in Columnstore. 
MariaDB [mytest]> SELECT * FROM column_test;
ERROR 1815 (HY000): Internal error: IDB-2006: 'mytest.column_test' does not exist in Columnstore.
MariaDB [mytest]> DROP TABLE column_test;
Query OK, 0 rows affected, 1 warning (0.046 sec)
 
MariaDB [mytest]> SELECT * FROM column_test;
ERROR 1146 (42S02): Table 'mytest.column_test' doesn't exist
MariaDB [mytest]> 


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