Details
Description
SET SESSION unique_checks=0; |
SET foreign_key_checks=0; |
SET GLOBAL innodb_stats_persistent=0; |
CREATE TABLE t1 (c1 MEDIUMINT); |
XA START 'a'; |
INSERT INTO t1 VALUES (3); |
SET GLOBAL innodb_stats_persistent=1; |
SET GLOBAL table_open_cache=+ 1; |
INSERT INTO t1 VALUES (NULL,'a'); |
|
Leads to:
10.6.12 377ec1b5c906ea55fa2af9ae048a14eb9e1cf201 |
InnoDB: Failing assertion: ib_table->stat_initialized
|
10.6.12 377ec1b5c906ea55fa2af9ae048a14eb9e1cf201 |
Core was generated by `/test/mtest/10.6/mariadb-10.6.12-linux-x86_64/bin/mysqld --no-defaults --core-f'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x153be43fb700 (LWP 3615589))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055919ea23dc5 in my_write_core (sig=6) at /test/mtest/10.6/mysys/stacktrace.c:424
|
#2 0x000055919e144c67 in handle_fatal_signal (sig=6) at /test/mtest/10.6/sql/signal_handler.cc:355
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000153be7f8a859 in __GI_abort () at abort.c:79
|
#6 0x000055919e7f853f in ut_dbg_assertion_failed (expr=0x55919ee4a418 "ib_table->stat_initialized", file=0x55919ee42638 "/test/mtest/10.6/storage/innobase/handler/ha_innodb.cc", line=14755) at /test/mtest/10.6/storage/innobase/ut/ut0dbg.cc:60
|
#7 0x000055919e588fec in ha_innobase::info_low (this=0x153b90076940, flag=282, is_analyze=false) at /test/mtest/10.6/storage/innobase/handler/ha_innodb.cc:14755
|
#8 0x000055919e589981 in ha_innobase::info (this=0x153b90076940, flag=282) at /test/mtest/10.6/storage/innobase/handler/ha_innodb.cc:15010
|
#9 0x000055919e57264c in ha_innobase::open (this=0x153b90076940, name=0x153b90021b80 "./test/t1") at /test/mtest/10.6/storage/innobase/handler/ha_innodb.cc:6197
|
#10 0x000055919e14f740 in handler::ha_open (this=0x153b90076940, table_arg=0x153b9005eeb8, name=0x153b90021b80 "./test/t1", mode=2, test_if_locked=18, mem_root=0x0, partitions_to_open=0x0) at /test/mtest/10.6/sql/handler.cc:3333
|
#11 0x000055919df0160c in open_table_from_share (thd=0x153b90000db8, share=0x153b900215e0, alias=0x153b90014110, db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x153b9005eeb8, is_create_table=false, partitions_to_open=0x0) at /test/mtest/10.6/sql/table.cc:4417
|
#12 0x000055919dcf33be in open_table (thd=0x153b90000db8, table_list=0x153b900140c8, ot_ctx=0x153be43f9800) at /test/mtest/10.6/sql/sql_base.cc:2036
|
#13 0x000055919dcf71e2 in open_and_process_table (thd=0x153b90000db8, tables=0x153b900140c8, counter=0x153be43f9894, flags=0, prelocking_strategy=0x153be43f9918, has_prelocking_list=false, ot_ctx=0x153be43f9800) at /test/mtest/10.6/sql/sql_base.cc:3847
|
#14 0x000055919dcf84a8 in open_tables (thd=0x153b90000db8, options=@0x153b90006640: {m_options = DDL_options_st::OPT_NONE}, start=0x153be43f9878, counter=0x153be43f9894, flags=0, prelocking_strategy=0x153be43f9918) at /test/mtest/10.6/sql/sql_base.cc:4330
|
#15 0x000055919dcfa4e3 in open_and_lock_tables (thd=0x153b90000db8, options=@0x153b90006640: {m_options = DDL_options_st::OPT_NONE}, tables=0x153b900140c8, derived=true, flags=0, prelocking_strategy=0x153be43f9918) at /test/mtest/10.6/sql/sql_base.cc:5303
|
#16 0x000055919dcaf961 in open_and_lock_tables (thd=0x153b90000db8, tables=0x153b900140c8, derived=true, flags=0) at /test/mtest/10.6/sql/sql_base.h:509
|
#17 0x000055919dd50e96 in mysql_insert (thd=0x153b90000db8, table_list=0x153b900140c8, fields=@0x153b90005ff8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55919f6fdee0 <end_of_list>, last = 0x153b90005ff8, elements = 0}, <No data fields>}, values_list=@0x153b90006040: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153b90014d78, last = 0x153b90014d78, elements = 1}, <No data fields>}, update_fields=@0x153b90006028: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55919f6fdee0 <end_of_list>, last = 0x153b90006028, elements = 0}, <No data fields>}, update_values=@0x153b90006010: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55919f6fdee0 <end_of_list>, last = 0x153b90006010, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0) at /test/mtest/10.6/sql/sql_insert.cc:757
|
#18 0x000055919dda7e03 in mysql_execute_command (thd=0x153b90000db8, is_called_from_prepared_stmt=false) at /test/mtest/10.6/sql/sql_parse.cc:4565
|
#19 0x000055919ddb3896 in mysql_parse (thd=0x153b90000db8, rawbuf=0x153b90013fe0 "INSERT INTO t1 VALUES (NULL,'a')", length=32, parser_state=0x153be43fa320) at /test/mtest/10.6/sql/sql_parse.cc:8016
|
#20 0x000055919dd9fd30 in dispatch_command (command=COM_QUERY, thd=0x153b90000db8, packet=0x153b9000b799 "INSERT INTO t1 VALUES (NULL,'a')", packet_length=32, blocking=true) at /test/mtest/10.6/sql/sql_parse.cc:1896
|
#21 0x000055919dd9e6ef in do_command (thd=0x153b90000db8, blocking=true) at /test/mtest/10.6/sql/sql_parse.cc:1409
|
#22 0x000055919df603e5 in do_handle_one_connection (connect=0x5591a0e0bb88, put_in_cache=true) at /test/mtest/10.6/sql/sql_connect.cc:1415
|
#23 0x000055919df60141 in handle_one_connection (arg=0x5591a0e03cb8) at /test/mtest/10.6/sql/sql_connect.cc:1317
|
#24 0x000055919e4954d3 in pfs_spawn_thread (arg=0x5591a0d02548) at /test/mtest/10.6/storage/perfschema/pfs.cc:2201
|
#25 0x0000153be84b6609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#26 0x0000153be8087133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized) |
InnoDB: Failing assertion: ib_table->stat_initialized
|
10.6.12 c4ce012e4b3dac44e76598a5d1f2fe92f836eb30 (Optimized) |
Core was generated by `/test/MD081122-mariadb-10.6.12-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x154518cdc700 (LWP 2913317))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000015453144e859 in __GI_abort () at abort.c:79
|
#2 0x000055d111896991 in ut_dbg_assertion_failed (expr=expr@entry=0x55d1124072e4 "ib_table->stat_initialized", file=file@entry=0x55d1124001e0 "/test/10.6_opt/storage/innobase/handler/ha_innodb.cc", line=line@entry=14779) at /test/10.6_opt/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x000055d1118705c2 in ha_innobase::info_low (this=0x1544e4040da0, flag=282, is_analyze=<optimized out>) at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:14779
|
#4 0x000055d111ea67bf in ha_innobase::info (flag=282, this=0x1544e4040da0) at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:15034
|
#5 ha_innobase::open (this=<optimized out>, name=<optimized out>) at /test/10.6_opt/storage/innobase/handler/ha_innodb.cc:6197
|
#6 0x000055d111c045ae in handler::ha_open (this=0x1544e4040da0, table_arg=table_arg@entry=0x1544e401c988, name=0x1544e401a500 "./test/t1", mode=mode@entry=2, test_if_locked=test_if_locked@entry=18, mem_root=mem_root@entry=0x0, partitions_to_open=0x0) at /test/10.6_opt/sql/handler.cc:3333
|
#7 0x000055d111ab2c11 in open_table_from_share (thd=thd@entry=0x1544e4000c58, share=share@entry=0x1544e401a060, alias=alias@entry=0x1544e40107b0, db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=0x1544e401c988, is_create_table=false, partitions_to_open=0x0) at /test/10.6_opt/sql/table.cc:4417
|
#8 0x000055d11196c9d4 in open_table (thd=0x1544e4000c58, table_list=0x1544e4010768, ot_ctx=0x154518cdaa90) at /test/10.6_opt/sql/sql_base.cc:2036
|
#9 0x000055d11196f6ce in open_and_process_table (ot_ctx=0x154518cdaa90, has_prelocking_list=false, prelocking_strategy=0x154518cdac40, flags=0, counter=0x154518cdab2c, tables=0x1544e4010768, thd=0x1544e4000c58) at /test/10.6_opt/sql/sql_base.cc:3847
|
#10 open_tables (thd=thd@entry=0x1544e4000c58, options=@0x1544e4006120: {m_options = DDL_options_st::OPT_NONE}, start=start@entry=0x154518cdab18, counter=counter@entry=0x154518cdab2c, flags=flags@entry=0, prelocking_strategy=0x154518cdac40) at /test/10.6_opt/sql/sql_base.cc:4330
|
#11 0x000055d11196fe7c in open_and_lock_tables (thd=thd@entry=0x1544e4000c58, options=<optimized out>, tables=<optimized out>, tables@entry=0x1544e4010768, derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=<optimized out>) at /test/10.6_opt/sql/sql_base.cc:5303
|
#12 0x000055d1119a0181 in open_and_lock_tables (flags=<optimized out>, derived=<optimized out>, tables=<optimized out>, thd=<optimized out>) at /test/10.6_opt/sql/sql_base.h:509
|
#13 open_and_lock_for_insert_delayed (table_list=<optimized out>, thd=<optimized out>) at /test/10.6_opt/sql/sql_insert.cc:626
|
#14 mysql_insert (thd=thd@entry=0x1544e4000c58, table_list=0x1544e4010768, fields=@0x1544e4005ad8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55d112a54650 <end_of_list>, last = 0x1544e4005ad8, elements = 0}, <No data fields>}, values_list=@0x1544e4005b20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1544e4011418, last = 0x1544e4011418, elements = 1}, <No data fields>}, update_fields=@0x1544e4005b08: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55d112a54650 <end_of_list>, last = 0x1544e4005b08, elements = 0}, <No data fields>}, update_values=@0x1544e4005af0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55d112a54650 <end_of_list>, last = 0x1544e4005af0, elements = 0}, <No data fields>}, duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /test/10.6_opt/sql/sql_insert.cc:752
|
#15 0x000055d1119db7f4 in mysql_execute_command (thd=0x1544e4000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:4565
|
#16 0x000055d1119cba65 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x1544e4000c58) at /test/10.6_opt/sql/sql_parse.cc:8016
|
#17 mysql_parse (thd=0x1544e4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:7938
|
#18 0x000055d1119d7aa2 in dispatch_command (command=COM_QUERY, thd=0x1544e4000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.6_opt/sql/sql_class.h:1365
|
#19 0x000055d1119d98ae in do_command (thd=0x1544e4000c58, blocking=blocking@entry=true) at /test/10.6_opt/sql/sql_parse.cc:1409
|
#20 0x000055d111ae05ff in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d1153e1a38, put_in_cache=put_in_cache@entry=true) at /test/10.6_opt/sql/sql_connect.cc:1416
|
#21 0x000055d111ae08ed in handle_one_connection (arg=0x55d1153e1a38) at /test/10.6_opt/sql/sql_connect.cc:1318
|
#22 0x000015453195f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#23 0x000015453154b133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.6.12 (dbg), 10.6.12 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.28 (dbg), 10.4.28 (opt), 10.5.19 (dbg), 10.5.19 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.7 (dbg), 10.8.7 (opt), 10.9.5 (dbg), 10.9.5 (opt), 10.10.3 (dbg), 10.10.3 (opt), 10.11.1 (dbg), 10.11.1 (opt)
Attachments
Issue Links
- relates to
-
MDEV-515 innodb bulk insert
- Closed
-
MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time
- Closed
-
MDEV-24818 Concurrent use of InnoDB table is impossible until the first transaction is finished
- Closed