Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13607

MariaDB crash in fix_semijoin_strategies_for_picked_join_order

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.8, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
    • 10.2.25, 5.5.65, 10.1.41, 10.3.16, 10.4.6
    • Optimizer
    • None
    • Centos 5.7

    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

        1. 1mdev13607.test
          161 kB
        2. query.txt
          138 kB
        3. test.dump
          14 kB

        Issue Links

          Activity

            RIght. It'll be merged upwards, as always. To 10.1, 10.2 and 10.3. I've updated the list of fixed versions.

            serg Sergei Golubchik added a comment - RIght. It'll be merged upwards, as always. To 10.1, 10.2 and 10.3. I've updated the list of fixed versions.

            The original user test case (test.dump + query.txt) doesn't crash it in 10.1, but it still crashes in 10.2

            serg Sergei Golubchik added a comment - The original user test case (test.dump + query.txt) doesn't crash it in 10.1, but it still crashes in 10.2
            alice Alice Sherepa added a comment -

            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
            

            alice Alice Sherepa added a comment - 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
            igor Igor Babaev added a comment -

            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.

            igor Igor Babaev added a comment - 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.
            igor Igor Babaev added a comment -

            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

            igor Igor Babaev added a comment - 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

            People

              igor Igor Babaev
              BB Silver Asu
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.