Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.6
Description
CREATE TABLE IF NOT EXISTS t1 (a INT UNIQUE, b INT) REPLACE SELECT 1 AS a, 1 AS b UNION SELECT 1 AS a, 2 AS b;
|
Leads to:
10.6.0 3f871b339429441ad907ecf7dfabdc414797e664 (Debug) |
mysqld: /data/builds/10.6_dbg/storage/innobase/row/row0upd.cc:2530: dberr_t row_upd_clust_rec(ulint, upd_node_t*, dict_index_t*, rec_offs*, mem_heap_t**, que_thr_t*, mtr_t*): Assertion `!node->table->skip_alter_undo' failed.
|
10.6.0 3f871b339429441ad907ecf7dfabdc414797e664 (Debug) |
Core was generated by `/test/MD260121-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 0x150c30b9e700 (LWP 2950885))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x0000556ec64dd210 in my_write_core (sig=sig@entry=6) at /data/builds/10.6_dbg/mysys/stacktrace.c:424
|
#2 0x0000556ec5c722d0 in handle_fatal_signal (sig=6) at /data/builds/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 0x0000150c3a003859 in __GI_abort () at abort.c:79
|
#6 0x0000150c3a003729 in __assert_fail_base (fmt=0x150c3a199588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x556ec68df273 "!node->table->skip_alter_undo", file=0x556ec68e4280 "/data/builds/10.6_dbg/storage/innobase/row/row0upd.cc", line=2530, function=<optimized out>) at assert.c:92
|
#7 0x0000150c3a014f36 in __GI___assert_fail (assertion=assertion@entry=0x556ec68df273 "!node->table->skip_alter_undo", file=file@entry=0x556ec68e4280 "/data/builds/10.6_dbg/storage/innobase/row/row0upd.cc", line=line@entry=2530, function=function@entry=0x556ec68e4ee8 "dberr_t row_upd_clust_rec(ulint, upd_node_t*, dict_index_t*, rec_offs*, mem_heap_t**, que_thr_t*, mtr_t*)") at assert.c:101
|
#8 0x0000556ec62505a6 in row_upd_clust_rec (flags=flags@entry=0, node=node@entry=0x150be4048d38, index=index@entry=0x150be4042948, offsets=<optimized out>, offsets@entry=0x150c30b9b570, offsets_heap=offsets_heap@entry=0x150c30b9b558, thr=thr@entry=0x150be4049040, mtr=0x150c30b9bbb0) at /data/builds/10.6_dbg/storage/innobase/row/row0upd.cc:2530
|
#9 0x0000556ec62526f1 in row_upd_clust_step (node=node@entry=0x150be4048d38, thr=thr@entry=0x150be4049040) at /data/builds/10.6_dbg/storage/innobase/row/row0upd.cc:2888
|
#10 0x0000556ec6254ceb in row_upd (thr=0x150be4049040, node=0x150be4048d38) at /data/builds/10.6_dbg/storage/innobase/row/row0upd.cc:2992
|
#11 row_upd_step (thr=thr@entry=0x150be4049040) at /data/builds/10.6_dbg/storage/innobase/row/row0upd.cc:3136
|
#12 0x0000556ec61f5ac1 in row_update_for_mysql (prebuilt=0x150be40482b8) at /data/builds/10.6_dbg/storage/innobase/row/row0mysql.cc:1854
|
#13 0x0000556ec607a257 in ha_innobase::update_row (this=0x150be4045b60, old_row=0x150be4045708 "\241\001", new_row=0x150be40456f8 "\371\001") at /data/builds/10.6_dbg/storage/innobase/handler/ha_innodb.cc:8130
|
#14 0x0000556ec5c86c37 in handler::ha_update_row (this=0x150be4045b60, old_data=0x150be4045708 "\241\001", new_data=0x150be40456f8 "\371\001") at /data/builds/10.6_dbg/sql/handler.cc:7204
|
#15 0x0000556ec595c7cd in write_record (thd=0x150be4000db8, table=0x150be4045268, info=info@entry=0x150be40150f0, sink=0x0) at /data/builds/10.6_dbg/sql/sql_insert.cc:2023
|
#16 0x0000556ec595c905 in select_insert::send_data (this=0x150be40150a0, values=<optimized out>) at /data/builds/10.6_dbg/sql/sql_insert.cc:4076
|
#17 0x0000556ec5a11ba8 in select_result_sink::send_data_with_check (sent=<optimized out>, u=<optimized out>, items=@0x150be40056d0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x150be4016360, last = 0x150be40164b0, elements = 2}, <No data fields>}, this=<optimized out>) at /data/builds/10.6_dbg/sql/sql_class.h:5376
|
#18 end_send (join=0x150be4016aa8, join_tab=0x150be404a5a8, end_of_records=<optimized out>) at /data/builds/10.6_dbg/sql/sql_select.cc:21802
|
#19 0x0000556ec59e087e in evaluate_join_record (join=join@entry=0x150be4016aa8, join_tab=join_tab@entry=0x150be404a1f8, error=error@entry=0) at /data/builds/10.6_dbg/sql/sql_select.cc:20825
|
#20 0x0000556ec59f7017 in sub_select (join=0x150be4016aa8, join_tab=0x150be404a1f8, end_of_records=<optimized out>) at /data/builds/10.6_dbg/sql/sql_select.cc:20641
|
#21 0x0000556ec5a2fa22 in do_select (procedure=0x0, join=0x150be4016aa8) at /data/builds/10.6_dbg/sql/sql_select.cc:20149
|
#22 JOIN::exec_inner (this=this@entry=0x150be4016aa8) at /data/builds/10.6_dbg/sql/sql_select.cc:4476
|
#23 0x0000556ec5a2fe92 in JOIN::exec (this=this@entry=0x150be4016aa8) at /data/builds/10.6_dbg/sql/sql_select.cc:4256
|
#24 0x0000556ec5a2e0f2 in mysql_select (thd=0x150be4000db8, tables=tables@entry=0x150be4004fc8, fields=@0x150be40056d0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x150be4016360, last = 0x150be40164b0, elements = 2}, <No data fields>}, conds=conds@entry=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2199023255552, result=0x150be40150a0, unit=0x150be4004f80, select_lex=0x150be4014760) at /data/builds/10.6_dbg/sql/sql_select.cc:4672
|
#25 0x0000556ec5a9ccdb in st_select_lex_unit::exec (this=this@entry=0x150be4004f80) at /data/builds/10.6_dbg/sql/sql_lex.h:925
|
#26 0x0000556ec5aa0ef2 in mysql_union (thd=thd@entry=0x150be4000db8, lex=lex@entry=0x150be4004eb8, result=result@entry=0x150be40150a0, unit=unit@entry=0x150be4004f80, setup_tables_done_option=<optimized out>, setup_tables_done_option@entry=0) at /data/builds/10.6_dbg/sql/sql_union.cc:41
|
#27 0x0000556ec5a2e2f6 in handle_select (thd=thd@entry=0x150be4000db8, lex=lex@entry=0x150be4004eb8, result=result@entry=0x150be40150a0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/builds/10.6_dbg/sql/sql_select.cc:407
|
#28 0x0000556ec5a854c4 in Sql_cmd_create_table_like::execute (this=<optimized out>, thd=0x150be4000db8) at /data/builds/10.6_dbg/sql/sql_table.cc:12110
|
#29 0x0000556ec59b3556 in mysql_execute_command (thd=thd@entry=0x150be4000db8) at /data/builds/10.6_dbg/sql/sql_parse.cc:5875
|
#30 0x0000556ec599a15e in mysql_parse (thd=thd@entry=0x150be4000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x150c30b9d3d0) at /data/builds/10.6_dbg/sql/sql_parse.cc:7901
|
#31 0x0000556ec59a824f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x150be4000db8, packet=packet@entry=0x150be401aac9 "CREATE TABLE IF NOT EXISTS t1 (a INT UNIQUE, b INT) REPLACE SELECT 1 AS a, 1 AS b UNION SELECT 1 AS a, 2 AS b", packet_length=packet_length@entry=109) at /data/builds/10.6_dbg/sql/sql_class.h:1294
|
#32 0x0000556ec59ab581 in do_command (thd=0x150be4000db8) at /data/builds/10.6_dbg/sql/sql_parse.cc:1365
|
#33 0x0000556ec5b07079 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x556ec9803688, put_in_cache=put_in_cache@entry=true) at /data/builds/10.6_dbg/sql/sql_connect.cc:1410
|
#34 0x0000556ec5b0777d in handle_one_connection (arg=arg@entry=0x556ec9803688) at /data/builds/10.6_dbg/sql/sql_connect.cc:1312
|
#35 0x0000556ec5fba43f in pfs_spawn_thread (arg=0x556ec96e8bd8) at /data/builds/10.6_dbg/storage/perfschema/pfs.cc:2201
|
#36 0x0000150c3a511609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#37 0x0000150c3a100293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.6.0 (dbg)
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), 10.6.0 (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
- relates to
-
MDEV-22255 SIGABRT: Assertion `id' failed in trx_write_trx_id on INSERT | Assertion `id > 0' failed in trx_write_trx_id | Assertion `val > 0' failed in row_upd_index_entry_sys_field | Assertion `thr_get_trx(thr)->id || index->table->no_rollback()' failed.
- Closed