Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
1.4.4
-
None
Description
Inserting one line of data with load data causes mariadb server to crash with the below stacktrace.
stack_bottom = 0x7ff7840a3c38 thread_stack 0x49000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c4492bd3ee]
|
/usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55c448d3daef]
|
sigaction.c:0(__restore_rt)[0x7ff7c4b99630]
|
:0(__memcpy_ssse3_back)[0x7ff7c2d1ea85]
|
/lib64/libstdc++.so.6(_ZNSs15_M_replace_safeEmmPKcm+0x3b)[0x7ff7c33581bb]
|
/usr/lib64/mysql/plugin/ha_columnstore.so(_Z28ha_mcs_impl_write_batch_row_PKhP5TABLERN11cal_impl_if19cal_connection_infoE+0x1125)[0x7ff7842683d5]
|
/usr/lib64/mysql/plugin/ha_columnstore.so(_Z21ha_mcs_impl_write_rowPKhP5TABLEm+0x2cc)[0x7ff78423f8cc]
|
/usr/lib64/mysql/plugin/ha_columnstore.so(_ZN6ha_mcs9write_rowEPKh+0x1f)[0x7ff78423a7cf]
|
/usr/sbin/mysqld(_ZN7handler12ha_write_rowEPKh+0x16d)[0x55c448d4903d]
|
/usr/sbin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x69)[0x55c448afa949]
|
/usr/sbin/mysqld(_Z10mysql_loadP3THDPK12sql_exchangeP10TABLE_LISTR4ListI4ItemES9_S9_15enum_duplicatesbb+0x1ba0)[0x55c448b23b50]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x59a6)[0x55c448b324c6]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x36d)[0x55c448b3605d]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x2209)[0x55c448b38a39]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x109)[0x55c448b39e99]
|
/usr/sbin/mysqld(_Z11tp_callbackP13TP_connection+0xd2)[0x55c448d0f902]
|
/usr/sbin/mysqld(+0xa5b3d0)[0x55c448ecc3d0]
|
/usr/sbin/mysqld(+0xdfd8ed)[0x55c44926e8ed]
|
pthread_create.c:0(start_thread)[0x7ff7c4b91ea5]
|
/lib64/libc.so.6(clone+0x6d)[0x7ff7c2cc88dd]
|
Command used:
LOAD DATA LOCAL INFILE 'Rick2.txt' INTO TABLE mytable FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY '#' LINES TERMINATED BY ''
|
Table structure:
CREATE TABLE `mytable` (
|
`Id` bigint(20) NOT NULL,
|
`redacted` bigint(20) unsigned DEFAULT NULL,
|
`redacted` int(11) NOT NULL,
|
`redacted` int(11) DEFAULT NULL,
|
`redacted` int(11) DEFAULT NULL,
|
`redacted` bigint(20) DEFAULT NULL,
|
`redacted` int(11) NOT NULL,
|
`redacted` bigint(20) NOT NULL,
|
`redacted` bigint(20) NOT NULL,
|
`redacted` int(4) unsigned DEFAULT NULL,
|
`redacted` int(4) unsigned DEFAULT NULL,
|
`redacted` int(4) unsigned DEFAULT NULL,
|
`redacted` int(4) unsigned DEFAULT NULL,
|
`redacted` int(4) unsigned DEFAULT NULL,
|
`redacted` varchar(63) DEFAULT NULL,
|
`redacted` decimal(18,8) NOT NULL,
|
`redacted` decimal(18,8) NOT NULL,
|
`redacted` tinyint(1) NOT NULL,
|
`redacted` int(11) NOT NULL DEFAULT 0,
|
`redacted` decimal(18,8) NOT NULL DEFAULT 0.00000000,
|
`redacted` decimal(18,8) NOT NULL,
|
`redacted` int(11) DEFAULT NULL,
|
`redacted` int(11) DEFAULT NULL,
|
`redacted` varchar(255) DEFAULT NULL,
|
`redacted` decimal(18,8) DEFAULT 0.00000000,
|
`redacted` decimal(18,8) DEFAULT NULL,
|
`redacted` decimal(18,8) DEFAULT NULL,
|
`redacted` decimal(5,2) DEFAULT NULL,
|
`redacted` decimal(5,2) DEFAULT NULL,
|
`redacted` decimal(8,4) DEFAULT NULL,
|
`redacted` decimal(5,2) DEFAULT NULL,
|
`redacted` decimal(8,2) DEFAULT NULL,
|
`redacted` decimal(6,4) DEFAULT NULL,
|
`redacted` int(3) DEFAULT NULL,
|
`redacted` int(11) NOT NULL,
|
`redacted` text DEFAULT NULL,
|
`redacted` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
|
`redacted` text DEFAULT NULL,
|
`redacted` text DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8
|
Data row that makes it crash:
3871250004#955385077888386499#131083#249881#171605#3826160523#5003#1577836919000#1577836919000#1#1#2020#0#3#"5141360283FC07BF"#40.54220581#-3.45858359#1#0#0.00001526#1154.44339348#NULL#NULL#""#0.00000000#NULL#NULL#NULL#NULL#NULL#NULL#NULL#NULL#NULL#37#"[]"#"2020-01-01 00:01:59"#NULL#01000000E066454440000000C02DAB0BC0D83B685E6F0100000000000000000000000000E066454440000000C02DAB0BC0604F685E6F0100000000000000000000000000E066454440000000C02DAB0BC0E862685E6F0100000000000000000000000000E066454440000000E02DAB0BC07076685E6F01000000000000000000000000000067454440000000E02DAB0BC0F889685E6F01000000000000000000000000000067454440000000E02DAB0BC0809D685E6F01000000000000000000000000000067454440000000E02DAB0BC008B1685E6F0100000000000000000000
|
The customer is unable to load data from application because of this bug, hence a blocker. cpimport can't be used because requires data to be on CS server.
