[MDEV-25094] main.query_cache_debug: Assertion `0' failed Created: 2021-03-09  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Query Cache, Tests
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Aleksey Midenkov Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-15281 main.query_cache_debug failed in buil... Closed

 Description   

http://buildbot.askmonty.org/buildbot/reports/cross_reference#branch=&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=^main.query_cache_debug&fail_variant=&fail_info_short=&fail_info_full=query_cache_size&limit=25

CURRENT_TEST: main.query_cache_debug
mysqltest: At line 345: query 'SET GLOBAL query_cache_size=@save_query_cache_size' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
SET GLOBAL query_cache_type= 1;
connect  con2,localhost,root,,test;
connect  con1,localhost,root,,test;

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/27370/steps/mtr_ps/logs/stdio

Thread 1 (Thread 0xb34d7b40 (LWP 32715)):
#0  0xb77bcc31 in __kernel_vsyscall ()
#1  0xb73a2ce1 in pthread_kill () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x812f7f83 in my_write_core (sig=6) at /home/buildbot/buildbot/build/mariadb-10.6.0/mysys/stacktrace.c:424
#3  0x80a51465 in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/mariadb-10.6.0/sql/signal_handler.cc:330
#4  <signal handler called>
#5  0xb77bcc31 in __kernel_vsyscall ()
#6  0xb701ce89 in raise () from /lib/i386-linux-gnu/libc.so.6
#7  0xb701e3e7 in abort () from /lib/i386-linux-gnu/libc.so.6
#8  0xb7015d07 in ?? () from /lib/i386-linux-gnu/libc.so.6
#9  0xb7015d8b in __assert_fail () from /lib/i386-linux-gnu/libc.so.6
#10 0x806490e7 in Query_cache::end_of_result (this=0x81f0c7e0 <query_cache>, thd=0xb0901918) at /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_cache.cc:1220
#11 0x806d55d0 in dispatch_command (command=COM_QUERY, thd=0xb0901918, packet=0xb0905c19 "", packet_length=69) at /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:2329
#12 0x806d1f54 in do_command (thd=0xb0901918) at /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_parse.cc:1366
#13 0x8088c7d2 in do_handle_one_connection (connect=0x8429e1c0, put_in_cache=true) at /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_connect.cc:1410
#14 0x8088c4ed in handle_one_connection (arg=0x8429e1c0) at /home/buildbot/buildbot/build/mariadb-10.6.0/sql/sql_connect.cc:1312
#15 0x80d8e4fe in pfs_spawn_thread (arg=0x841dc208) at /home/buildbot/buildbot/build/mariadb-10.6.0/storage/perfschema/pfs.cc:2201
#16 0xb739c2b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#17 0xb70d816e in clone () from /lib/i386-linux-gnu/libc.so.6



 Comments   
Comment by Alice Sherepa [ 2021-06-07 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/29205/steps/mtr_ps/logs/stdio

main.query_cache_debug                   w2 [ fail ]
        Test ended at 2021-06-06 03:00:10
 
CURRENT_TEST: main.query_cache_debug
mysqltest: At line 345: query 'SET GLOBAL query_cache_size=@save_query_cache_size' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
SET GLOBAL query_cache_type= 1;
connect  con2,localhost,root,,test;
connect  con1,localhost,root,,test;
set debug_sync="wait_in_query_cache_store_query SIGNAL parked WAIT_FOR go";
SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k;
connection default;
set debug_sync="now WAIT_FOR parked";
connection con2;
SET GLOBAL query_cache_type= 0;;
connection default;
set debug_sync="now SIGNAL go";
connection con1;
id
connection con2;
disconnect con1;
disconnect con2;
connection default;
set debug_sync= 'RESET';
DROP TABLE t1;
SET GLOBAL query_cache_size=@save_query_cache_size;
 
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.5.11/mysql-test/var/2/log/query_cache_debug.log
 
 
Server [mysqld.1 - pid: 28841, winpid: 28841, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
mariadbd: /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_cache.cc:1220: void Query_cache::end_of_result(THD*): Assertion `0' failed.
210606  3:00:09 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
 
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
 
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.
 
