[MDEV-22046] ASAN failure around INSERT IGNORE Created: 2020-03-26  Updated: 2020-03-26  Resolved: 2020-03-26

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5.2
Fix Version/s: 10.5.3

Type: Bug Priority: Major
Reporter: Matthias Leich Assignee: Marko Mäkelä
Resolution: Duplicate Votes: 0
Labels: None

Attachments: Text File backtrace.txt     File mysql.err     File rqg.log    
Issue Links:
Duplicate
duplicates MDEV-21850 ASAN use-after-poison in page_cur_ins... Closed

 Description   

ASAN failure hit during RQG testing.
Per Marko the problem is caused by MDEV-12353 and/or MDEV-21724.



 Comments   
Comment by Matthias Leich [ 2020-03-26 ]

The current bug seems to be a sibling of MDEV-21850.
The diff seems to be that it occurs here on INSERT IGNORE.

Comment by Elena Stepanova [ 2020-03-26 ]

To make it searchable in JIRA:

#5  0x00007f8444393801 in __GI_abort () at abort.c:79
#6  0x00007f844647772e in ?? () from /usr/lib/x86_64-linux-gnu/libasan.so.4
#7  0x00007f844647f518 in ?? () from /usr/lib/x86_64-linux-gnu/libasan.so.4
#8  0x00007f8446460515 in ?? () from /usr/lib/x86_64-linux-gnu/libasan.so.4
#9  0x00007f8446461007 in __asan_report_load1 () from /usr/lib/x86_64-linux-gnu/libasan.so.4
#10 0x0000558bcae98a76 in page_cur_insert_rec_low (cur=0x7f84275fc1d8, index=0x6190000bff20, rec=0x61a000261127 "in", '\276' <repeats 198 times>..., offsets=0x7f84275fc290, mtr=0x7f84275fc510) at /home/mleich/bb-10.5-marko/storage/innobase/page/page0cur.cc:1569
#11 0x0000558bcb1f8ce7 in page_cur_tuple_insert (cursor=0x7f84275fc1d8, tuple=0x62100077da20, index=0x6190000bff20, offsets=0x7f84275fc0d0, heap=0x7f84275fc060, n_ext=0, mtr=0x7f84275fc510) at /home/mleich/bb-10.5-marko/storage/innobase/include/page0cur.ic:284
#12 0x0000558bcb210cce in btr_cur_optimistic_insert (flags=0, cursor=0x7f84275fc1d0, offsets=0x7f84275fc0d0, heap=0x7f84275fc060, entry=0x62100077da20, rec=0x7f84275fc110, big_rec=0x7f84275fc150, n_ext=0, thr=0x628000032438, mtr=0x7f84275fc510)
    at /home/mleich/bb-10.5-marko/storage/innobase/btr/btr0cur.cc:3531
#13 0x0000558bcaf7dd41 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x6190000bff20, offsets_heap=0x61a000261098, heap=0x61a000261698, entry=0x62100077da20, trx_id=0, thr=0x628000032438) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0ins.cc:3110
#14 0x0000558bcaf7ef8c in row_ins_sec_index_entry (index=0x6190000bff20, entry=0x62100077da20, thr=0x628000032438, check_foreign=true) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0ins.cc:3311
#15 0x0000558bcaf7f2fa in row_ins_index_entry (index=0x6190000bff20, entry=0x62100077da20, thr=0x628000032438) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0ins.cc:3358
#16 0x0000558bcaf80410 in row_ins_index_entry_step (node=0x6280000317a0, thr=0x628000032438) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0ins.cc:3525
#17 0x0000558bcaf80da2 in row_ins (node=0x6280000317a0, thr=0x628000032438) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0ins.cc:3661
#18 0x0000558bcaf81ea7 in row_ins_step (thr=0x628000032438) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0ins.cc:3804
#19 0x0000558bcafc9b12 in row_insert_for_mysql (mysql_rec=0x619000137eb8 "", prebuilt=0x6280000301a0, ins_mode=ROW_INS_NORMAL) at /home/mleich/bb-10.5-marko/storage/innobase/row/row0mysql.cc:1463
#20 0x0000558bcac51dd0 in ha_innobase::write_row (this=0x61d0000492b8, record=0x619000137eb8 "") at /home/mleich/bb-10.5-marko/storage/innobase/handler/ha_innodb.cc:7753
#21 0x0000558bca1933ec in handler::ha_write_row (this=0x61d0000492b8, buf=0x619000137eb8 "") at /home/mleich/bb-10.5-marko/sql/handler.cc:6857
#22 0x0000558bc98e9c66 in write_record (thd=0x62b00009a218, table=0x620000044098, info=0x7f84275fe6b0, sink=0x0) at /home/mleich/bb-10.5-marko/sql/sql_insert.cc:2061
#23 0x0000558bc98e1bf3 in mysql_insert (thd=0x62b00009a218, table_list=0x62b0000a12c0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true, result=0x0) at /home/mleich/bb-10.5-marko/sql/sql_insert.cc:1086
#24 0x0000558bc99a5b10 in mysql_execute_command (thd=0x62b00009a218) at /home/mleich/bb-10.5-marko/sql/sql_parse.cc:4515
#25 0x0000558bc99be74a in mysql_parse (thd=0x62b00009a218, 
    rawbuf=0x7f843117b838 "INSERT /*! IGNORE */ INTO table100_innodb_default VALUES \n ('a', 'mwjfukqjqmrxcnkyjtiuxoptxfhlakopdumpdxaqypnggkrjbsbgyyphhbvxdozizgxolivamusxvobexuooodietykbfflmlitttmtzkadfkhsfyshqrhhwyeravpncpipvhs"..., length=517149, 
    parser_state=0x7f84275ff8f0, is_com_multi=false, is_next_command=false) at /home/mleich/bb-10.5-marko/sql/sql_parse.cc:7953
#26 0x0000558bc99940d7 in dispatch_command (command=COM_QUERY, thd=0x62b00009a218, 
    packet=0x7f843138c819 "INSERT /*! IGNORE */ INTO table100_innodb_default VALUES \n ('a', 'mwjfukqjqmrxcnkyjtiuxoptxfhlakopdumpdxaqypnggkrjbsbgyyphhbvxdozizgxolivamusxvobexuooodietykbfflmlitttmtzkadfkhsfyshqrhhwyeravpncpipvhs"..., packet_length=517150, 
    is_com_multi=false, is_next_command=false) at /home/mleich/bb-10.5-marko/sql/sql_parse.cc:1839
#27 0x0000558bc9990a72 in do_command (thd=0x62b00009a218) at /home/mleich/bb-10.5-marko/sql/sql_parse.cc:1358
#28 0x0000558bc9db5f3d in do_handle_one_connection (connect=0x608000003738, put_in_cache=true) at /home/mleich/bb-10.5-marko/sql/sql_connect.cc:1422
#29 0x0000558bc9db57d9 in handle_one_connection (arg=0x6080000036b8) at /home/mleich/bb-10.5-marko/sql/sql_connect.cc:1319
#30 0x0000558bcaa6037b in pfs_spawn_thread (arg=0x615000004918) at /home/mleich/bb-10.5-marko/storage/perfschema/pfs.cc:2201
#31 0x00007f844528e6db in start_thread (arg=0x7f8427601300) at pthread_create.c:463
#32 0x00007f844447488f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Comment by Marko Mäkelä [ 2020-03-26 ]

This turned out to be a duplicate of MDEV-21850. Sorry for not attending that earlier; I kind of forgot that it was open.

Generated at Thu Feb 08 09:11:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.