Details
Description
Note that main.sum_distinct-big is quite long, and it even times out occasionally without view protocol (MDEV-13661) on debug/instrumented builds.
I recommend experimenting with it on a non-debug build, where it ends in reasonable time, within a minute or so.
With view-protocol however it times out even on a non-debug build.
There is no such luxury with main.merge-big as it requires a debug build, but it's not normally as slow and should end within a minute on a debug build.
$ perl ./mtr main.sum_distinct-big --mem --view-protocol
|
|
main.sum_distinct-big 'innodb' [ fail ] timeout after 900 seconds
|
Test ended at 2023-06-12 15:43:59
|
|
Test case timeout after 900 seconds
|
|
== /mnt8t/bld/10.4-rel/mysql-test/var/log/sum_distinct-big.log ==
|
sm
|
536887296
|
SET max_heap_table_size=16384;
|
SELECT SUM(DISTINCT id) sm FROM t2;
|
sm
|
536887296
|
DROP TABLE t1;
|
DROP TABLE t2;
|
SET @@tmp_table_size=@save_tmp_table_size;
|
SET @@max_heap_table_size=@save_max_heap_table_size;
|
#
|
# MDEV-4311: COUNT(DISTINCT...) requiring a file for UNIQUE (bug #68749)
|
#
|
CREATE TABLE t2 (id INTEGER) ENGINE=InnoDB;
|
BEGIN;
|
INSERT INTO t2 SELECT b.seq FROM seq_1_to_128 a, seq_1_to_16384 b
|
ORDER BY b.seq*rand();
|
INSERT INTO t2 VALUE(NULL);
|
# With default tmp_table_size / max_heap_table_size
|
SELECT SQL_NO_CACHE count(DISTINCT id) sm FROM t2;
|
|
== /mnt8t/bld/10.4-rel/mysql-test/var/tmp/analyze-timeout-mysqld.1.err ==
|
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mnt8t/bld/10.4-rel/mysql-test/var/tmp/mysqld.1.sock' (111)
|
|
|
- found 'core' (0/5)
|
Core generated by '/mnt8t/bld/10.4-rel/bin/mysqld'
|
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).
|
--------------------------
|
|
warning: Can't open file /[aio] (deleted) during file-backed mapping note processing
|
[New LWP 1980816]
|
[New LWP 1980820]
|
[New LWP 1980817]
|
[New LWP 1980821]
|
[New LWP 1980825]
|
[New LWP 1980828]
|
[New LWP 1980822]
|
[New LWP 1980830]
|
[New LWP 1980831]
|
[New LWP 1980835]
|
[New LWP 1980840]
|
[New LWP 1980832]
|
[New LWP 1980843]
|
[New LWP 1980849]
|
[New LWP 1980838]
|
[New LWP 1980829]
|
[New LWP 1980846]
|
[New LWP 1980818]
|
[New LWP 1980842]
|
[New LWP 1980824]
|
[New LWP 1980826]
|
[New LWP 1980823]
|
[New LWP 1980833]
|
[New LWP 1980834]
|
[New LWP 1980836]
|
[New LWP 1980837]
|
[New LWP 1980839]
|
[New LWP 1980841]
|
[Thread debugging using libthread_db enabled]
|
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
|
Core was generated by `/mnt8t/bld/10.4-rel/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mnt8'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill_implementation (threadid=<optimized out>, signo=6, no_tid=<optimized out>) at ./nptl/pthread_kill.c:44
|
44 ./nptl/pthread_kill.c: No such file or directory.
|
[Current thread is 1 (Thread 0x7f5f3fa89e00 (LWP 1980816))]
|
|
Thread 28 (Thread 0x7f5f1cff96c0 (LWP 1980841)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x7f5f1cff8e58) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7f5f1cff8e58, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7f5f1cff8e58, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x7f5f1cff8e00, cond=0x7f5f1cff8e30) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x7f5f1cff8e30, mutex=0x7f5f1cff8e00) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c11578 in inline_mysql_cond_wait (src_file=0x5556b91d1128 "/data/src/10.4/storage/innobase/handler/ha_innodb.cc", src_line=308, mutex=0x7f5f1cff8e00, that=0x7f5f1cff8e30) at /data/src/10.4/include/mysql/psi/mysql_thread.h:1185
|
#6 thd_destructor_proxy () at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:308
|
#7 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbdbe198) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 27 (Thread 0x7f5f1dffb6c0 (LWP 1980839)):
|
#0 0x00007f5f3f6ee345 in __GI___clock_nanosleep (clock_id=clock_id@entry=0, flags=flags@entry=0, req=0x7f5f1dffa7e0, rem=0x0) at ../sysdeps/unix/sysv/linux/clock_nanosleep.c:48
|
#1 0x00007f5f3f6f2c53 in __GI___nanosleep (req=<optimized out>, rem=<optimized out>) at ../sysdeps/unix/sysv/linux/nanosleep.c:25
|
#2 0x00005556b8c9dd7d in os_thread_sleep (tm=tm@entry=1000000) at /data/src/10.4/storage/innobase/os/os0thread.cc:231
|
#3 0x00005556b8d854da in btr_defragment_thread () at /data/src/10.4/storage/innobase/btr/btr0defragment.cc:717
|
#4 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#5 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 26 (Thread 0x7f5f1effd6c0 (LWP 1980837)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556bbc49824) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc49824, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc49824, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556bbc497d0, cond=0x5556bbc497f8) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556bbc497f8, mutex=0x5556bbc497d0) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c9d8c9 in os_event::wait (this=0x5556bbc497c0) at /data/src/10.4/storage/innobase/os/os0event.cc:158
|
#6 os_event::wait_low (this=0x5556bbc497c0, reset_sig_count=8) at /data/src/10.4/storage/innobase/os/os0event.cc:325
|
#7 0x00005556b8c9dbb5 in os_event_wait_low (event=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:502
|
#8 0x00005556b8d1af53 in srv_resume_thread (sig_count=0, timeout_usec=0, wait=true, slot=0x5556b97a45a8 <srv_sys+360>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:897
|
#9 srv_worker_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2485
|
#10 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#11 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 25 (Thread 0x7f5f1ffff6c0 (LWP 1980836)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556bbc497b4) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc497b4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc497b4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556bbc49760, cond=0x5556bbc49788) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556bbc49788, mutex=0x5556bbc49760) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c9d8c9 in os_event::wait (this=0x5556bbc49750) at /data/src/10.4/storage/innobase/os/os0event.cc:158
|
#6 os_event::wait_low (this=0x5556bbc49750, reset_sig_count=10) at /data/src/10.4/storage/innobase/os/os0event.cc:325
|
#7 0x00005556b8c9dbb5 in os_event_wait_low (event=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:502
|
#8 0x00005556b8d1af53 in srv_resume_thread (sig_count=0, timeout_usec=0, wait=true, slot=0x5556b97a4570 <srv_sys+304>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:897
|
#9 srv_worker_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2485
|
#10 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#11 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 24 (Thread 0x7f5f257fa6c0 (LWP 1980834)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556bbc496d4) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc496d4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc496d4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556bbc49680, cond=0x5556bbc496a8) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556bbc496a8, mutex=0x5556bbc49680) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c9d8c9 in os_event::wait (this=0x5556bbc49670) at /data/src/10.4/storage/innobase/os/os0event.cc:158
|
#6 os_event::wait_low (this=0x5556bbc49670, reset_sig_count=2) at /data/src/10.4/storage/innobase/os/os0event.cc:325
|
#7 0x00005556b8c9dbb5 in os_event_wait_low (event=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:502
|
#8 0x00005556b8d1c3d4 in srv_resume_thread (timeout_usec=0, wait=true, sig_count=2, slot=0x5556b97a4500 <srv_sys+192>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:897
|
#9 srv_purge_coordinator_suspend (rseg_history_len=<optimized out>, slot=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2627
|
#10 srv_purge_coordinator_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2710
|
#11 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#12 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 23 (Thread 0x7f5f27fff6c0 (LWP 1980833)):
|
#0 0x00007f5f3f6ee345 in __GI___clock_nanosleep (clock_id=clock_id@entry=0, flags=flags@entry=0, req=0x7f5f27ffed80, rem=0x0) at ../sysdeps/unix/sysv/linux/clock_nanosleep.c:48
|
#1 0x00007f5f3f6f2c53 in __GI___nanosleep (req=<optimized out>, rem=<optimized out>) at ../sysdeps/unix/sysv/linux/nanosleep.c:25
|
#2 0x00005556b8c9dd7d in os_thread_sleep (tm=tm@entry=1000000) at /data/src/10.4/storage/innobase/os/os0thread.cc:231
|
#3 0x00005556b8d19e18 in srv_master_sleep () at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2302
|
#4 srv_master_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2342
|
#5 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#6 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 22 (Thread 0x7f5f327fc6c0 (LWP 1980823)):
|
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
|
#1 0x00007f5f3fb8d277 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#2 0x00005556b8c97154 in LinuxAIOHandler::collect (this=this@entry=0x7f5f327fbbb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1803
|
#3 0x00005556b8c9ab41 in LinuxAIOHandler::poll (this=this@entry=0x7f5f327fbbb0, m1=m1@entry=0x7f5f327fbc98, m2=m2@entry=0x7f5f327fbca0, request=request@entry=0x7f5f327fbcb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1964
|
#4 0x00005556b8c9c61d in os_aio_linux_handler (request=0x7f5f327fbcb0, m2=0x7f5f327fbca0, m1=0x7f5f327fbc98, global_segment=<optimized out>) at /data/src/10.4/storage/innobase/os/os0file.cc:2018
|
#5 os_aio_handler (segment=segment@entry=3, m1=m1@entry=0x7f5f327fbc98, m2=m2@entry=0x7f5f327fbca0, request=request@entry=0x7f5f327fbcb0) at /data/src/10.4/storage/innobase/os/os0file.cc:5296
|
#6 0x00005556b8df068a in fil_aio_wait (segment=segment@entry=3) at /data/src/10.4/storage/innobase/fil/fil0fil.cc:4330
|
#7 0x00005556b8d1da80 in io_handler_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0start.cc:324
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 21 (Thread 0x7f5f30ff96c0 (LWP 1980826)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f30ff8c00, op=393, expected=0, futex_word=0x5556bbc499e4) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc499e4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f30ff8c00, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc499e4, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f30ff8c00, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f30ff8c00, clockid=0, mutex=0x5556bbc49990, cond=0x5556bbc499b8) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556bbc499b8, mutex=0x5556bbc49990, abstime=0x7f5f30ff8c00) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8c9d842 in os_event::timed_wait (this=this@entry=0x5556bbc49980, abstime=abstime@entry=0x7f5f30ff8c00) at /data/src/10.4/storage/innobase/include/sync0types.h:461
|
#6 0x00005556b8c9d951 in os_event::wait_time_low (this=0x5556bbc49980, time_in_usec=<optimized out>, reset_sig_count=1728) at /data/src/10.4/storage/innobase/os/os0event.cc:385
|
#7 0x00005556b8c9dba5 in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:485
|
#8 0x00005556b8628bb7 in pc_sleep_if_needed (cur_time=1189999378, sig_count=1728, next_loop_time=1189999463) at /data/src/10.4/storage/innobase/buf/buf0flu.cc:2610
|
#9 buf_flush_page_cleaner_coordinator () at /data/src/10.4/storage/innobase/buf/buf0flu.cc:3069
|
#10 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#11 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 20 (Thread 0x7f5f31ffb6c0 (LWP 1980824)):
|
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
|
#1 0x00007f5f3fb8d277 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#2 0x00005556b8c97154 in LinuxAIOHandler::collect (this=this@entry=0x7f5f31ffabb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1803
|
#3 0x00005556b8c9ab41 in LinuxAIOHandler::poll (this=this@entry=0x7f5f31ffabb0, m1=m1@entry=0x7f5f31ffac98, m2=m2@entry=0x7f5f31ffaca0, request=request@entry=0x7f5f31ffacb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1964
|
#4 0x00005556b8c9c61d in os_aio_linux_handler (request=0x7f5f31ffacb0, m2=0x7f5f31ffaca0, m1=0x7f5f31ffac98, global_segment=<optimized out>) at /data/src/10.4/storage/innobase/os/os0file.cc:2018
|
#5 os_aio_handler (segment=segment@entry=4, m1=m1@entry=0x7f5f31ffac98, m2=m2@entry=0x7f5f31ffaca0, request=request@entry=0x7f5f31ffacb0) at /data/src/10.4/storage/innobase/os/os0file.cc:5296
|
#6 0x00005556b8df068a in fil_aio_wait (segment=segment@entry=4) at /data/src/10.4/storage/innobase/fil/fil0fil.cc:4330
|
#7 0x00005556b8d1da80 in io_handler_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0start.cc:324
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 19 (Thread 0x7f5f388a06c0 (LWP 1980842)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556b9829d0c <COND_manager+44>) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556b9829d0c <COND_manager+44>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556b9829d0c <COND_manager+44>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556b9829d20 <LOCK_manager>, cond=0x5556b9829ce0 <COND_manager>) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556b9829ce0 <COND_manager>, mutex=0x5556b9829d20 <LOCK_manager>) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b87279c7 in inline_mysql_cond_wait (that=0x5556b9829ce0 <COND_manager>, mutex=0x5556b9829d20 <LOCK_manager>, src_file=0x5556b9058bc0 "/data/src/10.4/sql/sql_manager.cc", src_line=102) at /data/src/10.4/include/mysql/psi/mysql_thread.h:1174
|
#6 handle_manager (arg=arg@entry=0x0) at /data/src/10.4/sql/sql_manager.cc:102
|
#7 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbe6d4d8) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 18 (Thread 0x7f5f39eac6c0 (LWP 1980818)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f39eabdb0, op=393, expected=0, futex_word=0x5556ba054248 <COND_checkpoint+40>) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556ba054248 <COND_checkpoint+40>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f39eabdb0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556ba054248 <COND_checkpoint+40>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f39eabdb0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f39eabdb0, clockid=0, mutex=0x5556ba054260 <LOCK_checkpoint>, cond=0x5556ba054220 <COND_checkpoint>) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=cond@entry=0x5556ba054220 <COND_checkpoint>, mutex=mutex@entry=0x5556ba054260 <LOCK_checkpoint>, abstime=abstime@entry=0x7f5f39eabdb0) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8b391ec in inline_mysql_cond_timedwait (src_file=0x5556b91ab2a0 "/data/src/10.4/storage/maria/ma_servicethread.c", src_line=115, abstime=0x7f5f39eabdb0, mutex=0x5556ba054260 <LOCK_checkpoint>, that=0x5556ba054220 <COND_checkpoint>) at /data/src/10.4/include/mysql/psi/mysql_thread.h:1211
|
#6 my_service_thread_sleep (control=control@entry=0x5556b9794f40 <checkpoint_control>, sleep_time=sleep_time@entry=30000000000) at /data/src/10.4/storage/maria/ma_servicethread.c:115
|
#7 0x00005556b8b317e9 in ma_checkpoint_background (arg=arg@entry=0x1e) at /data/src/10.4/storage/maria/ma_checkpoint.c:707
|
#8 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbc05238) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 17 (Thread 0x7f5f3880a6c0 (LWP 1980846)):
|
#0 0x00005556b8d21abb in rw_lock_lock_word_decr (threshold=268435456, amount=536870912, lock=0x7f5f38aa6f08) at /data/src/10.4/storage/innobase/include/sync0rw.inl:215
|
#1 rw_lock_x_lock_low (line=287, file_name=0x5556b9207840 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", pass=0, lock=0x7f5f38aa6f08) at /data/src/10.4/storage/innobase/sync/sync0rw.cc:490
|
#2 rw_lock_x_lock_func (lock=lock@entry=0x7f5f38aa6f08, pass=pass@entry=0, file_name=file_name@entry=0x5556b9207840 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", line=287, line@entry=25) at /data/src/10.4/storage/innobase/sync/sync0rw.cc:657
|
#3 0x00005556b8d87060 in pfs_rw_lock_x_lock_func (line=25, file_name=0x5556b9207840 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", pass=0, lock=0x7f5f38aa6f08) at /data/src/10.4/storage/innobase/include/sync0rw.inl:546
|
#4 buf_page_mtr_lock (block=block@entry=0x7f5f38aa6e80, rw_latch=rw_latch@entry=2, mtr=mtr@entry=0x7f5f38808a40, file=file@entry=0x5556b9207840 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", line=line@entry=287) at /data/src/10.4/storage/innobase/buf/buf0buf.cc:3929
|
#5 0x00005556b8d937e5 in buf_page_get_low (page_id=..., zip_size=<optimized out>, rw_latch=<optimized out>, guess=<optimized out>, mode=<optimized out>, file=<optimized out>, line=<optimized out>, mtr=<optimized out>, err=<optimized out>) at /data/src/10.4/storage/innobase/buf/buf0buf.cc:4604
|
#6 0x00005556b8d6752a in btr_block_get_func (file=0x5556b9207840 "/data/src/10.4/storage/innobase/btr/btr0cur.cc", mtr=<optimized out>, index=<optimized out>, line=287, mode=2, zip_size=93830955767307, page_id=...) at /data/src/10.4/storage/innobase/include/btr0btr.inl:56
|
#7 btr_cur_latch_leaves (block=block@entry=0x7f5f38aaf070, page_id=..., page_id@entry=..., zip_size=zip_size@entry=0, latch_mode=latch_mode@entry=33, cursor=cursor@entry=0x7f5eec04a288, mtr=<optimized out>) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:287
|
#8 0x00005556b8d71989 in btr_cur_search_to_nth_level (index=index@entry=0x7f5eec04e598, level=level@entry=0, tuple=tuple@entry=0x7f5eec1251e8, mode=<optimized out>, latch_mode=<optimized out>, cursor=cursor@entry=0x7f5eec04a288, file=<optimized out>, line=<optimized out>, mtr=<optimized out>, autoinc=<optimized out>) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:1848
|
#9 0x00005556b8d790c0 in btr_pcur_open_with_no_init_func (mtr=0x7f5f38808a40, line=<optimized out>, file=0x5556b92189c0 "/data/src/10.4/storage/innobase/row/row0uins.cc", cursor=0x7f5eec04a288, latch_mode=<optimized out>, mode=<optimized out>, tuple=0x7f5eec1251e8, index=0x7f5eec04e598) at /data/src/10.4/storage/innobase/include/btr0pcur.inl:495
|
#10 btr_pcur_t::restore_position (this=this@entry=0x7f5eec04a288, restore_latch_mode=<optimized out>, restore_latch_mode@entry=65569, file=file@entry=0x5556b92189c0 "/data/src/10.4/storage/innobase/row/row0uins.cc", line=line@entry=183, mtr=mtr@entry=0x7f5f38808a40) at /data/src/10.4/storage/innobase/btr/btr0pcur.cc:423
|
#11 0x00005556b8e46917 in row_undo_ins_remove_clust_rec (node=node@entry=0x7f5eec04a218) at /data/src/10.4/storage/innobase/row/row0uins.cc:183
|
#12 0x00005556b8e47ff1 in row_undo_ins (node=node@entry=0x7f5eec04a218, thr=thr@entry=0x7f5eec06e640) at /data/src/10.4/storage/innobase/row/row0uins.cc:588
|
#13 0x00005556b8d0783b in row_undo (thr=0x7f5eec06e640, node=0x7f5eec04a218) at /data/src/10.4/storage/innobase/row/row0undo.cc:427
|
#14 row_undo_step (thr=thr@entry=0x7f5eec06e640) at /data/src/10.4/storage/innobase/row/row0undo.cc:489
|
#15 0x00005556b8cb9a09 in que_thr_step (thr=<optimized out>) at /data/src/10.4/storage/innobase/que/que0que.cc:964
|
#16 que_run_threads_low (thr=<optimized out>) at /data/src/10.4/storage/innobase/que/que0que.cc:1028
|
#17 que_run_threads (thr=<optimized out>) at /data/src/10.4/storage/innobase/que/que0que.cc:1068
|
#18 0x00005556b8d385c8 in trx_rollback_to_savepoint_low (trx=trx@entry=0x7f5f392ac090, savept=savept@entry=0x0) at /data/src/10.4/storage/innobase/trx/trx0roll.cc:136
|
#19 0x00005556b8d38e30 in trx_rollback_for_mysql_low (trx=0x7f5f392ac090) at /data/src/10.4/storage/innobase/trx/trx0roll.cc:210
|
#20 trx_rollback_for_mysql (trx=trx@entry=0x7f5f392ac090) at /data/src/10.4/storage/innobase/trx/trx0roll.cc:281
|
#21 0x00005556b8c159ab in innobase_rollback (hton=<optimized out>, thd=0x7f5eec000c58, rollback_trx=<optimized out>) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:4830
|
#22 0x00005556b89409b8 in ha_rollback_trans (thd=thd@entry=0x7f5eec000c58, all=all@entry=true) at /data/src/10.4/sql/handler.cc:1939
|
#23 0x00005556b88465e7 in trans_rollback (thd=0x7f5eec000c58) at /data/src/10.4/sql/transaction.cc:342
|
#24 0x00005556b86e5b5d in THD::cleanup (this=this@entry=0x7f5eec000c58) at /data/src/10.4/sql/sql_class.cc:1532
|
#25 0x00005556b8665e07 in unlink_thd (thd=thd@entry=0x7f5eec000c58) at /data/src/10.4/sql/mysqld.cc:2633
|
#26 0x00005556b8665fed in one_thread_per_connection_end (thd=0x7f5eec000c58, put_in_cache=<optimized out>) at /data/src/10.4/sql/mysqld.cc:2782
|
#27 0x00005556b8837c5b in do_handle_one_connection (connect=connect@entry=0x5556bbee8748) at /data/src/10.4/sql/sql_connect.cc:1431
|
#28 0x00005556b8837e2d in handle_one_connection (arg=arg@entry=0x5556bbee8748) at /data/src/10.4/sql/sql_connect.cc:1324
|
#29 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbe42ef8) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#30 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#31 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 16 (Thread 0x7f5f277fe6c0 (LWP 1980829)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f277fdcb0, op=393, expected=0, futex_word=0x5556bbc49890) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc49890, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f277fdcb0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc49890, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f277fdcb0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f277fdcb0, clockid=0, mutex=0x5556bbc49840, cond=0x5556bbc49868) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556bbc49868, mutex=0x5556bbc49840, abstime=0x7f5f277fdcb0) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8c9d842 in os_event::timed_wait (this=this@entry=0x5556bbc49830, abstime=abstime@entry=0x7f5f277fdcb0) at /data/src/10.4/storage/innobase/include/sync0types.h:461
|
#6 0x00005556b8c9d951 in os_event::wait_time_low (this=0x5556bbc49830, time_in_usec=<optimized out>, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:385
|
#7 0x00005556b8c9dba5 in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:485
|
#8 0x00005556b8d19148 in srv_error_monitor_thread () at /data/src/10.4/storage/innobase/srv/srv0srv.cc:1815
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 15 (Thread 0x7f5f1e7fc6c0 (LWP 1980838)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556bbc49970) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc49970, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc49970, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556bbc49920, cond=0x5556bbc49948) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556bbc49948, mutex=0x5556bbc49920) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c9d8c9 in os_event::wait (this=0x5556bbc49910) at /data/src/10.4/storage/innobase/os/os0event.cc:158
|
#6 os_event::wait_low (this=0x5556bbc49910, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:325
|
#7 0x00005556b8c9dbb5 in os_event_wait_low (event=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:502
|
#8 0x00005556b8d9b72b in buf_dump_thread () at /data/src/10.4/storage/innobase/buf/buf0dump.cc:832
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 14 (Thread 0x7f5f387bf6c0 (LWP 1980849)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f387bed60, op=393, expected=0, futex_word=0x5556b982754c <COND_thread_cache+44>) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556b982754c <COND_thread_cache+44>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f387bed60, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556b982754c <COND_thread_cache+44>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f387bed60, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f387bed60, clockid=0, mutex=0x5556b9824d40 <LOCK_thread_cache>, cond=0x5556b9827520 <COND_thread_cache>) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556b9827520 <COND_thread_cache>, mutex=0x5556b9824d40 <LOCK_thread_cache>, abstime=0x7f5f387bed60) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8666183 in inline_mysql_cond_timedwait (that=0x5556b9827520 <COND_thread_cache>, mutex=0x5556b9824d40 <LOCK_thread_cache>, src_file=0x5556b9046004 "/data/src/10.4/sql/mysqld.cc", src_line=2697, abstime=0x7f5f387bed60) at /data/src/10.4/include/mysql/psi/mysql_thread.h:1211
|
#6 cache_thread (thd=0x7f5ee0000c58) at /data/src/10.4/sql/mysqld.cc:2697
|
#7 one_thread_per_connection_end (thd=0x7f5ee0000c58, put_in_cache=<optimized out>) at /data/src/10.4/sql/mysqld.cc:2783
|
#8 0x00005556b8837c5b in do_handle_one_connection (connect=connect@entry=0x5556bbef1498) at /data/src/10.4/sql/sql_connect.cc:1431
|
#9 0x00005556b8837e2d in handle_one_connection (arg=arg@entry=0x5556bbef1498) at /data/src/10.4/sql/sql_connect.cc:1324
|
#10 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbe43628) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#11 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#12 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 13 (Thread 0x7f5f388556c0 (LWP 1980843)):
|
#0 0x00007f5f3f65bbc2 in __GI___sigtimedwait (set=0x7f5f38854d50, info=0x7f5f38854dd0, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:31
|
#1 0x00005556b8664a33 in my_sigwait (code=<synthetic pointer>, sig=0x7f5f38854d48, set=0x7f5f38854d50) at /data/src/10.4/include/my_pthread.h:196
|
#2 signal_hand (arg=arg@entry=0x0) at /data/src/10.4/sql/mysqld.cc:3254
|
#3 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbc0f3e8) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#4 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#5 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 12 (Thread 0x7f5f25ffb6c0 (LWP 1980832)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f25ffab80, op=393, expected=0, futex_word=0x5556bbda99f0) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbda99f0, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f25ffab80, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbda99f0, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f25ffab80, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f25ffab80, clockid=0, mutex=0x5556bbda99a0, cond=0x5556bbda99c8) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556bbda99c8, mutex=0x5556bbda99a0, abstime=0x7f5f25ffab80) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8c9d842 in os_event::timed_wait (this=this@entry=0x5556bbda9990, abstime=abstime@entry=0x7f5f25ffab80) at /data/src/10.4/storage/innobase/include/sync0types.h:461
|
#6 0x00005556b8c9d951 in os_event::wait_time_low (this=0x5556bbda9990, time_in_usec=<optimized out>, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:385
|
#7 0x00005556b8c9dba5 in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:485
|
#8 0x00005556b8d52c60 in ib_wqueue_timedwait (wq=wq@entry=0x5556bbdabcf0, wait_in_usecs=wait_in_usecs@entry=5000000) at /data/src/10.4/storage/innobase/ut/ut0wqueue.cc:158
|
#9 0x00005556b8e23f3e in fts_optimize_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/fts/fts0opt.cc:2849
|
#10 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#11 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 11 (Thread 0x7f5f1d7fa6c0 (LWP 1980840)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556bbc49a50) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc49a50, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc49a50, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556bbc49a00, cond=0x5556bbc49a28) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556bbc49a28, mutex=0x5556bbc49a00) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c9d8c9 in os_event::wait (this=0x5556bbc499f0) at /data/src/10.4/storage/innobase/os/os0event.cc:158
|
#6 os_event::wait_low (this=0x5556bbc499f0, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:325
|
#7 0x00005556b8c9dbb5 in os_event_wait_low (event=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:502
|
#8 0x00005556b8d959e8 in buf_resize_thread () at /data/src/10.4/storage/innobase/buf/buf0buf.cc:2965
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 10 (Thread 0x7f5f24ff96c0 (LWP 1980835)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x0, op=393, expected=0, futex_word=0x5556bbc49740) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc49740, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc49740, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a73f8 in __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x5556bbc496f0, cond=0x5556bbc49718) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_wait (cond=0x5556bbc49718, mutex=0x5556bbc496f0) at ./nptl/pthread_cond_wait.c:618
|
#5 0x00005556b8c9d8c9 in os_event::wait (this=0x5556bbc496e0) at /data/src/10.4/storage/innobase/os/os0event.cc:158
|
#6 os_event::wait_low (this=0x5556bbc496e0, reset_sig_count=9) at /data/src/10.4/storage/innobase/os/os0event.cc:325
|
#7 0x00005556b8c9dbb5 in os_event_wait_low (event=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:502
|
#8 0x00005556b8d1af53 in srv_resume_thread (sig_count=0, timeout_usec=0, wait=true, slot=0x5556b97a4538 <srv_sys+248>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:897
|
#9 srv_worker_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0srv.cc:2485
|
#10 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#11 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 9 (Thread 0x7f5f267fc6c0 (LWP 1980831)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f267fbd60, op=393, expected=0, futex_word=0x5556bbe13440) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbe13440, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f267fbd60, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbe13440, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f267fbd60, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f267fbd60, clockid=0, mutex=0x5556bbe133f0, cond=0x5556bbe13418) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556bbe13418, mutex=0x5556bbe133f0, abstime=0x7f5f267fbd60) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8c9d842 in os_event::timed_wait (this=this@entry=0x5556bbe133e0, abstime=abstime@entry=0x7f5f267fbd60) at /data/src/10.4/storage/innobase/include/sync0types.h:461
|
#6 0x00005556b8c9d951 in os_event::wait_time_low (this=0x5556bbe133e0, time_in_usec=<optimized out>, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:385
|
#7 0x00005556b8c9dba5 in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:485
|
#8 0x00005556b8de0fb4 in dict_stats_thread () at /data/src/10.4/storage/innobase/dict/dict0stats_bg.cc:492
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 8 (Thread 0x7f5f26ffd6c0 (LWP 1980830)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f26ffcda0, op=393, expected=0, futex_word=0x5556bbc49900) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbc49900, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f26ffcda0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbc49900, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f26ffcda0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f26ffcda0, clockid=0, mutex=0x5556bbc498b0, cond=0x5556bbc498d8) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556bbc498d8, mutex=0x5556bbc498b0, abstime=0x7f5f26ffcda0) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8c9d842 in os_event::timed_wait (this=this@entry=0x5556bbc498a0, abstime=abstime@entry=0x7f5f26ffcda0) at /data/src/10.4/storage/innobase/include/sync0types.h:461
|
#6 0x00005556b8c9d951 in os_event::wait_time_low (this=0x5556bbc498a0, time_in_usec=<optimized out>, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:385
|
#7 0x00005556b8c9dba5 in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:485
|
#8 0x00005556b8d18870 in srv_monitor_thread () at /data/src/10.4/storage/innobase/srv/srv0srv.cc:1664
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 7 (Thread 0x7f5f32ffd6c0 (LWP 1980822)):
|
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
|
#1 0x00007f5f3fb8d277 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#2 0x00005556b8c97154 in LinuxAIOHandler::collect (this=this@entry=0x7f5f32ffcbb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1803
|
#3 0x00005556b8c9ab41 in LinuxAIOHandler::poll (this=this@entry=0x7f5f32ffcbb0, m1=m1@entry=0x7f5f32ffcc98, m2=m2@entry=0x7f5f32ffcca0, request=request@entry=0x7f5f32ffccb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1964
|
#4 0x00005556b8c9c61d in os_aio_linux_handler (request=0x7f5f32ffccb0, m2=0x7f5f32ffcca0, m1=0x7f5f32ffcc98, global_segment=<optimized out>) at /data/src/10.4/storage/innobase/os/os0file.cc:2018
|
#5 os_aio_handler (segment=segment@entry=2, m1=m1@entry=0x7f5f32ffcc98, m2=m2@entry=0x7f5f32ffcca0, request=request@entry=0x7f5f32ffccb0) at /data/src/10.4/storage/innobase/os/os0file.cc:5296
|
#6 0x00005556b8df068a in fil_aio_wait (segment=segment@entry=2) at /data/src/10.4/storage/innobase/fil/fil0fil.cc:4330
|
#7 0x00005556b8d1da80 in io_handler_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0start.cc:324
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 6 (Thread 0x7f5f1f7fe6c0 (LWP 1980828)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f1f7fdd50, op=393, expected=0, futex_word=0x5556bbde2130) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556bbde2130, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f1f7fdd50, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556bbde2130, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f1f7fdd50, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f1f7fdd50, clockid=0, mutex=0x5556bbde20e0, cond=0x5556bbde2108) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=0x5556bbde2108, mutex=0x5556bbde20e0, abstime=0x7f5f1f7fdd50) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8c9d842 in os_event::timed_wait (this=this@entry=0x5556bbde20d0, abstime=abstime@entry=0x7f5f1f7fdd50) at /data/src/10.4/storage/innobase/include/sync0types.h:461
|
#6 0x00005556b8c9d951 in os_event::wait_time_low (this=0x5556bbde20d0, time_in_usec=<optimized out>, reset_sig_count=1) at /data/src/10.4/storage/innobase/os/os0event.cc:385
|
#7 0x00005556b8c9dba5 in os_event_wait_time_low (event=<optimized out>, time_in_usec=<optimized out>, reset_sig_count=<optimized out>) at /data/src/10.4/storage/innobase/os/os0event.cc:485
|
#8 0x00005556b8c7c03f in lock_wait_timeout_thread () at /data/src/10.4/storage/innobase/lock/lock0wait.cc:514
|
#9 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#10 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 5 (Thread 0x7f5f317fa6c0 (LWP 1980825)):
|
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
|
#1 0x00007f5f3fb8d277 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#2 0x00005556b8c97154 in LinuxAIOHandler::collect (this=this@entry=0x7f5f317f9bb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1803
|
#3 0x00005556b8c9ab41 in LinuxAIOHandler::poll (this=this@entry=0x7f5f317f9bb0, m1=m1@entry=0x7f5f317f9c98, m2=m2@entry=0x7f5f317f9ca0, request=request@entry=0x7f5f317f9cb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1964
|
#4 0x00005556b8c9c61d in os_aio_linux_handler (request=0x7f5f317f9cb0, m2=0x7f5f317f9ca0, m1=0x7f5f317f9c98, global_segment=<optimized out>) at /data/src/10.4/storage/innobase/os/os0file.cc:2018
|
#5 os_aio_handler (segment=segment@entry=5, m1=m1@entry=0x7f5f317f9c98, m2=m2@entry=0x7f5f317f9ca0, request=request@entry=0x7f5f317f9cb0) at /data/src/10.4/storage/innobase/os/os0file.cc:5296
|
#6 0x00005556b8df068a in fil_aio_wait (segment=segment@entry=5) at /data/src/10.4/storage/innobase/fil/fil0fil.cc:4330
|
#7 0x00005556b8d1da80 in io_handler_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0start.cc:324
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 4 (Thread 0x7f5f337fe6c0 (LWP 1980821)):
|
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
|
#1 0x00007f5f3fb8d277 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#2 0x00005556b8c97154 in LinuxAIOHandler::collect (this=this@entry=0x7f5f337fdbb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1803
|
#3 0x00005556b8c9ab41 in LinuxAIOHandler::poll (this=this@entry=0x7f5f337fdbb0, m1=m1@entry=0x7f5f337fdc98, m2=m2@entry=0x7f5f337fdca0, request=request@entry=0x7f5f337fdcb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1964
|
#4 0x00005556b8c9c61d in os_aio_linux_handler (request=0x7f5f337fdcb0, m2=0x7f5f337fdca0, m1=0x7f5f337fdc98, global_segment=<optimized out>) at /data/src/10.4/storage/innobase/os/os0file.cc:2018
|
#5 os_aio_handler (segment=segment@entry=1, m1=m1@entry=0x7f5f337fdc98, m2=m2@entry=0x7f5f337fdca0, request=request@entry=0x7f5f337fdcb0) at /data/src/10.4/storage/innobase/os/os0file.cc:5296
|
#6 0x00005556b8df068a in fil_aio_wait (segment=segment@entry=1) at /data/src/10.4/storage/innobase/fil/fil0fil.cc:4330
|
#7 0x00005556b8d1da80 in io_handler_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0start.cc:324
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 3 (Thread 0x7f5f3b2186c0 (LWP 1980817)):
|
#0 __futex_abstimed_wait_common64 (private=0, cancel=true, abstime=0x7f5f3b217e20, op=393, expected=0, futex_word=0x5556ba0b7be8 <COND_timer+40>) at ./nptl/futex-internal.c:57
|
#1 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x5556ba0b7be8 <COND_timer+40>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f3b217e20, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#2 0x00007f5f3f6a4d9b in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x5556ba0b7be8 <COND_timer+40>, expected=expected@entry=0, clockid=clockid@entry=0, abstime=abstime@entry=0x7f5f3b217e20, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#3 0x00007f5f3f6a76dc in __pthread_cond_wait_common (abstime=0x7f5f3b217e20, clockid=0, mutex=0x5556ba0b7c00 <LOCK_timer>, cond=0x5556ba0b7bc0 <COND_timer>) at ./nptl/pthread_cond_wait.c:503
|
#4 ___pthread_cond_timedwait64 (cond=cond@entry=0x5556ba0b7bc0 <COND_timer>, mutex=mutex@entry=0x5556ba0b7c00 <LOCK_timer>, abstime=abstime@entry=0x7f5f3b217e20) at ./nptl/pthread_cond_wait.c:643
|
#5 0x00005556b8ec42fa in inline_mysql_cond_timedwait (that=0x5556ba0b7bc0 <COND_timer>, mutex=0x5556ba0b7c00 <LOCK_timer>, src_file=0x5556b921e598 "/data/src/10.4/mysys/thr_timer.c", src_line=291, abstime=0x7f5f3b217e20) at /data/src/10.4/include/mysql/psi/mysql_thread.h:1211
|
#6 timer_handler (arg=arg@entry=0x0) at /data/src/10.4/mysys/thr_timer.c:291
|
#7 0x00005556b8bca4cb in pfs_spawn_thread (arg=0x5556bbb537c8) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 2 (Thread 0x7f5f33fff6c0 (LWP 1980820)):
|
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
|
#1 0x00007f5f3fb8d277 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#2 0x00005556b8c97154 in LinuxAIOHandler::collect (this=this@entry=0x7f5f33ffebb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1803
|
#3 0x00005556b8c9ab41 in LinuxAIOHandler::poll (this=this@entry=0x7f5f33ffebb0, m1=m1@entry=0x7f5f33ffec98, m2=m2@entry=0x7f5f33ffeca0, request=request@entry=0x7f5f33ffecb0) at /data/src/10.4/storage/innobase/os/os0file.cc:1964
|
#4 0x00005556b8c9c61d in os_aio_linux_handler (request=0x7f5f33ffecb0, m2=0x7f5f33ffeca0, m1=0x7f5f33ffec98, global_segment=<optimized out>) at /data/src/10.4/storage/innobase/os/os0file.cc:2018
|
#5 os_aio_handler (segment=segment@entry=0, m1=m1@entry=0x7f5f33ffec98, m2=m2@entry=0x7f5f33ffeca0, request=request@entry=0x7f5f33ffecb0) at /data/src/10.4/storage/innobase/os/os0file.cc:5296
|
#6 0x00005556b8df068a in fil_aio_wait (segment=segment@entry=0) at /data/src/10.4/storage/innobase/fil/fil0fil.cc:4330
|
#7 0x00005556b8d1da80 in io_handler_thread (arg=<optimized out>) at /data/src/10.4/storage/innobase/srv/srv0start.cc:324
|
#8 0x00007f5f3f6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#9 0x00007f5f3f7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
Thread 1 (Thread 0x7f5f3fa89e00 (LWP 1980816)):
|
#0 __pthread_kill_implementation (threadid=<optimized out>, signo=6, no_tid=<optimized out>) at ./nptl/pthread_kill.c:44
|
#1 0x00005556b893c8db in handle_fatal_signal (sig=<optimized out>) at /data/src/10.4/sql/signal_handler.cc:372
|
#2 <signal handler called>
|
#3 0x00007f5f3f71afff in __GI___poll (fds=fds@entry=0x7ffd708e6410, nfds=nfds@entry=2, timeout=timeout@entry=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
|
#4 0x00005556b866d4eb in poll (__timeout=-1, __nfds=<optimized out>, __fds=0x7ffd708e6410) at /usr/include/x86_64-linux-gnu/bits/poll2.h:39
|
#5 handle_connections_sockets () at /data/src/10.4/sql/mysqld.cc:6509
|
#6 0x00005556b866e34d in mysqld_main (argc=<optimized out>, argv=<optimized out>) at /data/src/10.4/sql/mysqld.cc:5945
|
#7 0x00007f5f3f64618a in __libc_start_call_main (main=main@entry=0x5556b8646080 <main(int, char**)>, argc=argc@entry=24, argv=argv@entry=0x7ffd708e6878) at ../sysdeps/nptl/libc_start_call_main.h:58
|
#8 0x00007f5f3f646245 in __libc_start_main_impl (main=0x5556b8646080 <main(int, char**)>, argc=24, argv=0x7ffd708e6878, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7ffd708e6868) at ../csu/libc-start.c:381
|
#9 0x00005556b8662151 in _start ()
|
Attachments
Issue Links
- relates to
-
MDEV-31457 main.delete_use_source fails (hangs) with view-protocol
- Closed