[MCOL-3879] ExeMgr crash on select - SELECT TABLE FROM -- WHERE scan_code = 'DUP' and id_datasource <> 1002; Created: 2020-03-11  Updated: 2023-12-28  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.2.5
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: David Hill (Inactive) Assignee: Leonid Fedorov
Resolution: Fixed Votes: 0
Labels: None
Environment:

centos 7 single server

Issue Links:
Blocks
is blocked by MDEV-21504 Collation: Create shared library for ... Closed
Issue split
split to MCOL-4758 Cluster crashes when LONGTEXT or LONG... Closed
Relates
relates to MCOL-643 support longer then 8m rows in order by Closed
Sprint: 2020-5, 2020-6, 2020-7, 2021-4, 2021-5, 2021-6, 2021-7

 Description   

Reported by customer and reproduced inhouse.

run select statement and ExeMgr crashes.

SELECT * FROM dpdcoredata.ttevents_are WHERE scan_code = 'DUP' and id_datasource <> 1002;

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fa73e3ff700 (LWP 5787)]
0x00007fa7587e36dd in __memset_sse2 () from /lib64/libc.so.6
(gdb) bt
#0 0x00007fa7587e36dd in __memset_sse2 () from /lib64/libc.so.6
#1 0x00007fa75de14a88 in memset (__len=<optimized out>, __ch=0, __dest=<optimized out>) at /usr/include/bits/string3.h:84
#2 rowgroup::Row::initToNull (this=this@entry=0x7fa73e3fe220) at /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/utils/rowgroup/rowgroup.cpp:753
#3 0x00007fa75e9f42af in joblist::TupleBPS::receiveMultiPrimitiveMessages (this=0x7fa72f0fb000, threadID=0)
at /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/dbcon/joblist/tuple-bps.cpp:1968
#4 0x00007fa75e9faab9 in operator() (this=0x7fa73fc4cb60) at /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/dbcon/joblist/tuple-bps.cpp:142
#5 boost::detail::function::void_function_obj_invoker0<joblist::TupleBPSAggregators, void>::invoke (function_obj_ptr=...) at /usr/include/boost/function/function_template.hpp:153
#6 0x00007fa759569af8 in operator() (this=0x7fa73fc4cb58) at /usr/include/boost/function/function_template.hpp:767
#7 threadpool::ThreadPool::beginThread (this=0x7fa75eccd200 <joblist::JobStep::jobstepThreadPool>)
at /data/buildbot/bb-worker/centos7/mariadb-columnstore-engine/utils/threadpool/threadpool.cpp:391
#8 0x00007fa75b0d927a in thread_proxy () from /lib64/libboost_thread-mt.so.1.53.0
#9 0x00007fa75aeb7e25 in start_thread () from /lib64/libpthread.so.0
#10 0x00007fa758852bad in clone () from /lib64/libc.so.6
(gdb)

create table will be in protected comment.

 Comments   
Comment by Todd Stoffel (Inactive) [ 2020-03-11 ]

