[MDEV-14097] [Draft] Assertion `rec_get_deleted_flag(rec, dict_table_is_comp(cursor->index->table))' failed Created: 2017-10-20  Updated: 2019-02-01  Resolved: 2019-02-01

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Duplicate Votes: 0
Labels: None

Attachments: File master.err     File master.log    
Issue Links:
Duplicate
duplicates MDEV-14066 [Draft] Assertion failed: rec_get_del... Closed
is duplicated by MDEV-14066 [Draft] Assertion failed: rec_get_del... Closed

 Description   

10.3 3722372ae56b7ea

mysqld: /data/src/10.3/storage/innobase/row/row0ins.cc:349: dberr_t row_ins_clust_index_entry_by_modify(btr_pcur_t*, ulint, ulint, ulint**, mem_heap_t**, mem_heap_t*, const dtuple_t*, que_thr_t*, mtr_t*): Assertion `rec_get_deleted_flag(rec, dict_table_is_comp(cursor->index->table))' failed.
 
#7  0x00007fa9c6781ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055e7863d3203 in row_ins_clust_index_entry_by_modify (pcur=0x7fa9c485e1e0, flags=0, mode=2, offsets=0x7fa9c485e178, offsets_heap=0x7fa9c485e170, heap=0x7fa94c068360, entry=0x7fa94c089388, thr=0x7fa94c0542c0, mtr=0x7fa9c485e600) at /data/src/10.3/storage/innobase/row/row0ins.cc:348
#9  0x000055e7863d9158 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7fa954061718, n_uniq=1, entry=0x7fa94c089388, n_ext=0, thr=0x7fa94c0542c0, dup_chk_only=false) at /data/src/10.3/storage/innobase/row/row0ins.cc:2727
#10 0x000055e7863daa9f in row_ins_clust_index_entry (index=0x7fa954061718, entry=0x7fa94c089388, thr=0x7fa94c0542c0, n_ext=0, dup_chk_only=false) at /data/src/10.3/storage/innobase/row/row0ins.cc:3244
#11 0x000055e7863daede in row_ins_index_entry (index=0x7fa954061718, entry=0x7fa94c089388, thr=0x7fa94c0542c0) at /data/src/10.3/storage/innobase/row/row0ins.cc:3359
#12 0x000055e7863db48c in row_ins_index_entry_step (node=0x7fa94c053ff0, thr=0x7fa94c0542c0) at /data/src/10.3/storage/innobase/row/row0ins.cc:3509
#13 0x000055e7863db867 in row_ins (node=0x7fa94c053ff0, thr=0x7fa94c0542c0) at /data/src/10.3/storage/innobase/row/row0ins.cc:3651
#14 0x000055e7863dc0bc in row_ins_step (thr=0x7fa94c0542c0) at /data/src/10.3/storage/innobase/row/row0ins.cc:3855
#15 0x000055e7863fb430 in row_insert_for_mysql (mysql_rec=0x7fa94c02d028 "\377", prebuilt=0x7fa94c053a08) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1489
#16 0x000055e7862a0d9c in ha_innobase::write_row (this=0x7fa94c03ec98, record=0x7fa94c02d028 "\377") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8347
#17 0x000055e785f83451 in handler::ha_write_row (this=0x7fa94c03ec98, buf=0x7fa94c02d028 "\377") at /data/src/10.3/sql/handler.cc:6022
#18 0x000055e785c8625f in write_record (thd=0x7fa94c000b00, table=0x7fa94c03bb50, info=0x7fa9c485f400) at /data/src/10.3/sql/sql_insert.cc:1929
#19 0x000055e785c83be4 in mysql_insert (thd=0x7fa94c000b00, table_list=0x7fa94c013958, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.3/sql/sql_insert.cc:1057
#20 0x000055e785cb71f2 in mysql_execute_command (thd=0x7fa94c000b00) at /data/src/10.3/sql/sql_parse.cc:4684
#21 0x000055e785cc1a1c in mysql_parse (thd=0x7fa94c000b00, rawbuf=0x7fa94c0136e8 "INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount))  /* QNO 517 CON_ID 19 */", length=200, parser_state=0x7fa9c4860660, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7921
#22 0x000055e785caf1bd in dispatch_command (command=COM_QUERY, thd=0x7fa94c000b00, packet=0x7fa94c00ae01 " INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount))  /* QNO 517 CON_ID 19 *"..., packet_length=202, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1819
#23 0x000055e785cadc1b in do_command (thd=0x7fa94c000b00) at /data/src/10.3/sql/sql_parse.cc:1370
#24 0x000055e785e049f4 in do_handle_one_connection (connect=0x55e789795400) at /data/src/10.3/sql/sql_connect.cc:1418
#25 0x000055e785e04781 in handle_one_connection (arg=0x55e789795400) at /data/src/10.3/sql/sql_connect.cc:1324
#26 0x00007fa9c86c6494 in start_thread (arg=0x7fa9c4861700) at pthread_create.c:333
#27 0x00007fa9c683e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fa94c0136e8): INSERT INTO t1 (col1,col2,col3,col4) VALUES /* NULL */ (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount)), (NULL,NULL,NULL,REPEAT(CAST(NULL AS CHAR(1)),@fill_amount))  /* QNO 517 CON_ID 19 */
Connection ID (thread ID): 19
Status: NOT_KILLED

perl ./runall.pl --no-mask --seed=1508496021 --threads=5 --duration=400 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --redefine=conf/mariadb/redefine_random_keys.yy --redefine=conf/mariadb/redefine_set_session_vars.yy --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,DisableOptimizations,EnableOptimizations,ExecuteAsCTE,ExecuteAsInsertSelect,ExecuteAsPreparedOnce,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,NullIf,OrderBy,StraightJoin,ExecuteAsExecuteImmediate --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --mtr-build-thread=150 --basedir1=/data/bld/10.3  --vardir1=/data/logs/analyze11

Not easily reproducible



 Comments   
Comment by Marko Mäkelä [ 2018-02-21 ]

Possibly a duplicate of MDEV-14111, if the workload included ADD COLUMN.
Otherwise, related to MDEV-9663 and MDEV-14643.

Comment by Marko Mäkelä [ 2018-02-21 ]

This looks very similar to MDEV-14066.

Comment by Elena Stepanova [ 2019-02-01 ]

Same as MDEV-14066.

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