Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
12.2.2
Description
Hi,
I have a script file that can crash MariaDB.. I tried to reduce the test case but failed to do this. I tried to attach it, but it is bigger than 10MB. I can share it with you if there is any approach support to share a 80MB file.
This is the log:
260318 16:49:53 [ERROR] mariadbd got signal 11 ;
|
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/kb/en/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: 12.2.2-MariaDB-ubu2404 source revision: d26a6f44c1f2119377e79a9540886c6d8c01472f
|
|
The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
|
contains instructions to obtain a better version of the backtrace below.
|
Following these instructions will help MariaDB developers provide a fix quicker.
|
|
Attempting backtrace. Include this in the bug report.
|
(note: Retrieving this information may fail)
|
|
Thread pointer: 0x7f96ac000c68
|
stack_bottom = 0x7f9700231000 thread_stack 0x49000
|
Printing to addr2line failed
|
mariadbd(my_print_stacktrace+0x30)[0x5585c71f9960]
|
mariadbd(handle_fatal_signal+0x1f3)[0x5585c6d45843]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x45330)[0x7f971dfe8330]
|
mariadbd(_ZNK10Eq_creator6createEP3THDP4ItemS3_+0x9d)[0x5585c6da25ad]
|
mariadbd(_ZN17Item_in_subselect31create_single_in_to_exists_condEP4JOINPP4ItemS4_+0x43e)[0x5585c6e2abde]
|
mariadbd(_ZN17Item_in_subselect24create_in_to_exists_condEP4JOIN+0xc5)[0x5585c6e2c7c5]
|
mariadbd(_ZN4JOIN20choose_subquery_planEy+0x84)[0x5585c6c047b4]
|
mariadbd(+0x906142)[0x5585c6a8c142]
|
mariadbd(_ZN4JOIN14optimize_innerEv+0x13b0)[0x5585c6a74590]
|
mariadbd(_ZN4JOIN8optimizeEv+0x103)[0x5585c6a74b93]
|
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xdf)[0x5585c6a74ccf]
|
mariadbd(_Z19mysql_explain_unionP3THDP18st_select_lex_unitP13select_result+0x380)[0x5585c6ab7f60]
|
mariadbd(+0x11ffef5)[0x5585c7385ef5]
|
mariadbd(_ZN4JOIN10exec_innerEv+0x698)[0x5585c6a6b798]
|
mariadbd(_ZN4JOIN4execEv+0x37)[0x5585c6a6c187]
|
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x132)[0x5585c6a74d22]
|
mariadbd(_Z19mysql_explain_unionP3THDP18st_select_lex_unitP13select_result+0x380)[0x5585c6ab7f60]
|
mariadbd(+0x892107)[0x5585c6a18107]
|
mariadbd(_Z21mysql_execute_commandP3THDb+0x37ca)[0x5585c6a22e1a]
|
mariadbd(_ZN18Prepared_statement7executeEP6Stringb+0xa5d)[0x5585c6a5aead]
|
mariadbd(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0xf1)[0x5585c6a5b0a1]
|
mariadbd(_Z22mysql_sql_stmt_executeP3THD+0x1cf)[0x5585c6a4894f]
|
mariadbd(_Z21mysql_execute_commandP3THDb+0x1cb0)[0x5585c6a21300]
|
mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x19a)[0x5585c6a2daea]
|
mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1304)[0x5585c6a1db14]
|
mariadbd(_Z10do_commandP3THDb+0x199)[0x5585c6a1ede9]
|
mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x6b3)[0x5585c6bc2d83]
|
mariadbd(handle_one_connection+0x71)[0x5585c6bab161]
|
mariadbd(+0xdfa91e)[0x5585c6f8091e]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x9caa4)[0x7f971e03faa4]
|
/lib/x86_64-linux-gnu/libc.so.6(__clone+0x44)[0x7f971e0cca64]
|
|
|
Connection ID (thread ID): 1281
|
Status: NOT_KILLED
|
Query (0x7f96ac332310): EXPLAIN SELECT t0.c1, (CAST(? AS DECIMAL) REGEXP LOCATE(CAST(? AS DECIMAL), (SELECT BIT_COUNT((SELECT (- ?) FROM t0 WHERE (t0.c1 IN ((SELECT ? FROM t1 WHERE CAST(? AS DECIMAL) GROUP BY ?)))
|
GROUP BY (- ?))) FROM t0 GROUP BY BIT_COUNT((SELECT (- ?) FROM t0 WHERE (t0.c1 IN ((SELECT ? FROM t1 WHERE CAST(? AS DECIMAL) GROUP BY ?))) GROUP BY (- ?)))))) FROM t0 GROUP BY t0.c1, (CAST(? AS DECIMAL) REGEXP L
|
OCATE(CAST(? AS DECIMAL), (SELECT BIT_COUNT((SELECT (- ?) FROM t0 WHERE (t0.c1 IN ((SELECT ? FROM t1 WHERE CAST(? AS DECIMAL) GROUP BY ?))) GROUP BY (- ?))) FROM t0 GROUP BY BIT_COUNT((SELECT (- ?) FROM t0 WHERE (
|
t0.c1 IN ((SELECT ? FROM t1 WHERE CAST(? AS DECIMAL) GROUP BY ?))) GROUP BY (- ?))))))
|
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,first
|
match=on,loosescan=on,duplicateweedout=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=on,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_equalitie
|
s=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,hash_join_cardinality=on,cset_narrowing=on,
|
sargable_casefold=on
|
|
|
Writing a core file...
|
Working directory at /var/lib/mysql
|
Resource Limits (excludes unlimited resources):
|
Limit Soft Limit Hard Limit Units
|
Max stack size 8388608 unlimited bytes
|
Max processes 2062276 2062276 processes
|
Max open files 524288 524288 files
|
Max locked memory 8388608 8388608 bytes
|
Max pending signals 2062276 2062276 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Core pattern: core
|
|
|
Kernel version: Linux version 6.1.10-1-pve (build@proxmox) (gcc (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP PREEMPT_DYNAMIC PVE 6.1.10-1 (2023-02-07T00:00Z) ()
|