[MDEV-17644] DRAFT: Assertion `0' failed in row_log_table_apply_update Created: 2018-11-08  Updated: 2023-09-19

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3.11, 10.2.19
Fix Version/s: 10.2

Type: Bug Priority: Major
Reporter: Matthias Leich Assignee: Matthias Leich
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Ubuntu 17.04 but most probably unimportant


Issue Links:
Relates
relates to MDEV-28122 OPTIMIZE TABLE crash Closed

 Description   

Example from 10.3:
Version: '10.3.11-MariaDB-debug-log'  ...
mysqld: storage/innobase/row/row0log.cc:2260: dberr_t row_log_table_apply_update(que_thr_t*, ulint, const mrec_t*, const ulint*, mem_heap_t*, mem_heap_t*, row_merge_dup_t*, const dtuple_t*): Assertion `0' failed.
...
ALTER TABLE t1 CHANGE COLUMN col_int col_int INTEGER, LOCK = DEFAULT;
Status: NOT_KILLED
 
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58
#5  0x00007f8a4f59337a in __GI_abort () at abort.c:89
#6  0x00007f8a4f589b47 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5612ce3bcec0 "0", file=file@entry=0x5612ce3c0fc0 "storage/innobase/row/row0log.cc", line=line@entry=2260, function=function@entry=0x5612ce3c8f40 <row_log_table_apply_update(que_thr_t*, unsigned long, unsigned char const*, unsigned long const*, mem_block_info_t*, mem_block_info_t*, row_merge_dup_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_log_table_apply_update(que_thr_t*, ulint, const mrec_t*, const ulint*, mem_heap_t*, mem_heap_t*, row_merge_dup_t*, const dtuple_t*)") at assert.c:92
#7  0x00007f8a4f589bf2 in __GI___assert_fail (assertion=0x5612ce3bcec0 "0", file=0x5612ce3c0fc0 "storage/innobase/row/row0log.cc", line=2260, function=0x5612ce3c8f40 <row_log_table_apply_update(que_thr_t*, unsigned long, unsigned char const*, unsigned long const*, mem_block_info_t*, mem_block_info_t*, row_merge_dup_t*, dtuple_t const*)::__PRETTY_FUNCTION__> "dberr_t row_log_table_apply_update(que_thr_t*, ulint, const mrec_t*, const ulint*, mem_heap_t*, mem_heap_t*, row_merge_dup_t*, const dtuple_t*)") at assert.c:101
#8  0x00005612cd2efb38 in row_log_table_apply_update (thr=0x61a0005cb9c8, new_trx_id_col=1, mrec=0x7f8a214a4005 "\200", offsets=0x60800004baa0, offsets_heap=0x629000596200, heap=0x629000591200, dup=0x7f8a20db7320, old_pk=0x629000591288) at storage/innobase/row/row0log.cc:2260
#9  0x00005612cd2f22e1 in row_log_table_apply_op (thr=0x61a0005cb9c8, new_trx_id_col=1, dup=0x7f8a20db7320, error=0x7f8a20db7020, offsets_heap=0x629000596200, heap=0x629000591200, mrec=0x7f8a214a4005 "\200", mrec_end=0x7f8a214a406c "", offsets=0x60800004baa0) at storage/innobase/row/row0log.cc:2652
#10 0x00005612cd2f59b0 in row_log_table_apply_ops (thr=0x61a0005cb9c8, dup=0x7f8a20db7320, stage=0x60700003db90) at storage/innobase/row/row0log.cc:3026
#11 0x00005612cd2f6600 in row_log_table_apply (thr=0x61a0005cb9c8, old_table=0x617000020388, table=0x61f0002f4088, stage=0x60700003db90, new_table=0x617000434508) at storage/innobase/row/row0log.cc:3132
#12 0x00005612cd09d52f in ha_innobase::inplace_alter_table (this=0x61c0001d70a0, altered_table=0x61f0002f4088, ha_alter_info=0x7f8a20db82a0) at storage/innobase/handler/handler0alter.cc:7239
#13 0x00005612cc668530 in handler::ha_inplace_alter_table (this=0x61c0001d70a0, altered_table=0x61f0002f4088, ha_alter_info=0x7f8a20db82a0) at sql/handler.h:4183
#14 0x00005612cc651e44 in mysql_inplace_alter_table (thd=0x62a000198208, table_list=0x62b0000bd398, table=0x61f0002f4e88, altered_table=0x61f0002f4088, ha_alter_info=0x7f8a20db82a0, inplace_supported=HA_ALTER_INPLACE_COPY_NO_LOCK, target_mdl_request=0x7f8a20db8680, alter_ctx=0x7f8a20db9500) at sql/sql_table.cc:7557
#15 0x00005612cc65ece5 in mysql_alter_table (thd=0x62a000198208, new_db=0x62a00019c8c0, new_name=0x62a00019cc80, create_info=0x7f8a20dba200, table_list=0x62b0000bd398, alter_info=0x7f8a20dba120, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:9697
#16 0x00005612cc7a2303 in Sql_cmd_alter_table::execute (this=0x62b0000bdb08, thd=0x62a000198208) at sql/sql_alter.cc:491
#17 0x00005612cc45072b in mysql_execute_command (thd=0x62a000198208) at sql/sql_parse.cc:6283
#18 0x00005612cc45b5e1 in mysql_parse (thd=0x62a000198208, rawbuf=0x62b0000bd220 "ALTER TABLE t1 CHANGE COLUMN col_int col_int INTEGER, LOCK = DEFAULT /* E_R Thread2 QNO 70 CON_ID 16 */", length=103, parser_state=0x7f8a20dbbda0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8090
#19 0x00005612cc435d7f in dispatch_command (command=COM_QUERY, thd=0x62a000198208, packet=0x6290007d5209 "ALTER TABLE t1 CHANGE COLUMN col_int col_int INTEGER, LOCK = DEFAULT /* E_R Thread2 QNO 70 CON_ID 16 */ ", packet_length=104, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1850
#20 0x00005612cc432dd5 in do_command (thd=0x62a000198208) at sql/sql_parse.cc:1394


Generated at Thu Feb 08 08:38:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.