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

INSERT .. SELECT executed after previous interrupted operation causes ER_INTERNAL_ERROR

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 1.4.2
    • Icebox
    • N/A
    • None

    Description

      drop table if exists t1;
      create table t1 (a int) engine=Columnstore;
      set statement max_statement_time=1 for insert into t1 select seq from seq_1_to_10000000;
      insert into t1 select seq from seq_1_to_2;
      

      MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

      MariaDB [db]> create table t1 (a int) engine=Columnstore;
      Query OK, 0 rows affected (0.632 sec)
       
      MariaDB [db]> set statement max_statement_time=1 for insert into t1 select seq from seq_1_to_10000000;
      ERROR 1969 (70100): Query execution was interrupted (max_statement_time exceeded)
      MariaDB [db]> insert into t1 select seq from seq_1_to_2;
      ERROR 1815 (HY000): Internal error: PM1 : Bulkload Read (thread 0) Failed for Table db.t1.  Terminating this job.
      

      Time interval between the interrupted operation and the next one does not matter, even half an hour later it still returns the error.
      Next identical INSERT works fine.

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            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.