Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4934

Create table error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.6.2
    • Fix Version/s: N/A
    • Component/s: DDLProc
    • Labels:
    • 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

      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?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              cui3093 Kuijun Cui
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.