[MDEV-12329] [Draft] Assertion failed: !trx || !lock_rec_other_trx_holds_expl( LOCK_S | 1024U, trx, rec, block) Created: 2017-03-22  Updated: 2018-11-11

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.2
Fix Version/s: None

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

Attachments: File master.err     File master.log.gz     File trial12.log.gz    

 Description   

http://buildbot.askmonty.org/buildbot/builders/win-rqg-se/builds/3318/steps/rqg_crash_tests/logs/stdio

10.2 76f6c1e1ed2c48594832e20035cd15fec9c35d94

2017-03-20 17:02:41 3448 [ERROR] mysqld.exe: Deadlock found when trying to get lock; try restarting transaction
Assertion failed: !trx || !lock_rec_other_trx_holds_expl( LOCK_S | 1024U, trx, rec, block), file E:\buildbot\bbwin1\win-rqg-se\build\storage\innobase\lock\lock0lock.cc, line 6901
abort() has been called170320 17:03:02 [ERROR] mysqld got exception 0x80000003 ;

mysqld.exe!_wassert()[assert.cpp:405]
mysqld.exe!lock_rec_convert_impl_to_expl()[lock0lock.cc:6900]
mysqld.exe!lock_sec_rec_read_check_and_lock()[lock0lock.cc:7121]
mysqld.exe!sel_set_rec_lock()[row0sel.cc:1261]
mysqld.exe!row_search_mvcc()[row0sel.cc:4984]
mysqld.exe!ha_innobase::index_read()[ha_innodb.cc:9995]
mysqld.exe!ha_innobase::index_first()[ha_innodb.cc:10424]
mysqld.exe!handler::ha_index_first()[handler.cc:2718]
mysqld.exe!join_read_first()[sql_select.cc:19399]
mysqld.exe!sub_select()[sql_select.cc:18414]
mysqld.exe!do_select()[sql_select.cc:17961]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:3463]
mysqld.exe!JOIN::exec()[sql_select.cc:3267]
mysqld.exe!mysql_select()[sql_select.cc:3660]
mysqld.exe!mysql_derived_fill()[sql_derived.cc:1047]
mysqld.exe!mysql_handle_single_derived()[sql_derived.cc:197]
mysqld.exe!st_join_table::preread_init()[sql_select.cc:11715]
mysqld.exe!sub_select()[sql_select.cc:18385]
mysqld.exe!do_select()[sql_select.cc:17961]
mysqld.exe!JOIN::exec_inner()[sql_select.cc:3463]
mysqld.exe!JOIN::exec()[sql_select.cc:3267]
mysqld.exe!mysql_select()[sql_select.cc:3660]
mysqld.exe!handle_select()[sql_select.cc:361]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3908]
mysqld.exe!mysql_parse()[sql_parse.cc:7858]
mysqld.exe!dispatch_command()[sql_parse.cc:1814]
mysqld.exe!do_command()[sql_parse.cc:1361]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:346]
mysqld.exe!tp_callback()[threadpool_common.cc:192]
mysqld.exe!tp_callback()[threadpool_win.cc:378]
mysqld.exe!work_callback()[threadpool_win.cc:452]
ntdll.dll!RtlFreeUnicodeString()
ntdll.dll!RtlFreeUnicodeString()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

Query (0x94b65b34a0): CREATE TABLE transforms.insert_select_3060 SELECT field1, field2, field3, field4 FROM ( SELECT field1, min(field2) as field2, max(field3) as field3, count(field4) as field4 FROM table_virtual GROUP BY field1 ) AS select1  /* QUERY_NO 13180 CON_ID 16 */  /* QUERY_NO 13197 CON_ID 16 */
Connection ID (thread ID): 16
Status: NOT_KILLED

Original RQG command line (not reproducible so far)

# seed => 1490018080
 
E:\buildbot\rqg/runall.pl --no-mask --seed=time --threads=5 --duration=600 --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/optimizer/updateable_views.yy --mysqld=--default-storage-engine=InnoDB --mysqld=--init-file=E:/buildbot/rqg/conf/optimizer/updateable_views.init --mtr-build-thread=300 --basedir1=D:\win-rqg-se\build-debug --vardir1=E:\buildbot\vardirs\10.2-3318\optim-crash-tests/current1_1



 Comments   
Comment by Elena Stepanova [ 2018-11-11 ]

New occurrence on 10.2: https://travis-ci.org/elenst/travis-tests/jobs/452487769

Generated at Thu Feb 08 07:56:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.