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

Having issues loading data into ColumnStore

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.2
    • Fix Version/s: None
    • Component/s: cpimport
    • Labels:
      None
    • Environment:
      Debian 9

      Description

      Trying to load data, and I'm getting errors about ExeMgr:
      mysql> use ssb;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      mysql> \. /tmp/load.sql
      yuERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
      ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
      ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
      ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
      ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
      ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr.
      ^Z
      [1]+ Stopped mysql -h127.0.0.1 -P3306
      root@debian-c-32-64gib-nyc1-01:~/swanhart-tools/shard-query/bin# bg
      [1]+ mysql -h127.0.0.1 -P3306 &
      root@debian-c-32-64gib-nyc1-01:~/swanhart-tools/shard-query/bin# terror
      Dec 25 22:26:54 debian-c-32-64gib-nyc1-01 controllernode[5161]: 54.284066 |0|0|0| E 29 CAL0000: DBRM: error: SessionManager::getTxnID() failed (network)
      Dec 25 22:27:44 debian-c-32-64gib-nyc1-01 joblist[5161]: 44.424520 |0|0|0| C 05 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp @ 369 Could not get a ExeMgr connection.
      Dec 25 22:27:49 debian-c-32-64gib-nyc1-01 joblist[5161]: 49.438374 |0|0|0| C 05 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp @ 369 Could not get a ExeMgr connection.
      Dec 25 22:27:49 debian-c-32-64gib-nyc1-01 controllernode[5161]: 49.453035 |0|0|0| E 29 CAL0000: DBRM: error: SessionManager::getTxnID() failed (network)
      Dec 25 22:28:39 debian-c-32-64gib-nyc1-01 joblist[5161]: 39.593340 |0|0|0| C 05 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp @ 369 Could not get a ExeMgr connection.
      Dec 25 22:28:44 debian-c-32-64gib-nyc1-01 joblist[5161]: 44.608105 |0|0|0| C 05 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp @ 369 Could not get a ExeMgr connection.
      Dec 25 22:28:44 debian-c-32-64gib-nyc1-01 controllernode[5161]: 44.623095 |0|0|0| E 29 CAL0000: DBRM: error: SessionManager::getTxnID() failed (network)
      Dec 25 22:29:34 debian-c-32-64gib-nyc1-01 joblist[5161]: 34.761710 |0|0|0| C 05 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp @ 369 Could not get a ExeMgr connection.
      Dec 25 22:29:39 debian-c-32-64gib-nyc1-01 joblist[5161]: 39.762232 |0|0|0| C 05 CAL0000: /data/buildbot/bb-worker/debian9/mariadb-columnstore-engine/dbcon/execplan/clientrotator.cpp @ 369 Could not get a ExeMgr connection.
      Dec 25 22:29:39 debian-c-32-64gib-nyc1-01 controllernode[5161]: 39.776533 |0|0|0| E 29 CAL0000: DBRM: error: SessionManager::getTxnID() failed (network)

      table DDL:
      CREATE TABLE IF NOT EXISTS lineorder
      (
      LO_OrderKey bigint not null,
      LO_LineNumber tinyint not null,
      LO_CustKey int not null,
      LO_PartKey int not null,
      LO_SuppKey int not null,
      LO_OrderDateKey int not null,
      LO_OrderPriority varchar(15),
      LO_ShipPriority char(1),
      LO_Quantity tinyint,
      LO_ExtendedPrice decimal,
      LO_OrdTotalPrice decimal,
      LO_Discount decimal,
      LO_Revenue decimal,
      LO_SupplyCost decimal,
      LO_Tax tinyint,
      LO_CommitDateKey int not null,
      LO_ShipMode varchar(10)
      );

      LOAD DATA INFILE '/tmp/lineorder.tbl.1' INTO TABLE lineorder FIELDS TERMINATED BY '|';

      generate the data with http://github.com/greenlion/ssb-dbgen
      ./dbgen -T l -s 160 -C 32 (where 32 is number of cores)

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jswanhart Justin Swanhart (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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