[MDEV-20100] MariaDB 13.3.9 Crash "[ERROR] mysqld got signal 11 ;" - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3.9, 10.3.15
Fix Version/s: 10.3.26, 10.4.16, 10.5.7, 10.6.0
Component/s: Partitioning, Storage Engine - InnoDB, Storage Engine - Spider
Labels:
- crash
Environment:
CentOS 7

Description

We are using MariaDB 10.3.9.
We use spider on the Front side and InnoDB on the Back side.
In addition, the Front side has a partition table, and connect to a plurality of tables on the Back side.

In our system, with multiple sessions from the WebApp to the front side, the first query will always succeed if the select query is executed from one of the sessions.
MariaDB crashed when I ran a query with more partitions than the first one.

Example of the first query issued:
SELECT cellno, id, concat(date_format(FROM_UNIXTIME(truncate(time, -3) / 1000), '%Y/%m/%d %H:%i:%s'), '.', right(concat('000', cast(time % 1000 AS CHAR)), 3)) as time_disp, (CASE WHEN seqno = '0' THEN 'Default' WHEN seqno = '1' THEN 'Setup1' WHEN seqno = '2' THEN 'Setup2' WHEN seqno = '3' THEN 'Setup3' WHEN '4' <= seqno AND seqno <= '103' THEN concat('Seq.', seqno - 3) WHEN seqno = '255' THEN 'Seq ALL' ELSE 'unknown' END) as seqno_str, (CASE WHEN seqno <= '3' THEN seqno WHEN seqno = '255' THEN 4 ELSE seqno + 1 END) as seqno_order FROM test PARTITION (pn01,pn02) WHERE prtcltyp = 4294967295 ORDER BY seqno_order, pn

Example of query that MariadB crash:
SELECT cellno, id, concat(date_format(FROM_UNIXTIME(truncate(time, -3) / 1000), '%Y/%m/%d %H:%i:%s'), '.', right(concat('000', cast(time % 1000 AS CHAR)), 3)) as time_disp, (CASE WHEN seqno = '0' THEN 'Default' WHEN seqno = '1' THEN 'Setup1' WHEN seqno = '2' THEN 'Setup2' WHEN seqno = '3' THEN 'Setup3' WHEN '4' <= seqno AND seqno <= '103' THEN concat('Seq.', seqno - 3) WHEN seqno = '255' THEN 'Seq ALL' ELSE 'unknown' END) as seqno_str, (CASE WHEN seqno <= '3' THEN seqno WHEN seqno = '255' THEN 4 ELSE seqno + 1 END) as seqno_order FROM test PARTITION (pn01,pn02,pn03) WHERE prtcltyp = 4294967295 ORDER BY seqno_order, pn

Crash message on MariaDB 10.3.9:

Jul 17 10:44:15 localhost mysqld: 190717 10:44:15 [ERROR] mysqld got signal 11 ;

Jul 17 10:44:15 localhost mysqld: This could be because you hit a bug. It is also possible that this binary

Jul 17 10:44:15 localhost mysqld: or one of the libraries it was linked against is corrupt, improperly built,

Jul 17 10:44:15 localhost mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.

Jul 17 10:44:15 localhost mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Jul 17 10:44:15 localhost mysqld: We will try our best to scrape up some info that will hopefully help

Jul 17 10:44:15 localhost mysqld: diagnose the problem, but since we have already crashed,

Jul 17 10:44:15 localhost mysqld: something is definitely wrong and this may fail.

Jul 17 10:44:15 localhost mysqld: Server version: 10.3.9-MariaDB

Jul 17 10:44:15 localhost mysqld: key_buffer_size=134217728

Jul 17 10:44:15 localhost mysqld: read_buffer_size=131072

Jul 17 10:44:15 localhost mysqld: max_used_connections=3

Jul 17 10:44:15 localhost mysqld: max_threads=2050

Jul 17 10:44:15 localhost mysqld: thread_count=29

Jul 17 10:44:15 localhost mysqld: It is possible that mysqld could use up to

Jul 17 10:44:15 localhost mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4637654 K  bytes of memory

Jul 17 10:44:15 localhost mysqld: Hope that's ok; if not, decrease some variables in the equation.

