Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.6
Description
Sporadic. Usually requires 2 attempts sequentially on same server, sometimes more. Cores may not always be written. Frequently seen in runs.
DROP DATABASE test;
|
CREATE DATABASE test;
|
USE test;
|
XA START 'a';
|
SET GLOBAL innodb_adaptive_hash_index='ON';
|
CREATE TEMPORARY TABLE t1(c INT) ENGINE=InnoDB;
|
CREATE TEMPORARY TABLE t3(a INT) ENGINE=MERGE UNION=(t1,t2);
|
INSERT INTO t1(c) SELECT seq FROM seq_1_to_500;
|
LOAD INDEX INTO CACHE t3 KEY(b),t2 KEY(d);
|
INSERT INTO t1(c) SELECT seq FROM seq_1_to_500;
|
Leads to:
10.6.0 786bc312b85e58857cb26a24ab6e997ba0fdfc32 (Debug) |
InnoDB: Failing assertion: (block)->index || (block)->n_pointers == 0
|
10.6.0 786bc312b85e58857cb26a24ab6e997ba0fdfc32 (Debug) |
Core was generated by `/test/MD100221-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x14a64c737700 (LWP 2127796))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055b0c7a3955e in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424
|
#2 0x000055b0c71d14de in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:330
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x000014a657b9c859 in __GI_abort () at abort.c:79
|
#6 0x000055b0c7819e9a in ut_dbg_assertion_failed (expr=expr@entry=0x55b0c7e07a40 "(block)->index || (block)->n_pointers == 0", file=file@entry=0x55b0c7e58fe0 "/test/10.6_dbg/storage/innobase/btr/btr0sea.cc", line=line@entry=1379) at /test/10.6_dbg/storage/innobase/ut/ut0dbg.cc:60
|
#7 0x000055b0c7880d06 in btr_search_drop_page_hash_index (block=block@entry=0x14a634010a00) at /test/10.6_dbg/storage/innobase/btr/btr0sea.cc:1379
|
#8 0x000055b0c78290bb in dict_index_t::clear (this=this@entry=0x14a5e802e938, thr=thr@entry=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/btr/btr0btr.cc:1219
|
#9 0x000055b0c776e587 in dict_table_t::clear (this=<optimized out>, thr=thr@entry=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/row/row0log.cc:4129
|
#10 0x000055b0c79ae6f8 in row_undo_ins (node=node@entry=0x14a5e82bd628, thr=thr@entry=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/row/row0uins.cc:607
|
#11 0x000055b0c77a4eaf in row_undo (thr=0x14a5e82bd1d8, node=0x14a5e82bd628) at /test/10.6_dbg/storage/innobase/row/row0undo.cc:439
|
#12 row_undo_step (thr=thr@entry=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/row/row0undo.cc:495
|
#13 0x000055b0c76e92c8 in que_thr_step (thr=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/que/que0que.cc:651
|
#14 que_run_threads_low (thr=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/que/que0que.cc:709
|
#15 que_run_threads (thr=0x14a5e82bd1d8) at /test/10.6_dbg/storage/innobase/que/que0que.cc:729
|
#16 0x000055b0c77f4d1c in trx_t::rollback_low (this=this@entry=0x14a64e9f22a0, savept=savept@entry=0x0) at /test/10.6_dbg/storage/innobase/trx/trx0roll.cc:118
|
#17 0x000055b0c77f2ae3 in trx_rollback_for_mysql_low (trx=0x14a64e9f22a0) at /test/10.6_dbg/storage/innobase/trx/trx0roll.cc:189
|
#18 trx_rollback_for_mysql (trx=trx@entry=0x14a64e9f22a0) at /test/10.6_dbg/storage/innobase/trx/trx0roll.cc:219
|
#19 0x000055b0c75c42ae in innobase_rollback (hton=<optimized out>, thd=0x14a5e8000db8, rollback_trx=<optimized out>) at /test/10.6_dbg/storage/innobase/handler/ha_innodb.cc:4111
|
#20 0x000055b0c71d6c67 in ha_rollback_trans (thd=thd@entry=0x14a5e8000db8, all=all@entry=true) at /test/10.6_dbg/sql/handler.cc:2053
|
#21 0x000055b0c707c1ed in trans_rollback_implicit (thd=thd@entry=0x14a5e8000db8) at /test/10.6_dbg/sql/transaction.cc:421
|
#22 0x000055b0c707a3d5 in mysql_admin_table (thd=thd@entry=0x14a5e8000db8, tables=tables@entry=0x14a5e8012800, check_opt=check_opt@entry=0x0, operator_name=operator_name@entry=0x55b0c7d8dfa3 "preload_keys", lock_type=lock_type@entry=TL_READ_NO_INSERT, org_open_for_modify=org_open_for_modify@entry=false, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=&virtual table offset 752, view_operator_func=0x0) at /test/10.6_dbg/sql/sql_admin.cc:1240
|
#23 0x000055b0c707b09b in mysql_preload_keys (thd=thd@entry=0x14a5e8000db8, tables=tables@entry=0x14a5e8012800) at /test/10.6_dbg/sql/sql_admin.cc:1368
|
#24 0x000055b0c6f0d4be in mysql_execute_command (thd=thd@entry=0x14a5e8000db8) at /test/10.6_dbg/sql/sql_parse.cc:3976
|
#25 0x000055b0c6ef921a in mysql_parse (thd=thd@entry=0x14a5e8000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14a64c7363d0) at /test/10.6_dbg/sql/sql_parse.cc:7906
|
#26 0x000055b0c6f0730b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14a5e8000db8, packet=packet@entry=0x14a5e801aac9 "", packet_length=packet_length@entry=41) at /test/10.6_dbg/sql/sql_class.h:1295
|
#27 0x000055b0c6f0a63d in do_command (thd=0x14a5e8000db8) at /test/10.6_dbg/sql/sql_parse.cc:1365
|
#28 0x000055b0c70661ab in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55b0ca0176e8, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
|
#29 0x000055b0c70668af in handle_one_connection (arg=arg@entry=0x55b0ca0176e8) at /test/10.6_dbg/sql/sql_connect.cc:1312
|
#30 0x000055b0c751a27d in pfs_spawn_thread (arg=0x55b0c9f02c38) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
|
#31 0x000014a6580aa609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#32 0x000014a657c99293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.6.0 (dbg), 10.6.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.37 (dbg), 10.2.37 (opt), 10.3.28 (dbg), 10.3.28 (opt), 10.4.18 (dbg), 10.4.18 (opt), 10.5.9 (dbg), 10.5.9 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.33 (dbg), 5.7.33 (opt), 8.0.23 (dbg), 8.0.23 (opt)
Attachments
Issue Links
- is caused by
-
MDEV-515 innodb bulk insert
- Closed
-
MDEV-24720 Assertion `0' failed in btr_search_hash_table_validate
- Closed
- relates to
-
MDEV-20203 InnoDB: Failing assertion: (block)->index || (block)->n_pointers == 0
- Confirmed