Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3(EOL)
-
None
Description
10.3 c2352c45fbd670f50b73415eeeb676aa67fb4a29 |
mysqld: /data/src/10.3/storage/innobase/lock/lock0lock.cc:4985: bool lock_rec_queue_validate(bool, const buf_block_t*, const rec_t*, const dict_index_t*, const ulint*): Assertion `lock_get_wait(other_lock)' failed.
|
180517 14:00:38 [ERROR] mysqld got signal 6 ;
|
 |
#7 0x00007f8036f78312 in __GI___assert_fail (assertion=0x7f803a42a30f "lock_get_wait(other_lock)", file=0x7f803a4283d8 "/data/src/10.3/storage/innobase/lock/lock0lock.cc", line=4985, function=0x7f803a42f440 <lock_rec_queue_validate(bool, buf_block_t const*, unsigned char const*, dict_index_t const*, unsigned long const*)::__PRETTY_FUNCTION__> "bool lock_rec_queue_validate(bool, const buf_block_t*, const rec_t*, const dict_index_t*, const ulint*)") at assert.c:101
|
#8 0x00007f8039c9a8bc in lock_rec_queue_validate (locked_lock_trx_sys=false, block=0x7f8021425d00, rec=0x7f8025318158 "\200", index=0x7f7fb40e12c8, offsets=0x7f80346871d0) at /data/src/10.3/storage/innobase/lock/lock0lock.cc:4985
|
#9 0x00007f8039c9d813 in lock_clust_rec_read_check_and_lock (flags=0, block=0x7f8021425d00, rec=0x7f8025318158 "\200", index=0x7f7fb40e12c8, offsets=0x7f80346871d0, mode=LOCK_X, gap_mode=0, thr=0x7f7fb0031a20) at /data/src/10.3/storage/innobase/lock/lock0lock.cc:5862
|
#10 0x00007f8039d9b278 in sel_set_rec_lock (pcur=0x7f7fb0031458, rec=0x7f8025318158 "\200", index=0x7f7fb40e12c8, offsets=0x7f80346871d0, mode=3, type=0, thr=0x7f7fb0031a20, mtr=0x7f80346874f0) at /data/src/10.3/storage/innobase/row/row0sel.cc:1249
|
#11 0x00007f8039da4439 in row_search_mvcc (buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177", mode=PAGE_CUR_G, prebuilt=0x7f7fb0031288, match_mode=0, direction=1) at /data/src/10.3/storage/innobase/row/row0sel.cc:5023
|
#12 0x00007f8039c153e3 in ha_innobase::general_fetch (this=0x7f7fb00b9378, buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177", direction=1, match_mode=0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9642
|
#13 0x00007f8039c15964 in ha_innobase::rnd_next (this=0x7f7fb00b9378, buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:9851
|
#14 0x00007f80399bd763 in handler::ha_rnd_next (this=0x7f7fb00b9378, buf=0x7f7fb00bd5f8 "\370\001 \250'\023\270\177\177") at /data/src/10.3/sql/handler.cc:2764
|
#15 0x00007f8039b3e6a1 in rr_sequential (info=0x7f8034687d80) at /data/src/10.3/sql/records.cc:481
|
#16 0x00007f80396344f5 in READ_RECORD::read_record (this=0x7f8034687d80) at /data/src/10.3/sql/records.h:73
|
#17 0x00007f8039b5c1b9 in mysql_delete (thd=0x7f7fb8000b00, table_list=0x7f7fb80139f8, conds=0x7f7fb8014540, order_list=0x7f7fb8005370, limit=18446744073709551615, options=549755813888, result=0x0) at /data/src/10.3/sql/sql_delete.cc:729
|
#18 0x00007f80396cfee5 in mysql_execute_command (thd=0x7f7fb8000b00) at /data/src/10.3/sql/sql_parse.cc:4923
|
#19 0x00007f80396d9cd1 in mysql_parse (thd=0x7f7fb8000b00, rawbuf=0x7f7fb80138b8 "DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 45913 CON_ID 17 */", length=72, parser_state=0x7f8034689630, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8019
|
#20 0x00007f80396c7113 in dispatch_command (command=COM_QUERY, thd=0x7f7fb8000b00, packet=0x7f7fb800b0f1 "DELETE FROM t1 WHERE col3 = 3 OR col3 IS NULL /* QNO 45913 CON_ID 17 */ ", packet_length=73, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
|
#21 0x00007f80396c5b37 in do_command (thd=0x7f7fb8000b00) at /data/src/10.3/sql/sql_parse.cc:1391
|
#22 0x00007f803982aebb in do_handle_one_connection (connect=0x7f803c7b1090) at /data/src/10.3/sql/sql_connect.cc:1402
|
#23 0x00007f803982ac3f in handle_one_connection (arg=0x7f803c7b1090) at /data/src/10.3/sql/sql_connect.cc:1308
|
#24 0x00007f8038bdf064 in start_thread (arg=0x7f803468a700) at pthread_create.c:309
|
#25 0x00007f803703262d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
experimenal 6c40fc679d99de2a34ba7e3b6ac807b84be5942a |
perl ./runall-trials.pl --trials=50 --duration=400 --threads=6 --seed=1526336244 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/sequences.yy --basedir=/data/bld/10.3 --grammar=conf/runtime/alter_online.yy --gendata=conf/runtime/alter_online.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/dev/shm/vardir2 --mysqld=--lock-wait-timeout=5 --mysqld=--innodb-lock-wait-timeout=4
|
Happened on the 2nd trial.
Attachments
Issue Links
- relates to
-
MDEV-20605 Awaken transaction can miss inserted by other transaction records due to wrong persistent cursor restoration
- Closed