[#MCOL-3682] Unhelpful errors and empty warning upon attempt to create Columnstore table

[MCOL-3682] Unhelpful errors and empty warning upon attempt to create Columnstore table Created: 2019-12-18 Updated: 2021-01-07 Resolved: 2020-05-29
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	None
Affects Version/s:	1.4.2
Fix Version/s:	1.4.5

Type:

Bug

Priority:

Minor

Reporter:

Elena Stepanova

Assignee:

Ben Thompson (Inactive)

Resolution:

Cannot Reproduce

Votes:

Labels:

None

Attachments:

columnstoreSupportReport.columnstore-1.tar.gz

debug.log

Sprint:

2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7

Description

10.4-enterprise-linuxjedi 69ca663c
MariaDB [db]> create table t1 (a int) engine=columnstore;
ERROR 1815 (HY000): Internal error: Cannot execute the statement. DBRM is read only!
MariaDB [db]> show warnings;
+---------+------+-----------------------------------------------------------------------+
\| Level \| Code \| Message \|
+---------+------+-----------------------------------------------------------------------+
\| Error \| 1815 \| Internal error: Cannot execute the statement. DBRM is read only! \|
\| Warning \| 9999 \| \|
\| Warning \| 1030 \| Got error 1 "Operation not permitted" from storage engine Columnstore \|
+---------+------+-----------------------------------------------------------------------+
3 rows in set (0.000 sec)

The error log only says

DBRM::send_recv caught: InetStreamSocket::connect: connect() error: Connection refused to: InetStreamSocket: sd: 46 inet: 0.0.0.0 port: 8616

DBRM::send_recv caught: InetStreamSocket::connect: connect() error: Connection refused to: InetStreamSocket: sd: 46 inet: 0.0.0.0 port: 8616

DBRM: SessionManager::sysCatVerID(): network error

DBRM::send_recv caught: InetStreamSocket::connect: connect() error: Connection refused to: InetStreamSocket: sd: 46 inet: 0.0.0.0 port: 8616

DBRM::send_recv caught: InetStreamSocket::connect: connect() error: Connection refused to: InetStreamSocket: sd: 46 inet: 0.0.0.0 port: 8616

which doesn't clarify much.

Comments

Comment by Todd Stoffel (Inactive) [ 2020-01-20 ]

ColumnStore 1.4 Enterprise must be restarted after repo/rpm install otherwise a columnstore table cannot be created. Maybe a DBRM issue. Currently the documentation asks the customer to restart but this is just a work around.

Comment by Timofey Turenko [ 2020-02-27 ]

added debug.log

my scenario is :

build everything from 10.4-enterprise branch of server ( cmake .. -DBUILD_CONFIG=enterprise -DRPM=rhel7 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DPLUGIN_COLUMNSTORE=YES)

put packages to the repository (https://mdbe-ci-repo.mariadb.net/repository/logs/10.4-feb27-01/RPM/rhel_7_gcp/)

install server, galera4 and columnstore from this repo

stop server

sudo columnstore-post-install and sudo postConfigure -qs

start server

try create table x(x1 int, x2 int) engine=columnstore;

Comment by Ben Thompson (Inactive) [ 2020-05-29 ]

Cannot reproduce with latest builds from 1.4 / 10.4-enterprise. Not sure if this is still an issue and was likely with other convergence packaging issues.

Comment by Ben Thompson (Inactive) [ 2020-05-29 ]

Appears to no longer be an issue

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

[MCOL-3682] Unhelpful errors and empty warning upon attempt to create Columnstore table Created: 2019-12-18 Updated: 2021-01-07 Resolved: 2020-05-29