Jan 13 23:39:08 lorlen mysqld: 2020-01-13 23:39:08 0x7f07f40f9700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.21/storage/innobase/btr/btr0btr.cc line 205
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: Failing assertion: mach_read_from_4(seg_header + FSEG_HDR_SPACE) == space
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: We intentionally generate a memory trap.
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: If you get repeated assertion failures or crashes, even
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: immediately after the mysqld startup, there may be
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
Jan 13 23:39:08 lorlen mysqld: InnoDB: about forcing recovery.
|
Jan 13 23:39:08 lorlen mysqld: 200113 23:39:08 [ERROR] mysqld got signal 6 ;
|
Jan 13 23:39:08 lorlen mysqld: This could be because you hit a bug. It is also possible that this binary
|
Jan 13 23:39:08 lorlen mysqld: or one of the libraries it was linked against is corrupt, improperly built,
|
Jan 13 23:39:08 lorlen mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Jan 13 23:39:08 lorlen mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
Jan 13 23:39:08 lorlen mysqld: We will try our best to scrape up some info that will hopefully help
|
Jan 13 23:39:08 lorlen mysqld: diagnose the problem, but since we have already crashed,
|
Jan 13 23:39:08 lorlen mysqld: something is definitely wrong and this may fail.
|
Jan 13 23:39:08 lorlen mysqld: Server version: 10.3.21-MariaDB
|
Jan 13 23:39:08 lorlen mysqld: key_buffer_size=134217728
|
Jan 13 23:39:08 lorlen mysqld: read_buffer_size=131072
|
Jan 13 23:39:08 lorlen mysqld: max_used_connections=1
|
Jan 13 23:39:08 lorlen mysqld: max_threads=153
|
Jan 13 23:39:08 lorlen mysqld: thread_count=8
|
Jan 13 23:39:08 lorlen mysqld: It is possible that mysqld could use up to
|
Jan 13 23:39:08 lorlen mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467424 K bytes of memory
|
Jan 13 23:39:08 lorlen mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Jan 13 23:39:08 lorlen mysqld: Thread pointer: 0x7f07f0000a88
|
Jan 13 23:39:08 lorlen mysqld: Attempting backtrace. You can use the following information to find out
|
Jan 13 23:39:08 lorlen mysqld: where mysqld died. If you see no messages after this, something went
|
Jan 13 23:39:08 lorlen mysqld: terribly wrong...
|
Jan 13 23:39:08 lorlen mysqld: stack_bottom = 0x7f07f40f8d30 thread_stack 0x49000
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55e1e2346c0e]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55e1e1de640f]
|
Jan 13 23:39:08 lorlen mysqld: sigaction.c:0(__restore_rt)[0x7f0801bec5f0]
|
Jan 13 23:39:08 lorlen mysqld: :0(__GI_raise)[0x7f07ffebd337]
|
Jan 13 23:39:08 lorlen mysqld: :0(__GI_abort)[0x7f07ffebea28]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0x4d3b5c)[0x55e1e1b24b5c]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0xa8084f)[0x55e1e20d184f]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0xa826bd)[0x55e1e20d36bd]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0xa82891)[0x55e1e20d3891]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0x4d4302)[0x55e1e1b25302]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0xb03377)[0x55e1e2154377]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0xb0378d)[0x55e1e215478d]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0xaf2dbb)[0x55e1e2143dbb]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(+0x93e489)[0x55e1e1f8f489]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x55e1e1deaff7]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPK25st_mysql_const_lex_stringjjjP5TABLEbP4ListI6StringE+0xbb7)[0x55e1e1cbbc07]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xaac)[0x55e1e1ba9ebc]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xd57)[0x55e1e1bad307]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z29mysqld_show_create_get_fieldsP3THDP10TABLE_LISTP4ListI4ItemEP6String+0x1a2)[0x55e1e1c69da2]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z18mysqld_show_createP3THDP10TABLE_LIST+0x132)[0x55e1e1c6a6b2]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3387)[0x55e1e1c06b47]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x55e1e1c0c44b]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ca6)[0x55e1e1c0f036]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x55e1e1c0ff7e]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x221)[0x55e1e1ce4e91]
|
Jan 13 23:39:08 lorlen mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55e1e1ce4f5d]
|
Jan 13 23:39:08 lorlen mysqld: pthread_create.c:0(start_thread)[0x7f0801be4e65]
|
Jan 13 23:39:08 lorlen mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f07fff8588d]
|
Jan 13 23:39:08 lorlen mysqld: Trying to get some variables.
|
Jan 13 23:39:08 lorlen mysqld: Some pointers may be invalid and cause the dump to abort.
|
Jan 13 23:39:08 lorlen mysqld: Query (0x7f07f000f4c0): show create table `BaseFiles`
|
Jan 13 23:39:08 lorlen mysqld: Connection ID (thread ID): 10
|
Jan 13 23:39:08 lorlen mysqld: Status: NOT_KILLED
|
Jan 13 23:39:08 lorlen 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
|
Jan 13 23:39:08 lorlen mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
Jan 13 23:39:08 lorlen mysqld: information that should help you find out what is causing the crash.
|
Jan 13 23:39:08 lorlen mysqld: Writing a core file...
|
Jan 13 23:39:08 lorlen mysqld: Working directory at /var/lib/mysql
|
Jan 13 23:39:08 lorlen mysqld: Resource Limits:
|
Jan 13 23:39:08 lorlen mysqld: Limit Soft Limit Hard Limit Units
|
Jan 13 23:39:08 lorlen mysqld: Max cpu time unlimited unlimited seconds
|
Jan 13 23:39:08 lorlen mysqld: Max file size unlimited unlimited bytes
|
Jan 13 23:39:08 lorlen mysqld: Max data size unlimited unlimited bytes
|
Jan 13 23:39:08 lorlen mysqld: Max stack size 8388608 unlimited bytes
|
Jan 13 23:39:08 lorlen mysqld: Max core file size 0 unlimited bytes
|
Jan 13 23:39:08 lorlen mysqld: Max resident set unlimited unlimited bytes
|
Jan 13 23:39:08 lorlen mysqld: Max processes 7258 7258 processes
|
Jan 13 23:39:08 lorlen mysqld: Max open files 16364 16364 files
|
Jan 13 23:39:08 lorlen mysqld: Max locked memory 65536 65536 bytes
|
Jan 13 23:39:08 lorlen mysqld: Max address space unlimited unlimited bytes
|
Jan 13 23:39:08 lorlen mysqld: Max file locks unlimited unlimited locks
|
Jan 13 23:39:08 lorlen mysqld: Max pending signals 7258 7258 signals
|
Jan 13 23:39:08 lorlen mysqld: Max msgqueue size 819200 819200 bytes
|
Jan 13 23:39:08 lorlen mysqld: Max nice priority 0 0
|
Jan 13 23:39:08 lorlen mysqld: Max realtime priority 0 0
|
Jan 13 23:39:08 lorlen mysqld: Max realtime timeout unlimited unlimited us
|
Jan 13 23:39:08 lorlen systemd: mariadb.service: main process exited, code=killed, status=6/ABRT
|
Jan 13 23:39:08 lorlen systemd: Unit mariadb.service entered failed state.
|
Thank you for the report! Reproducible with MariaDB 10.2-10.4:
--source include/have_innodb.inc
unlock tables;
--source include/restart_mysqld.inc
10.2 0b4ae6724f2707841c50f88d
#4 0x00007f136e157428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5 0x00007f136e15902a in __GI_abort () at abort.c:89
#6 0x0000560fd2ab939e in ut_dbg_assertion_failed (expr=0x560fd2fdd988 "mach_read_from_4(seg_header + FSEG_HDR_SPACE) == space", file=0x560fd2fdd950 "/10.2/storage/innobase/btr/btr0btr.cc", line=205) at /10.2/storage/innobase/ut/ut0dbg.cc:60
#7 0x0000560fd2ac29c4 in btr_root_fseg_validate (seg_header=0x7f1362efc04a "", space=5) at /10.2/storage/innobase/btr/btr0btr.cc:205
#8 0x0000560fd2ac2bc2 in btr_root_block_get (index=0x7f1310135558, mode=4, mtr=0x7f13601a9be0) at /10.2/storage/innobase/btr/btr0btr.cc:251
#9 0x0000560fd2ac2c5e in btr_root_get (index=0x7f1310135558, mtr=0x7f13601a9be0) at /10.2/storage/innobase/btr/btr0btr.cc:274
#10 0x0000560fd2ac3613 in btr_get_size (index=0x7f1310135558, flag=2, mtr=0x7f13601a9be0) at /10.2/storage/innobase/btr/btr0btr.cc:615
#11 0x0000560fd2b85351 in dict_stats_update_transient_for_index (index=0x7f1310135558) at /10.2/storage/innobase/dict/dict0stats.cc:863
#12 0x0000560fd2b8563e in dict_stats_update_transient (table=0x7f1310137fd8) at /10.2/storage/innobase/dict/dict0stats.cc:950
#13 0x0000560fd2b8aabd in dict_stats_update (table=0x7f1310137fd8, stats_upd_option=DICT_STATS_RECALC_TRANSIENT) at /10.2/storage/innobase/dict/dict0stats.cc:3349
#14 0x0000560fd28a0b8a in dict_stats_init (table=0x7f1310137fd8) at /10.2/storage/innobase/include/dict0stats.ic:165
#15 0x0000560fd28aa5b7 in ha_innobase::open (this=0x7f1310133be8, name=0x7f1310137c20 "./test2/foo") at /10.2/storage/innobase/handler/ha_innodb.cc:6258
#16 0x0000560fd256b472 in handler::ha_open (this=0x7f1310133be8, table_arg=0x7f1310132fe0, name=0x7f1310137c20 "./test2/foo", mode=2, test_if_locked=18) at /10.2/sql/handler.cc:2585
#17 0x0000560fd23ed3ea in open_table_from_share (thd=0x7f1310000af0, share=0x7f1310137708, alias=0x7f1310014730 "foo", db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7f1310132fe0, is_create_table=false) at /10.2/sql/table.cc:3389
#18 0x0000560fd2270187 in open_table (thd=0x7f1310000af0, table_list=0x7f1310014738, ot_ctx=0x7f13601aaed0) at /10.2/sql/sql_base.cc:1931
#19 0x0000560fd227304a in open_and_process_table (thd=0x7f1310000af0, tables=0x7f1310014738, counter=0x7f13601aaf64, flags=0, prelocking_strategy=0x7f13601aafe0, has_prelocking_list=false, ot_ctx=0x7f13601aaed0) at /10.2/sql/sql_base.cc:3566
#20 0x0000560fd2273f3a in open_tables (thd=0x7f1310000af0, options=..., start=0x7f13601aaf48, counter=0x7f13601aaf64, flags=0, prelocking_strategy=0x7f13601aafe0) at /10.2/sql/sql_base.cc:4035
#21 0x0000560fd2275738 in open_and_lock_tables (thd=0x7f1310000af0, options=..., tables=0x7f1310014738, derived=true, flags=0, prelocking_strategy=0x7f13601aafe0) at /10.2/sql/sql_base.cc:4793
#22 0x0000560fd2268502 in open_and_lock_tables (thd=0x7f1310000af0, tables=0x7f1310014738, derived=true, flags=0) at /10.2/sql/sql_base.h:509
#23 0x0000560fd22eccfe in execute_sqlcom_select (thd=0x7f1310000af0, all_tables=0x7f1310014738) at /10.2/sql/sql_parse.cc:6146
#24 0x0000560fd22e3ba6 in mysql_execute_command (thd=0x7f1310000af0) at /10.2/sql/sql_parse.cc:3532
#25 0x0000560fd22f1035 in mysql_parse (thd=0x7f1310000af0, rawbuf=0x7f1310014548 "select * from test2.foo", length=23, parser_state=0x7f13601ac080, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7740
#26 0x0000560fd22df30a in dispatch_command (command=COM_QUERY, thd=0x7f1310000af0, packet=0x7f13100088a1 "select * from test2.foo", packet_length=23, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831
#27 0x0000560fd22ddc1e in do_command (thd=0x7f1310000af0) at /10.2/sql/sql_parse.cc:1385
#28 0x0000560fd24347c9 in do_handle_one_connection (connect=0x560fd5eb1ac0) at /10.2/sql/sql_connect.cc:1336
#29 0x0000560fd2434534 in handle_one_connection (arg=0x560fd5eb1ac0) at /10.2/sql/sql_connect.cc:1241
#30 0x0000560fd2c5dedc in pfs_spawn_thread (arg=0x560fd5f73720) at /10.2/storage/perfschema/pfs.cc:1862
#31 0x00007f136ed946ba in start_thread (arg=0x7f13601ad700) at pthread_create.c:333
#32 0x00007f136e22941d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109