CREATE TABLE ttevents_are (
id_ttevents bigint(20) DEFAULT NULL,
num_order int(11) DEFAULT NULL,
parcel_number varchar(14) DEFAULT NULL,
status_type varchar(5) DEFAULT NULL,
origin_parcel_number varchar(32) DEFAULT NULL,
service_code int(11) DEFAULT NULL,
as_code varchar(3) DEFAULT NULL,
d_zip_code varchar(9) DEFAULT NULL,
d_country_code int(11) DEFAULT NULL,
scan_code varchar(10) DEFAULT NULL,
reason_code varchar(3) DEFAULT NULL,
reason_code2 varchar(3) DEFAULT NULL,
reason_code3 varchar(3) DEFAULT NULL,
depot varchar(7) DEFAULT NULL,
agent_location_code varchar(7) DEFAULT NULL,
agent_location_code_type varchar(5) DEFAULT NULL,
agent_parcel_number varchar(32) DEFAULT NULL,
country int(11) DEFAULT NULL,
city varchar(32) DEFAULT NULL,
status_date_time datetime DEFAULT NULL,
time_zone varchar(5) DEFAULT NULL,
mem_date_time datetime DEFAULT NULL,
d_depot varchar(7) DEFAULT NULL,
delivery_tour varchar(5) DEFAULT NULL,
measured_weight int(11) DEFAULT NULL,
length_cm int(11) DEFAULT NULL,
height_cm int(11) DEFAULT NULL,
width_cm int(11) DEFAULT NULL,
parcel_ref varchar(35) DEFAULT NULL,
parcel_ref2 varchar(35) DEFAULT NULL,
pod_image_ref varchar(256) DEFAULT NULL,
r_name varchar(35) DEFAULT NULL,
r_street varchar(100) DEFAULT NULL,
r_prop_number varchar(8) DEFAULT NULL,
r_zipcode varchar(9) DEFAULT NULL,
r_city varchar(32) DEFAULT NULL,
trdpr_name varchar(35) DEFAULT NULL,
trdpr_street varchar(100) DEFAULT NULL,
trdp_propnumber varchar(8) DEFAULT NULL,
trdp_zipcode varchar(9) DEFAULT NULL,
trdp_city varchar(32) DEFAULT NULL,
area int(11) DEFAULT NULL,
stop int(11) DEFAULT NULL,
container_info1 int(11) DEFAULT NULL,
container_info2 varchar(200) DEFAULT NULL,
shipment_ref varchar(35) DEFAULT NULL,
supplier_ref varchar(35) DEFAULT NULL,
container_ref varchar(14) DEFAULT NULL,
container_type varchar(2) DEFAULT NULL,
actor_id varchar(10) DEFAULT NULL,
operativer_id varchar(10) DEFAULT NULL,
pickup_order_number varchar(20) DEFAULT NULL,
gps_lat double DEFAULT NULL,
gps_long double DEFAULT NULL,
return_parcel_number varchar(14) DEFAULT NULL,
comp_info1 varchar(1024) DEFAULT NULL,
comp_info2 varchar(1024) DEFAULT NULL,
status_date_time_utc datetime DEFAULT NULL,
has_parcel_bag smallint(6) DEFAULT NULL,
id_datasource bigint(20) DEFAULT NULL,
id_ttevents_current_db bigint(20) DEFAULT NULL,
id_databases int(11) DEFAULT NULL,
partition_timestamp datetime DEFAULT NULL,
zz_egk_num varchar(32) DEFAULT NULL,
zz_vgk_num varchar(10) DEFAULT NULL,
zz_wb_num varchar(10) DEFAULT NULL,
zz_stop_index int(11) DEFAULT NULL,
zz_gpstime datetime DEFAULT NULL,
zz_version varchar(40) DEFAULT NULL,
zz_serialno varchar(64) DEFAULT NULL,
zz_original_statustype varchar(5) DEFAULT NULL,
zz_original_scancode_alpha varchar(10) DEFAULT NULL,
zz_term_id varchar(20) DEFAULT NULL,
zz_geo_source varchar(32) DEFAULT NULL,
zz_c_driver varchar(50) DEFAULT NULL,
guid char(36) DEFAULT NULL,
container_info_json text DEFAULT NULL,
comp_info_json text DEFAULT NULL,
insert_date_time datetime DEFAULT NULL,
misc_json text DEFAULT NULL,
sequence_handler_timing datetime DEFAULT NULL,
id_fileinformation bigint(20) DEFAULT NULL,
zz_original_reasoncode1 varchar(3) DEFAULT NULL,
zz_original_reasoncode2 varchar(3) DEFAULT NULL,
zz_original_reasoncode3 varchar(3) DEFAULT NULL
)
ENGINE = COLUMNSTORE;

SELECT * FROM ttevents_are WHERE scan_code = 'DUP' and id_datasource <> 1002;

Comment by David Hall (Inactive) [ 2021-04-21 ]

A simpler example:

create table t1 (
 
    id bigint(20) DEFAULT NULL,
 
    v1 varchar(32) DEFAULT NULL,
 
    v2 varchar(100) DEFAULT NULL,
 
    json1 longtext DEFAULT NULL,
 
    json2 longtext DEFAULT NULL,
 
    json3 longtext DEFAULT NULL)
 
    ENGINE = COLUMNSTORE
 
    DEFAULT CHARSET utf8mb4;
 
insert into t1 (id,  v1,  v2) values (1, "DUP", "This is a test of a bug 1");
 
insert into t1 (id,  v1,  v2) values (2, "REF", "This is a test of a bug 2");
 
insert into t1 (id,  v1,  v2) values (1002, "REF", "This is a test of a bug 3");
 
insert into t1 (id,  v1,  v2) values (1002, "DUP", "This is a test of a bug 4");
 
insert into t1 (id,  v1,  v2) values (5, "dup", "This is a test of a bug 5");
 
select * from t1 where v1 = "DUP" and id <> 1002;
 
| id   | v1   | v2                        | json1 | json2 | json3 |
 
+------+------+---------------------------+-------+-------+-------+
 
|    1 | DUP  | This is a test of a bug 1 | NULL  | NULL  | NULL  |
 
|    5 | dup  | This is a test of a bug 5 | NULL  | NULL  | NULL  |
 
+------+------+---------------------------+-------+-------+-------+

Comment by David Hall (Inactive) [ 2021-04-21 ]

This is a 6.1.1 fix, so it can wait until after 5.6.1 is final.

Comment by David Hall (Inactive) [ 2022-03-04 ]

David – check to see if the patch was merged.

Comment by Leonid Fedorov [ 2023-10-27 ]

The fix was introduced with MCOL-271 with 23.10.0 version of Columnstore

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