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

ASAN error, server hang or crash upon query cache operations

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.6(EOL), 10.11, 11.4, 11.8, 12.3, 13.1
    • 11.4, 11.8, 12.3
    • Query Cache
    • None

    Description

      I've made it minor because the test case involves changing the global value of query cache type, which probably doesn't happen often in real life; but it doesn't get automatically recognized as any of existing query cache bugs, and it affects testing of new query cache-related features, so I need it filed.

      --source include/have_query_cache.inc
      --source include/have_sequence.inc
      --source include/count_sessions.inc
       
      SET @qct= @@global.query_cache_type, @qcs= @@global.query_cache_size;
      SET GLOBAL query_cache_size= 128*1024;
      SET GLOBAL query_cache_type= ON;
       
      CREATE TABLE t1 (a INT) ENGINE=MyISAM;
      INSERT INTO t1 SELECT seq FROM seq_1_to_400;
       
      --connect (con1,localhost,root,,)
      SET SESSION query_cache_type= ON;
      # A slow cacheable query
      --send SELECT COUNT(*) FROM t1 a, t1 b, t1 c WHERE a.a+b.a+c.a > 0
       
      --connection default
      --let $wait_condition= SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE info LIKE 'SELECT COUNT(*) FROM t1 a%' AND state = 'Sending data'
      --source include/wait_condition.inc
      SET GLOBAL query_cache_type= OFF;
      SET GLOBAL query_cache_type= ON;
       
      --connection con1
      --reap
      --disconnect con1
      --connection default
       
      DROP TABLE t1;
      SET GLOBAL query_cache_type= @qct, query_cache_size= @qcs;
      --source include/wait_until_count_sessions.inc
      

      main f6d172c03bf3cd71fd30ac9cc7b24fd64497b472 ASAN build

      ==1689157==ERROR: AddressSanitizer: heap-use-after-free on address 0x634000040940 at pc 0x564e4547a4d3 bp 0x7f8aa05c52e0 sp 0x7f8aa05c52d8
      READ of size 4 at 0x634000040940 thread T7
          #0 0x564e4547a4d2 in Query_cache_block::query() /data/bld/main-asan-ubsan/sql/sql_cache.cc:856
          #1 0x564e45494aed in Query_cache::insert(THD*, Query_cache_tls*, char const*, unsigned long, unsigned int) /data/bld/main-asan-ubsan/sql/sql_cache.cc:1096
          #2 0x564e454950bc in query_cache_insert(void*, char const*, unsigned long, unsigned int) /data/bld/main-asan-ubsan/sql/sql_cache.cc:1056
          #3 0x564e47875a80 in net_real_write /data/bld/main-asan-ubsan/sql/net_serv.cc:640
          #4 0x564e4787697c in net_flush /data/bld/main-asan-ubsan/sql/net_serv.cc:387
          #5 0x564e451213c4 in Protocol::net_send_eof(THD*, unsigned int, unsigned int) /data/bld/main-asan-ubsan/sql/protocol.cc:347
          #6 0x564e4511f56c in Protocol::send_eof(unsigned int, unsigned int) /data/bld/main-asan-ubsan/sql/protocol.cc:678
          #7 0x564e4512cc71 in Protocol::end_statement() /data/bld/main-asan-ubsan/sql/protocol.cc:614
          #8 0x564e4550dd2b in select_send::send_eof() /data/bld/main-asan-ubsan/sql/sql_class.cc:3533
          #9 0x564e45ac9543 in do_select /data/bld/main-asan-ubsan/sql/sql_select.cc:25141
          #10 0x564e45ba6b98 in JOIN::exec_inner() /data/bld/main-asan-ubsan/sql/sql_select.cc:5147
          #11 0x564e45ba713c in JOIN::exec() /data/bld/main-asan-ubsan/sql/sql_select.cc:4935
          #12 0x564e45b9dee5 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /data/bld/main-asan-ubsan/sql/sql_select.cc:5461
          #13 0x564e45b9f02d in handle_select(THD*, LEX*, select_result*, unsigned long long) /data/bld/main-asan-ubsan/sql/sql_select.cc:652
          #14 0x564e457d7109 in execute_sqlcom_select /data/bld/main-asan-ubsan/sql/sql_parse.cc:6266
          #15 0x564e45819f8b in mysql_execute_command(THD*, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:4038
          #16 0x564e458385b8 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/main-asan-ubsan/sql/sql_parse.cc:8005
          #17 0x564e458417e4 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:1903
          #18 0x564e4584ddb4 in do_command(THD*, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:1437
          #19 0x564e4611e68f in do_handle_one_connection(CONNECT*, bool) /data/bld/main-asan-ubsan/sql/sql_connect.cc:1514
          #20 0x564e4611f7f8 in handle_one_connection /data/bld/main-asan-ubsan/sql/sql_connect.cc:1426
          #21 0x564e47da6348 in pfs_spawn_thread /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2198
          #22 0x7f8aafaa71f4 in start_thread nptl/pthread_create.c:442
          #23 0x7f8aafb278eb in clone3 ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
       
      0x634000040940 is located 320 bytes inside of 114024-byte region [0x634000040800,0x63400005c568)
      freed by thread T6 here:
          #0 0x7f8ab04b76a8 in __interceptor_free ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:52
          #1 0x564e49141f89 in my_free /data/bld/main-asan-ubsan/mysys/my_malloc.c:218
          #2 0x564e4547a6ca in Query_cache::free_cache() /data/bld/main-asan-ubsan/sql/sql_cache.cc:2834
          #3 0x564e4547b12d in Query_cache::unlock() /data/bld/main-asan-ubsan/sql/sql_cache.cc:763
          #4 0x564e4547b270 in Query_cache::disable_query_cache(THD*) /data/bld/main-asan-ubsan/sql/sql_cache.cc:2534
          #5 0x564e461bea38 in fix_query_cache_type /data/bld/main-asan-ubsan/sql/sys_vars.cc:3593
          #6 0x564e45183879 in sys_var::update(THD*, set_var*) /data/bld/main-asan-ubsan/sql/set_var.cc:246
          #7 0x564e45185d26 in set_var::update(THD*) /data/bld/main-asan-ubsan/sql/set_var.cc:914
          #8 0x564e4518c8ba in sql_set_variables(THD*, List<set_var_base>*, bool) /data/bld/main-asan-ubsan/sql/set_var.cc:791
          #9 0x564e4582791e in mysql_execute_command(THD*, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:4965
          #10 0x564e458385b8 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/main-asan-ubsan/sql/sql_parse.cc:8005
          #11 0x564e458417e4 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:1903
          #12 0x564e4584ddb4 in do_command(THD*, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:1437
          #13 0x564e4611e68f in do_handle_one_connection(CONNECT*, bool) /data/bld/main-asan-ubsan/sql/sql_connect.cc:1514
          #14 0x564e4611f7f8 in handle_one_connection /data/bld/main-asan-ubsan/sql/sql_connect.cc:1426
          #15 0x564e47da6348 in pfs_spawn_thread /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2198
          #16 0x7f8aafaa71f4 in start_thread nptl/pthread_create.c:442
       
      previously allocated by thread T6 here:
          #0 0x7f8ab04b89cf in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
          #1 0x564e49141846 in my_malloc /data/bld/main-asan-ubsan/mysys/my_malloc.c:93
          #2 0x564e454723c2 in Query_cache::init_cache() /data/bld/main-asan-ubsan/sql/sql_cache.cc:2658
          #3 0x564e454969eb in Query_cache::resize(unsigned long) /data/bld/main-asan-ubsan/sql/sql_cache.cc:1335
          #4 0x564e461b2c32 in fix_query_cache_size /data/bld/main-asan-ubsan/sql/sys_vars.cc:3504
          #5 0x564e461be98c in fix_query_cache_type /data/bld/main-asan-ubsan/sql/sys_vars.cc:3590
          #6 0x564e45183879 in sys_var::update(THD*, set_var*) /data/bld/main-asan-ubsan/sql/set_var.cc:246
          #7 0x564e45185d26 in set_var::update(THD*) /data/bld/main-asan-ubsan/sql/set_var.cc:914
          #8 0x564e4518c8ba in sql_set_variables(THD*, List<set_var_base>*, bool) /data/bld/main-asan-ubsan/sql/set_var.cc:791
          #9 0x564e4582791e in mysql_execute_command(THD*, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:4965
          #10 0x564e458385b8 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/main-asan-ubsan/sql/sql_parse.cc:8005
          #11 0x564e458417e4 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:1903
          #12 0x564e4584ddb4 in do_command(THD*, bool) /data/bld/main-asan-ubsan/sql/sql_parse.cc:1437
          #13 0x564e4611e68f in do_handle_one_connection(CONNECT*, bool) /data/bld/main-asan-ubsan/sql/sql_connect.cc:1514
          #14 0x564e4611f7f8 in handle_one_connection /data/bld/main-asan-ubsan/sql/sql_connect.cc:1426
          #15 0x564e47da6348 in pfs_spawn_thread /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2198
          #16 0x7f8aafaa71f4 in start_thread nptl/pthread_create.c:442
       
      Thread T7 created by T0 here:
          #0 0x7f8ab0449726 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:207
          #1 0x564e47da2304 in my_thread_create /data/bld/main-asan-ubsan/storage/perfschema/my_thread.h:38
          #2 0x564e47da67c5 in pfs_spawn_thread_v1 /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2249
          #3 0x564e44f89c23 in inline_mysql_thread_create /data/bld/main-asan-ubsan/include/mysql/psi/mysql_thread.h:1139
          #4 0x564e44f89c23 in create_thread_to_handle_connection(CONNECT*) /data/bld/main-asan-ubsan/sql/mysqld.cc:6694
          #5 0x564e44f9f91b in create_new_thread(CONNECT*) /data/bld/main-asan-ubsan/sql/mysqld.cc:6756
          #6 0x564e44f9fb43 in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/bld/main-asan-ubsan/sql/mysqld.cc:6818
          #7 0x564e44fa0795 in handle_connections_sockets() /data/bld/main-asan-ubsan/sql/mysqld.cc:6930
          #8 0x564e44fa0c46 in run_main_loop /data/bld/main-asan-ubsan/sql/mysqld.cc:6171
          #9 0x564e44fa22b9 in mysqld_main(int, char**) /data/bld/main-asan-ubsan/sql/mysqld.cc:6590
          #10 0x564e44f6eea1 in main /data/bld/main-asan-ubsan/sql/main.cc:34
          #11 0x7f8aafa45249 in __libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58
       
      Thread T6 created by T0 here:
          #0 0x7f8ab0449726 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:207
          #1 0x564e47da2304 in my_thread_create /data/bld/main-asan-ubsan/storage/perfschema/my_thread.h:38
          #2 0x564e47da67c5 in pfs_spawn_thread_v1 /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2249
          #3 0x564e44f89c23 in inline_mysql_thread_create /data/bld/main-asan-ubsan/include/mysql/psi/mysql_thread.h:1139
          #4 0x564e44f89c23 in create_thread_to_handle_connection(CONNECT*) /data/bld/main-asan-ubsan/sql/mysqld.cc:6694
          #5 0x564e44f9f91b in create_new_thread(CONNECT*) /data/bld/main-asan-ubsan/sql/mysqld.cc:6756
          #6 0x564e44f9fb43 in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/bld/main-asan-ubsan/sql/mysqld.cc:6818
          #7 0x564e44fa0795 in handle_connections_sockets() /data/bld/main-asan-ubsan/sql/mysqld.cc:6930
          #8 0x564e44fa0c46 in run_main_loop /data/bld/main-asan-ubsan/sql/mysqld.cc:6171
          #9 0x564e44fa22b9 in mysqld_main(int, char**) /data/bld/main-asan-ubsan/sql/mysqld.cc:6590
          #10 0x564e44f6eea1 in main /data/bld/main-asan-ubsan/sql/main.cc:34
          #11 0x7f8aafa45249 in __libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58
       
      SUMMARY: AddressSanitizer: heap-use-after-free /data/bld/main-asan-ubsan/sql/sql_cache.cc:856 in Query_cache_block::query()
      Shadow bytes around the buggy address:
        0x0c68800000d0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c68800000e0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c68800000f0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c6880000100: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
        0x0c6880000110: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      =>0x0c6880000120: fd fd fd fd fd fd fd fd[fd]fd fd fd fd fd fd fd
        0x0c6880000130: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
        0x0c6880000140: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
        0x0c6880000150: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
        0x0c6880000160: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
        0x0c6880000170: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      Shadow byte legend (one shadow byte represents 8 application bytes):
        Addressable:           00
        Partially addressable: 01 02 03 04 05 06 07 
        Heap left redzone:       fa
        Freed heap region:       fd
        Stack left redzone:      f1
        Stack mid redzone:       f2
        Stack right redzone:     f3
        Stack after return:      f5
        Stack use after scope:   f8
        Global redzone:          f9
        Global init order:       f6
        Poisoned by user:        f7
        Container overflow:      fc
        Array cookie:            ac
        Intra object redzone:    bb
        ASan internal:           fe
        Left alloca redzone:     ca
        Right alloca redzone:    cb
      ==1689157==ABORTING
      261021 16:53:50 [ERROR] /share8t/bld/main-asan-ubsan/sql/mariadbd got signal 6 ;
      Sorry, we probably made a mistake, and this is a bug.
       
      Your assistance in bug reporting will enable us to fix this for the next release.
      To report this bug, see https://mariadb.com/docs/general-resources/community/community/bug-tracking/reporting-bugs about how to report
      a bug on https://jira.mariadb.org/.
       
      Please include the information from the server start above, to the end of the
      information below.
       
      Server version: 13.2.0-MariaDB-asan-debug-log source revision: f6d172c03bf3cd71fd30ac9cc7b24fd64497b472
       
       
      Connection ID (thread ID): 5
      Status: NOT_KILLED
      Query (0x62d00037a448): SELECT COUNT(*) FROM t1 a, t1 b, t1 c WHERE a.a+b.a+c.a > 0
      

      main f6d172c03bf3cd71fd30ac9cc7b24fd64497b472 non-ASAN build

      3  <signal handler called>
      #4  0x000055676f9bb535 in pfs_start_rwlock_wait_v1 (state=0x7f0d6664fa80, rwlock=0xa5a5a5a5a5a5a5a5, op=PSI_RWLOCK_WRITELOCK, src_file=0x556770243d10 "/data/bld/main-debug/sql/sql_cache.cc", src_line=920) at /data/bld/main-debug/storage/perfschema/pfs.cc:2730
      #5  0x000055676f9bb9d0 in pfs_start_rwlock_wrwait_v1 (state=0x7f0d6664fa80, rwlock=0xa5a5a5a5a5a5a5a5, op=PSI_RWLOCK_WRITELOCK, src_file=0x556770243d10 "/data/bld/main-debug/sql/sql_cache.cc", src_line=920) at /data/bld/main-debug/storage/perfschema/pfs.cc:2860
      #6  0x00005567700b229e in psi_rwlock_wrlock (that=0x7f0d480496b0, file=0x556770243d10 "/data/bld/main-debug/sql/sql_cache.cc", line=920) at /data/bld/main-debug/mysys/my_thr_init.c:538
      #7  0x000055676f0dd157 in inline_mysql_rwlock_wrlock (that=0x7f0d480496b0, src_file=0x556770243d10 "/data/bld/main-debug/sql/sql_cache.cc", src_line=920) at /data/bld/main-debug/include/mysql/psi/mysql_thread.h:932
      #8  0x000055676f0dd6c3 in Query_cache_query::lock_writing (this=0x7f0d480496a8) at /data/bld/main-debug/sql/sql_cache.cc:920
      #9  0x000055676f0cf6d0 in Query_cache::insert (this=0x55677120a960 <query_cache>, thd=0x7f0d4c000dd0, query_cache_tls=0x7f0d4c0011d8, packet=0x7f0d4c00c600 "\002", length=72, pkt_nr=6) at /data/bld/main-debug/sql/sql_cache.cc:1096
      #10 0x000055676f0cf59b in query_cache_insert (thd_arg=0x7f0d4c000dd0, packet=0x7f0d4c00c600 "\002", length=72, pkt_nr=6) at /data/bld/main-debug/sql/sql_cache.cc:1056
      #11 0x000055676f832f54 in net_real_write (net=0x7f0d4c0011e0, packet=0x7f0d4c00c600 "\002", len=72) at /data/bld/main-debug/sql/net_serv.cc:640
      #12 0x000055676f832739 in net_flush (net=0x7f0d4c0011e0) at /data/bld/main-debug/sql/net_serv.cc:387
      #13 0x000055676f004b33 in Protocol::net_send_eof (this=0x7f0d4c0014b0, thd=0x7f0d4c000dd0, server_status=2082, statement_warn_count=0) at /data/bld/main-debug/sql/protocol.cc:347
      #14 0x000055676f005826 in Protocol::send_eof (this=0x7f0d4c0014b0, server_status=2082, statement_warn_count=0) at /data/bld/main-debug/sql/protocol.cc:678
      #15 0x000055676f005461 in Protocol::end_statement (this=0x7f0d4c0014b0) at /data/bld/main-debug/sql/protocol.cc:614
      #16 0x000055676f0ea4b5 in select_send::send_eof (this=0x7f0d4c01a4a0) at /data/bld/main-debug/sql/sql_class.cc:3533
      #17 0x000055676f24bd01 in do_select (join=0x7f0d4c01a4d0, procedure=0x0) at /data/bld/main-debug/sql/sql_select.cc:25141
      #18 0x000055676f211f4e in JOIN::exec_inner (this=0x7f0d4c01a4d0) at /data/bld/main-debug/sql/sql_select.cc:5147
      #19 0x000055676f210fca in JOIN::exec (this=0x7f0d4c01a4d0) at /data/bld/main-debug/sql/sql_select.cc:4935
      #20 0x000055676f212977 in mysql_select (thd=0x7f0d4c000dd0, tables=0x7f0d4c017b10, fields=..., conds=0x7f0d4c019890, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x7f0d4c01a4a0, unit=0x7f0d4c005568, select_lex=0x7f0d4c017390) at /data/bld/main-debug/sql/sql_select.cc:5461
      #21 0x000055676f20050a in handle_select (thd=0x7f0d4c000dd0, lex=0x7f0d4c005488, result=0x7f0d4c01a4a0, setup_tables_done_option=0) at /data/bld/main-debug/sql/sql_select.cc:652
      #22 0x000055676f1961a0 in execute_sqlcom_select (thd=0x7f0d4c000dd0, all_tables=0x7f0d4c017b10) at /data/bld/main-debug/sql/sql_parse.cc:6266
      #23 0x000055676f18dc34 in mysql_execute_command (thd=0x7f0d4c000dd0, is_called_from_prepared_stmt=false) at /data/bld/main-debug/sql/sql_parse.cc:4038
      #24 0x000055676f19b5c2 in mysql_parse (thd=0x7f0d4c000dd0, rawbuf=0x7f0d4c0172b0 "SELECT COUNT(*) FROM t1 a, t1 b, t1 c WHERE a.a+b.a+c.a > 0", length=59, parser_state=0x7f0d66651220) at /data/bld/main-debug/sql/sql_parse.cc:8005
      #25 0x000055676f187174 in dispatch_command (command=COM_QUERY, thd=0x7f0d4c000dd0, packet=0x7f0d4c00c601 "", packet_length=59, blocking=true) at /data/bld/main-debug/sql/sql_parse.cc:1903
      #26 0x000055676f185abc in do_command (thd=0x7f0d4c000dd0, blocking=true) at /data/bld/main-debug/sql/sql_parse.cc:1437
      #27 0x000055676f3b4d13 in do_handle_one_connection (connect=0x556797274cc0, put_in_cache=true) at /data/bld/main-debug/sql/sql_connect.cc:1514
      #28 0x000055676f3b4a94 in handle_one_connection (arg=0x556797274cc0) at /data/bld/main-debug/sql/sql_connect.cc:1426
      #29 0x000055676f9ba3a6 in pfs_spawn_thread (arg=0x5567971b86b0) at /data/bld/main-debug/storage/perfschema/pfs.cc:2198
      #30 0x00007f0d6c0a71f5 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #31 0x00007f0d6c1278ec in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      MTR runs with performance schema on by default, hence the test case above. With performance schema off (--mysqld=--performance-schema=off, it crashes in a different way or hangs:

      #3  <signal handler called>
      #4  Query_cache::free_query_internal (this=0x555a63b70960 <query_cache>, query_block=0x7f4410040810) at /data/bld/main-debug/sql/sql_cache.cc:2947
      #5  0x0000555a61a3afe4 in Query_cache::free_query (this=0x555a63b70960 <query_cache>, query_block=0x7f4410040810) at /data/bld/main-debug/sql/sql_cache.cc:3011
      #6  0x0000555a61a357e6 in Query_cache::insert (this=0x555a63b70960 <query_cache>, thd=0x7f4414000dd0, query_cache_tls=0x7f44140011d8, packet=0x7f441400c600 "\002", length=72, pkt_nr=6) at /data/bld/main-debug/sql/sql_cache.cc:1115
      #7  0x0000555a61a3559b in query_cache_insert (thd_arg=0x7f4414000dd0, packet=0x7f441400c600 "\002", length=72, pkt_nr=6) at /data/bld/main-debug/sql/sql_cache.cc:1056
      #8  0x0000555a62198f54 in net_real_write (net=0x7f44140011e0, packet=0x7f441400c600 "\002", len=72) at /data/bld/main-debug/sql/net_serv.cc:640
      #9  0x0000555a62198739 in net_flush (net=0x7f44140011e0) at /data/bld/main-debug/sql/net_serv.cc:387
      #10 0x0000555a6196ab33 in Protocol::net_send_eof (this=0x7f44140014b0, thd=0x7f4414000dd0, server_status=2082, statement_warn_count=0) at /data/bld/main-debug/sql/protocol.cc:347
      #11 0x0000555a6196b826 in Protocol::send_eof (this=0x7f44140014b0, server_status=2082, statement_warn_count=0) at /data/bld/main-debug/sql/protocol.cc:678
      #12 0x0000555a6196b461 in Protocol::end_statement (this=0x7f44140014b0) at /data/bld/main-debug/sql/protocol.cc:614
      #13 0x0000555a61a504b5 in select_send::send_eof (this=0x7f441401a4a0) at /data/bld/main-debug/sql/sql_class.cc:3533
      #14 0x0000555a61bb1d01 in do_select (join=0x7f441401a4d0, procedure=0x0) at /data/bld/main-debug/sql/sql_select.cc:25141
      #15 0x0000555a61b77f4e in JOIN::exec_inner (this=0x7f441401a4d0) at /data/bld/main-debug/sql/sql_select.cc:5147
      #16 0x0000555a61b76fca in JOIN::exec (this=0x7f441401a4d0) at /data/bld/main-debug/sql/sql_select.cc:4935
      #17 0x0000555a61b78977 in mysql_select (thd=0x7f4414000dd0, tables=0x7f4414017b10, fields=..., conds=0x7f4414019890, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x7f441401a4a0, unit=0x7f4414005568, select_lex=0x7f4414017390) at /data/bld/main-debug/sql/sql_select.cc:5461
      #18 0x0000555a61b6650a in handle_select (thd=0x7f4414000dd0, lex=0x7f4414005488, result=0x7f441401a4a0, setup_tables_done_option=0) at /data/bld/main-debug/sql/sql_select.cc:652
      #19 0x0000555a61afc1a0 in execute_sqlcom_select (thd=0x7f4414000dd0, all_tables=0x7f4414017b10) at /data/bld/main-debug/sql/sql_parse.cc:6266
      #20 0x0000555a61af3c34 in mysql_execute_command (thd=0x7f4414000dd0, is_called_from_prepared_stmt=false) at /data/bld/main-debug/sql/sql_parse.cc:4038
      #21 0x0000555a61b015c2 in mysql_parse (thd=0x7f4414000dd0, rawbuf=0x7f44140172b0 "SELECT COUNT(*) FROM t1 a, t1 b, t1 c WHERE a.a+b.a+c.a > 0", length=59, parser_state=0x7f442ed00220) at /data/bld/main-debug/sql/sql_parse.cc:8005
      #22 0x0000555a61aed174 in dispatch_command (command=COM_QUERY, thd=0x7f4414000dd0, packet=0x7f441400c601 "", packet_length=59, blocking=true) at /data/bld/main-debug/sql/sql_parse.cc:1903
      #23 0x0000555a61aebabc in do_command (thd=0x7f4414000dd0, blocking=true) at /data/bld/main-debug/sql/sql_parse.cc:1437
      #24 0x0000555a61d1ad13 in do_handle_one_connection (connect=0x555a878c5950, put_in_cache=true) at /data/bld/main-debug/sql/sql_connect.cc:1514
      #25 0x0000555a61d1aa94 in handle_one_connection (arg=0x555a878c5950) at /data/bld/main-debug/sql/sql_connect.cc:1426
      #26 0x0000555a623203a6 in pfs_spawn_thread (arg=0x555a8780b8f0) at /data/bld/main-debug/storage/perfschema/pfs.cc:2198
      #27 0x00007f442fca71f5 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #28 0x00007f442fd278ec in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Activity

          People

            raghunandan.bhat Raghunandan Bhat
            elenst Elena Stepanova
            Oleksandr Byelkin Oleksandr Byelkin
            Raghunandan Bhat Raghunandan Bhat
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 0.25d Original Estimate - 0.25d
                0.25d
                Remaining:
                Time Spent - 20m Remaining Estimate - 0.25d
                0.25d
                Logged:
                Time Spent - 20m Remaining Estimate - 0.25d
                20m

                Git Integration

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