Error with single server DBRM while creating table using Columnstore Engine in Docker

[Bryan Perkins]

I have recently been receiving an error regarding the DBRM, the specific error being:

ERROR 1815 (HY000) at line 1: Internal error: Cannot execute the statement. DBRM is read only!

 I'm running Columnstore in single server mode in a Docker Container, with data1 and mysql/db mounted externally. When I create a table using the following syntax:

CREATE TABLE iis.logs (

`date` varchar(10) DEFAULT NULL,

`time` varchar(8) DEFAULT NULL,

`sip` varchar(50) DEFAULT NULL,

`csmethod` varchar(50) DEFAULT NULL,

`csuristem` varchar(50) DEFAULT NULL,

`csuriquery` int(11) DEFAULT NULL,

`sport` varchar(20) DEFAULT NULL,

`csusername` varchar(100) DEFAULT NULL,

`cip` varchar(1500) DEFAULT NULL,

`csuseragent` int(11) DEFAULT NULL,

`scstatus` int(11) DEFAULT NULL,

`scsubstatus` int(11) DEFAULT NULL,

`scwin32status` int(11) DEFAULT NULL,

`timetaken` varchar(500) DEFAULT NULL

) ENGINE=Columnstore DEFAULT CHARSET=utf8;

I receive the error I listed above. When I run it without the "ENGINE=Columnstore" the table is successfully created. It is a requirement for me to run in the Columnstore engine, so this problem is currently halting my progress.

I need to fix this problem, but I'm confused as to what I need to do.

[David Thompson]

Hi Bryan,

Log in to your docker container and try the following:

 

Option 1:

/usr/local/mariadb/columnstore/bin/dbrmctl status

/usr/local/mariadb/columnstore/bin/dbrmctl readwrite

/usr/local/mariadb/columnstore/bin/dbrmctl reload

 

Option 2:

Mcsadmin shutdownsystem

Mcsadmin startSystem

 

If neither of these clear it please run the ColumnStore support utility (without restarting the container so hopefully useful logs are available). https://mariadb.com/kb/en/mariadb/system-troubleshooting-mariadb-columnstore/#mariadb-columnstore-support-tool

 

David.

--
You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To post to this group, send email to mariadb-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/6bdb0cfd-9ca8-49a0-a3ae-50eedfe2392f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Bryan Perkins]

I performed the steps you asked, and successfully got the table to be created, but now I'm receiving an odd behavior.

The table that I created doesn't seem to exist after the restart.

I have attached the support report.

To recreate the error, these are all the steps I took:

1) Open a new VM with ubuntu installed

2) Run this command to install Docker: 

sudo wget-O - https://storage.googleapis.com/vm-utilities/DockerInstall| bash

3) Extract this file into /root/

https://storage.googleapis.com/mdbcs-install/MDBCS.tar

4) In /root/MDBCS run ./startDatabaseHeadless

5) Attempt to create the table using:

CREATE TABLE iis.logs (

        `date` varchar(10) DEFAULT NULL,

        `time` varchar(8) DEFAULT NULL,

        `sip` varchar(50) DEFAULT NULL,

        `csmethod` varchar(50) DEFAULT NULL,

        `csuristem` varchar(50) DEFAULT NULL,

        `csuriquery` int(11) DEFAULT NULL,

        `sport` varchar(20) DEFAULT NULL,

        `csusername` varchar(100) DEFAULT NULL,

        `cip` varchar(1500) DEFAULT NULL,

        `csuseragent` int(11) DEFAULT NULL,

        `scstatus` int(11) DEFAULT NULL,

        `scsubstatus` int(11) DEFAULT NULL,

        `scwin32status` int(11) DEFAULT NULL,

        `timetaken` varchar(500) DEFAULT NULL

  ) ENGINE=Columnstore DEFAULT CHARSET=utf8;

6) This is where I recieved 

ERROR 1815 (HY000) at line 1: Internal error: Cannot execute the statement. DBRM is read only!

so I ran:

/usr/local/mariadb/columnstore/bin/dbrmctl status

/usr/local/mariadb/columnstore/bin/dbrmctl readwrite

/usr/local/mariadb/columnstore/bin/dbrmctl reload

ma shutdownSystem
ma startSystem

I would then recreate the table and succeed, loading some data in

7) Run ma shutdownSystem and close the docker container.

8) Startup the container the same way as before

9) Attempt to query the table only to recieve the error I listed in the folder

[David Thompson]

Hi Bryan,

I tried to reproduce this locally on an ubuntu16 vm and I was able to create the table correctly without any errors. Unfortunately there isn’t much useful in the logs. I can see that the image is ubuntu based and I’m suspicious about no logs and a few other things. I can find your repo on docker hub but could you point me to your dockerfile?

 

We have a reference centos7 based dockerfile here: https://github.com/mariadb-corporation/mariadb-columnstore-docker if that help gives you some pointers or if you want to fork that instead.

 

David.

 

From: mariadb-c...@googlegroups.com [mailto:mariadb-c...@googlegroups.com] On Behalf Of Bryan Perkins
Sent: Friday, July 28, 2017 10:44 AM
To: MariaDB ColumnStore <mariadb-c...@googlegroups.com>

--

You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To post to this group, send email to mariadb-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/d0482dfc-d8fe-4360-a437-777b30a9688a%40googlegroups.com.