Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.2.5
-
None
-
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
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]>
|