Details
Critical Description
Here's what I did:
MariaDB [test]> SET @connection_string = 'wrapper "mysql", user "maxuser", password "maxpwd", host "127.0.0.1", port "3001", database "test"';
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [test]> CREATE OR REPLACE TABLE t1(id INT);
|
Query OK, 0 rows affected (0.001 sec)
|
|
|
MariaDB [test]> SET spider_udf_ds_use_real_table=1;
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [test]> SELECT SPIDER_DIRECT_SQL('select 1 as 1', 't1', @connection_string);
|
ERROR 2013 (HY000): Lost connection to server during query
|
Stacktrace:
221022 12:09:56 [ERROR] mysqld got signal 11 ;
|
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.9.3-MariaDB-1:10.9.3+maria~ubu2204-log
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=3
|
max_threads=10002
|
thread_count=23
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 22159044 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x7ff7d4002888
|
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 = 0x7ff80407cc78 thread_stack 0x49000
|
Printing to addr2line failed
|
mysqld(my_print_stacktrace+0x32)[0x55931fed1342]
|
mysqld(handle_fatal_signal+0x478)[0x55931f9a28e8]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7ff81ea46520]
|
mysqld(strmake+0x10)[0x55931ff32020]
|
mysqld(_ZN11MDL_request16init_with_sourceEN7MDL_key18enum_mdl_namespaceEPKcS3_13enum_mdl_type17enum_mdl_durationS3_j+0x41)[0x55931f87e3e1]
|
/usr/lib/mysql/plugin/ha_spider.so(_Z22spider_direct_sql_bodyP11st_udf_initP11st_udf_argsPcS3_c+0x49a)[0x7ff7f857033a]
|
mysqld(_ZN17Item_func_udf_int7val_intEv+0x4e)[0x55931fa1b36e]
|
mysqld(_ZNK12Type_handler18Item_send_longlongEP4ItemP8ProtocolP8st_value+0x1d)[0x55931f90250d]
|
mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xea)[0x55931f67810a]
|
mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0x37)[0x55931f6f5607]
|
mysqld(_ZN4JOIN10exec_innerEv+0xcd0)[0x55931f7ca200]
|
mysqld(_ZN4JOIN4execEv+0x39)[0x55931f7ca939]
|
mysqld(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x121)[0x55931f7c89c1]
|
mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x154)[0x55931f7c9174]
|
mysqld(+0x7ebce5)[0x55931f742ce5]
|
mysqld(_Z21mysql_execute_commandP3THDb+0x47d2)[0x55931f751ff2]
|
mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x55931f753697]
|
mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14d5)[0x55931f755e35]
|
mysqld(_Z10do_commandP3THDb+0x138)[0x55931f757b38]
|
mysqld(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x55931f87641f]
|
mysqld(handle_one_connection+0x5d)[0x55931f87676d]
|
mysqld(+0xc76de6)[0x55931fbcdde6]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x94b43)[0x7ff81ea98b43]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x44)[0x7ff81eb29bb4]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7ff7d4011290): SELECT SPIDER_DIRECT_SQL('select 1 as 1', 't1', @connection_string)
|
Connection ID (thread ID): 29
|
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 /var/lib/mysql
|
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 unlimited unlimited processes
|
Max open files 60000 60000 files
|
Max locked memory 8388608 8388608 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 127100 127100 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/lib/systemd/systemd-coredump %P %u %g %s %t %c %h
|
Kernel version: Linux version 5.19.16-200.fc36.x86_64 (mockbuild@bkernel01.iad2.fedoraproject.org) (gcc (GCC) 12.2.1 20220819 (Red Hat 12.2.1-2), GNU ld version 2.37-36.fc36) #1 SMP PREEMPT_DYNAMIC Sun Oct 16 22:50:04 UTC 2022
|
This also happens with the ODBC wrapper. Using a temporary table prevents this.