Server version: 10.5.11-MariaDB-debug-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=3
max_threads=153
thread_count=4
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62313 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0xb0805920
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0xb34521e0 thread_stack 0x49000
mysys/stacktrace.c:212(my_print_stacktrace)[0x8123285a]
sql/signal_handler.cc:222(handle_fatal_signal)[0x8094c52d]
addr2line: '': No such file
[0xb7737c14]
[0xb7737c31]
??:0(gsignal)[0xb6f97e89]
??:0(abort)[0xb6f993e7]
??:0(uselocale)[0xb6f90d07]
??:0(__assert_fail)[0xb6f90d8b]
sql/sql_cache.cc:1221(Query_cache::end_of_result(THD*))[0x80568e21]
sql/sql_parse.cc:2478(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x805f399d]
sql/sql_parse.cc:1371(do_command(THD*))[0x805efab6]
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x8078ae4a]
sql/sql_connect.cc:1312(handle_one_connection)[0x8078ab65]
perfschema/pfs.cc:2201(pfs_spawn_thread)[0x80c8987a]
??:0(start_thread)[0xb73172b5]
??:0(clone)[0xb705316e]
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0xb0813e80): SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k
 
Connection ID (thread ID): 28
Status: NOT_KILLED
 
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
 
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /dev/shm/var_auto_dkmT/2/mysqld.1/data
Resource Limits:
Limit                     Soft Limit           Hard Limit           Units     
Max cpu time              unlimited            unlimited            seconds   
Max file size             unlimited            unlimited            bytes     
Max data size             unlimited            unlimited            bytes     
Max stack size            8388608              unlimited            bytes     
Max core file size        unlimited            unlimited            bytes     
Max resident set          unlimited            unlimited            bytes     
Max processes             64511                64511                processes 
Max open files            1024                 1024                 files     
Max locked memory         65536                65536                bytes     
Max address space         unlimited            unlimited            bytes     
Max file locks            unlimited            unlimited            locks     
Max pending signals       64511                64511                signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Max realtime timeout      unlimited            unlimited            us        
Core pattern: |/usr/share/apport/apport %p %s %c %P
 
----------SERVER LOG END-------------
 
 
 - found 'core' (0/0)
 
Trying 'dbx' to get a backtrace
 
