Details
Description
Found this query that crashes latest MariaDB 10.2.8
# cat query.txt|mysql test
|
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
|
mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 8
|
Server version: 10.2.8-MariaDB MariaDB Server
|
Aug 21 19:02:42 uvn-234-24 mysqld: 170821 19:02:42 [ERROR] mysqld got signal 11 ;
|
Aug 21 19:02:42 uvn-234-24 mysqld: This could be because you hit a bug. It is also possible that this binary
|
Aug 21 19:02:42 uvn-234-24 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
|
Aug 21 19:02:42 uvn-234-24 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Aug 21 19:02:42 uvn-234-24 mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
Aug 21 19:02:42 uvn-234-24 mysqld: We will try our best to scrape up some info that will hopefully help
|
Aug 21 19:02:42 uvn-234-24 mysqld: diagnose the problem, but since we have already crashed,
|
Aug 21 19:02:42 uvn-234-24 mysqld: something is definitely wrong and this may fail.
|
Aug 21 19:02:42 uvn-234-24 mysqld: Server version: 10.2.8-MariaDB
|
Aug 21 19:02:42 uvn-234-24 mysqld: key_buffer_size=134217728
|
Aug 21 19:02:42 uvn-234-24 mysqld: read_buffer_size=131072
|
Aug 21 19:02:42 uvn-234-24 mysqld: max_used_connections=3
|
Aug 21 19:02:42 uvn-234-24 mysqld: max_threads=153
|
Aug 21 19:02:42 uvn-234-24 mysqld: thread_count=9
|
Aug 21 19:02:42 uvn-234-24 mysqld: It is possible that mysqld could use up to
|
Aug 21 19:02:42 uvn-234-24 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467215 K bytes of memory
|
Aug 21 19:02:42 uvn-234-24 mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Aug 21 19:02:42 uvn-234-24 mysqld: Thread pointer: 0x7faf21eb99e8
|
Aug 21 19:02:42 uvn-234-24 mysqld: Attempting backtrace. You can use the following information to find out
|
Aug 21 19:02:42 uvn-234-24 mysqld: where mysqld died. If you see no messages after this, something went
|
Aug 21 19:02:42 uvn-234-24 mysqld: terribly wrong...
|
Aug 21 19:02:42 uvn-234-24 mysqld: stack_bottom = 0x7faef80f4d70 thread_stack 0x49000
|
Aug 21 19:02:42 uvn-234-24 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7faf1edf0a7e]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x7faf1e836dbd]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /lib64/libpthread.so.0(+0xf130)[0x7faf1dd9f130]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /usr/sbin/mysqld(_Z45fix_semijoin_strategies_for_picked_join_orderP4JOIN+0x91)[0x7faf1e7a8bf1]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN4JOIN20get_best_combinationEv+0xc0)[0x7faf1e6d84c0]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /usr/sbin/mysqld(+0x5239d4)[0x7faf1e6f29d4]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x8c0)[0x7faf1e6f8050]
|
Aug 21 19:02:42 uvn-234-24 mysqld: mysys/stacktrace.c:268(my_print_stacktrace)[0x7faf1e6fa32f]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/opt_subselect.cc:3453(fix_semijoin_strategies_for_picked_join_order(JOIN*))[0x7faf1e6fba34]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_select.cc:8859(JOIN::get_best_combination())[0x7faf1e6fc614]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_parse.cc:6447(execute_sqlcom_select)[0x7faf1e69f556]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_parse.cc:3460(mysql_execute_command(THD*))[0x7faf1e6ab9d2]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_parse.cc:7887(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7faf1e6af0ae]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_parse.cc:1812(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7faf1e6b205d]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_parse.cc:1362(do_command(THD*))[0x7faf1e6b2c69]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x7faf1e7765da]
|
Aug 21 19:02:42 uvn-234-24 mysqld: sql/sql_connect.cc:1262(handle_one_connection)[0x7faf1e7766fd]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /lib64/libpthread.so.0(+0x7df3)[0x7faf1dd97df3]
|
Aug 21 19:02:42 uvn-234-24 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7faf1c3ef1ad]
|
Aug 21 19:02:42 uvn-234-24 mysqld: Trying to get some variables.
|
Aug 21 19:02:42 uvn-234-24 mysqld: Some pointers may be invalid and cause the dump to abort.
|
Aug 21 19:02:42 uvn-234-24 mysqld: Query (0x7faf21f272f0): SELECT f1_user.name,
|
Attachments
- 1mdev13607.test
- 161 kB
- query.txt
- 138 kB
- test.dump
- 14 kB
Issue Links
- duplicates
-
MDEV-19484 Server crashes in fix_semijoin_strategies_for_picked_join_order
-
- Closed
-
- is duplicated by
-
MDEV-18479 Assertion `join->best_read < double(1.79769313486231570815e+308L)' or server crashes in JOIN::fix_all_splittings_in_plan after EXPLAIN
-
- Closed
-
-
MDEV-19615 CRASH : [ERROR] mysqld got signal 11
-
- Closed
-
Activity
The original user test case (test.dump + query.txt) doesn't crash it in 10.1, but it still crashes in 10.2
on 10.1 c84f390df20c9fa385351, debug:
Right after applying dump, the first execution of the query hangs. But after killing the query and running it again - the results are returned, (0.17 sec), worked as expected.
MariaDB [(none)]> show processlist\G
|
*************************** 1. row ***************************
|
Id: 3
|
User: root
|
Host: localhost
|
db: test
|
Command: Query
|
Time: 632
|
State: statistics
|
Info: SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNU
|
Progress: 0.000
|
Thread 28 (Thread 0x7f79d5464700 (LWP 30039)):
|
#0 0x00007f79d310974d in poll () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000055d7116241d3 in vio_io_wait (vio=0x7f79bf3a3bf0, event=VIO_IO_EVENT_READ, timeout=28800000) at /git/10.1/src/vio/viosocket.c:992
|
#2 0x000055d711622a3f in vio_socket_io_wait (vio=0x7f79bf3a3bf0, event=VIO_IO_EVENT_READ) at /git/10.1/src/vio/viosocket.c:108
|
#3 0x000055d711622bf2 in vio_read (vio=0x7f79bf3a3bf0, buf=0x7f79a32ac070 "\001", size=4) at /git/10.1/src/vio/viosocket.c:184
|
#4 0x000055d710c65406 in my_real_read (net=0x7f79a32a6330, complen=0x7f79d5463800, header=1 '\001') at /git/10.1/src/sql/net_serv.cc:877
|
#5 0x000055d710c65b9a in my_net_read_packet (net=0x7f79a32a6330, read_from_server=1 '\001') at /git/10.1/src/sql/net_serv.cc:1140
|
#6 0x000055d710d2072a in do_command (thd=0x7f79a32a6070) at /git/10.1/src/sql/sql_parse.cc:1002
|
#7 0x000055d710e5cd49 in do_handle_one_connection (thd_arg=0x7f79a32a6070) at /git/10.1/src/sql/sql_connect.cc:1330
|
#8 0x000055d710e5ca98 in handle_one_connection (arg=0x7f79a32a6070) at /git/10.1/src/sql/sql_connect.cc:1242
|
#9 0x00007f79d3a6a6ba in start_thread (arg=0x7f79d5464700) at pthread_create.c:333
|
#10 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 27 (Thread 0x7f79d54ae700 (LWP 29957)):
|
#0 0x000055d7115c7a7f in my_thread_var_dbug () at /git/10.1/src/mysys/my_thr_init.c:444
|
#1 0x000055d7115e8432 in code_state () at /git/10.1/src/dbug/dbug.c:350
|
#2 0x000055d7115ea74f in _db_enter_ (_func_=0x55d711687b0c "best_access_path", _file_=0x55d711686f48 "/git/10.1/src/sql/sql_select.cc", _line_=5948, _stack_frame_=0x7f79d54a6af0) at /git/10.1/src/dbug/dbug.c:1101
|
#3 0x000055d710d71c35 in best_access_path (join=0x7f79a3d327e8, s=0x7f79a31dd5b0, remaining_tables=2032, idx=34, disable_jbuf=false, record_count=9765625, pos=0x7f79a31e1580, loose_scan_pos=0x7f79d54a6c70) at /git/10.1/src/sql/sql_select.cc:5948
|
#4 0x000055d710d768e9 in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2032, idx=34, record_count=9765625, read_time=65273670.200000003, search_depth=28, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7925
|
#5 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2040, idx=33, record_count=9765625, read_time=53554920.200000003, search_depth=29, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#6 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2044, idx=32, record_count=9765625, read_time=41836170.200000003, search_depth=30, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#7 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2046, idx=31, record_count=9765625, read_time=30117420.199999999, search_depth=31, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#8 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=33556478, idx=30, record_count=9765625, read_time=28164290.199999999, search_depth=32, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#9 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=50333694, idx=29, record_count=9765625, read_time=16445540.199999999, search_depth=33, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#10 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099561961470, idx=28, record_count=9765625, read_time=14492410.199999999, search_depth=34, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#11 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099830396926, idx=27, record_count=9765625, read_time=12539280.199999999, search_depth=35, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#12 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099830921214, idx=26, record_count=9765625, read_time=10586150.199999999, search_depth=36, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#13 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099839309822, idx=25, record_count=1953125, read_time=8607945.1999999993, search_depth=37, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#14 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099839571966, idx=24, record_count=1953125, read_time=6264195.2000000002, search_depth=38, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#15 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099973789694, idx=23, record_count=1953125, read_time=3920445.2000000002, search_depth=39, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#16 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649729603582, idx=22, record_count=1953125, read_time=1576695.2, search_depth=40, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#17 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649733797886, idx=21, record_count=1953125, read_time=1186065.2, search_depth=41, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#18 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649733928958, idx=20, record_count=390625, read_time=790736.19999999995, search_depth=42, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#19 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649736026110, idx=19, record_count=390625, read_time=321986.20000000001, search_depth=43, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#20 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649803134974, idx=18, record_count=78125, read_time=242946.20000000001, search_depth=44, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#21 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649803200510, idx=17, record_count=78125, read_time=227316.20000000001, search_depth=45, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#22 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1666983069694, idx=16, record_count=78125, read_time=211686.20000000001, search_depth=46, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#23 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1675573004286, idx=15, record_count=78125, read_time=117936.2, search_depth=47, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#24 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1675573037054, idx=14, record_count=78125, read_time=24186.200000000001, search_depth=48, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#25 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1675573053438, idx=13, record_count=15625, read_time=8390.2000000000007, search_depth=49, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#26 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950450960382, idx=12, record_count=3125, read_time=5229.1999999999998, search_depth=50, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#27 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950450968574, idx=11, record_count=3125, read_time=4599.1999999999998, search_depth=51, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#28 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950450972670, idx=10, record_count=3125, read_time=849.20000000000005, search_depth=52, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#29 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950452021246, idx=9, record_count=625, read_time=215.19999999999999, search_depth=53, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#30 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1954746988542, idx=8, record_count=125, read_time=87.200000000000003, search_depth=54, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#31 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1954746990590, idx=7, record_count=25, read_time=61.200000000000003, search_depth=55, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#32 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2092185944062, idx=6, record_count=25, read_time=51.200000000000003, search_depth=56, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#33 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2160905420798, idx=5, record_count=25, read_time=21.199999999999999, search_depth=57, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#34 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2195265159166, idx=4, record_count=5, read_time=15.199999999999999, search_depth=58, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#35 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2197412642814, idx=3, record_count=5, read_time=9.1999999999999993, search_depth=59, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#36 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2198486384638, idx=2, record_count=5, read_time=3.2000000000000002, search_depth=60, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#37 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2199023255550, idx=1, record_count=1, read_time=1.2, search_depth=61, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#38 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2199023255551, idx=0, record_count=1, read_time=0, search_depth=62, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996
|
#39 0x000055d710d74f1a in greedy_search (join=0x7f79a3d327e8, remaining_tables=2199023255551, search_depth=62, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7159
|
#40 0x000055d710d7446b in choose_plan (join=0x7f79a3d327e8, join_tables=2199023255551) at /git/10.1/src/sql/sql_select.cc:6736
|
#41 0x000055d710d6d9f3 in make_join_statistics (join=0x7f79a3d327e8, tables_list=..., keyuse_array=0x7f79a3d32b28) at /git/10.1/src/sql/sql_select.cc:4247
|
#42 0x000055d710d636d6 in JOIN::optimize_inner (this=0x7f79a3d327e8) at /git/10.1/src/sql/sql_select.cc:1403
|
#43 0x000055d710d623b0 in JOIN::optimize (this=0x7f79a3d327e8) at /git/10.1/src/sql/sql_select.cc:1058
|
#44 0x000055d710d6ad17 in mysql_select (thd=0x7f79bf3f7070, rref_pointer_array=0x7f79ae0acd50, tables=0x7f79ae107c60, wild_num=0, fields=..., conds=0x0, og_num=11, order=0x7f79ae112a90, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f79a3d326f0, unit=0x7f79ae0ace38, select_lex=0x7f79ae0acaa8) at /git/10.1/src/sql/sql_select.cc:3485
|
#45 0x000055d710cfb23f in mysql_derived_fill (thd=0x7f79bf3f7070, lex=0x7f79bf3faaf0, derived=0x7f79ae113ea8) at /git/10.1/src/sql/sql_derived.cc:955
|
#46 0x000055d710cfa009 in mysql_derived_merge (thd=0x7f79bf3f7070, lex=0x7f79bf3faaf0, derived=0x7f79ae113ea8) at /git/10.1/src/sql/sql_derived.cc:464
|
#47 0x000055d710cf9912 in mysql_handle_single_derived (lex=0x7f79bf3faaf0, derived=0x7f79ae113ea8, phases=8) at /git/10.1/src/sql/sql_derived.cc:196
|
#48 0x000055d710e2413a in TABLE_LIST::handle_derived (this=0x7f79ae113ea8, lex=0x7f79bf3faaf0, phases=8) at /git/10.1/src/sql/table.cc:7218
|
#49 0x000055d710d0e0de in LEX::handle_list_of_derived (this=0x7f79bf3faaf0, table_list=0x7f79ae0abe38, phases=8) at /git/10.1/src/sql/sql_lex.h:3026
|
#50 0x000055d710d1864a in st_select_lex::handle_derived (this=0x7f79bf3fb2b8, lex=0x7f79bf3faaf0, phases=8) at /git/10.1/src/sql/sql_lex.cc:3854
|
#51 0x000055d710d62634 in JOIN::optimize_inner (this=0x7f79a3d2d7d8) at /git/10.1/src/sql/sql_select.cc:1110
|
#52 0x000055d710d623b0 in JOIN::optimize (this=0x7f79a3d2d7d8) at /git/10.1/src/sql/sql_select.cc:1058
|
#53 0x000055d710d6ad17 in mysql_select (thd=0x7f79bf3f7070, rref_pointer_array=0x7f79bf3fb560, tables=0x7f79ae0abe38, wild_num=0, fields=..., conds=0x0, og_num=11, order=0x7f79a3d26300, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f79a3d2d7b8, unit=0x7f79bf3fabb8, select_lex=0x7f79bf3fb2b8) at /git/10.1/src/sql/sql_select.cc:3485
|
#54 0x000055d710d60487 in handle_select (thd=0x7f79bf3f7070, lex=0x7f79bf3faaf0, result=0x7f79a3d2d7b8, setup_tables_done_option=0) at /git/10.1/src/sql/sql_select.cc:388
|
#55 0x000055d710d2fc92 in execute_sqlcom_select (thd=0x7f79bf3f7070, all_tables=0x7f79ae0abe38) at /git/10.1/src/sql/sql_parse.cc:5951
|
#56 0x000055d710d25fe0 in mysql_execute_command (thd=0x7f79bf3f7070) at /git/10.1/src/sql/sql_parse.cc:3038
|
#57 0x000055d710d338e3 in mysql_parse (thd=0x7f79bf3f7070, rawbuf=0x7f79ae02d088 "SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNULL(gp_3.score, 0) AS gp_3_score, IFNULL(gp_4.score, 0) AS gp_4_score, IFNULL(gp_5.score, 0) AS gp_5_"..., length=140919, parser_state=0x7f79d54ad0b0) at /git/10.1/src/sql/sql_parse.cc:7469
|
#58 0x000055d710d21f70 in dispatch_command (command=COM_QUERY, thd=0x7f79bf3f7070, packet=0x7f79ae009071 "SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNULL(gp_3.score, 0) AS gp_3_score, IFNULL(gp_4.score, 0) AS gp_4_score, IFNULL(gp_5.score, 0) AS gp_5_"..., packet_length=140919) at /git/10.1/src/sql/sql_parse.cc:1499
|
#59 0x000055d710d20cf2 in do_command (thd=0x7f79bf3f7070) at /git/10.1/src/sql/sql_parse.cc:1131
|
#60 0x000055d710e5cd49 in do_handle_one_connection (thd_arg=0x7f79bf3f7070) at /git/10.1/src/sql/sql_connect.cc:1330
|
#61 0x000055d710e5ca98 in handle_one_connection (arg=0x7f79bf3f7070) at /git/10.1/src/sql/sql_connect.cc:1242
|
#62 0x00007f79d3a6a6ba in start_thread (arg=0x7f79d54ae700) at pthread_create.c:333
|
#63 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 26 (Thread 0x7f79d54f8700 (LWP 29949)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000055d7115cf18d in safe_cond_wait (cond=0x55d711ffcac0 <COND_slave_background>, mp=0x55d711fffb80 <LOCK_slave_background>, file=0x55d711660ee0 "/git/10.1/src/include/mysql/psi/mysql_thread.h", line=1165) at /git/10.1/src/mysys/thr_mutex.c:493
|
#2 0x000055d710c79846 in inline_mysql_cond_wait (that=0x55d711ffcac0 <COND_slave_background>, mutex=0x55d711fffb80 <LOCK_slave_background>, src_file=0x55d711661790 "/git/10.1/src/sql/slave.cc", src_line=336) at /git/10.1/src/include/mysql/psi/mysql_thread.h:1165
|
#3 0x000055d710c7a536 in handle_slave_background (arg=0x0) at /git/10.1/src/sql/slave.cc:336
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79d54f8700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 25 (Thread 0x7f79d5542700 (LWP 29948)):
|
#0 do_sigwait (sig=0x7f79d5541ca0, set=<optimized out>) at ../sysdeps/unix/sysv/linux/sigwait.c:64
|
#1 __sigwait (set=<optimized out>, sig=0x7f79d5541ca0) at ../sysdeps/unix/sysv/linux/sigwait.c:96
|
#2 0x000055d710c56a6f in signal_hand (arg=0x0) at /git/10.1/src/sql/mysqld.cc:3408
|
#3 0x00007f79d3a6a6ba in start_thread (arg=0x7f79d5542700) at pthread_create.c:333
|
#4 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 24 (Thread 0x7f79a63fe700 (LWP 29947)):
|
#0 0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307
|
#2 0x000055d71144e2ba in btr_defragment_thread () at /git/10.1/src/storage/xtradb/btr/btr0defragment.cc:708
|
#3 0x00007f79d3a6a6ba in start_thread (arg=0x7f79a63fe700) at pthread_create.c:333
|
#4 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 23 (Thread 0x7f79a6bff700 (LWP 29946)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000055d7113005bf in os_cond_wait (cond=0x7f79d1b5b2e8, fast_mutex=0x7f79d1b5b2b0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:196
|
#2 0x000055d71130092d in os_event_wait_low (event=0x7f79d1b5b2b0, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:477
|
#3 0x000055d711468272 in buf_dump_thread () at /git/10.1/src/storage/xtradb/buf/buf0dump.cc:731
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79a6bff700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 22 (Thread 0x7f79a7fff700 (LWP 29945)):
|
#0 0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307
|
#2 0x000055d7114709e0 in page_cleaner_sleep_if_needed (next_loop_time=1558080728612) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2678
|
#3 0x000055d71147135f in buf_flush_lru_manager_thread (arg=0x0) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2979
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79a7fff700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 21 (Thread 0x7f79acffe700 (LWP 29944)):
|
#0 0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307
|
#2 0x000055d7114709e0 in page_cleaner_sleep_if_needed (next_loop_time=1558080728618) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2678
|
#3 0x000055d711470d31 in buf_flush_page_cleaner_thread (arg=0x0) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2819
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79acffe700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 20 (Thread 0x7f79a9ff8700 (LWP 29943)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000055d7113005bf in os_cond_wait (cond=0x7f79d1b5b198, fast_mutex=0x7f79d1b5b160) at /git/10.1/src/storage/xtradb/os/os0sync.cc:196
|
#2 0x000055d71130092d in os_event_wait_low (event=0x7f79d1b5b160, reset_sig_count=13) at /git/10.1/src/storage/xtradb/os/os0sync.cc:477
|
#3 0x000055d7113be296 in srv_resume_thread (slot=0x55d712859018 <srv_sys+536>, sig_count=13, wait=true, timeout_usec=0) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:1082
|
#4 0x000055d7113c36af in srv_purge_coordinator_suspend (slot=0x55d712859018 <srv_sys+536>, rseg_history_len=129) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3492
|
#5 0x000055d7113c3a61 in srv_purge_coordinator_thread (arg=0x0) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3583
|
#6 0x00007f79d3a6a6ba in start_thread (arg=0x7f79a9ff8700) at pthread_create.c:333
|
#7 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 19 (Thread 0x7f79aa7f9700 (LWP 29942)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5cd98, fast_mutex=0x7f79d1b5cd60, abstime=0x7f79aa7f8c60) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159
|
#2 0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5cd60, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591
|
#3 0x000055d7114093a5 in ib_wqueue_timedwait (wq=0x7f79d185fd78, wait_in_usecs=5000000) at /git/10.1/src/storage/xtradb/ut/ut0wqueue.cc:155
|
#4 0x000055d71150b6fa in fts_optimize_thread (arg=0x7f79d185fd78) at /git/10.1/src/storage/xtradb/fts/fts0opt.cc:2908
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79aa7f9700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 18 (Thread 0x7f79aaffa700 (LWP 29941)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5c7e8, fast_mutex=0x7f79d1b5c7b0, abstime=0x7f79aaff9d10) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159
|
#2 0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5c7b0, time_in_usec=10000000, reset_sig_count=2) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591
|
#3 0x000055d7114bf433 in dict_stats_thread () at /git/10.1/src/storage/xtradb/dict/dict0stats_bg.cc:534
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79aaffa700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 17 (Thread 0x7f79ab7fb700 (LWP 29940)):
|
#0 0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307
|
#2 0x000055d7113c2b04 in srv_master_sleep () at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3116
|
#3 0x000055d7113c2c48 in srv_master_thread (arg=0x0) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3166
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79ab7fb700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 16 (Thread 0x7f79abffc700 (LWP 29939)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5b208, fast_mutex=0x7f79d1b5b1d0, abstime=0x7f79abffbcb0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159
|
#2 0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5b1d0, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591
|
#3 0x000055d7113c139c in srv_error_monitor_thread () at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:2424
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79abffc700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 15 (Thread 0x7f79ac7fd700 (LWP 29938)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5c548, fast_mutex=0x7f79d1b5c510, abstime=0x7f79ac7fccf0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159
|
#2 0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5c510, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591
|
#3 0x000055d7112cf2c9 in lock_wait_timeout_thread () at /git/10.1/src/storage/xtradb/lock/lock0wait.cc:597
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79ac7fd700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 14 (Thread 0x7f79ad7ff700 (LWP 29936)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5b278, fast_mutex=0x7f79d1b5b240, abstime=0x7f79ad7fecc0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159
|
#2 0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5b240, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591
|
#3 0x000055d7113c0d6e in srv_monitor_thread () at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:2183
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79ad7ff700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 13 (Thread 0x7f79aeff6700 (LWP 29935)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=3, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=9, message1=0x7f79aeff5cc0, message2=0x7f79aeff5cc8, type=0x7f79aeff5cd0, space_id=0x7f79aeff5cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=9) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d768 <n+72>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79aeff6700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 12 (Thread 0x7f79af7f7700 (LWP 29934)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=2, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=8, message1=0x7f79af7f6cc0, message2=0x7f79af7f6cc8, type=0x7f79af7f6cd0, space_id=0x7f79af7f6cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=8) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d760 <n+64>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79af7f7700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 11 (Thread 0x7f79afff8700 (LWP 29933)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=1, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=7, message1=0x7f79afff7cc0, message2=0x7f79afff7cc8, type=0x7f79afff7cd0, space_id=0x7f79afff7cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=7) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d758 <n+56>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79afff8700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 10 (Thread 0x7f79b07f9700 (LWP 29932)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=6, message1=0x7f79b07f8cc0, message2=0x7f79b07f8cc8, type=0x7f79b07f8cd0, space_id=0x7f79b07f8cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=6) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d750 <n+48>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b07f9700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 9 (Thread 0x7f79b0ffa700 (LWP 29931)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=3, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=5, message1=0x7f79b0ff9cc0, message2=0x7f79b0ff9cc8, type=0x7f79b0ff9cd0, space_id=0x7f79b0ff9cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=5) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d748 <n+40>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b0ffa700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 8 (Thread 0x7f79b17fb700 (LWP 29930)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=2, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=4, message1=0x7f79b17facc0, message2=0x7f79b17facc8, type=0x7f79b17facd0, space_id=0x7f79b17facd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=4) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d740 <n+32>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b17fb700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 7 (Thread 0x7f79b1ffc700 (LWP 29929)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=1, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=3, message1=0x7f79b1ffbcc0, message2=0x7f79b1ffbcc8, type=0x7f79b1ffbcd0, space_id=0x7f79b1ffbcd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=3) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d738 <n+24>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b1ffc700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 6 (Thread 0x7f79b27fd700 (LWP 29928)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=2, message1=0x7f79b27fccc0, message2=0x7f79b27fccc8, type=0x7f79b27fccd0, space_id=0x7f79b27fccd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=2) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d730 <n+16>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b27fd700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 5 (Thread 0x7f79b2ffe700 (LWP 29927)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d18811a0, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=1, message1=0x7f79b2ffdcc0, message2=0x7f79b2ffdcc8, type=0x7f79b2ffdcd0, space_id=0x7f79b2ffdcd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=1) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d728 <n+8>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b2ffe700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 4 (Thread 0x7f79b37ff700 (LWP 29926)):
|
#0 0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881200, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618
|
#2 0x000055d7112fdacd in os_aio_linux_handle (global_seg=0, message1=0x7f79b37fecc0, message2=0x7f79b37fecc8, type=0x7f79b37fecd0, space_id=0x7f79b37fecd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772
|
#3 0x000055d7114d3885 in fil_aio_wait (segment=0) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262
|
#4 0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d720 <n>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79b37ff700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 3 (Thread 0x7f79befff700 (LWP 29925)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7115cf497 in safe_cond_timedwait (cond=0x55d71282b8a0 <COND_checkpoint>, mp=0x55d71282b7e0 <LOCK_checkpoint>, abstime=0x7f79beffec90, file=0x55d711786320 "/git/10.1/src/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/src/mysys/thr_mutex.c:547
|
#2 0x000055d71116bf62 in inline_mysql_cond_timedwait (that=0x55d71282b8a0 <COND_checkpoint>, mutex=0x55d71282b7e0 <LOCK_checkpoint>, abstime=0x7f79beffec90, src_file=0x55d711786360 "/git/10.1/src/storage/maria/ma_servicethread.c", src_line=116) at /git/10.1/src/include/mysql/psi/mysql_thread.h:1202
|
#3 0x000055d71116c3f9 in my_service_thread_sleep (control=0x55d711e34b20 <checkpoint_control>, sleep_time=30000000000) at /git/10.1/src/storage/maria/ma_servicethread.c:115
|
#4 0x000055d711160d47 in ma_checkpoint_background (arg=0x1e) at /git/10.1/src/storage/maria/ma_checkpoint.c:708
|
#5 0x00007f79d3a6a6ba in start_thread (arg=0x7f79befff700) at pthread_create.c:333
|
#6 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 2 (Thread 0x7f79d0fbf700 (LWP 29924)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000055d7115cf497 in safe_cond_timedwait (cond=0x55d71287ff40 <COND_timer>, mp=0x55d71287fe80 <LOCK_timer>, abstime=0x7f79d0fbed40, file=0x55d711869030 "/git/10.1/src/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/src/mysys/thr_mutex.c:547
|
#2 0x000055d7115d0437 in inline_mysql_cond_timedwait (that=0x55d71287ff40 <COND_timer>, mutex=0x55d71287fe80 <LOCK_timer>, abstime=0x7f79d0fbed40, src_file=0x55d711869070 "/git/10.1/src/mysys/thr_timer.c", src_line=292) at /git/10.1/src/include/mysql/psi/mysql_thread.h:1202
|
#3 0x000055d7115d0ee5 in timer_handler (arg=0x0) at /git/10.1/src/mysys/thr_timer.c:292
|
#4 0x00007f79d3a6a6ba in start_thread (arg=0x7f79d0fbf700) at pthread_create.c:333
|
#5 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
|
Thread 1 (Thread 0x7f79d555e900 (LWP 29920)):
|
#0 0x00007f79d310974d in poll () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000055d710c5c88d in handle_connections_sockets () at /git/10.1/src/sql/mysqld.cc:6548
|
#2 0x000055d710c5b838 in mysqld_main (argc=11, argv=0x7f79d180f640) at /git/10.1/src/sql/mysqld.cc:5973
|
#3 0x000055d710c50810 in main (argc=3, argv=0x7ffd17dd3ae8) at /git/10.1/src/sql/main.cc:25
|
Succeeded to reproduce a problem on Debug build of 5.5 with the explain from 1mdev13607.test:
mysqld: /home/igor/maria-git/5.5/sql/sql_select.cc:6666: bool greedy_search(JOIN*, table_map, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
|
The problem appears sporadically.
Tested that the patch for MDEV-18479 fixed this problem in 5.5. Checked that reported test cases worked fine after the patch had been applied to 5.5
RIght. It'll be merged upwards, as always. To 10.1, 10.2 and 10.3. I've updated the list of fixed versions.