Jul 17 10:44:15 localhost mysqld: Thread pointer: 0x7f808c0009a8

Jul 17 10:44:15 localhost mysqld: Attempting backtrace. You can use the following information to find out

Jul 17 10:44:15 localhost mysqld: where mysqld died. If you see no messages after this, something went

Jul 17 10:44:15 localhost mysqld: terribly wrong...

Jul 17 10:44:15 localhost mysqld: stack_bottom = 0x7f87a804dd30 thread_stack 0x49000

Jul 17 10:44:15 localhost mysqld: mysys/stacktrace.c:270(my_print_stacktrace)[0x7f87bfeb566e]

Jul 17 10:44:15 localhost mysqld: sql/signal_handler.cc:168(handle_fatal_signal)[0x7f87bf945f37]

Jul 17 10:44:15 localhost mysqld: sigaction.c:0(__restore_rt)[0x7f87bed956d0]

Jul 17 10:44:15 localhost mysqld: spider/spd_db_conn.cc:8541(spider_db_print_item_type(Item*, Field*, ha_spider*, spider_string*, char const*, unsigned int, unsigned int, bool, spider_fields*))[0x7f87b12980ca]

Jul 17 10:44:15 localhost mysqld: spider/spd_db_mysql.cc:8454(spider_mysql_handler::append_condition(spider_string*, char const*, unsigned int, bool, unsigned long))[0x7f87b12fd887]

Jul 17 10:44:15 localhost mysqld: spider/ha_spider.cc:14684(ha_spider::append_condition_sql_part(char const*, unsigned int, unsigned long, bool))[0x7f87b12df1b8]

Jul 17 10:44:15 localhost mysqld: spider/spd_db_conn.cc:9352(spider_db_append_condition(ha_spider*, char const*, unsigned int, bool))[0x7f87b1298a9b]

Jul 17 10:44:15 localhost mysqld: spider/spd_table.cc:8852(spider_check_direct_order_limit(ha_spider*))[0x7f87b12badca]

Jul 17 10:44:15 localhost mysqld: spider/ha_spider.cc:12732(ha_spider::check_direct_order_limit())[0x7f87b12d7cc5]

Jul 17 10:44:15 localhost mysqld: spider/ha_spider.cc:7506(ha_spider::rnd_next_internal(unsigned char*))[0x7f87b12e1b44]

Jul 17 10:44:15 localhost mysqld: spider/ha_spider.cc:7832(ha_spider::pre_rnd_next(bool))[0x7f87b12e23ba]

Jul 17 10:44:15 localhost mysqld: sql/ha_partition.cc:7222(ha_partition::handle_pre_scan(bool, bool))[0x7f87bfe85fac]

Jul 17 10:44:15 localhost mysqld: sql/ha_partition.cc:5050(ha_partition::rnd_next(unsigned char*))[0x7f87bfe88649]

Jul 17 10:44:15 localhost mysqld: sql/handler.cc:2764(handler::ha_rnd_next(unsigned char*))[0x7f87bf94ac3f]

Jul 17 10:44:15 localhost mysqld: sql/filesort.cc:778(filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long))[0x7f87bf944dbf]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:22426(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0x7f87bf7b88b7]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:20256(st_join_table::sort_table())[0x7f87bf7b8bd3]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:20195(join_init_read_record(st_join_table*))[0x7f87bf7b8c3d]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:19281(sub_select(JOIN*, st_join_table*, bool))[0x7f87bf7a8689]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:18824(JOIN::exec_inner())[0x7f87bf7c9d42]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:3823(JOIN::exec())[0x7f87bf7c9f93]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:4229(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x7f87bf7ca0ea]

Jul 17 10:44:15 localhost mysqld: sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x7f87bf7cabfc]

Jul 17 10:44:15 localhost mysqld: sql/sql_parse.cc:6547(execute_sqlcom_select(THD*, TABLE_LIST*))[0x7f87bf68019f]

Jul 17 10:44:15 localhost mysqld: sql/sql_parse.cc:3768(mysql_execute_command(THD*))[0x7f87bf776fbd]

Jul 17 10:44:15 localhost mysqld: sql/sql_parse.cc:8089(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7f87bf7797cb]

Jul 17 10:44:15 localhost mysqld: sql/sql_parse.cc:1850(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7f87bf77c315]

