Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 10.5(EOL)
-
None
Description
I'm filing it as minor, as I could only reproduce it with a debug sync point timeout, couldn't convert it into a send/kill test case or such. So, maybe the issue is related to the debug sync facility itself. If the analysis reveals something different, please adjust categories and priority as needed.
--source include/have_debug_sync.inc
|
|
|
SET @qcache= @@global.query_cache_type; |
SET @@global.query_cache_type=1; |
SET @@session.query_cache_type=1; |
|
|
CREATE TABLE t1 (a INT); |
CREATE TABLE t2 (b INT); |
|
|
SET debug_sync= 'wait_in_query_cache_store_query WAIT_FOR go TIMEOUT 1'; |
SELECT a FROM t1 JOIN t2; |
|
|
DROP TABLE t1, t2; |
SET @@global.query_cache_type= @qcache; |
|
main cbd6755869a725e39458893366c2204aef267d25 |
mariadbd: /data/bld/main-asan/storage/perfschema/pfs.cc:3695: void pfs_unlock_rwlock_v1(PSI_rwlock*): Assertion `pfs_rwlock == sanitize_rwlock(pfs_rwlock)' failed.
|
250425 14:40:46 [ERROR] /share8t/bld/main-asan/sql/mariadbd got signal 6 ;
|
|
|
#9 0x00007fb1b5453eb2 in __GI___assert_fail (assertion=0x55ec4c748360 "pfs_rwlock == sanitize_rwlock(pfs_rwlock)", file=0x55ec4c745ac0 "/data/bld/main-asan/storage/perfschema/pfs.cc", line=3695, function=0x55ec4c748300 "void pfs_unlock_rwlock_v1(PSI_rwlock*)") at ./assert/assert.c:101
|
#10 0x000055ec4ad59b2b in pfs_unlock_rwlock_v1 (rwlock=0xbebebebebebebebe) at /data/bld/main-asan/storage/perfschema/pfs.cc:3695
|
#11 0x000055ec499ec12f in inline_mysql_rwlock_unlock (that=0x7fb1a45d9a38) at /data/bld/main-asan/include/mysql/psi/mysql_thread.h:987
|
#12 0x000055ec49a0f6f8 in Query_cache_query::unlock_writing (this=0x7fb1a45d9a30) at /data/bld/main-asan/sql/sql_cache.cc:952
|
#13 0x000055ec499f3918 in Query_cache::store_query (this=0x55ec4e70be80 <query_cache>, thd=0x62c0000b0218, tables_used=0x62d000348b60) at /data/bld/main-asan/sql/sql_cache.cc:1578
|
#14 0x000055ec49b8fdcb in execute_sqlcom_select (thd=0x62c0000b0218, all_tables=0x62d000348b60) at /data/bld/main-asan/sql/sql_parse.cc:6190
|
#15 0x000055ec49b7fa3a in mysql_execute_command (thd=0x62c0000b0218, is_called_from_prepared_stmt=false) at /data/bld/main-asan/sql/sql_parse.cc:3979
|
#16 0x000055ec49b9a87c in mysql_parse (thd=0x62c0000b0218, rawbuf=0x62d000348438 "SELECT a FROM t1 JOIN t2", length=24, parser_state=0x7fb1a570ea30) at /data/bld/main-asan/sql/sql_parse.cc:7915
|
#17 0x000055ec49b71695 in dispatch_command (command=COM_QUERY, thd=0x62c0000b0218, packet=0x6290002a3219 "SELECT a FROM t1 JOIN t2", packet_length=24, blocking=true) at /data/bld/main-asan/sql/sql_parse.cc:1902
|
#18 0x000055ec49b6e39d in do_command (thd=0x62c0000b0218, blocking=true) at /data/bld/main-asan/sql/sql_parse.cc:1415
|
#19 0x000055ec4a06c5ed in do_handle_one_connection (connect=0x608000004438, put_in_cache=true) at /data/bld/main-asan/sql/sql_connect.cc:1415
|
#20 0x000055ec4a06c14c in handle_one_connection (arg=0x6080000043b8) at /data/bld/main-asan/sql/sql_connect.cc:1327
|
#21 0x000055ec4ad51324 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/main-asan/storage/perfschema/pfs.cc:2198
|
#22 0x00007fb1b54a81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#23 0x00007fb1b552885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
|
...
|
Connection ID (thread ID): 4
|
Status: KILL_CONNECTION
|
Query (0x62d000348438): SELECT a FROM t1 JOIN t2
|