Assertion `thr_get_trx(thr)->id != 0' failed in dberr_t row_ins_sec_index_entry(dict_index_t *, dtuple_t *, que_thr_t *, bool)

--source include/have_innodb.inc

CREATE TEMPORARY TABLE t1 (c INT KEY) ENGINE=INNODB;

INSERT INTO t1 (c) VALUES(0);

ALTER TABLE t1 ADD INDEX (c);

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE,READ ONLY;

HANDLER t1 OPEN AS h2;

ALTER TABLE t1 RENAME COLUMN IF EXISTS c TO d;

# Clean up

DROP TABLE t1;

mariadbd: /test/12.3_dbg/storage/innobase/row/row0ins.cc:3391: dberr_t row_ins_sec_index_entry(dict_index_t *, dtuple_t *, que_thr_t *, bool): Assertion `thr_get_trx(thr)->id != 0' failed.

Core was generated by `/test/MD220526-mariadb-12.3.2-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 1703244)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89

#3  0x0000709cfba4527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#4  0x0000709cfba288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x0000709cfba2881b in __assert_fail_base (fmt=0x709cfbbd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x581a1afc9f8c "thr_get_trx(thr)->id != 0", file=file@entry=0x581a1afc9956 "/test/12.3_dbg/storage/innobase/row/row0ins.cc", line=line@entry=3391, function=function@entry=0x581a1afc9fa6 "dberr_t row_ins_sec_index_entry(dict_index_t *, dtuple_t *, que_thr_t *, bool)") at ./assert/assert.c:96

#6  0x0000709cfba3b517 in __assert_fail (assertion=0x581a1afc9f8c "thr_get_trx(thr)->id != 0", file=0x581a1afc9956 "/test/12.3_dbg/storage/innobase/row/row0ins.cc", line=3391, function=0x581a1afc9fa6 "dberr_t row_ins_sec_index_entry(dict_index_t *, dtuple_t *, que_thr_t *, bool)") at ./assert/assert.c:105

#7  0x0000581a1a788500 in row_ins_sec_index_entry (index=0x688208062ba8, entry=0x688208063eb8, thr=0x6882080a98c0, check_foreign=true) at /test/12.3_dbg/storage/innobase/row/row0ins.cc:3391

#8  0x0000581a1a79096e in row_ins_index_entry (index=0x688208062ba8, entry=0x688208063eb8, thr=0x6882080a98c0) at /test/12.3_dbg/storage/innobase/row/row0ins.cc:3474

#9  0x0000581a1a78fbae in row_ins_index_entry_step (node=0x6882080a96c0, thr=0x6882080a98c0) at /test/12.3_dbg/storage/innobase/row/row0ins.cc:3638

#10 0x0000581a1a789072 in row_ins (node=0x6882080a96c0, thr=0x6882080a98c0) at /test/12.3_dbg/storage/innobase/row/row0ins.cc:3755

#11 0x0000581a1a788cc0 in row_ins_step (thr=0x6882080a98c0) at /test/12.3_dbg/storage/innobase/row/row0ins.cc:3884

#12 0x0000581a1a7b3432 in row_insert_for_mysql (mysql_rec=0x6882080a6e20 "\377", prebuilt=0x6882080a92b8, ins_mode=ROW_INS_NORMAL) at /test/12.3_dbg/storage/innobase/row/row0mysql.cc:1295

#13 0x0000581a1a5978ec in ha_innobase::write_row (this=0x6882080a65b0, record=0x6882080a6e20 "\377") at /test/12.3_dbg/storage/innobase/handler/ha_innodb.cc:7765

#14 0x0000581a1a17decf in handler::ha_write_row (this=0x6882080a65b0, buf=0x6882080a6e20 "\377") at /test/12.3_dbg/sql/handler.cc:8521

#15 0x0000581a19e4a58f in copy_data_between_tables (thd=0x688208000d60, from=0x6882080bc240, to=0x688208062e80, ignore=false, order_num=0, order=0x0, copied=0x709cf95daed0, deleted=0x709cf95daec8, alter_info=0x709cf95dddf8, alter_ctx=0x709cf95dbdf8, online=false, start_alter_id=0) at /test/12.3_dbg/sql/sql_table.cc:12978

#16 0x0000581a19e3fd33 in mysql_alter_table (thd=0x688208000d60, new_db=0x688208005ba8, new_name=0x688208006020, create_info=0x709cf95ddf70, table_list=0x688208017070, recreate_info=0x709cf95dd688, alter_info=0x709cf95dddf8, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/12.3_dbg/sql/sql_table.cc:12015

#17 0x0000581a19f0fbae in Sql_cmd_alter_table::execute (this=0x688208017820, thd=0x688208000d60) at /test/12.3_dbg/sql/sql_alter.cc:695

#18 0x0000581a19d180e5 in mysql_execute_command (thd=0x688208000d60, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:5910

#19 0x0000581a19d07264 in mysql_parse (thd=0x688208000d60, rawbuf=0x688208016f40 "ALTER TABLE t1 RENAME COLUMN IF EXISTS c TO d", length=45, parser_state=0x709cf95df9f0) at /test/12.3_dbg/sql/sql_parse.cc:7949

#20 0x0000581a19d045ad in dispatch_command (command=COM_QUERY, thd=0x688208000d60, packet=0x6882081cc4b1 "ALTER TABLE t1 RENAME COLUMN IF EXISTS c TO d", packet_length=45, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:1903

#21 0x0000581a19d07e13 in do_command (thd=0x688208000d60, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:1437

#22 0x0000581a19f04219 in do_handle_one_connection (connect=0x581a5a139890, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1503

#23 0x0000581a19f03fbe in handle_one_connection (arg=0x581a5a221700) at /test/12.3_dbg/sql/sql_connect.cc:1415

#24 0x0000709cfba9caa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447

#25 0x0000709cfbb29c6c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed

CS  10.11  dbg  220526  6f1204ad849b72a997fd34ce44a522d76716c24d  No bug found

CS  10.11  opt  220526  6f1204ad849b72a997fd34ce44a522d76716c24d  No bug found

CS  11.4   dbg  220526  19c59f2c79637cc360cc6d6b219ed9131124500d  No bug found

CS  11.4   opt  220526  19c59f2c79637cc360cc6d6b219ed9131124500d  No bug found

CS  11.8   dbg  220526  b494164767979072713fdeccc175ce3b3f5b1983  thr_get_trx(thr)->id != 0|SIGABRT|row_ins_sec_index_entry|row_ins_index_entry|row_ins_index_entry_step|row_ins

CS  11.8   opt  220526  b494164767979072713fdeccc175ce3b3f5b1983  No bug found

CS  12.3   dbg  220526  66b3c6784689fbb65110a5b21efcb815a8bcde24  thr_get_trx(thr)->id != 0|SIGABRT|row_ins_sec_index_entry|row_ins_index_entry|row_ins_index_entry_step|row_ins

CS  12.3   opt  220526  66b3c6784689fbb65110a5b21efcb815a8bcde24  No bug found

CS  13.0   dbg  220526  c8e8d33309606e682c98675d594dbd23ebc2ddf6  thr_get_trx(thr)->id != 0|SIGABRT|row_ins_sec_index_entry|row_ins_index_entry|row_ins_index_entry_step|row_ins

CS  13.0   opt  220526  c8e8d33309606e682c98675d594dbd23ebc2ddf6  No bug found

ES  10.6   dbg  040825  9b794f34b48fb7eee490b6da44edc0f33a947447  No bug found

ES  10.6   opt  040825  9b794f34b48fb7eee490b6da44edc0f33a947447  No bug found

ES  11.4   dbg  040825  a1c03ccd54b582e75506687ee19b273ca897f261  No bug found

ES  11.4   opt  040825  a1c03ccd54b582e75506687ee19b273ca897f261  No bug found

ES  11.8   dbg  151025  780565c207e9ce0ebf7d8e3d59f223801447b619  thr_get_trx(thr)->id != 0|SIGABRT|row_ins_sec_index_entry|row_ins_index_entry|row_ins_index_entry_step|row_ins

ES  11.8   opt  151025  780565c207e9ce0ebf7d8e3d59f223801447b619  No bug found

----- UBASAN Execution of the testcase ----- (Builds used: /test/UBASAN_MD220526-mariadb-12.3.2-linux-x86_64-opt and _dbg)

 opt: No SAN issue detected

 dbg: No SAN issue detected, though saw thr_get_trx(thr)->id != 0|SIGABRT|row_ins_sec_index_entry|row_ins_index_entry|row_ins_index_entry_step|row_ins