Jul 17 10:44:15 localhost mysqld: sql/sql_parse.cc:1397(do_command(THD*))[0x7f87bf77d17e]

Jul 17 10:44:15 localhost mysqld: sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x7f87bf84d50a]

Jul 17 10:44:15 localhost mysqld: sql/sql_connect.cc:1310(handle_one_connection)[0x7f87bf84d62d]

Jul 17 10:44:15 localhost mysqld: pthread_create.c:0(start_thread)[0x7f87bed8de25]

Jul 17 10:44:15 localhost mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f87bd362bad]

Jul 17 10:44:15 localhost mysqld: Trying to get some variables.

Jul 17 10:44:15 localhost mysqld: Some pointers may be invalid and cause the dump to abort.

Jul 17 10:44:15 localhost mysqld: Query (0x7f808c0136e0): SELECT cellno, id, concat(date_format(FROM_UNIXTIME(truncate(time, -3) / 1000), '%Y/%m/%d %H:%i:%s'), '.', right(concat('000', cast(time % 1000 AS CHAR)), 3)) as time_disp, (CASE WHEN seqno = '0' THEN 'Default' WHEN seqno = '1' THEN 'Setup1' WHEN seqno = '2' THEN 'Setup2' WHEN seqno = '3' THEN 'Setup3' WHEN '4' <= seqno AND seqno <= '103' THEN concat('Seq.', seqno - 3) WHEN seqno = '255' THEN 'Seq ALL' ELSE 'unknown' END) as seqno_str, (CASE WHEN seqno <= '3' THEN seqno WHEN seqno = '255' THEN 4 ELSE seqno + 1 END) as seqno_order FROM test PARTITION (pn01,pn02,pn03) WHERE prtcltyp = 4294967295 ORDER BY seqno_order, pn

Jul 17 10:44:15 localhost mysqld: Connection ID (thread ID): 68

Jul 17 10:44:15 localhost mysqld: Status: NOT_KILLED

Jul 17 10:44:15 localhost mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on

Jul 17 10:44:15 localhost mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

Jul 17 10:44:15 localhost mysqld: information that should help you find out what is causing the crash.

Jul 17 10:44:16 localhost systemd: mariadb.service: main process exited, code=killed, status=11/SEGV

Jul 17 10:44:16 localhost systemd: Unit mariadb.service entered failed state.

Jul 17 10:44:16 localhost systemd: mariadb.service failed.

Jul 17 10:44:46 localhost systemd: mariadb.service holdoff time over, scheduling restart.

Jul 17 10:44:46 localhost systemd: Starting MariaDB 10.3.9 database server...

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] /usr/sbin/mysqld (mysqld 10.3.9-MariaDB) starting as process 7091 ...

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Warning] Could not increase number of max_open_files to more than 65536 (request: 264223)

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Warning] Changed limits: max_open_files: 65536  max_connections: 2048 (was 2048)  table_cache: 31729 (was 131072)

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Using Linux native AIO

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Uses event mutexes

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.7

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Number of pools: 1

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Using SSE2 crc32 instructions

Jul 17 10:44:46 localhost mysqld: 2019-07-17 10:44:46 0 [Note] InnoDB: Initializing buffer pool, total size = 24G, instances = 8, chunk size = 128M

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Completed initialization of buffer pool

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=22142516

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Waiting for purge to start

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: 10.3.9 started; log sequence number 22142525; transaction id 9717

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/data/mariadb/ib_buffer_pool

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] RocksDB: 2 column families found

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] InnoDB: Buffer pool(s) load completed at 190717 10:44:47

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note] RocksDB: Column Families at start:

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note]   cf=default

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note]     write_buffer_size=67108864

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note]     target_file_size_base=67108864

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note]   cf=__system__

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note]     write_buffer_size=67108864

Jul 17 10:44:47 localhost mysqld: 2019-07-17 10:44:47 0 [Note]     target_file_size_base=67108864

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] RocksDB: Table_store: loaded DDL data for 0 tables

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] MyRocks storage engine plugin has been successfully initialized.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Plugin 'FEEDBACK' is disabled.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Recovering after a crash using tc.log

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Starting crash recovery...

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Crash recovery finished.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Server socket created on IP: '::'.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Warning] 'proxies_priv' entry '@% root@localhost.localdomain' ignored in --skip-name-resolve mode.

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Reading of all Master_info entries succeded

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] Added new Master_info '' to hash table

Jul 17 10:44:48 localhost mysqld: 2019-07-17 10:44:48 0 [Note] /usr/sbin/mysqld: ready for connections.

Jul 17 10:44:48 localhost mysqld: Version: '10.3.9-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

Jul 17 10:44:48 localhost systemd: Started MariaDB 10.3.9 database server.

The version of MariaDB was changed to MariaDB 10.3.15 just in case, but it happened with MariaDB 10.3.15.

Crash message on MariaDB 10.3.15:

Jul 19 10:07:35 localhost mysqld: 190719 10:07:35 [ERROR] mysqld got signal 11 ;

Jul 19 10:07:35 localhost mysqld: This could be because you hit a bug. It is also possible that this binary

Jul 19 10:07:35 localhost mysqld: or one of the libraries it was linked against is corrupt, improperly built,

Jul 19 10:07:35 localhost mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.

Jul 19 10:07:35 localhost mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Jul 19 10:07:35 localhost mysqld: We will try our best to scrape up some info that will hopefully help

Jul 19 10:07:35 localhost mysqld: diagnose the problem, but since we have already crashed,

Jul 19 10:07:35 localhost mysqld: something is definitely wrong and this may fail.

Jul 19 10:07:35 localhost mysqld: Server version: 10.3.15-MariaDB

Jul 19 10:07:35 localhost mysqld: key_buffer_size=134217728

Jul 19 10:07:35 localhost mysqld: read_buffer_size=131072

Jul 19 10:07:35 localhost mysqld: max_used_connections=2

Jul 19 10:07:35 localhost mysqld: max_threads=502

Jul 19 10:07:35 localhost mysqld: thread_count=23

Jul 19 10:07:35 localhost mysqld: It is possible that mysqld could use up to

Jul 19 10:07:35 localhost mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1234696 K  bytes of memory

Jul 19 10:07:35 localhost mysqld: Hope that's ok; if not, decrease some variables in the equation.

Jul 19 10:07:35 localhost mysqld: Thread pointer: 0x7fa0e40009a8

Jul 19 10:07:35 localhost mysqld: Attempting backtrace. You can use the following information to find out

Jul 19 10:07:35 localhost mysqld: where mysqld died. If you see no messages after this, something went

Jul 19 10:07:35 localhost mysqld: terribly wrong...

Jul 19 10:07:35 localhost mysqld: stack_bottom = 0x7fa1641cad30 thread_stack 0x49000

Jul 19 10:07:35 localhost mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fa18c16891e]

Jul 19 10:07:35 localhost mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x7fa18bc0553f]

Jul 19 10:07:35 localhost mysqld: sigaction.c:0(__restore_rt)[0x7fa18b0566d0]

Jul 19 10:07:35 localhost mysqld: /usr/sbin/mysqld(my_charset_bin+0x0)[0x7fa18ca7e440]

Jul 19 10:07:35 localhost mysqld: Trying to get some variables.

Jul 19 10:07:35 localhost mysqld: Some pointers may be invalid and cause the dump to abort.

Jul 19 10:07:35 localhost mysqld: Query (0x7fa0e400f440): SELECT cellno, id, concat(date_format(FROM_UNIXTIME(truncate(time, -3) / 1000), '%Y/%m/%d %H:%i:%s'), '.', right(concat('000', cast(time % 1000 AS CHAR)), 3)) as time_disp, (CASE WHEN seqno = '0' THEN 'Default' WHEN seqno = '1' THEN 'Setup1' WHEN seqno = '2' THEN 'Setup2' WHEN seqno = '3' THEN 'Setup3' WHEN '4' <= seqno AND seqno <= '103' THEN concat('Seq.', seqno - 3) WHEN seqno = '255' THEN 'Seq ALL' ELSE 'unknown' END) as seqno_str, (CASE WHEN seqno <= '3' THEN seqno WHEN seqno = '255' THEN 4 ELSE seqno + 1 END) as seqno_order FROM test PARTITION (pn01,pn02,pn03) WHERE prtcltyp = 4294967295 ORDER BY seqno_order, pn

