[MCOL-3500] create table returned a "CAL0009: Error while calling getSysCatDBRoot" Created: 2019-09-10  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None


 Description   

Build tested: 1.4.0-1

server commit:
67452bc
engine commit:
64ceb86

I created a 1um2pm stack with S3 localStorage using non-distributed installation. When creating a table, I got the following error:

[root@localhost tests]# cat createTablestest1.log
ERROR 1815 (HY000) at line 2: Internal error: CAL0009: Error while calling getSysCatDBRoot
--------------
drop table if exists nation
--------------

Query OK, 0 rows affected, 1 warning (0.000 sec)

--------------
create table nation (
n_nationkey int,
n_name char (25),
n_regionkey int,
n_comment varchar (152)
) engine=columnstore
--------------

Bye

err.log file in UM1 also contains the following:

Sep 10 22:34:58 localhost ddlpackageproc[16958]: 58.587709 |0|0|0| E 23 CAL0009: Error while calling getSysCatDBRoot
Sep 10 22:36:45 localhost ddlpackageproc[16958]: 45.339723 |0|0|0| E 23 CAL0009: Error while calling getSysCatDBRoot

The same test on a stack installed using distributed method worked fine.



 Comments   
Comment by Patrick LeBlanc (Inactive) [ 2020-01-02 ]

Daniel reproduced it on Deb 8 w/gluster. My suspicion is that dbbuilder didn't run and didn't create the syscat. Nothing to do with the S3 stuff afaict.

Comment by Daniel Lee (Inactive) [ 2020-01-02 ]

I tried installing 1um2pm with cluster on Debian 8 again and it failed. As Patrick suggested above, the "dbbuilder 7" (create system category) was not executed or not executed successfully during postConfigure. I manually executed "dbbuilder 7" and was able to execute the a sql test script.

Comment by Daniel Lee (Inactive) [ 2020-02-27 ]

For both 1.4.2 and 1.4.3, this issue occurred only during glusterfs installations.

Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was opened prior to convergence with the server. It may have been rendered obsolete. If this issue still exists in a modern version, please open a new request.

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