[Draft] Assertion failed: !trx || !lock_rec_other_trx_holds_expl( LOCK_S | 1024U, trx, rec, block)

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

# 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