Jul 19 10:07:35 localhost mysqld: Connection ID (thread ID): 34

Jul 19 10:07:35 localhost mysqld: Status: NOT_KILLED

Jul 19 10:07:35 localhost mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on

Jul 19 10:07:35 localhost mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

Jul 19 10:07:35 localhost mysqld: information that should help you find out what is causing the crash.

Jul 19 10:07:35 localhost mysqld: Writing a core file...

Jul 19 10:07:35 localhost mysqld: Working directory at /mnt/data/mariadb

Jul 19 10:07:35 localhost mysqld: Resource Limits:

Jul 19 10:07:35 localhost mysqld: Limit                     Soft Limit           Hard Limit           Units

Jul 19 10:07:35 localhost mysqld: Max cpu time              unlimited            unlimited            seconds

Jul 19 10:07:35 localhost mysqld: Max file size             unlimited            unlimited            bytes

Jul 19 10:07:35 localhost mysqld: Max data size             unlimited            unlimited            bytes

Jul 19 10:07:35 localhost mysqld: Max stack size            8388608              unlimited            bytes

Jul 19 10:07:35 localhost mysqld: Max core file size        0                    unlimited            bytes

Jul 19 10:07:35 localhost mysqld: Max resident set          unlimited            unlimited            bytes

Jul 19 10:07:35 localhost mysqld: Max processes             379607               379607               processes

Jul 19 10:07:35 localhost mysqld: Max open files            65536                65536                files

Jul 19 10:07:35 localhost mysqld: Max locked memory         65536                65536                bytes

Jul 19 10:07:35 localhost mysqld: Max address space         unlimited            unlimited            bytes

Jul 19 10:07:35 localhost mysqld: Max file locks            unlimited            unlimited            locks

Jul 19 10:07:35 localhost mysqld: Max pending signals       379607               379607               signals

Jul 19 10:07:35 localhost mysqld: Max msgqueue size         819200               819200               bytes

Jul 19 10:07:35 localhost mysqld: Max nice priority         0                    0

Jul 19 10:07:35 localhost mysqld: Max realtime priority     0                    0

Jul 19 10:07:35 localhost mysqld: Max realtime timeout      unlimited            unlimited            us

Jul 19 10:07:35 localhost mysqld: Core pattern: core

Jul 19 10:07:35 localhost systemd: mariadb.service: main process exited, code=killed, status=11/SEGV

Jul 19 10:07:35 localhost systemd: Unit mariadb.service entered failed state.

Jul 19 10:07:35 localhost systemd: mariadb.service failed.

Jul 19 10:08:06 localhost systemd: mariadb.service holdoff time over, scheduling restart.

Jul 19 10:08:06 localhost systemd: Starting MariaDB 10.3.15 database server...

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] /usr/sbin/mysqld (mysqld 10.3.15-MariaDB) starting as process 424752 ...

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Warning] Could not increase number of max_open_files to more than 65536 (request: 262699)

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Warning] Changed limits: max_open_files: 65536  max_connections: 500 (was 500)  table_cache: 32503 (was 131072)

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'InnoDB' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] RocksDB: 2 column families found

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] RocksDB: Column Families at start:

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note]   cf=default

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note]     write_buffer_size=67108864

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note]     target_file_size_base=67108864

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note]   cf=__system__

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note]     write_buffer_size=67108864

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note]     target_file_size_base=67108864

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] RocksDB: Table_store: loaded DDL data for 67 tables

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] RocksDB: global statistics using get_sched_indexer_t indexer

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] MyRocks storage engine plugin has been successfully initialized.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_TRX' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_METRICS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'FEEDBACK' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Recovering after a crash using tc.log

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Starting crash recovery...

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Crash recovery finished.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Server socket created on IP: '::'.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Warning] 'user' entry '@localhost.localdomain' ignored in --skip-name-resolve mode.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Warning] 'proxies_priv' entry '@% root@localhost.localdomain' ignored in --skip-name-resolve mode.

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 21 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Reading of all Master_info entries succeded

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] Added new Master_info '' to hash table

Jul 19 10:08:06 localhost mysqld: 2019-07-19 10:08:06 0 [Note] /usr/sbin/mysqld: ready for connections.

