Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.3.9
-
None
-
CentOS 7.4
Description
Spider crashes when selecting a literal. Reproduce like this:
CREATE TABLE t1(c1 INTEGER); |
CREATE TABLE t1s(c1 INTEGER) ENGINE=SPIDER COMMENT="host '127.0.0.1', user 'root', table 't1'"; |
SELECT c1 FROM t1s; |
SELECT 1 FROM t1s; |
ERROR 2013 (HY000): Lost connection to MySQL server during query |
Error log:
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.3.9-MariaDB |
key_buffer_size=134217728 |
read_buffer_size=131072 |
max_used_connections=2 |
max_threads=153 |
thread_count=28 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467396 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0x7f603ff309a8 |
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 = 0x7f60192cfd70 thread_stack 0x49000 |
mysys/stacktrace.c:270(my_print_stacktrace)[0x7f603c3a366e] |
sql/signal_handler.cc:168(handle_fatal_signal)[0x7f603be33f37] |
sigaction.c:0(__restore_rt)[0x7f603b283100] |
spider/spd_db_mysql.cc:12892(spider_mysql_handler::append_list_item_select(List<Item>*, spider_string*, char const*, unsigned int, bool, spider_fields*))[0x7f602e467751] |
spider/spd_group_by_handler.cc:1264(spider_group_by_handler::init_scan())[0x7f602e46acdf] |
sql/group_by_handler.cc:49(Pushdown_query::execute(JOIN*))[0x7f603bcd3ad3] |
sql/sql_select.cc:18741(do_select)[0x7f603bcb770a] |
sql/sql_select.cc:3823(JOIN::exec())[0x7f603bcb7f93] |
sql/sql_select.cc:4229(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x7f603bcb80ea] |
sql/sql_select.cc:382(handle_select(THD*, LEX*, select_result*, unsigned long))[0x7f603bcb8bfc] |
sql/sql_parse.cc:6547(execute_sqlcom_select)[0x7f603bb6e19f] |
sql/sql_parse.cc:3768(mysql_execute_command(THD*))[0x7f603bc64fbd] |
sql/sql_parse.cc:8089(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7f603bc677cb] |
sql/sql_parse.cc:1850(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7f603bc6a315] |
sql/sql_parse.cc:1397(do_command(THD*))[0x7f603bc6b17e] |
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x7f603bd3b50a] |
sql/sql_connect.cc:1310(handle_one_connection)[0x7f603bd3b62d] |
pthread_create.c:0(start_thread)[0x7f603b27bdc5] |
/lib64/libc.so.6(clone+0x6d)[0x7f60398d1ced] |
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f603ff403b0): select 1 from t1s |
Connection ID (thread ID): 28 |
Status: NOT_KILLED
|
Attachments
Issue Links
- relates to
-
MDEV-16398 Spider Creates Query With Non-Existent Function
- Closed