Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20100

MariaDB 13.3.9 Crash "[ERROR] mysqld got signal 11 ;"

    Details

      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

          Issue Links

            Activity

              People

              • Assignee:
                Kentoku Kentoku Shiba
                Reporter:
                nagao toru nagao
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: