DEADLOCK of threads detected: row0sel.cc S-LOCK / btr0cur.cc S-LOCK / row0quiesce.cc X-LOCK

DEADLOCK of threads detected!

rw-lock 0x7f6a5405f800 --Thread 140088265795328 has waited at row0sel.cc line 3509 for 0.00 seconds the semaphore:

X-lock (wait_ex) on RW-latch at 0x7f6a5405f800 created in file buf0buf.cc line 1286

a writer (thread id 140088265795328) has reserved it in mode  wait exclusive

number of readers 1, waiters flag 0, lock_word: ffffffff

Last time write locked in file row0sel.cc line 3509

Locked: thread 140088269248256 file row0sel.cc line 3509  S-LOCK

Locked: thread 140088269248256 file row0sel.cc line 3509  S-LOCK

rw-lock 0x7f68dc1a1b58 --Thread 140090090170112 has waited at row0quiesce.cc line 666 for 0.00 seconds the semaphore:

X-lock (wait_ex) on RW-latch at 0x7f68dc1a1b58 created in file dict0dict.cc line 2155

a writer (thread id 140090090170112) has reserved it in mode  wait exclusive

number of readers 1, waiters flag 0, lock_word: ffffffff

Last time write locked in file btr0cur.cc line 1468

Locked: thread 140088265795328 file btr0cur.cc line 1499  S-LOCK

Locked: thread 140088265795328 file btr0cur.cc line 1499  S-LOCK

rw-lock 0x5595755bb218 --Thread 140088269248256 has waited at btr0cur.cc line 1499 for 0.00 seconds the semaphore:

S-lock on RW-latch at 0x5595755bb218 created in file dict0dict.cc line 2155

a writer (thread id 140090090170112) has reserved it in mode  exclusive

number of readers 0, waiters flag 1, lock_word: 0

Last time write locked in file row0quiesce.cc line 666

Locked: thread 140090090170112 file row0quiesce.cc line 666  X-LOCK

2020-06-14  0:07:40 22 [ERROR] [FATAL] InnoDB: ######################################## Deadlock Detected!

#1  0x00007f6a79220801 in __GI_abort () at abort.c:79

#2  0x000055956fd693bd in ib::fatal::~fatal (this=0x7f68d7865520, __in_chrg=<optimized out>) at /home/mariadb/deadlock_detected/10.5/storage/innobase/ut/ut0ut.cc:586

#3  0x000055956fd020c2 in sync_array_wait_event (arr=0x559572023268, cell=@0x7f68d78656e0: 0x559572023778) at /home/mariadb/deadlock_detected/10.5/storage/innobase/sync/sync0arr.cc:447

#4  0x000055956fd069af in rw_lock_s_lock_spin (lock=0x5595755bb218, pass=0, file_name=0x5595704c1210 "/home/mariadb/deadlock_detected/10.5/storage/innobase/btr/btr0cur.cc", line=1499)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/sync/sync0rw.cc:367

#5  0x000055956fc4e71e in rw_lock_s_lock_func (lock=0x5595755bb218, pass=0, file_name=0x5595704c1210 "/home/mariadb/deadlock_detected/10.5/storage/innobase/btr/btr0cur.cc", line=1499)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/include/sync0rw.ic:308

#6  0x000055956fc4e7d0 in pfs_rw_lock_s_lock_func (lock=0x5595755bb218, pass=0, file_name=0x5595704c1210 "/home/mariadb/deadlock_detected/10.5/storage/innobase/btr/btr0cur.cc", 

    line=1499) at /home/mariadb/deadlock_detected/10.5/storage/innobase/include/sync0rw.ic:658

#7  0x000055956fc5f19b in mtr_t::s_lock (this=0x7f68d7866df0, lock=0x5595755bb218, file=0x5595704c1210 "/home/mariadb/deadlock_detected/10.5/storage/innobase/btr/btr0cur.cc", 

    line=1499) at /home/mariadb/deadlock_detected/10.5/storage/innobase/include/mtr0mtr.h:222

#8  0x000055956fd9f425 in btr_cur_search_to_nth_level_func (index=0x5595755bb018, level=0, tuple=0x7f68ec3354a0, mode=PAGE_CUR_LE, latch_mode=1, cursor=0x7f68ec334e90, ahi_latch=0x0, 

    file=0x559570471258 "/home/mariadb/deadlock_detected/10.5/storage/innobase/row/row0sel.cc", line=3256, mtr=0x7f68d7866df0, autoinc=0)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/btr/btr0cur.cc:1499

#9  0x000055956fcbfb02 in btr_pcur_open_with_no_init_func (index=0x5595755bb018, tuple=0x7f68ec3354a0, mode=PAGE_CUR_LE, latch_mode=1, cursor=0x7f68ec334e90, ahi_latch=0x0, 

    file=0x559570471258 "/home/mariadb/deadlock_detected/10.5/storage/innobase/row/row0sel.cc", line=3256, mtr=0x7f68d7866df0)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/include/btr0pcur.ic:504

#10 0x000055956fcc8f0e in Row_sel_get_clust_rec_for_mysql::operator() (this=0x7f68d78669e0, prebuilt=0x7f68ec334bc8, sec_index=0x7f68dc1a1958, 

    rec=0x7f6a581c1055 "a", ' ' <repeats 199 times>..., thr=0x7f68ec3356b8, out_rec=0x7f68d7866910, offsets=0x7f68d7866930, offset_heap=0x7f68d7866928, vrow=0x0, mtr=0x7f68d7866df0)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/row/row0sel.cc:3254

#11 0x000055956fccef25 in row_search_mvcc (buf=0x7f68ec200550 "\217\207\217", mode=PAGE_CUR_G, prebuilt=0x7f68ec334bc8, match_mode=0, direction=1)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/row/row0sel.cc:5244

#12 0x000055956fad21e8 in ha_innobase::general_fetch (this=0x7f68ec14da60, buf=0x7f68ec200550 "\217\207\217", direction=1, match_mode=0)

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/handler/ha_innodb.cc:9227

#13 0x000055956fad2466 in ha_innobase::index_next (this=0x7f68ec14da60, buf=0x7f68ec200550 "\217\207\217")

    at /home/mariadb/deadlock_detected/10.5/storage/innobase/handler/ha_innodb.cc:9294

#14 0x000055956f6725f3 in handler::ha_index_next (this=0x7f68ec14da60, buf=0x7f68ec200550 "\217\207\217") at /home/mariadb/deadlock_detected/10.5/sql/handler.cc:3096

#15 0x000055956f397f5d in join_read_next (info=0x7f68ec0795e0) at /home/mariadb/deadlock_detected/10.5/sql/sql_select.cc:21618

#16 0x000055956f25fc6b in READ_RECORD::read_record (this=0x7f68ec0795e0) at /home/mariadb/deadlock_detected/10.5/sql/records.h:79

#17 0x000055956f3956ee in sub_select (join=0x7f68ec1fad10, join_tab=0x7f68ec079518, end_of_records=false) at /home/mariadb/deadlock_detected/10.5/sql/sql_select.cc:20613

#18 0x000055956f394a91 in do_select (join=0x7f68ec1fad10, procedure=0x0) at /home/mariadb/deadlock_detected/10.5/sql/sql_select.cc:20128

#19 0x000055956f368a79 in JOIN::exec_inner (this=0x7f68ec1fad10) at /home/mariadb/deadlock_detected/10.5/sql/sql_select.cc:4444

#20 0x000055956f367ba5 in JOIN::exec (this=0x7f68ec1fad10) at /home/mariadb/deadlock_detected/10.5/sql/sql_select.cc:4225

#21 0x000055956f4326f9 in st_select_lex_unit::exec (this=0x7f68ec02a280) at /home/mariadb/deadlock_detected/10.5/sql/sql_union.cc:2196

#22 0x000055956f42ae79 in mysql_union (thd=0x7f68ec026268, lex=0x7f68ec02a1b8, result=0x7f68ec1fabd0, unit=0x7f68ec02a280, setup_tables_done_option=0)

    at /home/mariadb/deadlock_detected/10.5/sql/sql_union.cc:41

#23 0x000055956f358edf in handle_select (thd=0x7f68ec026268, lex=0x7f68ec02a1b8, result=0x7f68ec1fabd0, setup_tables_done_option=0)

    at /home/mariadb/deadlock_detected/10.5/sql/sql_select.cc:407

#24 0x000055956f31e5a5 in execute_sqlcom_select (thd=0x7f68ec026268, all_tables=0x7f68ec031428) at /home/mariadb/deadlock_detected/10.5/sql/sql_parse.cc:6208

#25 0x000055956f3158d6 in mysql_execute_command (thd=0x7f68ec026268) at /home/mariadb/deadlock_detected/10.5/sql/sql_parse.cc:3939

#26 0x000055956f3233f1 in mysql_parse (thd=0x7f68ec026268, 

    rawbuf=0x7f68ec030a90 "/* QNO 1386 CON_ID 22  GenTest::Transform::ExecuteAsUnion  */ ( SELECT /* QNO 1375 CON_ID 22 */ `col_char_255_utf8_key` FROM `view_table100_int_autoinc` ) UNION ALL ( SELECT /* QNO 1375 CON_ID 22 */ `"..., length=305, parser_state=0x7f68d7868510, is_com_multi=false, is_next_command=false)

    at /home/mariadb/deadlock_detected/10.5/sql/sql_parse.cc:7992

#27 0x000055956f30f77e in dispatch_command (command=COM_QUERY, thd=0x7f68ec026268, packet=0x7f68ec01c499 "", packet_length=305, is_com_multi=false, is_next_command=false)

    at /home/mariadb/deadlock_detected/10.5/sql/sql_parse.cc:1874

#28 0x000055956f30deb5 in do_command (thd=0x7f68ec026268) at /home/mariadb/deadlock_detected/10.5/sql/sql_parse.cc:1355

#29 0x000055956f4b2751 in do_handle_one_connection (connect=0x5595755b19e8, put_in_cache=true) at /home/mariadb/deadlock_detected/10.5/sql/sql_connect.cc:1411

#30 0x000055956f4b24b5 in handle_one_connection (arg=0x5595755b19e8) at /home/mariadb/deadlock_detected/10.5/sql/sql_connect.cc:1313

---Type <return> to continue, or q <return> to quit---

#31 0x000055956f9ed777 in pfs_spawn_thread (arg=0x5595755b1ac8) at /home/mariadb/deadlock_detected/10.5/storage/perfschema/pfs.cc:2201

#32 0x00007f6a7a11b6db in start_thread (arg=0x7f68d7869700) at pthread_create.c:463

#33 0x00007f6a7930188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95