[MCOL-3697] Bulk INSERT into table without compression fails with ER_INTERNAL_ERROR Created: 2019-12-26  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.4.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None

Attachments: File columnstoreSupportReport.columnstore-1.tar.gz    

 Description   

drop table if exists t2;
create table t2 (a int) engine=Columnstore comment 'compression=0';
insert into t2 select 1 from seq_1_to_300000;
alter table t2 add b int;
insert into t2 select 2, 3 from seq_1_to_300000;

MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

MariaDB [db]> insert into t2 select 2, 3 from seq_1_to_300000;
ERROR 1815 (HY000): Internal error: PM1 : Bulkload Parse (thread 0) Failed for Table db.t2 during parse completion.  Terminating this job.

Support report is attached.



 Comments   
Comment by Roman [ 2020-07-13 ]

Can't reproduce with 10.5.4, will test with 10.4.

MariaDB [test]>  drop table if exists t2;
Query OK, 0 rows affected (0.335 sec)
 
MariaDB [test]> create table t2 (a int) engine=Columnstore comment 'compression=0';
Query OK, 0 rows affected (0.463 sec)
 
MariaDB [test]> insert into t2 select 1 from seq_1_to_300000;
Query OK, 300000 rows affected (1.213 sec)
Records: 300000  Duplicates: 0  Warnings: 0
 
MariaDB [test]> alter table t2 add b int;
Query OK, 0 rows affected (0.512 sec)              
Records: 0  Duplicates: 0  Warnings: 0
 
MariaDB [test]> insert into t2 select 2, 3 from seq_1_to_300000;
Query OK, 300000 rows affected (1.217 sec)
Records: 300000  Duplicates: 0  Warnings: 0

Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was opened prior to convergence with the server. It may have been rendered obsolete. If this issue still exists in a modern version, please open a new request.

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