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

INSERT..SELECT Fails "Error Code: 1815. Internal error"

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.1.1
    • Icebox
    • N/A
    • None

    Description

      use test;

      create table test1_cs (id int,cName varchar(50)) engine=columnstore;

      – This statement works as expected
      insert into test1_cs(id,cName) values(1,'Testing1');

      – Thist statement does not work.
      insert into test1_cs (id,cName)
      select 2,'Testing2';

      – Results in following error
      /*
      Error Code: 1815. Internal error: load failed. The detailed error information is listed in err.log.
      */

      Is this a bug or do I need to enable some flag?

      We are not able to transfer data from one columnstore table to another and worst yet from staging innodb table to columnstore table. Currently we have written a work around to use CPIMPORT tool. This is certainly slowing down our pipeline and testing.

      Here is getsoftwareinfo
      Tue Jan 30 22:05:04 2018

      Name : mariadb-columnstore-platform Relocations: (not relocatable)
      Version : 1.1.1 Vendor: MariaDB Corporation Ab
      Release : 1 Build Date: Thu 02 Nov 2017 11:28:34 PM UTC
      Install Date: Tue 14 Nov 2017 11:18:21 PM UTC Build Host: ip-172-30-0-72.us-west-2.compute.internal
      Group : Applications/Databases Source RPM: mariadb-columnstore-platform-1.1.1-1.src.rpm
      Size : 10817092 License: Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
      Signature : (none)
      URL : http://mariadb.org
      Summary : MariaDB-Columnstore software

      Attachments

        Activity

          People

            Unassigned Unassigned
            avahora Aziz Vahora
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.