Jul 19 10:08:06 localhost mysqld: Version: '10.3.15-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

Jul 19 10:08:06 localhost systemd: Started MariaDB 10.3.15 database server.

The parameters are described in the attached text file.

Also, one of our tables is as follows.

Front side:

create table `test` (

	`pn` smallint(5) unsigned not null,

	`id` bigint(20) unsigned,

	`timegroup` bigint(20) unsigned not null,

	`time` bigint(20) unsigned not null,

	`cellno` smallint(5) unsigned not null,

	`seqno` smallint(5) unsigned not null,

	index idx_seqno(seqno),

	primary key (`id`,`pn`)

engine=SPIDER

PARTITION BY LIST (`pn`)(

	PARTITION `pn00` VALUES IN (0) COMMENT = 'server "mysqld1", table "test_00", internal_delayed "1"' ,

	PARTITION `pn01` VALUES IN (1) COMMENT = 'server "mysqld1", table "test_01", internal_delayed "1"' ,

	PARTITION `pn02` VALUES IN (2) COMMENT = 'server "mysqld1", table "test_02", internal_delayed "1"' ,

	PARTITION `pn03` VALUES IN (3) COMMENT = 'server "mysqld1", table "test_03", internal_delayed "1"' ,

	PARTITION `pn04` VALUES IN (4) COMMENT = 'server "mysqld1", table "test_04", internal_delayed "1"' ,

	PARTITION `pn05` VALUES IN (5) COMMENT = 'server "mysqld1", table "test_05", internal_delayed "1"' ,

	PARTITION `pn06` VALUES IN (6) COMMENT = 'server "mysqld1", table "test_06", internal_delayed "1"' ,

	PARTITION `pn07` VALUES IN (7) COMMENT = 'server "mysqld1", table "test_07", internal_delayed "1"' ,

	PARTITION `pn08` VALUES IN (8) COMMENT = 'server "mysqld1", table "test_08", internal_delayed "1"' ,

	PARTITION `pn09` VALUES IN (9) COMMENT = 'server "mysqld1", table "test_09", internal_delayed "1"' ,

	PARTITION `pn10` VALUES IN (10) COMMENT = 'server "mysqld1", table "test_10", internal_delayed "1"' ,

	PARTITION `pn11` VALUES IN (11) COMMENT = 'server "mysqld1", table "test_11", internal_delayed "1"' ,

	PARTITION `pn12` VALUES IN (12) COMMENT = 'server "mysqld1", table "test_12", internal_delayed "1"' ,

	PARTITION `pn13` VALUES IN (13) COMMENT = 'server "mysqld1", table "test_13", internal_delayed "1"' ,

	PARTITION `pn14` VALUES IN (14) COMMENT = 'server "mysqld1", table "test_14", internal_delayed "1"' ,

	PARTITION `pn15` VALUES IN (15) COMMENT = 'server "mysqld1", table "test_15", internal_delayed "1"' ,

	PARTITION `pn16` VALUES IN (16) COMMENT = 'server "mysqld1", table "test_16", internal_delayed "1"' ,

	PARTITION `pn17` VALUES IN (17) COMMENT = 'server "mysqld1", table "test_17", internal_delayed "1"' ,

	PARTITION `pn18` VALUES IN (18) COMMENT = 'server "mysqld1", table "test_18", internal_delayed "1"' ,

	PARTITION `pn19` VALUES IN (19) COMMENT = 'server "mysqld1", table "test_19", internal_delayed "1"' ,

	PARTITION `pn20` VALUES IN (20) COMMENT = 'server "mysqld1", table "test_20", internal_delayed "1"' ,

	PARTITION `pn21` VALUES IN (21) COMMENT = 'server "mysqld1", table "test_21", internal_delayed "1"' ,

	PARTITION `pn22` VALUES IN (22) COMMENT = 'server "mysqld1", table "test_22", internal_delayed "1"' ,

	PARTITION `pn23` VALUES IN (23) COMMENT = 'server "mysqld1", table "test_23", internal_delayed "1"' ,

	PARTITION `pn24` VALUES IN (24) COMMENT = 'server "mysqld1", table "test_24", internal_delayed "1"' ,

	PARTITION `pn25` VALUES IN (25) COMMENT = 'server "mysqld1", table "test_25", internal_delayed "1"' ,

	PARTITION `pn26` VALUES IN (26) COMMENT = 'server "mysqld1", table "test_26", internal_delayed "1"' ,

	PARTITION `pn27` VALUES IN (27) COMMENT = 'server "mysqld1", table "test_27", internal_delayed "1"' ,

	PARTITION `pn28` VALUES IN (28) COMMENT = 'server "mysqld1", table "test_28", internal_delayed "1"' ,

	PARTITION `pn29` VALUES IN (29) COMMENT = 'server "mysqld1", table "test_29", internal_delayed "1"' ,

	PARTITION `pn30` VALUES IN (30) COMMENT = 'server "mysqld1", table "test_30", internal_delayed "1"' ,

	PARTITION `pn31` VALUES IN (31) COMMENT = 'server "mysqld1", table "test_31", internal_delayed "1"' ,

	PARTITION `pn32` VALUES IN (32) COMMENT = 'server "mysqld1", table "test_32", internal_delayed "1"' ,

	PARTITION `pn33` VALUES IN (33) COMMENT = 'server "mysqld1", table "test_33", internal_delayed "1"' ,

	PARTITION `pn34` VALUES IN (34) COMMENT = 'server "mysqld1", table "test_34", internal_delayed "1"' ,

	PARTITION `pn35` VALUES IN (35) COMMENT = 'server "mysqld1", table "test_35", internal_delayed "1"' ,

	PARTITION `pn36` VALUES IN (36) COMMENT = 'server "mysqld1", table "test_36", internal_delayed "1"' ,

	PARTITION `pn37` VALUES IN (37) COMMENT = 'server "mysqld1", table "test_37", internal_delayed "1"' ,

	PARTITION `pn38` VALUES IN (38) COMMENT = 'server "mysqld1", table "test_38", internal_delayed "1"' ,

	PARTITION `pn39` VALUES IN (39) COMMENT = 'server "mysqld1", table "test_39", internal_delayed "1"' ,

	PARTITION `pn40` VALUES IN (40) COMMENT = 'server "mysqld1", table "test_40", internal_delayed "1"' ,

	PARTITION `pn41` VALUES IN (41) COMMENT = 'server "mysqld1", table "test_41", internal_delayed "1"' ,

	PARTITION `pn42` VALUES IN (42) COMMENT = 'server "mysqld1", table "test_42", internal_delayed "1"' ,

	PARTITION `pn43` VALUES IN (43) COMMENT = 'server "mysqld1", table "test_43", internal_delayed "1"' ,

	PARTITION `pn44` VALUES IN (44) COMMENT = 'server "mysqld1", table "test_44", internal_delayed "1"' ,

	PARTITION `pn45` VALUES IN (45) COMMENT = 'server "mysqld1", table "test_45", internal_delayed "1"' ,

	PARTITION `pn46` VALUES IN (46) COMMENT = 'server "mysqld1", table "test_46", internal_delayed "1"' ,

	PARTITION `pn47` VALUES IN (47) COMMENT = 'server "mysqld1", table "test_47", internal_delayed "1"' ,

	PARTITION `pn48` VALUES IN (48) COMMENT = 'server "mysqld1", table "test_48", internal_delayed "1"'

);

Back side:

create table `test_00` (

	`pn` smallint(5) unsigned not null,

	`id` bigint(20) unsigned,

	`timegroup` bigint(20) unsigned not null,

	`time` bigint(20) unsigned not null,

	`cellno` smallint(5) unsigned not null,

	`seqno` smallint(5) unsigned not null,

	`prtcltyp` int(10) unsigned not null,

	index idx_seqno(seqno),

	primary key (`id`,`pn`)

ENGINE=InnoDB ROW_FORMAT=COMPRESSED;

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

mysql_variable.txt
649 kB
2019-07-19 04:05

Issue Links

relates to

MDEV-20108 [ERROR] mysqld got signal 11 in st_select_lex::add_table_to_list

Closed

Activity

People

Assignee:: Kentoku Shiba (Inactive)

Reporter:: toru nagao

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2019-07-19 04:08

Updated:: 2020-10-21 20:33

Resolved:: 2020-10-21 20:33

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.