Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.7, 11.8
-
None
Description
Server crashes on insert after changing table option to sequence=0 for engine InnoDB with error:
../storage/innobase/row/row0ins.cc:295: dberr_t row_ins_clust_index_entry_by_modify(btr_pcur_t*, ulint, ulint, rec_offs**, mem_heap_t**, mem_heap_t*, const dtuple_t*, que_thr_t*, mtr_t*): Assertion `rec_get_deleted_flag(rec, cursor->index()->table->not_redundant())' failed
|
Case example:
--source include/have_innodb.inc
|
 |
create sequence s engine=InnoDB; |
alter table s sequence=0; |
insert into s values (3,1,9223372036854775806,1,1,1000,0,0); |
drop table s; |
Stacktrace for v.11.8:
mysys/stacktrace.c:215(my_print_stacktrace)[0x56c9e6449e34]
|
sql/signal_handler.cc:247(handle_fatal_signal)[0x56c9e5a390bb]
|
libc_sigaction.c:0(__restore_rt)[0x7c2ef4c42520]
|
nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7c2ef4c969fc]
|
posix/raise.c:27(__GI_raise)[0x7c2ef4c42476]
|
stdlib/abort.c:81(__GI_abort)[0x7c2ef4c287f3]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7c2ef4c2871b]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x39e96)[0x7c2ef4c39e96]
|
row/row0ins.cc:299(row_ins_clust_index_entry_by_modify(btr_pcur_t*, unsigned long, unsigned long, unsigned short**, mem_block_info_t**, mem_block_info_t*, dtuple_t const*, que_thr_t*, mtr_t*))[0x56c9e60d7160]
|
row/row0ins.cc:2865(row_ins_clust_index_entry_low(unsigned long, btr_latch_mode, dict_index_t*, unsigned long, dtuple_t*, unsigned long, que_thr_t*))[0x56c9e60df619]
|
row/row0ins.cc:3267(row_ins_clust_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, unsigned long))[0x56c9e60e0d7e]
|
row/row0ins.cc:3402(row_ins_index_entry(dict_index_t*, dtuple_t*, que_thr_t*))[0x56c9e60e13eb]
|
row/row0ins.cc:3568(row_ins_index_entry_step(ins_node_t*, que_thr_t*))[0x56c9e60e1d7c]
|
row/row0ins.cc:3685(row_ins(ins_node_t*, que_thr_t*))[0x56c9e60e229a]
|
row/row0ins.cc:3814(row_ins_step(que_thr_t*))[0x56c9e60e2b13]
|
row/row0mysql.cc:1292(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x56c9e610a735]
|
handler/ha_innodb.cc:7744(ha_innobase::write_row(unsigned char const*))[0x56c9e5ee5a15]
|
sql/handler.cc:8194(handler::ha_write_row(unsigned char const*))[0x56c9e5a56107]
|
sql/sql_insert.cc:2321(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x56c9e55aa626]
|
sql/sql_insert.cc:1181(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x56c9e55a69ee]
|
sql/sql_parse.cc:4471(mysql_execute_command(THD*, bool))[0x56c9e5601346]
|
sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x56c9e560cc3c]
|
sql/sql_parse.cc:1905(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56c9e55f9134]
|
sql/sql_parse.cc:1416(do_command(THD*, bool))[0x56c9e55f7a7a]
|
sql/sql_connect.cc:1438(do_handle_one_connection(CONNECT*, bool))[0x56c9e5802868]
|
sql/sql_connect.cc:1352(handle_one_connection)[0x56c9e58025dd]
|
perfschema/pfs.cc:2200(pfs_spawn_thread)[0x56c9e5dda48f]
|
nptl/pthread_create.c:442(start_thread)[0x7c2ef4c94ac3]
|
x86_64/clone3.S:83(__clone3)[0x7c2ef4d26850]
|