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

JSON_TABLE: AddressSanitizer CHECK failed in Binary_string::realloc_raw

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: 10.6.0
    • Component/s: JSON
    • Labels:
      None

      Description

      I'm not sure whether it is really JSON_TABLE-specific, there have been failures like this in the vanilla server. But I can't convert the test case into a non-JSON_TABLE form, so filing it as related for now.

      SELECT x, COUNT(*) FROM JSON_TABLE(
        '{}', '$' COLUMNS(
          a BIT(14) PATH '$',
          b CHAR(16) PATH '$',
          c INT PATH '$[0]',
          d INT PATH '$[1]',
          e INT PATH '$[2]',
          f INT PATH '$[3]',
          g INT PATH '$[4]',
          h INT PATH '$[5]',
          i INT PATH '$[6]',
          j INT PATH '$[7]',
          x TEXT PATH '$[9]'
        )
      ) AS jt GROUP BY x;
      

      bb-10.6-mdev17399-hf d9a80ae19

      ==1873706==AddressSanitizer CHECK failed: ../../../../src/libsanitizer/asan/asan_descriptions.cc:79 "((0 && "Address is not in memory and not in shadow?")) != (0)" (0x0, 0x0)
          #0 0x7f918c6e9c7e  (/lib/x86_64-linux-gnu/libasan.so.5+0x117c7e)
          #1 0x7f918c7082ae  (/lib/x86_64-linux-gnu/libasan.so.5+0x1362ae)
          #2 0x7f918c5ffb5f  (/lib/x86_64-linux-gnu/libasan.so.5+0x2db5f)
          #3 0x7f918c601376  (/lib/x86_64-linux-gnu/libasan.so.5+0x2f376)
          #4 0x7f918c603e84  (/lib/x86_64-linux-gnu/libasan.so.5+0x31e84)
          #5 0x7f918c6e930d  (/lib/x86_64-linux-gnu/libasan.so.5+0x11730d)
          #6 0x7f918c66d49e  (/lib/x86_64-linux-gnu/libasan.so.5+0x9b49e)
          #7 0x55b1c1d07d6b in Binary_string::realloc_raw(unsigned long) /data/src/bb-10.6-mdev17399-hf/sql/sql_string.cc:108
          #8 0x55b1c17b4cb8 in Binary_string::realloc(unsigned long) /data/src/bb-10.6-mdev17399-hf/sql/sql_string.h:645
          #9 0x55b1c1d08a0b in Binary_string::copy() /data/src/bb-10.6-mdev17399-hf/sql/sql_string.cc:220
          #10 0x55b1c20ab7d3 in String::copy() /data/src/bb-10.6-mdev17399-hf/sql/sql_string.h:823
          #11 0x55b1c20ac401 in Field_blob::store_field(Field*) /data/src/bb-10.6-mdev17399-hf/sql/field.h:4456
          #12 0x55b1c2296bc5 in field_conv_incompatible /data/src/bb-10.6-mdev17399-hf/sql/field_conv.cc:850
          #13 0x55b1c2296c66 in field_conv(Field*, Field*) /data/src/bb-10.6-mdev17399-hf/sql/field_conv.cc:863
          #14 0x55b1c1be8e31 in Create_tmp_table::finalize(THD*, TABLE*, TMP_TABLE_PARAM*, bool, bool) /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:18927
          #15 0x55b1c1bee422 in create_tmp_table(THD*, TMP_TABLE_PARAM*, List<Item>&, st_order*, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const*, bool, bool) /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:19303
          #16 0x55b1c1b79925 in JOIN::create_postjoin_aggr_table(st_join_table*, List<Item>*, st_order*, bool, bool, bool) /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3784
          #17 0x55b1c1b7540c in JOIN::make_aggr_tables_info() /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3384
          #18 0x55b1c1b70fd0 in JOIN::optimize_stage2() /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3028
          #19 0x55b1c1b69516 in JOIN::optimize_inner() /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:2299
          #20 0x55b1c1b6269b in JOIN::optimize() /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:1642
          #21 0x55b1c1b833f3 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/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:4750
          #22 0x55b1c1b54677 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:420
          #23 0x55b1c1abe23d in execute_sqlcom_select /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:6231
          #24 0x55b1c1aad522 in mysql_execute_command(THD*) /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:3927
          #25 0x55b1c1ac94b6 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:8005
          #26 0x55b1c1a9ff2f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:1888
          #27 0x55b1c1a9cc6a in do_command(THD*, bool) /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:1399
          #28 0x55b1c1edfc19 in do_handle_one_connection(CONNECT*, bool) /data/src/bb-10.6-mdev17399-hf/sql/sql_connect.cc:1410
          #29 0x55b1c1edf576 in handle_one_connection /data/src/bb-10.6-mdev17399-hf/sql/sql_connect.cc:1312
          #30 0x55b1c2bf0cbe in pfs_spawn_thread /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
          #31 0x7f918c18f608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477
          #32 0x7f918bd63292 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x122292)
       
      210414  2:22:36 [ERROR] mysqld got signal 6 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
       
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs
       
      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed, 
      something is definitely wrong and this may fail.
       
      Server version: 10.6.0-MariaDB-debug-log
      key_buffer_size=1048576
      read_buffer_size=131072
      max_used_connections=1
      max_threads=153
      thread_count=1
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63804 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x62b000069288
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7f9182977d50 thread_stack 0x100000
      ??:0(__interceptor_tcgetattr)[0x7f918c63ed30]
      mysys/stacktrace.c:212(my_print_stacktrace)[0x55b1c3816a6b]
      sql/signal_handler.cc:224(handle_fatal_signal)[0x55b1c22b4b27]
      sigaction.c:0(__restore_rt)[0x7f918c19b3c0]
      ??:0(gsignal)[0x7f918bc8718b]
      ??:0(abort)[0x7f918bc66859]
      ??:0(__sanitizer_set_report_fd)[0x7f918c6fd6a2]
      ??:0(__sanitizer_get_module_and_offset_for_pc)[0x7f918c70824c]
      ??:0(__sanitizer_ptr_cmp)[0x7f918c6e9c47]
      ??:0(__sanitizer_get_module_and_offset_for_pc)[0x7f918c7082af]
      ??:0(__asan_get_shadow_mapping)[0x7f918c5ffb60]
      ??:0(__asan_get_shadow_mapping)[0x7f918c601377]
      ??:0(__asan_get_shadow_mapping)[0x7f918c603e85]
      ??:0(__asan_on_error)[0x7f918c6e930e]
      ??:0(__interceptor_getdelim)[0x7f918c66d49f]
      sql/sql_string.cc:109(Binary_string::realloc_raw(unsigned long))[0x55b1c1d07d6c]
      sql/sql_string.h:645(Binary_string::realloc(unsigned long))[0x55b1c17b4cb9]
      sql/sql_string.cc:220(Binary_string::copy())[0x55b1c1d08a0c]
      sql/sql_string.h:824(String::copy())[0x55b1c20ab7d4]
      sql/field.h:4457(Field_blob::store_field(Field*))[0x55b1c20ac402]
      sql/field_conv.cc:851(field_conv_incompatible(Field*, Field*))[0x55b1c2296bc6]
      sql/field_conv.cc:864(field_conv(Field*, Field*))[0x55b1c2296c67]
      sql/sql_select.cc:18928(Create_tmp_table::finalize(THD*, TABLE*, TMP_TABLE_PARAM*, bool, bool))[0x55b1c1be8e32]
      sql/sql_select.cc:19302(create_tmp_table(THD*, TMP_TABLE_PARAM*, List<Item>&, st_order*, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const*, bool, bool))[0x55b1c1bee423]
      sql/sql_select.cc:3784(JOIN::create_postjoin_aggr_table(st_join_table*, List<Item>*, st_order*, bool, bool, bool))[0x55b1c1b79926]
      sql/sql_select.cc:3384(JOIN::make_aggr_tables_info())[0x55b1c1b7540d]
      sql/sql_select.cc:3028(JOIN::optimize_stage2())[0x55b1c1b70fd1]
      sql/sql_select.cc:2299(JOIN::optimize_inner())[0x55b1c1b69517]
      sql/sql_select.cc:1642(JOIN::optimize())[0x55b1c1b6269c]
      sql/sql_select.cc:4750(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*))[0x55b1c1b833f4]
      sql/sql_select.cc:420(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55b1c1b54678]
      sql/sql_parse.cc:6231(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b1c1abe23e]
      sql/sql_parse.cc:3927(mysql_execute_command(THD*))[0x55b1c1aad523]
      sql/sql_parse.cc:8005(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55b1c1ac94b7]
      sql/sql_parse.cc:1890(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55b1c1a9ff30]
      sql/sql_parse.cc:1399(do_command(THD*, bool))[0x55b1c1a9cc6b]
      sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x55b1c1edfc1a]
      sql/sql_connect.cc:1314(handle_one_connection)[0x55b1c1edf577]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55b1c2bf0cbf]
      nptl/pthread_create.c:478(start_thread)[0x7f918c18f609]
      ??:0(clone)[0x7f918bd63293]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x62b000038440): SELECT x, COUNT(*) FROM JSON_TABLE(
      '{}', '$' COLUMNS(
      a BIT(14) PATH '$',
      b CHAR(16) PATH '$',
      c INT PATH '$[0]',
      d INT PATH '$[1]',
      e INT PATH '$[2]',
      f INT PATH '$[3]',
      g INT PATH '$[4]',
      h INT PATH '$[5]',
      i INT PATH '$[6]',
      j INT PATH '$[7]',
      x TEXT PATH '$[9]'
        )
      ) AS jt GROUP BY x
       
      Connection ID (thread ID): 4
      Status: NOT_KILLED
       
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
       
      The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
      information that should help you find out what is causing the crash.
      Writing a core file...
      Working directory at /dev/shm/var_auto_RMi8/mysqld.1/data
      Resource Limits:
      Limit                     Soft Limit           Hard Limit           Units     
      Max cpu time              unlimited            unlimited            seconds   
      Max file size             unlimited            unlimited            bytes     
      Max data size             unlimited            unlimited            bytes     
      Max stack size            8388608              unlimited            bytes     
      Max core file size        unlimited            unlimited            bytes     
      Max resident set          unlimited            unlimited            bytes     
      Max processes             385874               385874               processes 
      Max open files            1024                 1024                 files     
      Max locked memory         67108864             67108864             bytes     
      Max address space         unlimited            unlimited            bytes     
      Max file locks            unlimited            unlimited            locks     
      Max pending signals       385874               385874               signals   
      Max msgqueue size         819200               819200               bytes     
      Max nice priority         0                    0                    
      Max realtime priority     0                    0                    
      Max realtime timeout      unlimited            unlimited            us        
      Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E
       
      ----------SERVER LOG END-------------
       
       
       - found 'core' (0/5)
       
      Trying 'dbx' to get a backtrace
       
      Trying 'gdb' to get a backtrace from coredump /mnt-hd8t/src/bb-10.6-mdev17399-hf/mysql-test/var/log/bug.json49/mysqld.1/data/core
      Core generated by '/mnt-hd8t/src/bb-10.6-mdev17399-hf/sql/mariadbd'
      Output from gdb follows. The first stack trace is from the failing thread.
      The following stack traces are from all threads (so the failing one is
      duplicated).
      --------------------------
      [New LWP 1873713]
      [New LWP 1873708]
      [New LWP 1873707]
      [New LWP 1873706]
      [New LWP 1873709]
      [New LWP 1873712]
      [Thread debugging using libthread_db enabled]
      Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
      Core was generated by `/mnt-hd8t/src/bb-10.6-mdev17399-hf/sql/mariadbd --defaults-group-suffix=.1 --de'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      56	../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
      [Current thread is 1 (Thread 0x7f9182978700 (LWP 1873713))]
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055b1c3816bed in my_write_core (sig=6) at /data/src/bb-10.6-mdev17399-hf/mysys/stacktrace.c:424
      #2  0x000055b1c22b5067 in handle_fatal_signal (sig=6) at /data/src/bb-10.6-mdev17399-hf/sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00007f918bc66859 in __GI_abort () at abort.c:79
      #6  0x00007f918c6fd6a2 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #7  0x00007f918c70824c in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #8  0x00007f918c6e9c47 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #9  0x00007f918c7082af in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #10 0x00007f918c5ffb60 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #11 0x00007f918c601377 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #12 0x00007f918c603e85 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #13 0x00007f918c6e930e in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #14 0x00007f918c66d49f in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #15 0x000055b1c1d07d6c in Binary_string::realloc_raw (this=0x61900008d118, alloc_length=8224) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.cc:108
      #16 0x000055b1c17b4cb9 in Binary_string::realloc (this=0x61900008d118, arg_length=8224) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.h:645
      #17 0x000055b1c1d08a0c in Binary_string::copy (this=0x61900008d118) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.cc:220
      #18 0x000055b1c20ab7d4 in String::copy (this=0x61900008d110) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.h:823
      #19 0x000055b1c20ac402 in Field_blob::store_field (this=0x61900008d028, from=0x61d0001cfee8) at /data/src/bb-10.6-mdev17399-hf/sql/field.h:4456
      #20 0x000055b1c2296bc6 in field_conv_incompatible (to=0x61900008d028, from=0x61d0001cfee8) at /data/src/bb-10.6-mdev17399-hf/sql/field_conv.cc:850
      #21 0x000055b1c2296c67 in field_conv (to=0x61900008d028, from=0x61d0001cfee8) at /data/src/bb-10.6-mdev17399-hf/sql/field_conv.cc:863
      #22 0x000055b1c1be8e32 in Create_tmp_table::finalize (this=0x7f9182974e90, thd=0x62b000069288, table=0x620000017128, param=0x6290002601f8, do_not_open=true, keep_row_order=false) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:18927
      #23 0x000055b1c1bee423 in create_tmp_table (thd=0x62b000069288, param=0x6290002601f8, fields=..., group=0x62b00003e228, distinct=false, save_sum_fields=false, select_options=2147748608, rows_limit=18446744073709551615, table_alias=0x55b1c4ea8300 <empty_clex_str>, do_not_open=true, keep_row_order=false) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:19303
      #24 0x000055b1c1b79926 in JOIN::create_postjoin_aggr_table (this=0x62900025e2d8, tab=0x62900025fa60, table_fields=0x62900025e608, table_group=0x62b00003e228, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3784
      #25 0x000055b1c1b7540d in JOIN::make_aggr_tables_info (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3384
      #26 0x000055b1c1b70fd1 in JOIN::optimize_stage2 (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3028
      #27 0x000055b1c1b69517 in JOIN::optimize_inner (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:2299
      #28 0x000055b1c1b6269c in JOIN::optimize (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:1642
      #29 0x000055b1c1b833f4 in mysql_select (thd=0x62b000069288, tables=0x62b00003db20, fields=..., conds=0x0, og_num=1, order=0x0, group=0x62b00003e228, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62900025e2a8, unit=0x62b00006d460, select_lex=0x62b0000386f0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:4750
      #30 0x000055b1c1b54678 in handle_select (thd=0x62b000069288, lex=0x62b00006d398, result=0x62900025e2a8, setup_tables_done_option=0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:420
      #31 0x000055b1c1abe23e in execute_sqlcom_select (thd=0x62b000069288, all_tables=0x62b00003db20) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:6231
      #32 0x000055b1c1aad523 in mysql_execute_command (thd=0x62b000069288) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:3927
      #33 0x000055b1c1ac94b7 in mysql_parse (thd=0x62b000069288, rawbuf=0x62b000038440 "SELECT x, COUNT(*) FROM JSON_TABLE(\n'{}', '$' COLUMNS(\na BIT(14) PATH '$',\nb CHAR(16) PATH '$',\nc INT PATH '$[0]',\nd INT PATH '$[1]',\ne INT PATH '$[2]',\nf INT PATH '$[3]',\ng INT PATH '$[4]',\nh INT PAT"..., length=289, parser_state=0x7f9182976bb0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:8005
      #34 0x000055b1c1a9ff30 in dispatch_command (command=COM_QUERY, thd=0x62b000069288, packet=0x629000258289 "SELECT x, COUNT(*) FROM JSON_TABLE(\n'{}', '$' COLUMNS(\na BIT(14) PATH '$',\nb CHAR(16) PATH '$',\nc INT PATH '$[0]',\nd INT PATH '$[1]',\ne INT PATH '$[2]',\nf INT PATH '$[3]',\ng INT PATH '$[4]',\nh INT PAT"..., packet_length=289, blocking=true) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:1888
      #35 0x000055b1c1a9cc6b in do_command (thd=0x62b000069288, blocking=true) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:1399
      #36 0x000055b1c1edfc1a in do_handle_one_connection (connect=0x61100000b388, put_in_cache=true) at /data/src/bb-10.6-mdev17399-hf/sql/sql_connect.cc:1410
      #37 0x000055b1c1edf577 in handle_one_connection (arg=0x61100000b248) at /data/src/bb-10.6-mdev17399-hf/sql/sql_connect.cc:1312
      #38 0x000055b1c2bf0cbf in pfs_spawn_thread (arg=0x616000101b08) at /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
      #39 0x00007f918c18f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #40 0x00007f918bd63293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 6 (Thread 0x7f9182aa0700 (LWP 1873712)):
      #0  futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55b1c5dc0688 <COND_manager+40>) at ../sysdeps/nptl/futex-internal.h:183
      #1  __pthread_cond_wait_common (abstime=0x0, clockid=0, mutex=0x55b1c5dc05a8 <LOCK_manager+40>, cond=0x55b1c5dc0660 <COND_manager>) at pthread_cond_wait.c:508
      #2  __pthread_cond_wait (cond=0x55b1c5dc0660 <COND_manager>, mutex=0x55b1c5dc05a8 <LOCK_manager+40>) at pthread_cond_wait.c:638
      #3  0x000055b1c3824131 in safe_cond_wait (cond=0x55b1c5dc0660 <COND_manager>, mp=0x55b1c5dc0580 <LOCK_manager>, file=0x55b1c4a17760 "/data/src/bb-10.6-mdev17399-hf/mysys/my_thr_init.c", line=596) at /data/src/bb-10.6-mdev17399-hf/mysys/thr_mutex.c:492
      #4  0x000055b1c38117fe in psi_cond_wait (that=0x55b1c5dc0660 <COND_manager>, mutex=0x55b1c5dc0580 <LOCK_manager>, file=0x55b1c3b2ece0 "/data/src/bb-10.6-mdev17399-hf/sql/sql_manager.cc", line=103) at /data/src/bb-10.6-mdev17399-hf/mysys/my_thr_init.c:596
      #5  0x000055b1c1a93056 in inline_mysql_cond_wait (that=0x55b1c5dc0660 <COND_manager>, mutex=0x55b1c5dc0580 <LOCK_manager>, src_file=0x55b1c3b2ece0 "/data/src/bb-10.6-mdev17399-hf/sql/sql_manager.cc", src_line=103) at /data/src/bb-10.6-mdev17399-hf/include/mysql/psi/mysql_thread.h:1070
      #6  0x000055b1c1a936ee in handle_manager (arg=0x0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_manager.cc:103
      #7  0x000055b1c2bf0cbf in pfs_spawn_thread (arg=0x6160000ed408) at /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
      #8  0x00007f918c18f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #9  0x00007f918bd63293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 5 (Thread 0x7f9182bf8700 (LWP 1873709)):
      #0  0x00007f918bc88322 in __GI___sigtimedwait (set=0x7f9182bf7cf0, info=0x7f9182bf7b20, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29
      #1  0x00007f918c659111 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #2  0x000055b1c17900dc in my_sigwait (set=0x7f9182bf7cf0, sig=0x7f9182bf7c60, code=0x7f9182bf7c70) at /data/src/bb-10.6-mdev17399-hf/include/my_pthread.h:195
      #3  0x000055b1c179e8f7 in signal_hand (arg=0x0) at /data/src/bb-10.6-mdev17399-hf/sql/mysqld.cc:3104
      #4  0x000055b1c2bf0cbf in pfs_spawn_thread (arg=0x616000067f08) at /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
      #5  0x00007f918c18f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #6  0x00007f918bd63293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 4 (Thread 0x7f918bc331c0 (LWP 1873706)):
      #0  0x00007f918bd56aff in __GI___poll (fds=0x61200000b048, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
      #1  0x00007f918c60e5ba in poll () from /lib/x86_64-linux-gnu/libasan.so.5
      #2  0x000055b1c17a9146 in handle_connections_sockets () at /data/src/bb-10.6-mdev17399-hf/sql/mysqld.cc:6081
      #3  0x000055b1c17a7937 in mysqld_main (argc=139, argv=0x61b000000f68) at /data/src/bb-10.6-mdev17399-hf/sql/mysqld.cc:5786
      #4  0x000055b1c178ff5d in main (argc=6, argv=0x7ffcbc7d55b8) at /data/src/bb-10.6-mdev17399-hf/sql/main.cc:25
       
      Thread 3 (Thread 0x7f91845fb700 (LWP 1873707)):
      #0  futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f91845fad90, clockid=<optimized out>, expected=0, futex_word=0x55b1c6702f68 <COND_timer+40>) at ../sysdeps/nptl/futex-internal.h:320
      #1  __pthread_cond_wait_common (abstime=0x7f91845fad90, clockid=<optimized out>, mutex=0x55b1c6702e88 <LOCK_timer+40>, cond=0x55b1c6702f40 <COND_timer>) at pthread_cond_wait.c:520
      #2  __pthread_cond_timedwait (cond=0x55b1c6702f40 <COND_timer>, mutex=0x55b1c6702e88 <LOCK_timer+40>, abstime=0x7f91845fad90) at pthread_cond_wait.c:656
      #3  0x000055b1c3824a6a in safe_cond_timedwait (cond=0x55b1c6702f40 <COND_timer>, mp=0x55b1c6702e60 <LOCK_timer>, abstime=0x7f91845fad90, file=0x55b1c4a17760 "/data/src/bb-10.6-mdev17399-hf/mysys/my_thr_init.c", line=609) at /data/src/bb-10.6-mdev17399-hf/mysys/thr_mutex.c:546
      #4  0x000055b1c3811acf in psi_cond_timedwait (that=0x55b1c6702f40 <COND_timer>, mutex=0x55b1c6702e60 <LOCK_timer>, abstime=0x7f91845fad90, file=0x55b1c4a1b0a0 "/data/src/bb-10.6-mdev17399-hf/mysys/thr_timer.c", line=321) at /data/src/bb-10.6-mdev17399-hf/mysys/my_thr_init.c:609
      #5  0x000055b1c38274f0 in inline_mysql_cond_timedwait (that=0x55b1c6702f40 <COND_timer>, mutex=0x55b1c6702e60 <LOCK_timer>, abstime=0x7f91845fad90, src_file=0x55b1c4a1b0a0 "/data/src/bb-10.6-mdev17399-hf/mysys/thr_timer.c", src_line=321) at /data/src/bb-10.6-mdev17399-hf/include/mysql/psi/mysql_thread.h:1086
      #6  0x000055b1c38296d0 in timer_handler (arg=0x0) at /data/src/bb-10.6-mdev17399-hf/mysys/thr_timer.c:321
      #7  0x000055b1c2bf0cbf in pfs_spawn_thread (arg=0x616000004c08) at /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
      #8  0x00007f918c18f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #9  0x00007f918bd63293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 2 (Thread 0x7f91836e2700 (LWP 1873708)):
      #0  futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f91836e1c40, clockid=<optimized out>, expected=0, futex_word=0x55b1c6627808 <COND_checkpoint+40>) at ../sysdeps/nptl/futex-internal.h:320
      #1  __pthread_cond_wait_common (abstime=0x7f91836e1c40, clockid=<optimized out>, mutex=0x55b1c6627728 <LOCK_checkpoint+40>, cond=0x55b1c66277e0 <COND_checkpoint>) at pthread_cond_wait.c:520
      #2  __pthread_cond_timedwait (cond=0x55b1c66277e0 <COND_checkpoint>, mutex=0x55b1c6627728 <LOCK_checkpoint+40>, abstime=0x7f91836e1c40) at pthread_cond_wait.c:656
      #3  0x000055b1c3824a6a in safe_cond_timedwait (cond=0x55b1c66277e0 <COND_checkpoint>, mp=0x55b1c6627700 <LOCK_checkpoint>, abstime=0x7f91836e1c40, file=0x55b1c4a17760 "/data/src/bb-10.6-mdev17399-hf/mysys/my_thr_init.c", line=609) at /data/src/bb-10.6-mdev17399-hf/mysys/thr_mutex.c:546
      #4  0x000055b1c3811acf in psi_cond_timedwait (that=0x55b1c66277e0 <COND_checkpoint>, mutex=0x55b1c6627700 <LOCK_checkpoint>, abstime=0x7f91836e1c40, file=0x55b1c425fec0 "/data/src/bb-10.6-mdev17399-hf/storage/maria/ma_servicethread.c", line=115) at /data/src/bb-10.6-mdev17399-hf/mysys/my_thr_init.c:609
      #5  0x000055b1c29faea6 in inline_mysql_cond_timedwait (that=0x55b1c66277e0 <COND_checkpoint>, mutex=0x55b1c6627700 <LOCK_checkpoint>, abstime=0x7f91836e1c40, src_file=0x55b1c425fec0 "/data/src/bb-10.6-mdev17399-hf/storage/maria/ma_servicethread.c", src_line=115) at /data/src/bb-10.6-mdev17399-hf/include/mysql/psi/mysql_thread.h:1086
      #6  0x000055b1c29fbc6b in my_service_thread_sleep (control=0x55b1c55aa240 <checkpoint_control>, sleep_time=29000000000) at /data/src/bb-10.6-mdev17399-hf/storage/maria/ma_servicethread.c:115
      #7  0x000055b1c29dddea in ma_checkpoint_background (arg=0x1e) at /data/src/bb-10.6-mdev17399-hf/storage/maria/ma_checkpoint.c:707
      #8  0x000055b1c2bf0cbf in pfs_spawn_thread (arg=0x616000021108) at /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
      #9  0x00007f918c18f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #10 0x00007f918bd63293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
       
      Thread 1 (Thread 0x7f9182978700 (LWP 1873713)):
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055b1c3816bed in my_write_core (sig=6) at /data/src/bb-10.6-mdev17399-hf/mysys/stacktrace.c:424
      #2  0x000055b1c22b5067 in handle_fatal_signal (sig=6) at /data/src/bb-10.6-mdev17399-hf/sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00007f918bc66859 in __GI_abort () at abort.c:79
      #6  0x00007f918c6fd6a2 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #7  0x00007f918c70824c in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #8  0x00007f918c6e9c47 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #9  0x00007f918c7082af in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #10 0x00007f918c5ffb60 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #11 0x00007f918c601377 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #12 0x00007f918c603e85 in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #13 0x00007f918c6e930e in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #14 0x00007f918c66d49f in ?? () from /lib/x86_64-linux-gnu/libasan.so.5
      #15 0x000055b1c1d07d6c in Binary_string::realloc_raw (this=0x61900008d118, alloc_length=8224) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.cc:108
      #16 0x000055b1c17b4cb9 in Binary_string::realloc (this=0x61900008d118, arg_length=8224) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.h:645
      #17 0x000055b1c1d08a0c in Binary_string::copy (this=0x61900008d118) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.cc:220
      #18 0x000055b1c20ab7d4 in String::copy (this=0x61900008d110) at /data/src/bb-10.6-mdev17399-hf/sql/sql_string.h:823
      #19 0x000055b1c20ac402 in Field_blob::store_field (this=0x61900008d028, from=0x61d0001cfee8) at /data/src/bb-10.6-mdev17399-hf/sql/field.h:4456
      #20 0x000055b1c2296bc6 in field_conv_incompatible (to=0x61900008d028, from=0x61d0001cfee8) at /data/src/bb-10.6-mdev17399-hf/sql/field_conv.cc:850
      #21 0x000055b1c2296c67 in field_conv (to=0x61900008d028, from=0x61d0001cfee8) at /data/src/bb-10.6-mdev17399-hf/sql/field_conv.cc:863
      #22 0x000055b1c1be8e32 in Create_tmp_table::finalize (this=0x7f9182974e90, thd=0x62b000069288, table=0x620000017128, param=0x6290002601f8, do_not_open=true, keep_row_order=false) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:18927
      #23 0x000055b1c1bee423 in create_tmp_table (thd=0x62b000069288, param=0x6290002601f8, fields=..., group=0x62b00003e228, distinct=false, save_sum_fields=false, select_options=2147748608, rows_limit=18446744073709551615, table_alias=0x55b1c4ea8300 <empty_clex_str>, do_not_open=true, keep_row_order=false) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:19303
      #24 0x000055b1c1b79926 in JOIN::create_postjoin_aggr_table (this=0x62900025e2d8, tab=0x62900025fa60, table_fields=0x62900025e608, table_group=0x62b00003e228, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3784
      #25 0x000055b1c1b7540d in JOIN::make_aggr_tables_info (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3384
      #26 0x000055b1c1b70fd1 in JOIN::optimize_stage2 (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:3028
      #27 0x000055b1c1b69517 in JOIN::optimize_inner (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:2299
      #28 0x000055b1c1b6269c in JOIN::optimize (this=0x62900025e2d8) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:1642
      #29 0x000055b1c1b833f4 in mysql_select (thd=0x62b000069288, tables=0x62b00003db20, fields=..., conds=0x0, og_num=1, order=0x0, group=0x62b00003e228, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62900025e2a8, unit=0x62b00006d460, select_lex=0x62b0000386f0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:4750
      #30 0x000055b1c1b54678 in handle_select (thd=0x62b000069288, lex=0x62b00006d398, result=0x62900025e2a8, setup_tables_done_option=0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_select.cc:420
      #31 0x000055b1c1abe23e in execute_sqlcom_select (thd=0x62b000069288, all_tables=0x62b00003db20) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:6231
      #32 0x000055b1c1aad523 in mysql_execute_command (thd=0x62b000069288) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:3927
      #33 0x000055b1c1ac94b7 in mysql_parse (thd=0x62b000069288, rawbuf=0x62b000038440 "SELECT x, COUNT(*) FROM JSON_TABLE(\n'{}', '$' COLUMNS(\na BIT(14) PATH '$',\nb CHAR(16) PATH '$',\nc INT PATH '$[0]',\nd INT PATH '$[1]',\ne INT PATH '$[2]',\nf INT PATH '$[3]',\ng INT PATH '$[4]',\nh INT PAT"..., length=289, parser_state=0x7f9182976bb0) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:8005
      #34 0x000055b1c1a9ff30 in dispatch_command (command=COM_QUERY, thd=0x62b000069288, packet=0x629000258289 "SELECT x, COUNT(*) FROM JSON_TABLE(\n'{}', '$' COLUMNS(\na BIT(14) PATH '$',\nb CHAR(16) PATH '$',\nc INT PATH '$[0]',\nd INT PATH '$[1]',\ne INT PATH '$[2]',\nf INT PATH '$[3]',\ng INT PATH '$[4]',\nh INT PAT"..., packet_length=289, blocking=true) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:1888
      #35 0x000055b1c1a9cc6b in do_command (thd=0x62b000069288, blocking=true) at /data/src/bb-10.6-mdev17399-hf/sql/sql_parse.cc:1399
      #36 0x000055b1c1edfc1a in do_handle_one_connection (connect=0x61100000b388, put_in_cache=true) at /data/src/bb-10.6-mdev17399-hf/sql/sql_connect.cc:1410
      #37 0x000055b1c1edf577 in handle_one_connection (arg=0x61100000b248) at /data/src/bb-10.6-mdev17399-hf/sql/sql_connect.cc:1312
      #38 0x000055b1c2bf0cbf in pfs_spawn_thread (arg=0x616000101b08) at /data/src/bb-10.6-mdev17399-hf/storage/perfschema/pfs.cc:2201
      #39 0x00007f918c18f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #40 0x00007f918bd63293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration