[MCOL-4934] Create table error Created: 2021-11-29  Updated: 2021-12-08  Resolved: 2021-12-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 5.6.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Kuijun Cui Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: Columnstore
Environment:

LSB Version: :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description: CentOS Linux release 7.6.1810 (Core)
Release: 7.6.1810
Codename: Core

Attachments: File mariadb.tar.gz    
Issue Links:
Relates
relates to MCOL-4793 Make Columnstore installation relocat... Open

 Description   

when create table, error 1815 comes, detail as below.

MariaDB [inventory]> CREATE TABLE inventory.products (    product_name varchar(11) NOT NULL DEFAULT '',    supplier varchar(128) NOT NULL DEFAULT '',    quantity varchar(128) NOT NULL DEFAULT '',    unit_cost varchar(128) NOT NULL DEFAULT '' ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
 
ERROR 1815 (HY000): Internal error: Lost connection to DDLProc

The error log as below:

2021-11-29T12:28:22.939549+09:00 m5-rnd-db001 ddlpackageproc[112037]: 22.939101 |8|2|0| D 23 CAL0041: Start SQL statement: CREATE TABLE inventory.products (    product_name varchar(11) NOT NULL DEFAULT '',    supplier varchar(128) NOT NULL DEFAULT '',    quantity varchar(128) NOT NULL DEFAULT '',    unit_cost varchar(128) NOT NULL DEFAULT '' ) ENGINE=Columnstore DEFAULT CHARSET=utf8;|inventory|
 
2021-11-29T12:28:22.946615+09:00 m5-rnd-db001 IDBFile[124710]: 22.946560 |0|0|0| D 35 CAL0002: Failed to open file: /opt/csdata/columnstore/data1/000.dir/000.dir/003.dir/243.dir/000.dir/FILE000.cdf, exception: unable to open Buffered file  
2021-11-29T12:28:22.946946+09:00 m5-rnd-db001 writeengineserver[124710]: 22.946618 |0|0|0| C 32 CAL0006: FileOp::openFile(): fopen(/opt/csdata/columnstore/data1/000.dir/000.dir/003.dir/243.dir/000.dir/FILE000.cdf, r+b): errno = 5: Input/output error
 
2021-11-29T12:28:22.947237+09:00 m5-rnd-db001 writeengineserver[124710]: 22.946642 |0|0|0| E 32 CAL0006: FileOp::openFile(): fopen(/opt/csdata/columnstore/data1/000.dir/000.dir/003.dir/243.dir/000.dir/FILE000.cdf, r+b): errno = 5: Input/output error
 
2021-11-29T12:28:22.947463+09:00 m5-rnd-db001 dmlpackageproc[124710]: 22.946672 |0|0|0| E 21 CAL0001: Error opening file  oid: 1011 with path /opt/csdata/columnstore/data1/000.dir/000.dir/003.dir/243.dir/000.dir/FILE000.cdf

The path /opt/csdata/columnstore I ever changed, but I had reinstalled all rpm packege, but still exists, could you show me the way to correct it?

 Comments   
Comment by Roman [ 2021-12-06 ]

Hey.

MCS now is not relocatable so you need to use certain default data paths, namely configs must be in /etc/columnstore and data in /var/lib/columnstore.t(Plz see the linked issue).
JFYI he data itself(/var/lib/columnstore/dataX(where X in 1-N) can be wherever you want using symlinks. However from what I see in this particular case you hit the ownership issue. Can you double check who owns the files MCS fails to open?

Comment by Kuijun Cui [ 2021-12-07 ]

Regarding the path /opt/csdata/columnstore/data1/000.dir/000.dir/003.dir/243.dir/000.dir/FILE000.cdf in the log I did not declare it in configeration file, and not symbol link from it. Just think seem that some place cache the configuration although I restart all steps.

Comment by Kuijun Cui [ 2021-12-08 ]

After changing to a new host, issue disppeared, please close it.
Thanks for Roman's support.

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