Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.10, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
-
Centos 7 x86_64
-
5.5.59
Description
Mariadb keeps crashing repeatedly when query_cache_type is set to 1.
Steps to reproduce.
While queries are running, type below in cli.
set global query_cache_type =1; |
171129 6:02:26 [ERROR] mysqld got signal 11 ;
|
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.2.10-MariaDB-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=8
|
max_threads=502
|
thread_count=15
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1234038 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7fc7480009a8
|
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 = 0x7fce8c29ad70 thread_stack 0x49000
|
*** buffer overflow detected ***: /usr/sbin/mysqld terminated
|
======= Backtrace: =========
|
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fcea6a08d87]
|
/lib64/libc.so.6(+0x10df40)[0x7fcea6a06f40]
|
/lib64/libc.so.6(+0x10fcf7)[0x7fcea6a08cf7]
|
/usr/sbin/mysqld(my_addr_resolve+0x48)[0x55a5497d6128]
|
/usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x55a5497bfbc2]
|
/usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55a54923cb6d]
|
/lib64/libpthread.so.0(+0xf5e0)[0x7fcea84215e0]
|
/usr/sbin/mysqld(_ZN11Query_cache26double_linked_list_excludeEP17Query_cache_blockPS1_+0x0)[0x55a5490730d0]
|
/usr/sbin/mysqld(_ZN11Query_cache12unlink_tableEP23Query_cache_block_table+0x56)[0x55a549073606]
|
/usr/sbin/mysqld(_ZN11Query_cache19register_all_tablesEP3THDP17Query_cache_blockP10TABLE_LISTj+0x97)[0x55a549074647]
|
/usr/sbin/mysqld(_ZN11Query_cache11store_queryEP3THDP10TABLE_LIST+0x381)[0x55a549076221]
|
/usr/sbin/mysqld(+0x415773)[0x55a548fe9773]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6688)[0x55a5490b2418]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x55a5490b4fde]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x202d)[0x55a5490b7f7d]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x149)[0x55a5490b8b79]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x55a54917cb7a]
|
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55a54917cc9d]
|
/lib64/libpthread.so.0(+0x7e25)[0x7fcea8419e25]
|
/lib64/libc.so.6(clone+0x6d)[0x7fcea69f134d]
|
======= Memory map: ========
|
55a548bd4000-55a549cf5000 r-xp 00000000 fd:00 2374972 /usr/sbin/mysqld
|
55a549ef5000-55a549fcf000 r--p 01121000 fd:00 2374972 /usr/sbin/mysqld
|
55a549fcf000-55a54a086000 rw-p 011fb000 fd:00 2374972 /usr/sbin/mysqld
|
55a54a086000-55a54a919000 rw-p 00000000 00:00 0
|
55a54c5e0000-55a578a0d000 rw-p 00000000 00:00 0 [heap]
|
7fc71c000000-7fc71c021000 rw-p 00000000 00:00 0
|
7fc71c021000-7fc720000000 ---p 00000000 00:00 0
|
7fc720000000-7fc720021000 rw-p 00000000 00:00 0
|
7fc720021000-7fc724000000 ---p 00000000 00:00 0
|
7fc724000000-7fc724021000 rw-p 00000000 00:00 0
|
7fc724021000-7fc728000000 ---p 00000000 00:00 0
|
7fc728000000-7fc728021000 rw-p 00000000 00:00 0
|
7fc728021000-7fc72c000000 ---p 00000000 00:00 0
|
7fc72c000000-7fc72e2f6000 rw-p 00000000 00:00 0
|
7fc72e2f6000-7fc730000000 ---p 00000000 00:00 0
|
7fc730000000-7fc731081000 rw-p 00000000 00:00 0
|
7fc731081000-7fc734000000 ---p 00000000 00:00 0
|
7fc734000000-7fc7350f6000 rw-p 00000000 00:00 0
|
7fc7350f6000-7fc738000000 ---p 00000000 00:00 0
|
7fc738000000-7fc739fc1000 rw-p 00000000 00:00 0
|
7fc739fc1000-7fc73c000000 ---p 00000000 00:00 0
|
7fc73c000000-7fc73efe3000 rw-p 00000000 00:00 0
|
7fc73efe3000-7fc740000000 ---p 00000000 00:00 0
|
7fc740000000-7fc742f5d000 rw-p 00000000 00:00 0
|
7fc742f5d000-7fc744000000 ---p 00000000 00:00 0
|
7fc744000000-7fc746521000 rw-p 00000000 00:00 0
|
7fc746521000-7fc748000000 ---p 00000000 00:00 0
|
7fc748000000-7fc74963a000 rw-p 00000000 00:00 0
|
7fc74963a000-7fc74c000000 ---p 00000000 00:00 0
|
7fc74c000000-7fc74c021000 rw-p 00000000 00:00 0
|
7fc74c021000-7fc750000000 ---p 00000000 00:00 0
|
7fc750000000-7fc750021000 rw-p 00000000 00:00 0
|
7fc750021000-7fc754000000 ---p 00000000 00:00 0
|
7fc754000000-7fc754021000 rw-p 00000000 00:00 0
|
7fc754021000-7fc758000000 ---p 00000000 00:00 0
|
7fc758000000-7fc758021000 rw-p 00000000 00:00 0
|
7fc758021000-7fc75c000000 ---p 00000000 00:00 0
|
7fc75c000000-7fc75c056000 rw-p 00000000 00:00 0
|
7fc75c056000-7fc760000000 ---p 00000000 00:00 0
|
7fc760000000-7fc760021000 rw-p 00000000 00:00 0
|
7fc760021000-7fc764000000 ---p 00000000 00:00 0
|
7fc764000000-7fc764021000 rw-p 00000000 00:00 0
|
7fc764021000-7fc768000000 ---p 00000000 00:00 0
|
7fc768000000-7fc768021000 rw-p 00000000 00:00 0
|
7fc768021000-7fc76c000000 ---p 00000000 00:00 0
|
7fc76c000000-7fc76c021000 rw-p 00000000 00:00 0
|
7fc76c021000-7fc770000000 ---p 00000000 00:00 0
|
7fc770000000-7fc770021000 rw-p 00000000 00:00 0
|
7fc770021000-7fc774000000 ---p 00000000 00:00 0
|
7fc774000000-7fc774021000 rw-p 00000000 00:00 0
|
7fc774021000-7fc778000000 ---p 00000000 00:00 0
|
7fc77969e000-7fc780000000 rw-p 00000000 00:00 0
|
7fc780000000-7fc780021000 rw-p 00000000 00:00 0
|
7fc780021000-7fc784000000 ---p 00000000 00:00 0
|
7fc784000000-7fc784021000 rw-p 00000000 00:00 0
|
7fc784021000-7fc788000000 ---p 00000000 00:00 0
|
7fc788000000-7fc788021000 rw-p 00000000 00:00 0
|
7fc788021000-7fc78c000000 ---p 00000000 00:00 0
|
7fc78c000000-7fc78c021000 rw-p 00000000 00:00 0
|
7fc78c021000-7fc790000000 ---p 00000000 00:00 0
|
7fc790000000-7fc790021000 rw-p 00000000 00:00 0
|
7fc790021000-7fc794000000 ---p 00000000 00:00 0
|
7fc794024000-7fc794025000 ---p 00000000 00:00 0
|
7fc794025000-7fc794825000 rw-p 00000000 00:00 0
|
7fc794825000-7fc794826000 ---p 00000000 00:00 0
|
7fc794826000-7fc795026000 rw-p 00000000 00:00 0
|
7fc795026000-7fc795027000 ---p 00000000 00:00 0
|
7fc795027000-7fc795827000 rw-p 00000000 00:00 0
|
7fc795827000-7fc795828000 ---p 00000000 00:00 0
|
7fc795828000-7fc796028000 rw-p 00000000 00:00 0
|
7fc796028000-7fc796029000 ---p 00000000 00:00 0
|
7fc796029000-7fc796829000 rw-p 00000000 00:00 0
|
7fc796829000-7fc79682a000 ---p 00000000 00:00 0
|
7fc79682a000-7fc79702a000 rw-p 00000000 00:00 0
|
7fc79702a000-7fc79702b000 ---p 00000000 00:00 0
|
7fc79702b000-7fc79782b000 rw-p 00000000 00:00 0
|
7fc79782b000-7fc79782c000 ---p 00000000 00:00 0
|
7fc79782c000-7fc79802c000 rw-p 00000000 00:00 0
|
7fc79802c000-7fc79802d000 ---p 00000000 00:00 0
|
7fc79802d000-7fc79882d000 rw-p 00000000 00:00 0
|
7fc79882d000-7fc79882e000 ---p 00000000 00:00 0
|
7fc79882e000-7fc79902e000 rw-p 00000000 00:00 0
|
7fc79902e000-7fc79902f000 ---p 00000000 00:00 0
|
7fc79902f000-7fc79982f000 rw-p 00000000 00:00 0
|
7fc79982f000-7fc799830000 ---p 00000000 00:00 0
|
7fc799830000-7fc79a030000 rw-p 00000000 00:00 0
|
7fc79a030000-7fc79a031000 ---p 00000000 00:00 0
|
7fc79a031000-7fc79a831000 rw-p 00000000 00:00 0
|
7fc79a831000-7fc79a832000 ---p 00000000 00:00 0
|
7fc79a832000-7fc7a7df1000 rw-p 00000000 00:00 0
|
7fc7a8000000-7fc7a8021000 rw-p 00000000 00:00 0
|
7fc7a8021000-7fc7ac000000 ---p 00000000 00:00 0
|
7fc7ac000000-7fc7ac021000 rw-p 00000000 00:00 0
|
7fc7ac021000-7fc7b0000000 ---p 00000000 00:00 0
|
7fc7b0000000-7fc7b0021000 rw-p 00000000 00:00 0
|
7fc7b0021000-7fc7b4000000 ---p 00000000 00:00 0
|
7fc7b4000000-7fc7b4021000 rw-p 00000000 00:00 0
|
7fc7b4021000-7fc7b8000000 ---p 00000000 00:00 0
|
7fc7b8000000-7fc7b8021000 rw-p 00000000 00:00 0
|
7fc7b8021000-7fc7bc000000 ---p 00000000 00:00 0
|
7fc7bc36b000-7fc7bc36c000 ---p 00000000 00:00 0
|
7fc7bc36c000-7fc7bcb6c000 rw-p 00000000 00:00 0
|
7fc7bcb6c000-7fc7bcb6d000 ---p 00000000 00:00 0
|
7fc7bcb6d000-7fc7bd36d000 rw-p 00000000 00:00 0
|
7fc7bd36d000-7fc7bd36e000 ---p 00000000 00:00 0
|
7fc7bd36e000-7fc7bdb6e000 rw-p 00000000 00:00 0
|
7fc7bdb6e000-7fc7bdb6f000 ---p 00000000 00:00 0
|
7fc7bdb6f000-7fc7be36f000 rw-p 00000000 00:00 0
|
7fc7be36f000-7fc7be370000 ---p 00000000 00:00 0
|
7fc7be370000-7fc7beb70000 rw-p 00000000 00:00 0
|
7fc7beb70000-7fc7beb71000 ---p 00000000 00:00 0
|
7fc7beb71000-7fc7bf371000 rw-p 00000000 00:00 0
|
7fc7bf371000-7fc7bf372000 ---p 00000000 00:00 0
|
7fc7bf372000-7fc7bfb72000 rw-p 00000000 00:00 0
|
7fc7bfb72000-7fc7bfb73000 ---p 00000000 00:00 0
|
7fc7bfb73000-7fc7c0373000 rw-p 00000000 00:00 0
|
7fc7c0373000-7fc7c0374000 ---p 00000000 00:00 0
|
7fc7c0374000-7fc7c0b74000 rw-p 00000000 00:00 0
|
7fc7c0b74000-7fc7c0b75000 ---p 00000000 00:00 0
|
7fc7c0b75000-7fc7c1375000 rw-p 00000000 00:00 0
|
7fc7c1375000-7fc7c1376000 ---p 00000000 00:00 0
|
7fc7c1376000-7fc7c1b76000 rw-p 00000000 00:00 0
|
7fc7c1b76000-7fc7c1b77000 ---p 00000000 00:00 0
|
7fc7c1b77000-7fce88000000 rw-p 00000000 00:00 0
|
7fce88000000-7fce88021000 rw-p 00000000 00:00 0
|
7fce88021000-7fce8c000000 ---p 00000000 00:00 0
|
7fce8c096000-7fce8c097000 ---p 00000000 00:00 0
|
7fce8c097000-7fce8c0e0000 rw-p 00000000 00:00 0
|
7fce8c0e0000-7fce8c0e1000 ---p 00000000 00:00 0
|
7fce8c0e1000-7fce8c12a000 rw-p 00000000 00:00 0
|
7fce8c12a000-7fce8c12b000 ---p 00000000 00:00 0
|
7fce8c12b000-7fce8c174000 rw-p 00000000 00:00 0
|
7fce8c174000-7fce8c175000 ---p 00000000 00:00 0
|
7fce8c175000-7fce8c1be000 rw-p 00000000 00:00 0
|
7fce8c1be000-7fce8c1bf000 ---p 00000000 00:00 0
|
7fce8c1bf000-7fce8c208000 rw-p 00000000 00:00 0
|
7fce8c208000-7fce8c209000 ---p 00000000 00:00 0
|
7fce8c209000-7fce8c252000 rw-p 00000000 00:00 0
|
7fce8c252000-7fce8c253000 ---p 00000000 00:00 0
|
7fce8c253000-7fce8c4a1000 rw-p 00000000 00:00 0
|
7fce8c4a1000-7fce8c4a2000 ---p 00000000 00:00 0
|
7fce8c4a2000-7fce8cca2000 rw-p 00000000 00:00 0
|
7fce8cca2000-7fce8cca3000 ---p 00000000 00:00 0
|
7fce8cca3000-7fce8d4a3000 rw-p 00000000 00:00 0
|
7fce8d4a3000-7fce8d4a4000 ---p 00000000 00:00 0
|
7fce8d4a4000-7fce9c000000 rw-p 00000000 00:00 0
|
7fce9c000000-7fce9c021000 rw-p 00000000 00:00 0
|
7fce9c021000-7fcea0000000 ---p 00000000 00:00 0
|
7fcea0035000-7fcea0036000 ---p 00000000 00:00 0
|
7fcea0036000-7fcea007f000 rw-p 00000000 00:00 0
|
7fcea007f000-7fcea0080000 ---p 00000000 00:00 0
|
7fcea0080000-7fcea00c9000 rw-p 00000000 00:00 0
|
7fcea00c9000-7fcea00ca000 ---p 00000000 00:00 0
|
7fcea00ca000-7fcea0113000 rw-p 00000000 00:00 0
|
7fcea0113000-7fcea0114000 ---p 00000000 00:00 0
|
7fcea0114000-7fcea0c93000 rw-p 00000000 00:00 0
|
7fcea0c93000-7fcea0ca7000 r-xp 00000000 fd:00 2374479 /usr/lib64/mysql/plugin/ha_federated.so
|
7fcea0ca7000-7fcea0ea7000 ---p 00014000 fd:00 2374479 /usr/lib64/mysql/plugin/ha_federated.so
|
7fcea0ea7000-7fcea0ea8000 r--p 00014000 fd:00 2374479 /usr/lib64/mysql/plugin/ha_federated.so
|
7fcea0ea8000-7fcea0ea9000 rw-p 00015000 fd:00 2374479 /usr/lib64/mysql/plugin/ha_federated.so
|
7fcea0ea9000-7fcea2603000 rw-p 00000000 00:00 0
|
7fcea2603000-7fcea2604000 ---p 00000000 00:00 0
|
7fcea2604000-7fcea2e04000 rw-p 00000000 00:00 0
|
7fcea2e04000-7fcea2e10000 r-xp 00000000 fd:00 2365044 /usr/lib64/libnss_files-2.17.so
|
7fcea2e10000-7fcea300f000 ---p 0000c000 fd:00 2365044 /usr/lib64/libnss_files-2.17.so
|
7fcea300f000-7fcea3010000 r--p 0000b000 fd:00 2365044 /usr/lib64/libnss_files-2.17.so
|
7fcea3010000-7fcea3011000 rw-p 0000c000 fd:00 2365044 /usr/lib64/libnss_files-2.17.so
|
7fcea3011000-7fcea3fb8000 rw-p 00000000 00:00 0
|
7fcea3fb8000-7fcea3fbb000 r-xp 00000000 fd:00 2360776 /usr/lib64/libkeyutils.so.1.5
|
7fcea3fbb000-7fcea41ba000 ---p 00003000 fd:00 2360776 /usr/lib64/libkeyutils.so.1.5
|
7fcea41ba000-7fcea41bb000 r--p 00002000 fd:00 2360776 /usr/lib64/libkeyutils.so.1.5
|
7fcea41bb000-7fcea41bc000 rw-p 00003000 fd:00 2360776 /usr/lib64/libkeyutils.so.1.5
|
7fcea41bc000-7fcea41c9000 r-xp 00000000 fd:00 2363615 /usr/lib64/libkrb5support.so.0.1
|
7fcea41c9000-7fcea43c8000 ---p 0000d000 fd:00 2363615 /usr/lib64/libkrb5support.so.0.1
|
7fcea43c8000-7fcea43c9000 r--p 0000c000 fd:00 2363615 /usr/lib64/libkrb5support.so.0.1
|
7fcea43c9000-7fcea43ca000 rw-p 0000d000 fd:00 2363615 /usr/lib64/libkrb5support.so.0.1
|
7fcea43ca000-7fcea43d9000 r-xp 00000000 fd:00 2360434 /usr/lib64/libbz2.so.1.0.6
|
7fcea43d9000-7fcea45d8000 ---p 0000f000 fd:00 2360434 /usr/lib64/libbz2.so.1.0.6
|
7fcea45d8000-7fcea45d9000 r--p 0000e000 fd:00 2360434 /usr/lib64/libbz2.so.1.0.6
|
7fcea45d9000-7fcea45da000 rw-p 0000f000 fd:00 2360434 /usr/lib64/libbz2.so.1.0.6
|
7fcea45da000-7fcea45f1000 r-xp 00000000 fd:00 2377181 /usr/lib64/libelf-0.168.so
|
7fcea45f1000-7fcea47f0000 ---p 00017000 fd:00 2377181 /usr/lib64/libelf-0.168.so
|
7fcea47f0000-7fcea47f1000 r--p 00016000 fd:00 2377181 /usr/lib64/libelf-0.168.so
|
7fcea47f1000-7fcea47f2000 rw-p 00017000 fd:00 2377181 /usr/lib64/libelf-0.168.so
|
7fcea47f2000-7fcea4852000 r-xp 00000000 fd:00 2360774 /usr/lib64/libpcre.so.1.2.0
|
7fcea4852000-7fcea4a52000 ---p 00060000 fd:00 2360774 /usr/lib64/libpcre.so.1.2.0
|
7fcea4a52000-7fcea4a53000 r--p 00060000 fd:00 2360774 /usr/lib64/libpcre.so.1.2.0
|
7fcea4a53000-7fcea4a54000 rw-p 00061000 fd:00 2360774 /usr/lib64/libpcre.so.1.2.0
|
7fcea4a54000-7fcea4a58000 r-xp 00000000 fd:00 2360478 /usr/lib64/libattr.so.1.1.0
|
7fcea4a58000-7fcea4c57000 ---p 00004000 fd:00 2360478 /usr/lib64/libattr.so.1.1.0
|
7fcea4c57000-7fcea4c58000 r--p 00003000 fd:00 2360478 /usr/lib64/libattr.so.1.1.0
|
7fcea4c58000-7fcea4c59000 rw-p 00004000 fd:00 2360478 /usr/lib64/libattr.so.1.1.0
|
7fcea4c59000-7fcea4c8a000 r-xp 00000000 fd:00 2361048 /usr/lib64/libk5crypto.so.3.1
|
7fcea4c8a000-7fcea4e89000 ---p 00031000 fd:00 2361048 /usr/lib64/libk5crypto.so.3.1
|
7fcea4e89000-7fcea4e8b000 r--p 00030000 fd:00 2361048 /usr/lib64/libk5crypto.so.3.1
|
7fcea4e8b000-7fcea4e8c000 rw-p 00032000 fd:00 2361048 /usr/lib64/libk5crypto.so.3.1
|
7fcea4e8c000-7fcea4e8f000 r-xp 00000000 fd:00 2360513 /usr/lib64/libcom_err.so.2.1
|
7fcea4e8f000-7fcea508e000 ---p 00003000 fd:00 2360513 /usr/lib64/libcom_err.so.2.1
|
7fcea508e000-7fcea508f000 r--p 00002000 fd:00 2360513 /usr/lib64/libcom_err.so.2.1
|
7fcea508f000-7fcea5090000 rw-p 00003000 fd:00 2360513 /usr/lib64/libcom_err.so.2.1
|
7fcea5090000-7fcea5168000 r-xp 00000000 fd:00 2361058 /usr/lib64/libkrb5.so.3.3
|
7fcea5168000-7fcea5367000 ---p 000d8000 fd:00 2361058 /usr/lib64/libkrb5.so.3.3
|
7fcea5367000-7fcea5375000 r--p 000d7000 fd:00 2361058 /usr/lib64/libkrb5.so.3.3
|
7fcea5375000-7fcea5378000 rw-p 000e5000 fd:00 2361058 /usr/lib64/libkrb5.so.3.3
|
7fcea5378000-7fcea53c2000 r-xp 00000000 fd:00 2361076 /usr/lib64/libgssapi_krb5.so.2.2
|
7fcea53c2000-7fcea55c2000 ---p 0004a000 fd:00 2361076 /usr/lib64/libgssapi_krb5.so.2.2
|
7fcea55c2000-7fcea55c3000 r--p 0004a000 fd:00 2361076 /usr/lib64/libgssapi_krb5.so.2.2
|
7fcea55c3000-7fcea55c5000 rw-p 0004b000 fd:00 2361076 /usr/lib64/libgssapi_krb5.so.2.2
|
7fcea55c5000-7fcea55da000 r-xp 00000000 fd:00 2377139 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7fcea55da000-7fcea57d9000 ---p 00015000 fd:00 2377139 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7fcea57d9000-7fcea57da000 r--p 00014000 fd:00 2377139 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7fcea57da000-7fcea57db000 rw-p 00015000 fd:00 2377139 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
|
7fcea57db000-7fcea581f000 r-xp 00000000 fd:00 2365679 /usr/lib64/libdw-0.168.so
|
7fcea581f000-7fcea5a1f000 ---p 00044000 fd:00 2365679 /usr/lib64/libdw-0.168.so
|
7fcea5a1f000-7fcea5a21000 r--p 00044000 fd:00 2365679 /usr/lib64/libdw-0.168.so
|
7fcea5a21000-7fcea5a22000 rw-p 00046000 fd:00 2365679 /usr/lib64/libdw-0.168.so
|
7fcea5a22000-7fcea5a38000 r-xp 00000000 fd:00 2365046 /usr/lib64/libresolv-2.17.so
|
7fcea5a38000-7fcea5c38000 ---p 00016000 fd:00 2365046 /usr/lib64/libresolv-2.17.so
|
7fcea5c38000-7fcea5c39000 r--p 00016000 fd:00 2365046 /usr/lib64/libresolv-2.17.so
|
7fcea5c39000-7fcea5c3a000 rw-p 00017000 fd:00 2365046 /usr/lib64/libresolv-2.17.so
|
7fcea5c3a000-7fcea5c3c000 rw-p 00000000 00:00 0
|
7fcea5c3c000-7fcea5c40000 r-xp 00000000 fd:00 2360468 /usr/lib64/libgpg-error.so.0.10.0
|
7fcea5c40000-7fcea5e3f000 ---p 00004000 fd:00 2360468 /usr/lib64/libgpg-error.so.0.10.0
|
7fcea5e3f000-7fcea5e40000 r--p 00003000 fd:00 2360468 /usr/lib64/libgpg-error.so.0.10.0
|
7fcea5e40000-7fcea5e41000 rw-p 00004000 fd:00 2360468 /usr/lib64/libgpg-error.so.0.10.0
|
7fcea5e41000-7fcea5ebe000 r-xp 00000000 fd:00 2360489 /usr/lib64/libgcrypt.so.11.8.2
|
7fcea5ebe000-7fcea60bd000 ---p 0007d000 fd:00 2360489 /usr/lib64/libgcrypt.so.11.8.2
|
7fcea60bd000-7fcea60be000 r--p 0007c000 fd:00 2360489 /usr/lib64/libgcrypt.so.11.8.2
|
7fcea60be000-7fcea60c1000 rw-p 0007d000 fd:00 2360489 /usr/lib64/libgcrypt.so.11.8.2
|
7fcea60c1000-7fcea60c2000 rw-p 00000000 00:00 0
|
7fcea60c2000-7fcea60e6000 r-xp 00000000 fd:00 2360326 /usr/lib64/libselinux.so.1
|
7fcea60e6000-7fcea62e5000 ---p 00024000 fd:00 2360326 /usr/lib64/libselinux.so.1
|
7fcea62e5000-7fcea62e6000 r--p 00023000 fd:00 2360326 /usr/lib64/libselinux.so.1
|
7fcea62e6000-7fcea62e7000 rw-p 00024000 fd:00 2360326 /usr/lib64/libselinux.so.1
|
7fcea62e7000-7fcea62e9000 rw-p 00000000 00:00 0
|
7fcea62e9000-7fcea62f0000 r-xp 00000000 fd:00 2365047 /usr/lib64/librt-2.17.so
|
7fcea62f0000-7fcea64ef000 ---p 00007000 fd:00 2365047 /usr/lib64/librt-2.17.so
|
7fcea64ef000-7fcea64f0000 r--p 00006000 fd:00 2365047 /usr/lib64/librt-2.17.so
|
7fcea64f0000-7fcea64f1000 rw-p 00007000 fd:00 2365047 /usr/lib64/librt-2.17.so
|
7fcea64f1000-7fcea64f5000 r-xp 00000000 fd:00 2360481 /usr/lib64/libcap.so.2.22
|
7fcea64f5000-7fcea66f4000 ---p 00004000 fd:00 2360481 /usr/lib64/libcap.so.2.22
|
7fcea66f4000-7fcea66f5000 r--p 00003000 fd:00 2360481 /usr/lib64/libcap.so.2.22
|
7fcea66f5000-7fcea66f6000 rw-p 00004000 fd:00 2360481 /usr/lib64/libcap.so.2.22
|
7fcea66f6000-7fcea66f8000 r-xp 00000000 fd:00 2359856 /usr/lib64/libfreebl3.so
|
7fcea66f8000-7fcea68f7000 ---p 00002000 fd:00 2359856 /usr/lib64/libfreebl3.so
|
7fcea68f7000-7fcea68f8000 r--p 00001000 fd:00 2359856 /usr/lib64/libfreebl3.so
|
7fcea68f8000-7fcea68f9000 rw-p 00002000 fd:00 2359856 /usr/lib64/libfreebl3.so
|
7fcea68f9000-7fcea6ab1000 r-xp 00000000 fd:00 2359896 /usr/lib64/libc-2.17.so
|
7fcea6ab1000-7fcea6cb1000 ---p 001b8000 fd:00 2359896 /usr/lib64/libc-2.17.so
|
7fcea6cb1000-7fcea6cb5000 r--p 001b8000 fd:00 2359896 /usr/lib64/libc-2.17.so
|
7fcea6cb5000-7fcea6cb7000 rw-p 001bc000 fd:00 2359896 /usr/lib64/libc-2.17.so
|
7fcea6cb7000-7fcea6cbc000 rw-p 00000000 00:00 0
|
7fcea6cbc000-7fcea6dbd000 r-xp 00000000 fd:00 2365041 /usr/lib64/libm-2.17.so
|
7fcea6dbd000-7fcea6fbc000 ---p 00101000 fd:00 2365041 /usr/lib64/libm-2.17.so
|
7fcea6fbc000-7fcea6fbd000 r--p 00100000 fd:00 2365041 /usr/lib64/libm-2.17.so
|
7fcea6fbd000-7fcea6fbe000 rw-p 00101000 fd:00 2365041 /usr/lib64/libm-2.17.so
|
7fcea6fbe000-7fcea70a7000 r-xp 00000000 fd:00 2365054 /usr/lib64/libstdc++.so.6.0.19
|
7fcea70a7000-7fcea72a7000 ---p 000e9000 fd:00 2365054 /usr/lib64/libstdc++.so.6.0.19
|
7fcea72a7000-7fcea72af000 r--p 000e9000 fd:00 2365054 /usr/lib64/libstdc++.so.6.0.19
|
7fcea72af000-7fcea72b1000 rw-p 000f1000 fd:00 2365054 /usr/lib64/libstdc++.so.6.0.19
|
7fcea72b1000-7fcea72c6000 rw-p 00000000 00:00 0
|
7fcea72c6000-7fcea72c8000 r-xp 00000000 fd:00 2365040 /usr/lib64/libdl-2.17.so
|
7fcea72c8000-7fcea74c8000 ---p 00002000 fd:00 2365040 /usr/lib64/libdl-2.17.so
|
7fcea74c8000-7fcea74c9000 r--p 00002000 fd:00 2365040 /usr/lib64/libdl-2.17.so
|
7fcea74c9000-7fcea74ca000 rw-p 00003000 fd:00 2365040 /usr/lib64/libdl-2.17.so
|
7fcea74ca000-7fcea76fe000 r-xp 00000000 fd:00 2361071 /usr/lib64/libcrypto.so.1.0.2k
|
7fcea76fe000-7fcea78fe000 ---p 00234000 fd:00 2361071 /usr/lib64/libcrypto.so.1.0.2k
|
7fcea78fe000-7fcea791a000 r--p 00234000 fd:00 2361071 /usr/lib64/libcrypto.so.1.0.2k
|
7fcea791a000-7fcea7927000 rw-p 00250000 fd:00 2361071 /usr/lib64/libcrypto.so.1.0.2k
|
7fcea7927000-7fcea792b000 rw-p 00000000 00:00 0
|
7fcea792b000-7fcea7992000 r-xp 00000000 fd:00 2362638 /usr/lib64/libssl.so.1.0.2k
|
7fcea7992000-7fcea7b92000 ---p 00067000 fd:00 2362638 /usr/lib64/libssl.so.1.0.2k
|
7fcea7b92000-7fcea7b96000 r--p 00067000 fd:00 2362638 /usr/lib64/libssl.so.1.0.2k
|
7fcea7b96000-7fcea7b9d000 rw-p 0006b000 fd:00 2362638 /usr/lib64/libssl.so.1.0.2k
|
7fcea7b9d000-7fcea7ba5000 r-xp 00000000 fd:00 2359900 /usr/lib64/libcrypt-2.17.so
|
7fcea7ba5000-7fcea7da4000 ---p 00008000 fd:00 2359900 /usr/lib64/libcrypt-2.17.so
|
7fcea7da4000-7fcea7da5000 r--p 00007000 fd:00 2359900 /usr/lib64/libcrypt-2.17.so
|
7fcea7da5000-7fcea7da6000 rw-p 00008000 fd:00 2359900 /usr/lib64/libcrypt-2.17.so
|
7fcea7da6000-7fcea7dd4000 rw-p 00000000 00:00 0
|
7fcea7dd4000-7fcea7de9000 r-xp 00000000 fd:00 2360330 /usr/lib64/libz.so.1.2.7
|
7fcea7de9000-7fcea7fe8000 ---p 00015000 fd:00 2360330 /usr/lib64/libz.so.1.2.7
|
7fcea7fe8000-7fcea7fe9000 r--p 00014000 fd:00 2360330 /usr/lib64/libz.so.1.2.7
|
7fcea7fe9000-7fcea7fea000 rw-p 00015000 fd:00 2360330 /usr/lib64/libz.so.1.2.7
|
7fcea7fea000-7fcea7feb000 r-xp 00000000 fd:00 2363515 /usr/lib64/libaio.so.1.0.1
|
7fcea7feb000-7fcea81ea000 ---p 00001000 fd:00 2363515 /usr/lib64/libaio.so.1.0.1
|
7fcea81ea000-7fcea81eb000 r--p 00000000 fd:00 2363515 /usr/lib64/libaio.so.1.0.1
|
7fcea81eb000-7fcea81ec000 rw-p 00001000 fd:00 2363515 /usr/lib64/libaio.so.1.0.1
|
7fcea81ec000-7fcea8211000 r-xp 00000000 fd:00 2360189 /usr/lib64/liblzma.so.5.2.2
|
7fcea8211000-7fcea8410000 ---p 00025000 fd:00 2360189 /usr/lib64/liblzma.so.5.2.2
|
7fcea8410000-7fcea8411000 r--p 00024000 fd:00 2360189 /usr/lib64/liblzma.so.5.2.2
|
7fcea8411000-7fcea8412000 rw-p 00025000 fd:00 2360189 /usr/lib64/liblzma.so.5.2.2
|
7fcea8412000-7fcea8429000 r-xp 00000000 fd:00 2359922 /usr/lib64/libpthread-2.17.so
|
7fcea8429000-7fcea8628000 ---p 00017000 fd:00 2359922 /usr/lib64/libpthread-2.17.so
|
7fcea8628000-7fcea8629000 r--p 00016000 fd:00 2359922 /usr/lib64/libpthread-2.17.so
|
7fcea8629000-7fcea862a000 rw-p 00017000 fd:00 2359922 /usr/lib64/libpthread-2.17.so
|
7fcea862a000-7fcea862e000 rw-p 00000000 00:00 0
|
7fcea862e000-7fcea864f000 r-xp 00000000 fd:00 2377151 /usr/lib64/ld-2.17.so
|
7fcea8677000-7fcea8678000 rw-p 00000000 00:00 0
|
7fcea8678000-7fcea8679000 rw-s 00000000 00:0a 1302474 /[aio] (deleted)
|
7fcea8679000-7fcea867c000 rw-s 00000000 00:0a 1302473 /[aio] (deleted)
|
7fcea867c000-7fcea867f000 rw-s 00000000 00:0a 1302472 /[aio] (deleted)
|
7fcea867f000-7fcea8682000 rw-s 00000000 00:0a 1302471 /[aio] (deleted)
|
7fcea8682000-7fcea8685000 rw-s 00000000 00:0a 1302470 /[aio] (deleted)
|
7fcea8685000-7fcea8688000 rw-s 00000000 00:0a 1302469 /[aio] (deleted)
|
7fcea8688000-7fcea8814000 rw-p 00000000 00:00 0
|
7fcea8814000-7fcea883a000 r-xp 00000000 fd:00 2365681 /usr/lib64/libsystemd.so.0.6.0
|
7fcea883a000-7fcea883b000 r--p 00025000 fd:00 2365681 /usr/lib64/libsystemd.so.0.6.0
|
7fcea883b000-7fcea883c000 rw-p 00026000 fd:00 2365681 /usr/lib64/libsystemd.so.0.6.0
|
7fcea883c000-7fcea883e000 rw-p 00000000 00:00 0
|
7fcea883e000-7fcea8841000 rw-s 00000000 00:0a 1302468 /[aio] (deleted)
|
7fcea8841000-7fcea8844000 rw-s 00000000 00:0a 1302467 /[aio] (deleted)
|
7fcea8844000-7fcea8847000 rw-s 00000000 00:0a 1302466 /[aio] (deleted)
|
7fcea8847000-7fcea884a000 rw-s 00000000 00:0a 1302465 /[aio] (deleted)
|
7fcea884a000-7fcea884d000 rw-s 00000000 00:0a 1302464 /[aio] (deleted)
|
7fcea884d000-7fcea884e000 rw-s 00000000 00:0a 1302463 /[aio] (deleted)
|
7fcea884e000-7fcea884f000 rw-p 00000000 00:00 0
|
7fcea884f000-7fcea8850000 r--p 00021000 fd:00 2377151 /usr/lib64/ld-2.17.so
|
7fcea8850000-7fcea8851000 rw-p 00022000 fd:00 2377151 /usr/lib64/ld-2.17.so
|
7fcea8851000-7fcea8852000 rw-p 00000000 00:00 0
|
7ffd01eec000-7ffd01f0d000 rw-p 00000000 00:00 0 [stack]
|
7ffd01f6e000-7ffd01f70000 r-xp 00000000 00:00 0 [vdso]
|
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
|
Fatal signal 6 while backtracing
|
Attachments
Issue Links
- relates to
-
-
- Confirmed
-
-
-
- Closed
-
Activity
Was caught crash where clear visible that shutdown of the cache was not waiting untill all request will be finished... Now should be found how...
Problem is that we always first unlock whole cache then query in it. normal cache freeing do query by query freeing and it works, fast one does not do it, so ban free earlier then we get query free.
github: bb-5.5-MDEV-14526
revision-id: f26192559161143c7c0880cf24c63ced1cf9655e (mariadb-5.5.58-31-gf2619255916)
parent(s): 5ea28015d5864bec1e44722bbc7a3d1f2371c85d
author: Oleksandr Byelkin
committer: Oleksandr Byelkin
timestamp: 2018-01-12 18:17:55 +0100
message:
MDEV-14526: MariaDB keeps crashing under load when query_cache_type is changed
The problem was in such scenatio:
T1 - starts geristering query and locked QC
T2 - starts disabling QC and wait for UNLOCK
T1 - unlock QC
T2 - disable QC and destroy sugnals without waitiung for query unlock
T1 a) - not yet unlocked query in qc and crach on attempt to unlock because QC signals are destroyed
b) if above was done before distruction, it execute end_of results first time
it exit on after try_lock which see QC disables and return TRUE.
But it do not reset query_cache_tls->first_query_block which lead to
second call of end_of_result when diagnostic arena has already inapropriate staus (not is_eof()).
Fix is:
1) wait for all queries unlocked before destroing them by locking and unlockin
2) remove query_cache_tls->first_query_block if QC disabled
—
still happens
10.1 6aa50bad3947a0eab24fb029cd58f5945439e365
|
Server version: 10.1.34-MariaDB-debug
|
|
|
Thread pointer: 0x5626d60fa748
|
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 = 0x7fd22ad15270 thread_stack 0x48400
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x5626d40ddb1b]
|
sql/signal_handler.cc:168(handle_fatal_signal)[0x5626d3a1f7d7]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fd22f8ae390]
|
/lib/x86_64-linux-gnu/libpthread.so.0(pthread_rwlock_unlock+0x2c)[0x7fd22f8a9edc]
|
psi/mysql_thread.h:1071(inline_mysql_rwlock_unlock)[0x5626d377e1fb]
|
sql/sql_cache.cc:951(Query_cache_query::unlock_writing())[0x5626d378c627]
|
sql/sql_cache.cc:1562(Query_cache::store_query(THD*, TABLE_LIST*))[0x5626d378120a]
|
sql/sql_parse.cc:5944(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5626d37df8e7]
|
sql/sql_parse.cc:2989(mysql_execute_command(THD*))[0x5626d37d5a9f]
|
sql/sql_parse.cc:7449(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5626d37e3441]
|
sql/sql_parse.cc:1494(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5626d37d1b3c]
|
sql/sql_parse.cc:1121(do_command(THD*))[0x5626d37d08ba]
|
sql/sql_connect.cc:1330(do_handle_one_connection(THD*))[0x5626d390fe4b]
|
sql/sql_connect.cc:1243(handle_one_connection)[0x5626d390fb9a]
|
perfschema/pfs.cc:1863(pfs_spawn_thread)[0x5626d406f61a]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd22f8a46ba]
|
x86_64/clone.S:111(clone)[0x7fd22ef4f41d]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fd20c004de0): SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k
|
Connection ID (thread ID): 54
|
Status: NOT_KILLED
|
|
Thread 1 (Thread 0x7fd22ad15b00 (LWP 16273)):
|
#0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x00005626d40ddc0d in my_write_core (sig=11) at /home/alice/git/10.1/mysys/stacktrace.c:477
|
#2 0x00005626d3a1fb69 in handle_fatal_signal (sig=11) at /home/alice/git/10.1/sql/signal_handler.cc:296
|
#3 <signal handler called>
|
#4 0x00007fd22f8a9edc in _xend () at pthread_rwlock_unlock.c:38
|
#5 __GI___pthread_rwlock_unlock (rwlock=0x7fd218189278) at pthread_rwlock_unlock.c:38
|
#6 0x00005626d377e1fb in inline_mysql_rwlock_unlock (that=0x7fd218189278) at /home/alice/git/10.1/include/mysql/psi/mysql_thread.h:1071
|
#7 0x00005626d378c627 in Query_cache_query::unlock_writing (this=0x7fd218189270) at /home/alice/git/10.1/sql/sql_cache.cc:951
|
#8 0x00005626d378120a in Query_cache::store_query (this=0x5626d4b8d6e0 <query_cache>, thd=0x5626d60fa748, tables_used=0x7fd20c0051b0) at /home/alice/git/10.1/sql/sql_cache.cc:1562
|
#9 0x00005626d37df8e7 in execute_sqlcom_select (thd=0x5626d60fa748, all_tables=0x7fd20c0051b0) at /home/alice/git/10.1/sql/sql_parse.cc:5943
|
#10 0x00005626d37d5a9f in mysql_execute_command (thd=0x5626d60fa748) at /home/alice/git/10.1/sql/sql_parse.cc:2989
|
#11 0x00005626d37e3441 in mysql_parse (thd=0x5626d60fa748, rawbuf=0x7fd20c004de0 "SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k", length=69, parser_state=0x7fd22ad14610) at /home/alice/git/10.1/sql/sql_parse.cc:7449
|
#12 0x00005626d37d1b3c in dispatch_command (command=COM_QUERY, thd=0x5626d60fa748, packet=0x5626d6101639 "SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k", packet_length=69) at /home/alice/git/10.1/sql/sql_parse.cc:1492
|
#13 0x00005626d37d08ba in do_command (thd=0x5626d60fa748) at /home/alice/git/10.1/sql/sql_parse.cc:1121
|
#14 0x00005626d390fe4b in do_handle_one_connection (thd_arg=0x5626d60fa748) at /home/alice/git/10.1/sql/sql_connect.cc:1330
|
#15 0x00005626d390fb9a in handle_one_connection (arg=0x5626d60fa748) at /home/alice/git/10.1/sql/sql_connect.cc:1242
|
#16 0x00005626d406f61a in pfs_spawn_thread (arg=0x5626d5f529c8) at /home/alice/git/10.1/storage/perfschema/pfs.cc:1861
|
#17 0x00007fd22f8a46ba in start_thread (arg=0x7fd22ad15b00) at pthread_create.c:333
|
#18 0x00007fd22ef4f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thanks for the report.
There are lots of problems around changing query_cache_type at runtime, especially under the load. I recommend to avoid it if possible. Normally it shouldn't be needed.
Some of them are easy enough to reproduce. Initial work in this direction has been done in scope of MDEV-10826; however, let's move it into this issue and continue here.
Unfortunately, with the random crashes that this scenario produces, there is no way to be sure in advance that all of them have the same root cause – the only option is to fix some and then see if others stop happening, too.
The non-deterministic test case below causes at various failures by just re-running it on the same builds. Examples are given after the test case. Run with --repeat=N.
ENGINE=MyISAM;--connect (con1,localhost,root,,test)--send--connection default--connection con1--reap# Cleanup--disconnect con1--connection default5.5 c64a697bba4c3, also happens on all 10.x
mysqld: /data/src/5.5/sql/sql_cache.cc:1173: void Query_cache::end_of_result(THD*): Assertion `thd->stmt_da->is_eof()' failed.171130 0:15:29 [ERROR] mysqld got signal 6 ;#7 0x00007f24b33d0ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6#8 0x00000000005b63e1 in Query_cache::end_of_result (this=0x14d43c0 <query_cache>, thd=0x7f24aee69060) at /data/src/5.5/sql/sql_cache.cc:1173#9 0x00000000005fe8c5 in dispatch_command (command=COM_QUIT, thd=0x7f24aee69060, packet=0x7f24aee6e061 "", packet_length=0) at /data/src/5.5/sql/sql_parse.cc:1463#10 0x00000000005fc735 in do_command (thd=0x7f24aee69060) at /data/src/5.5/sql/sql_parse.cc:793#11 0x00000000006ff647 in do_handle_one_connection (thd_arg=0x7f24aee69060) at /data/src/5.5/sql/sql_connect.cc:1268#12 0x00000000006ff3d4 in handle_one_connection (arg=0x7f24aee69060) at /data/src/5.5/sql/sql_connect.cc:1184#13 0x0000000000a0d517 in pfs_spawn_thread (arg=0x7f24afb93080) at /data/src/5.5/storage/perfschema/pfs.cc:1015#14 0x00007f24b4a77494 in start_thread (arg=0x7f24b4dfc700) at pthread_create.c:333#15 0x00007f24b348d93f in clone () from /lib/x86_64-linux-gnu/libc.so.610.0 78b63425a3f172 non-debug
#2 <signal handler called>#3 0x00007f38708c2c23 in _xend () at pthread_rwlock_unlock.c:38#4 __GI___pthread_rwlock_unlock (rwlock=0x7f38672371b0) at pthread_rwlock_unlock.c:38#5 0x0000000000576417 in unlock_writing (this=<optimized out>) at /data/src/10.0/sql/sql_cache.cc:951#6 Query_cache::store_query (this=0x1269740 <query_cache>, thd=thd@entry=0x7f386886f008, tables_used=tables_used@entry=0x7f3866c1f278) at /data/src/10.0/sql/sql_cache.cc:1567#7 0x000000000059ce07 in execute_sqlcom_select (thd=0x7f386886f008, all_tables=0x7f3866c1f278) at /data/src/10.0/sql/sql_parse.cc:5301#8 0x00000000005a817d in mysql_execute_command (thd=0x7f386886f008) at /data/src/10.0/sql/sql_parse.cc:2562#9 0x00000000005aa0b8 in mysql_parse (thd=0x7f386886f008, rawbuf=<optimized out>, length=69, parser_state=0x7f3870c40850) at /data/src/10.0/sql/sql_parse.cc:6578#10 0x00000000005abad9 in dispatch_command (command=<optimized out>, thd=0x7f386886f008, packet=<optimized out>, packet_length=<optimized out>) at /data/src/10.0/sql/sql_parse.cc:1305#11 0x00000000005ac46f in do_command (thd=<optimized out>) at /data/src/10.0/sql/sql_parse.cc:999#12 0x000000000065b9e4 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f386886f008) at /data/src/10.0/sql/sql_connect.cc:1377#13 0x000000000065ba28 in handle_one_connection (arg=arg@entry=0x7f386886f008) at /data/src/10.0/sql/sql_connect.cc:1292#14 0x000000000088f6d4 in pfs_spawn_thread (arg=0x7f386e042208) at /data/src/10.0/storage/perfschema/pfs.cc:1860#15 0x00007f38708bd494 in start_thread (arg=0x7f3870c41700) at pthread_create.c:333#16 0x00007f386ea0893f in clone () from /lib/x86_64-linux-gnu/libc.so.610.2 414d3a3e17a6c8c0b debug
3 <signal handler called>#4 0x000055be0d141b4e in inline_mysql_rwlock_unlock (that=0x7f1ea60aa740) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1052#5 0x000055be0d150516 in Query_cache_query::unlock_writing (this=0x7f1ea60aa738) at /data/src/10.2/sql/sql_cache.cc:952#6 0x000055be0d144c03 in Query_cache::store_query (this=0x55be0e729ec0 <query_cache>, thd=0x7f1da8000b00, tables_used=0x7f1da80114b8) at /data/src/10.2/sql/sql_cache.cc:1569#7 0x000055be0d1a9426 in execute_sqlcom_select (thd=0x7f1da8000b00, all_tables=0x7f1da80114b8) at /data/src/10.2/sql/sql_parse.cc:6445#8 0x000055be0d19f433 in mysql_execute_command (thd=0x7f1da8000b00) at /data/src/10.2/sql/sql_parse.cc:3462#9 0x000055be0d1ace0a in mysql_parse (thd=0x7f1da8000b00, rawbuf=0x7f1da8011270 "SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k", length=69, parser_state=0x7f1dc7a12200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7887#10 0x000055be0d19ad24 in dispatch_command (command=COM_QUERY, thd=0x7f1da8000b00, packet=0x7f1da80861b1 "SELECT DISTINCT id FROM t1 WHERE id BETWEEN 5603 AND 16218 ORDER BY k", packet_length=69, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805#11 0x000055be0d199682 in do_command (thd=0x7f1da8000b00) at /data/src/10.2/sql/sql_parse.cc:1360#12 0x000055be0d2e7111 in do_handle_one_connection (connect=0x55be10211cc0) at /data/src/10.2/sql/sql_connect.cc:1354#13 0x000055be0d2e6e9e in handle_one_connection (arg=0x55be10211cc0) at /data/src/10.2/sql/sql_connect.cc:1260#14 0x000055be0d70572a in pfs_spawn_thread (arg=0x55be100326e0) at /data/src/10.2/storage/perfschema/pfs.cc:1863#15 0x00007f1dcd712494 in start_thread (arg=0x7f1dc7a13700) at pthread_create.c:333#16 0x00007f1dcbaf893f in clone () from /lib/x86_64-linux-gnu/libc.so.610.2.10 release
#2 <signal handler called>#3 unlock_rwlock_v1 (rwlock=0x4f33000000070000) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:3231#4 0x000055924b62b6b5 in inline_mysql_rwlock_unlock (that=0x7f5ac40e4bd0) at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1053#5 0x000055924b62f78d in unlock_writing (this=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_cache.cc:952#6 Query_cache::insert (this=0x55924c660880 <query_cache>, thd=<optimized out>, query_cache_tls=<optimized out>, packet=packet@entry=0x7f5ab8006c68 "]", length=97, pkt_nr=1) at /home/buildbot/buildbot/build/sql/sql_cache.cc:1124#7 0x000055924b62f809 in query_cache_insert (thd_arg=<optimized out>, packet=packet@entry=0x7f5ab8006c68 "]", length=<optimized out>, pkt_nr=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_cache.cc:1058#8 0x000055924b5ddc71 in net_real_write (net=net@entry=0x7f5ab8000be8, packet=0x7f5ab8006c68 "]", len=97) at /home/buildbot/buildbot/build/sql/net_serv.cc:619#9 0x000055924b5de233 in net_flush (net=0x7f5ab8000be8) at /home/buildbot/buildbot/build/sql/net_serv.cc:376#10 0x000055924b5fce8d in send_server_handshake_packet (mpvio=0x7f5ad8476460, data=0x7f5ab8004070 "=(N2Py3/3Ot|4)ov$L4_", data_len=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_acl.cc:12146#11 0x000055924b5fe245 in server_mpvio_write_packet (param=0x7f5ad8476460, packet=<optimized out>, packet_len=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_acl.cc:12827#12 0x000055924b5fc766 in native_password_authenticate (vio=0x7f5ad8476460, info=0x7f5ad8476478) at /home/buildbot/buildbot/build/sql/sql_acl.cc:13476#13 0x000055924b602f91 in do_auth_once (thd=thd@entry=0x7f5ab80009a8, auth_plugin_name=auth_plugin_name@entry=0x55924c5b0220 <native_password_plugin_name>, mpvio=mpvio@entry=0x7f5ad8476460) at /home/buildbot/buildbot/build/sql/sql_acl.cc:13087#14 0x000055924b618fdc in acl_authenticate (thd=thd@entry=0x7f5ab80009a8, com_change_user_pkt_len=com_change_user_pkt_len@entry=0) at /home/buildbot/buildbot/build/sql/sql_acl.cc:13185#15 0x000055924b727fa0 in check_connection (thd=thd@entry=0x7f5ab80009a8) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1022#16 0x000055924b729380 in login_connection (thd=thd@entry=0x7f5ab80009a8) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1091#17 0x000055924b729a49 in thd_prepare_connection (thd=0x7f5ab80009a8) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1268#18 0x000055924b729e2b in do_handle_one_connection (connect=connect@entry=0x55924e2d9668) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1345#19 0x000055924b729f74 in handle_one_connection (arg=arg@entry=0x55924e2d9668) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1260#20 0x000055924b962c2d in pfs_spawn_thread (arg=0x55924e2841b8) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1863#21 0x00007f5add0b5494 in start_thread (arg=0x7f5ad8477700) at pthread_create.c:333#22 0x00007f5adc77293f in clone () from /lib/x86_64-linux-gnu/libc.so.6