Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
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
- relates to
-
MDEV-17399 Add support for JSON_TABLE
- Closed