Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
23.02.4
-
None
-
None
-
Linux Ubuntu image: docker.io/amd64/ubuntu:focal
Description
Another ridiculously long bug report. The attempt is to deploy just one pod that actually works. Nothing as fancy as the undocumented cluster config.
First: I can't pull your docker repo image. It's a heavily regulated environment. That means I use a compliant image currently based on image: docker.io/amd64/ubuntu:focal
Second: This is a proof of concept. If there's any possibility of spending money at MariaDB, the proof of concept has to work.
I have so many more questions, but basically the scant documentation to run columnstore in even a single pod isn't correct for 11.1.
Scant documentation: https://mariadb.com/docs/server/deploy/topologies/single-node/community-columnstore-cs10-6/
Getting the repo configured, and packages installed works... Sort of.
/etc/rsyslog.d/49-columnstore.conf is created. But, doesn't seem to do anything? Everything is logged to /var/log/syslog.
I couldn't create a table. Is there logging somewhere else? Reboots destroy everything despite using persistent volumes??
tail /var/log/syslog
Aug 9 23:07:03 mariadb11-0 DMLProc[9667]: 03.349525 |0|0|0| I 20 CAL0002: DMLProc finished rollbackAll.
Aug 9 23:07:03 mariadb11-0 ddlpackageproc[9664]: 03.354914 |0|0|0| C 23 CAL0008: DMLProc main process has started
Aug 9 23:07:07 mariadb11-0 ddlpackageproc[9684]: 07.595832 |0|0|0| C 23 CAL0008: DDLProc main process has started
Aug 9 23:16:26 mariadb11-0 workernode[9831]: 26.473212 |0|0|0| C 30 CAL0000: Usage: /usr/bin/workernode DBRM_WorkerN %%10%%
Aug 9 23:16:35 mariadb11-0 workernode[9835]: 35.761498 |0|0|0| I 30 CAL0000: WorkerNode main process has started %%10%%
Aug 9 23:25:24 mariadb11-0 workernode[9955]: 24.346956 |0|0|0| C 30 CAL0000: Usage: workernode DBRM_WorkerN %%10%%
Aug 9 23:52:52 mariadb11-0 ddlpackageproc[9686]: 52.292228 |19|6|0| D 23 CAL0041: Start SQL statement: create table foo (`interactionId` varchar(64) NOT NULL,#012 `number` int(11) unsigned DEFAULT NULL,#012 `accountId` varchar(64) DEFAULT NULL,#012 `queueId` varchar(64) DEFAULT NULL) ENGINE=columnStore DEFAULT CHARSET=latin1;|db1|
Aug 9 23:52:52 mariadb11-0 controllernode[9686]: 52.294864 |0|0|0| W 29 CAL0000: ExtentMap::getSysCatDBRoot(): OID not found: 1001 %%10%%
Aug 9 23:52:52 mariadb11-0 ddlpackageproc[9686]: 52.295288 |19|6|0| D 23 CAL0042: End SQL statement
Aug 9 23:52:52 mariadb11-0 ddlpackageproc[9686]: 52.296787 |0|0|0| E 23 CAL0009: Error while calling getSysCatDBRoot