Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
1.0.0
-
Ubuntu 20.04 Server
-
2021-4, 2021-5, 2021-6, 2021-7
Description
Hello everybody, first time reporting a (possible) bug.
So thank you for your patience in case I do something wrong concerning report process.
I installed Ubuntu 20.04 freshly an installed mariadb 10.5.4 along with ColumnStore aiming to compare performance to standard InnoDB Instance.
I was able to successfully fill some ColumnStore tables with gigabytes of data.
However for three tables i run into an error which seems to be a server crash. See attached Server log.
One of the SQL Queries leading to the error is:
load data infile '/data/import/delta_180_result_op_rule.csv' |
into table result_op_rule
|
character set utf8mb4
|
fields terminated by ',' optionally enclosed by '"' |
lines terminated by '\r\n' |
(point_value_prep_id,op_state_group,op_state,op_rule,@var_status) |
set status = substring(@var_status, 6, 1); |
When the csv file is needed, please let me know.
This is the defaults
system-admin@vm-mnt-cs-test:/var/lib/mysql$ my_print_defaults --mysqld |
--socket=/run/mysqld/mysqld.sock
|
--innodb_buffer_pool_size=5G
|
--user=mysql
|
--pid-file=/run/mysqld/mysqld.pid
|
--basedir=/usr
|
--datadir=/var/lib/mysql
|
--tmpdir=/tmp
|
--lc-messages-dir=/usr/share/mysql
|
--lc-messages=en_US
|
--skip-external-locking
|
--bind-address=0.0.0.0 |
--log_error=/var/log/mysql/error.log
|
--expire_logs_days=10 |
--character-set-server=utf8mb4
|
--collation-server=utf8mb4_general_ci
|
--plugin-load-add=ha_columnstore.so
|
--plugin-maturity=beta
|
Best regards
Alex Schabel
Attachments
Issue Links
- relates to
-
-
- Closed
-