Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.9, 10.7.5
-
pkg_name: MariaDB-server
pkg_release: 1.el7.centos
pkg_vendor: MariaDB Foundation
pkg_version: 10.7.5
Description
If a MySQL 8 server allows a remote connection, attempts to use CONNECT engine causes a crash:
MariaDB [(none)]> CREATE OR REPLACE TABLE test.t1 ENGINE = CONNECT TABLE_TYPE = MYSQL CONNECTION= 'mysql://foo:bar@mysql8:3306/foo/bar';
|
ERROR 1105 (HY000): (1130) Host '192.168.100.100' is not allowed to connect to this MySQL server
|
|
|
mysql> create user 'random'@'%' identified by 'SDfkhskj53!';
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
mysql> drop database if exists foo;
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
|
MariaDB [(none)]> CREATE OR REPLACE TABLE test.t1 ENGINE = CONNECT TABLE_TYPE = MYSQL CONNECTION= 'mysql://foo:bar@mysql8:3306/foo/bar';
|
ERROR 2013 (HY000): Lost connection to server during query
|
220914 4:38:43 [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.7.5-MariaDB-log
|
key_buffer_size=134217728
|
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 = 467995 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7fcb180009b8
|
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 = 0x7fcb24beecc0 thread_stack 0x49000
|
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x5625a1bd347e]
|
/usr/sbin/mariadbd(handle_fatal_signal+0x307)[0x5625a1641df7]
|
sigaction.c:0(__restore_rt)[0x7fcb4fe7f630]
|
/usr/sbin/mariadbd(+0x9ea8f7)[0x5625a16148f7]
|
/usr/sbin/mariadbd(mysql_close+0x22)[0x5625a1617eb2]
|
connect/myconn.cpp:541(MYSQLC::Open(_global*, char const*, char const*, char const*, char const*, int, char const*))[0x7fcb4c20e3e9]
|
connect/myconn.cpp:156(MyColumns(_global*, THD*, char const*, char const*, char const*, char const*, char const*, char const*, int, bool))[0x7fcb4c20fc98]
|
connect/ha_connect.cc:6087(CheckSelf(_global*, TABLE_SHARE*, char const*, char const*, char const*, char const*, int))[0x7fcb4c1d556d]
|
/usr/sbin/mariadbd(_Z17create_table_implP3THDP16st_ddl_log_stateS2_RK25st_mysql_const_lex_stringS5_S5_S5_S5_14DDL_options_stP14HA_CREATE_INFOP10Alter_infoiPbPP6st_keyPjP34st_mysql_const_unsigned_lex_string+0x658)[0x5625a14b2628]
|
/usr/sbin/mariadbd(_Z26mysql_create_table_no_lockP3THDP16st_ddl_log_stateS2_PK25st_mysql_const_lex_stringS5_P22Table_specification_stP10Alter_infoPbiP10TABLE_LIST+0x15f)[0x5625a14b2c8f]
|
/usr/sbin/mariadbd(_Z18mysql_create_tableP3THDP10TABLE_LISTP22Table_specification_stP10Alter_info+0x1d6)[0x5625a14b2fa6]
|
/usr/sbin/mariadbd(_ZN25Sql_cmd_create_table_like7executeEP3THD+0x7e4)[0x5625a14b48a4]
|
/usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x1ecc)[0x5625a140e7cc]
|
/usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x20b)[0x5625a141215b]
|
/usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1217)[0x5625a1414317]
|
/usr/sbin/mariadbd(_Z10do_commandP3THDb+0x123)[0x5625a14159b3]
|
sql/sql_table.cc:4531(create_table_impl(THD*, st_ddl_log_state*, st_ddl_log_state*, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, DDL_options_st, HA_CREATE_INFO*, Alter_info*, int, bool*, st_key**, unsigned int*, st_mysql_const_unsigned_lex_string*))[0x5625a1519477]
|
sql/sql_table.cc:4677(mysql_create_table_no_lock(THD*, st_ddl_log_state*, st_ddl_log_state*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, Alter_info*, bool*, int, TABLE_LIST*))[0x5625a1519714]
|
sql/sql_table.cc:4784(mysql_create_table(THD*, TABLE_LIST*, Table_specification_st*, Alter_info*))[0x5625a18658ac]
|
nptl/pthread_create.c:307(start_thread)[0x7fcb4fe77ea5]
|
x86_64/clone.S:113(__clone)[0x7fcb4f392b0d]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fcb180106a0): CREATE OR REPLACE TABLE test.t1 ENGINE = CONNECT TABLE_TYPE = MYSQL CONNECTION= 'mysql://foo:bar@mysql8:3306/foo/bar'
|
{ "frames":
|
[ { "address": 94176680802551
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 10397943
|
, "function_name": "mysql_close_free_options"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176680816306
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 10411698
|
, "function_name": "mysql_close"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 140345776632809
|
, "build_id": "02e7e47d60e44fbc104573c33d439bfea32bad86"
|
, "build_id_offset": 926697
|
, "function_name": "MYSQLC::Open(_global*, char const*, char const*, char const*, char const*, int, char const*)"
|
, "file_name": "/usr/lib64/mysql/plugin/ha_connect.so"
|
}
|
, { "address": 140345776639128
|
, "build_id": "02e7e47d60e44fbc104573c33d439bfea32bad86"
|
, "build_id_offset": 933016
|
, "function_name": "MyColumns(_global*, THD*, char const*, char const*, char const*, char const*, char const*, char const*, int, bool)"
|
, "file_name": "/usr/lib64/mysql/plugin/ha_connect.so"
|
}
|
, { "address": 140345776399725
|
, "build_id": "02e7e47d60e44fbc104573c33d439bfea32bad86"
|
, "build_id_offset": 693613
|
, "function_name": "connect_assisted_discovery(handlerton*, THD*, TABLE_SHARE*, HA_CREATE_INFO*)"
|
, "file_name": "/usr/lib64/mysql/plugin/ha_connect.so"
|
}
|
, { "address": 94176679351848
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8947240
|
, "function_name": "create_table_impl(THD*, st_ddl_log_state*, st_ddl_log_state*, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, st_mysql_const_lex_string const&, DDL_options_st, HA_CREATE_INFO*, Alter_info*, int, bool*, st_key**, unsigned int*, st_mysql_const_unsigned_lex_string*)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176679353487
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8948879
|
, "function_name": "mysql_create_table_no_lock(THD*, st_ddl_log_state*, st_ddl_log_state*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, Alter_info*, bool*, int, TABLE_LIST*)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176679354278
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8949670
|
, "function_name": "mysql_create_table(THD*, TABLE_LIST*, Table_specification_st*, Alter_info*)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176679360676
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8956068
|
, "function_name": "Sql_cmd_create_table_like::execute(THD*)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176678680524
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8275916
|
, "function_name": "mysql_execute_command(THD*, bool)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176678695259
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8290651
|
, "function_name": "mysql_parse(THD*, char*, unsigned int, Parser_state*)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176678703895
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8299287
|
, "function_name": "dispatch_command(enum_server_command, THD*, char*, unsigned int, bool)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176678709683
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 8305075
|
, "function_name": "do_command(THD*, bool)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176679773303
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 9368695
|
, "function_name": "do_handle_one_connection(CONNECT*, bool)"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176679773972
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 9369364
|
, "function_name": "handle_one_connection"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 94176683231404
|
, "build_id": "ad4952ebe4515fa6114eeabfca86f0ea821f1fbd"
|
, "build_id_offset": 12826796
|
, "function_name": "pfs_spawn_thread"
|
, "file_name": "/usr/sbin/mariadbd"
|
}
|
, { "address": 140345864466085
|
, "build_id": "e10cc8f2b932fc3daeda22f8dac5ebb969524e5b"
|
, "build_id_offset": 32421
|
, "function_name": "start_thread"
|
, "file_name": "/lib64/libpthread.so.0"
|
}
|
, { "address": 140345853041421
|
, "build_id": "9470e279388f7f9cb2ed3b2872d0c2095b191ff4"
|
, "build_id_offset": 1043213
|
, "function_name": "__clone"
|
, "file_name": "/lib64/libc.so.6"
|
} ]
|
Attachments
Issue Links
- relates to
-
-
- In Progress
-