Trying 'gdb' to get a backtrace from coredump /mnt/buildbot/build/mariadb-10.5.11/mysql-test/var/2/log/main.query_cache_debug/mysqld.1/data/core
Core generated by '/mnt/buildbot/build/mariadb-10.5.11/sql/mariadbd'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
[New LWP 30737]
[New LWP 28849]
[New LWP 30738]
[New LWP 30741]
[New LWP 28846]
[New LWP 28845]
[New LWP 28844]
[New LWP 28843]
[New LWP 28842]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/i386-linux-gnu/libthread_db.so.1".
Core was generated by `/mnt/buildbot/build/mariadb-10.5.11/sql/mariadbd --defaults-group-suffix=.1 --d'.
Program terminated with signal SIGABRT, Aborted.
#0  0xb7737c31 in __kernel_vsyscall ()
[Current thread is 1 (Thread 0xb3452b40 (LWP 30737))]
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731dce1 in pthread_kill () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x81232954 in my_write_core (sig=6) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/stacktrace.c:424
#3  0x8094c89b in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/signal_handler.cc:343
#4  <signal handler called>
#5  0xb7737c31 in __kernel_vsyscall ()
#6  0xb6f97e89 in raise () from /lib/i386-linux-gnu/libc.so.6
#7  0xb6f993e7 in abort () from /lib/i386-linux-gnu/libc.so.6
#8  0xb6f90d07 in ?? () from /lib/i386-linux-gnu/libc.so.6
#9  0xb6f90d8b in __assert_fail () from /lib/i386-linux-gnu/libc.so.6
#10 0x80568e21 in Query_cache::end_of_result (this=0x81e6b140 <query_cache>, thd=0xb0805920) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_cache.cc:1220
#11 0x805f399d in dispatch_command (command=COM_QUERY, thd=0xb0805920, packet=0xb080b769 "", packet_length=69, is_com_multi=false, is_next_command=false) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:2478
#12 0x805efab6 in do_command (thd=0xb0805920) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:1371
#13 0x8078ae4a in do_handle_one_connection (connect=0x83ebfdf8, put_in_cache=true) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1410
#14 0x8078ab65 in handle_one_connection (arg=0x83ebfdf8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1312
#15 0x80c8987a in pfs_spawn_thread (arg=0x83e06ae8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#16 0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#17 0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 9 (Thread 0xb6dd9a40 (LWP 28842)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb7048f8f in poll () from /lib/i386-linux-gnu/libc.so.6
#2  0x804b6722 in handle_connections_sockets () at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/mysqld.cc:6204
#3  0x804b5c20 in mysqld_main (argc=147, argv=0x83bc51e4) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/mysqld.cc:5653
#4  0x804aa0eb in main (argc=6, argv=0xbfb62904) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/main.cc:25
 
Thread 8 (Thread 0xb3354b40 (LWP 28843)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731ce56 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x81237585 in safe_cond_timedwait (cond=0x82709cc0 <COND_timer>, mp=0x82709c40 <LOCK_timer>, abstime=0xb3354210, file=0x817bbc78 "/home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h", line=1259) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_mutex.c:546
#3  0x81238537 in inline_mysql_cond_timedwait (that=0x82709cc0 <COND_timer>, mutex=0x82709c40 <LOCK_timer>, abstime=0xb3354210, src_file=0x817bbcc8 "/home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_timer.c", src_line=321) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h:1259
#4  0x81239255 in timer_handler (arg=0x0) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_timer.c:321
#5  0x80c8987a in pfs_spawn_thread (arg=0x83d026b8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#6  0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#7  0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 7 (Thread 0xb2726b40 (LWP 28844)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731ce56 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x81237585 in safe_cond_timedwait (cond=0x82696aa0 <COND_checkpoint>, mp=0x82696a20 <LOCK_checkpoint>, abstime=0xb272615c, file=0x8159b3b8 "/home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h", line=1259) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_mutex.c:546
#3  0x80be04ef in inline_mysql_cond_timedwait (that=0x82696aa0 <COND_checkpoint>, mutex=0x82696a20 <LOCK_checkpoint>, abstime=0xb272615c, src_file=0x8159b408 "/home/buildbot/buildbot/build/mariadb-10.5.11/storage/maria/ma_servicethread.c", src_line=116) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h:1259
#4  0x80be0a54 in my_service_thread_sleep (control=0x81cbb138 <checkpoint_control>, sleep_time=30000000000) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/maria/ma_servicethread.c:115
#5  0x80bd3fd8 in ma_checkpoint_background (arg=0x1e) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/maria/ma_checkpoint.c:707
#6  0x80c8987a in pfs_spawn_thread (arg=0x83d8c0a0) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#7  0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#8  0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 6 (Thread 0xb1b98b40 (LWP 28845)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb6f98e8c in sigwaitinfo () from /lib/i386-linux-gnu/libc.so.6
#2  0x804aa1a4 in my_sigwait (set=0xb1b98190, sig=0xb1b98160, code=0xb1b98164) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/my_pthread.h:196
#3  0x804afc0a in signal_hand (arg=0x0) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/mysqld.cc:2957
#4  0x80c8987a in pfs_spawn_thread (arg=0x83e02720) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#5  0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#6  0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 5 (Thread 0xb1b4eb40 (LWP 28846)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731ca8c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x812372da in safe_cond_wait (cond=0x81e6e660 <COND_manager>, mp=0x81e6e5e0 <LOCK_manager>, file=0x81336d20 "/home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h", line=1222) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_mutex.c:492
#3  0x805ea7e8 in inline_mysql_cond_wait (that=0x81e6e660 <COND_manager>, mutex=0x81e6e5e0 <LOCK_manager>, src_file=0x8133735c "/home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_manager.cc", src_line=103) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h:1222
#4  0x805eac9b in handle_manager (arg=0x0) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_manager.cc:103
#5  0x80c8987a in pfs_spawn_thread (arg=0x83e83cd8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#6  0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#7  0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 4 (Thread 0xb33beb40 (LWP 30741)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731ce56 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x81237585 in safe_cond_timedwait (cond=0x81e68100 <thread_cache>, mp=0x81e68168 <thread_cache+104>, abstime=0xb33be17c, file=0x813863a8 "/home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h", line=1259) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_mutex.c:546
#3  0x8078703c in inline_mysql_cond_timedwait (that=0x81e68100 <thread_cache>, mutex=0x81e68168 <thread_cache+104>, abstime=0xb33be17c, src_file=0x81386a44 "/home/buildbot/buildbot/build/mariadb-10.5.11/sql/thread_cache.h", src_line=177) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h:1259
#4  0x8078b855 in Thread_cache::park (this=0x81e68100 <thread_cache>) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/thread_cache.h:176
#5  0x8078aedd in do_handle_one_connection (connect=0x83d30ab8, put_in_cache=true) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1422
#6  0x8078ab65 in handle_one_connection (arg=0x83eaa5c0) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1312
#7  0x80c8987a in pfs_spawn_thread (arg=0x83e06ae8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#8  0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#9  0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 3 (Thread 0xb3408b40 (LWP 30738)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731ce56 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x81237585 in safe_cond_timedwait (cond=0x81e68100 <thread_cache>, mp=0x81e68168 <thread_cache+104>, abstime=0xb340817c, file=0x813863a8 "/home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h", line=1259) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_mutex.c:546
#3  0x8078703c in inline_mysql_cond_timedwait (that=0x81e68100 <thread_cache>, mutex=0x81e68168 <thread_cache+104>, abstime=0xb340817c, src_file=0x81386a44 "/home/buildbot/buildbot/build/mariadb-10.5.11/sql/thread_cache.h", src_line=177) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h:1259
#4  0x8078b855 in Thread_cache::park (this=0x81e68100 <thread_cache>) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/thread_cache.h:176
#5  0x8078aedd in do_handle_one_connection (connect=0x83d30ab8, put_in_cache=true) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1422
#6  0x8078ab65 in handle_one_connection (arg=0x83ebfdf8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1312
#7  0x80c8987a in pfs_spawn_thread (arg=0x83e06ae8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#8  0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#9  0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 2 (Thread 0xb19ffb40 (LWP 28849)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731ca8c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x812372da in safe_cond_wait (cond=0x81e6b170 <query_cache+48>, mp=0x81e6b1b0 <query_cache+112>, file=0x8131dec8 "/home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h", line=1222) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/thr_mutex.c:492
#3  0x80566ed6 in inline_mysql_cond_wait (that=0x81e6b170 <query_cache+48>, mutex=0x81e6b1b0 <query_cache+112>, src_file=0x8131e4e8 "/home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_cache.cc", src_line=695) at /home/buildbot/buildbot/build/mariadb-10.5.11/include/mysql/psi/mysql_thread.h:1222
#4  0x805679e5 in Query_cache::lock_and_suspend (this=0x81e6b140 <query_cache>) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_cache.cc:695
#5  0x805692a9 in Query_cache::resize (this=0x81e6b140 <query_cache>, query_cache_size_arg=1048576) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_cache.cc:1302
#6  0x807aac95 in fix_query_cache_size (self=0x81e83d20 <Sys_query_cache_size>, thd=0xb17005e8, type=SHOW_OPT_GLOBAL) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sys_vars.cc:3061
#7  0x804d8804 in sys_var::update (this=0x81e83d20 <Sys_query_cache_size>, thd=0xb17005e8, var=0xb1710d68) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/set_var.cc:208
#8  0x804da45c in set_var::update (this=0xb1710d68, thd=0xb17005e8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/set_var.cc:859
#9  0x804da00e in sql_set_variables (thd=0xb17005e8, var_list=0xb17038f8, free=true) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/set_var.cc:746
#10 0x805fc4d2 in mysql_execute_command (thd=0xb17005e8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:5096
#11 0x80606584 in mysql_parse (thd=0xb17005e8, rawbuf=0xb1710be0 "SET GLOBAL query_cache_size=@save_query_cache_size", length=50, parser_state=0xb19feb3c, is_com_multi=false, is_next_command=false) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:8096
#12 0x805f1559 in dispatch_command (command=COM_QUERY, thd=0xb17005e8, packet=0xb1503c61 "SET GLOBAL query_cache_size=@save_query_cache_size", packet_length=50, is_com_multi=false, is_next_command=false) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:1892
#13 0x805efab6 in do_command (thd=0xb17005e8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:1371
#14 0x8078ae4a in do_handle_one_connection (connect=0x83ebfdf8, put_in_cache=true) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1410
#15 0x8078ab65 in handle_one_connection (arg=0x83ebfdf8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1312
#16 0x80c8987a in pfs_spawn_thread (arg=0x83e06ae8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#17 0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#18 0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6
 
Thread 1 (Thread 0xb3452b40 (LWP 30737)):
#0  0xb7737c31 in __kernel_vsyscall ()
#1  0xb731dce1 in pthread_kill () from /lib/i386-linux-gnu/libpthread.so.0
#2  0x81232954 in my_write_core (sig=6) at /home/buildbot/buildbot/build/mariadb-10.5.11/mysys/stacktrace.c:424
#3  0x8094c89b in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/signal_handler.cc:343
#4  <signal handler called>
#5  0xb7737c31 in __kernel_vsyscall ()
#6  0xb6f97e89 in raise () from /lib/i386-linux-gnu/libc.so.6
#7  0xb6f993e7 in abort () from /lib/i386-linux-gnu/libc.so.6
#8  0xb6f90d07 in ?? () from /lib/i386-linux-gnu/libc.so.6
#9  0xb6f90d8b in __assert_fail () from /lib/i386-linux-gnu/libc.so.6
#10 0x80568e21 in Query_cache::end_of_result (this=0x81e6b140 <query_cache>, thd=0xb0805920) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_cache.cc:1220
#11 0x805f399d in dispatch_command (command=COM_QUERY, thd=0xb0805920, packet=0xb080b769 "", packet_length=69, is_com_multi=false, is_next_command=false) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:2478
#12 0x805efab6 in do_command (thd=0xb0805920) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_parse.cc:1371
#13 0x8078ae4a in do_handle_one_connection (connect=0x83ebfdf8, put_in_cache=true) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1410
#14 0x8078ab65 in handle_one_connection (arg=0x83ebfdf8) at /home/buildbot/buildbot/build/mariadb-10.5.11/sql/sql_connect.cc:1312
#15 0x80c8987a in pfs_spawn_thread (arg=0x83e06ae8) at /home/buildbot/buildbot/build/mariadb-10.5.11/storage/perfschema/pfs.cc:2201
#16 0xb73172b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0
#17 0xb705316e in clone () from /lib/i386-linux-gnu/libc.so.6

Comment by Alice Sherepa [ 2022-12-27 ]

on 10.9 https://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/38852/steps/mtr_opttrace/logs/stdio

Generated at Thu Feb 08 09:35:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.