Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.8, 12.0
-
None
Description
SImilar to MDEV-33783, seems the fix did not resolve the issue completely
--source include/have_innodb.inc
|
|
|
CREATE OR REPLACE TABLE mysql.servers (x INT) ENGINE=INNODB; |
CREATE SERVER s FOREIGN DATA WRAPPER mariadb OPTIONS (USER 'test_user'); |
Leads to:
|
CS 10.11.12 6e6a1b316ca8df5116613fbe4ca2dc37b3c73bd1 (Optimized) Build 03/03/2025 |
Core was generated by `/test/MD030325-mariadb-10.11.12-linux-x86_64-opt/bin/mariadbd --no-defaults --m'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x0000561bedefa5f7 in TABLE::actual_n_key_parts (this=<optimized out>, keyinfo=<optimized out>) at /test/10.11_opt/sql/table.cc:8623
|
|
|
[Current thread is 1 (Thread 0x153d5ce466c0 (LWP 3000975))]
|
(gdb) bt
|
#0 0x0000561bedefa5f7 in TABLE::actual_n_key_parts (this=<optimized out>, keyinfo=<optimized out>) at /test/10.11_opt/sql/table.cc:8623
|
#1 calculate_key_len (table=<optimized out>, key=<optimized out>, buf=<optimized out>, keypart_map=18446744073709551615)at /test/10.11_opt/sql/table.cc:5177
|
#2 0x0000561bedfdd408 in handler::index_read_map (this=0x153d0404cb58, buf=0x153d0404d358 "\377", key=0x0, keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT) at /test/10.11_opt/sql/handler.h:3863
|
#3 0x0000561bee060899 in handler::index_read_idx_map (this=0x153d0404cb58, buf=0x153d0404d358 "\377", index=0, key=0x153d0404d359 "", keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT)at /test/10.11_opt/sql/handler.cc:6961
|
#4 0x0000561bee05a06b in handler::ha_index_read_idx_map (this=0x153d0404cb58, buf=0x153d0404d358 "\377", index=0, key=<optimized out>, keypart_map=<optimized out>, find_flag=<optimized out>)at /test/10.11_opt/sql/handler.cc:3623
|
#5 0x0000561bedf2a3f8 in insert_server_record (table=0x153d04045de8, server=0x153d04007a80) at /test/10.11_opt/sql/sql_servers.cc:648
|
#6 insert_server (thd=0x153d04000c68, server=0x153d04007a80)at /test/10.11_opt/sql/sql_servers.cc:484
|
#7 create_server (thd=thd@entry=0x153d04000c68, server_options=server_options@entry=0x153d04006698)at /test/10.11_opt/sql/sql_servers.cc:1140
|
#8 0x0000561bede0fed6 in mysql_execute_command (thd=thd@entry=0x153d04000c68, is_called_from_prepared_stmt=<optimized out>)at /test/10.11_opt/sql/sql_parse.cc:6096
|
#9 0x0000561bede09471 in mysql_parse (thd=thd@entry=0x153d04000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153d5ce45480)at /test/10.11_opt/sql/sql_parse.cc:8188
|
#10 0x0000561bede0792c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153d04000c68, packet=packet@entry=0x153d04008759 "CREATE SERVER s FOREIGN DATA WRAPPER mariadb OPTIONS (USER 'test_user')", packet_length=packet_length@entry=71, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1905
|
#11 0x0000561bede09881 in do_command (thd=thd@entry=0x153d04000c68, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1418
|
#12 0x0000561bedf2d92d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x561c11ecbe98, put_in_cache=true)at /test/10.11_opt/sql/sql_connect.cc:1386
|
#13 0x0000561bedf2d6f3 in handle_one_connection (arg=arg@entry=0x561c11ecbe98)at /test/10.11_opt/sql/sql_connect.cc:1298
|
#14 0x0000561bee28629e in pfs_spawn_thread (arg=0x561c11ef3fa8)at /test/10.11_opt/storage/perfschema/pfs.cc:2201
|
#15 0x0000153d5d29caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#16 0x0000153d5d329c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug confirmed present in:
MariaDB: 10.6.21 (dbg), 10.6.21 (opt), 10.11.12 (dbg), 10.11.12 (opt), 11.4.6 (dbg), 11.4.6 (opt), 11.8.1 (dbg), 11.8.1 (opt), 12.0.0 (dbg), 12.0.0 (opt)
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Confirmed
-
Activity
ramesh no worries and thanks for confirming. I think the fix should go to 10.11 since it is not a common query triggering the issue, not of high priority, and I suspect not a new bug either.
$ ./mtr main.servers --mysqld=--default-storage-engine=innodb --mysqld=--innodb
|
|
|
==============================================================================
|
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
|
worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029
|
main.servers [ fail ]
|
Test ended at 2025-04-03 15:25:10
|
|
|
CURRENT_TEST: main.servers
|
mysqltest: At line 38: query 'alter server s1 options(host 'server.example.org')' failed with wrong errno <Unknown> (2013): 'Lost connection to server during query', instead of ER_FOREIGN_SERVER_DOESNT_EXIST (1477)...
|
|
|
The result from queries just before the failure was:
|
< snip >
|
s1 bar 3306 mysql {"HOST": "bar"}
|
DROP SERVER s1;
|
CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(SOCKET 'bar');
|
SELECT * FROM mysql.servers;
|
Server_name Host Db Username Password Port Socket Wrapper Owner Options
|
s1 3306 bar mysql {"SOCKET": "bar"}
|
DROP SERVER s1;
|
CREATE SERVER s1 FOREIGN DATA WRAPPER mysql OPTIONS(SOCKET '/tmp/1234567890_1234567890_1234567890_1234567890_1234567890_1234567890.sock');
|
SELECT Socket FROM mysql.servers where Server_name = 's1';
|
Socket
|
/tmp/1234567890_1234567890_1234567890_1234567890_1234567890_1234567890.sock
|
DROP SERVER s1;
|
#
|
# MDEV-33783 CREATE SERVER segfaults on wrong mysql.servers
|
#
|
create server s1 foreign data wrapper foo options(user 'a');
|
alter server s1 options(host 'server.example.org');
|
rename table mysql.servers to mysql.servers_save;
|
create table mysql.servers (x int);
|
alter server s1 options(host 'server.example.org');
|
|
|
Server [mysqld.1 - pid: 2962162, winpid: 2962162, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
|
250403 15:25:10 [ERROR] /home/alice/am/m2-11.8/bld/sql/mariadbd got signal 11 ;
|
|
|
Server version: 11.8.1-MariaDB-debug-log source revision: cc831f16c82f00d3531e09c2f5c59eadc0abb0d7
|
|
sql/signal_handler.cc:230(handle_fatal_signal)[0x55e35808ece5]
|
sigaction.c:0(__restore_rt)[0x7f84c4d78420]
|
sql/table.cc:5313(calculate_key_len(TABLE*, unsigned int, unsigned char const*, unsigned long))[0x55e357ad0aab]
|
sql/handler.h:4226(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x55e357edb5b2]
|
sql/handler.cc:7367(handler::index_read_idx_map(unsigned char*, unsigned int, unsigned char const*, unsigned long, ha_rkey_function))[0x55e3580d0344]
|
sql/handler.cc:3869(handler::ha_index_read_idx_map(unsigned char*, unsigned int, unsigned char const*, unsigned long, ha_rkey_function))[0x55e3580b19de]
|
sql/sql_servers.cc:1076(update_server_record(TABLE*, st_federated_server*))[0x55e357bb0438]
|
sql/sql_servers.cc:921(update_server(THD*, st_federated_server*, st_federated_server*))[0x55e357baf302]
|
sql/sql_servers.cc:1264(alter_server(THD*, st_lex_server_options*))[0x55e357bb18ce]
|
sql/sql_parse.cc:5829(mysql_execute_command(THD*, bool))[0x55e3576c516a]
|
sql/sql_parse.cc:7915(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55e3576d30a0]
|
sql/sql_parse.cc:1904(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55e3576a94c4]
|
sql/sql_parse.cc:1415(do_command(THD*, bool))[0x55e3576a615b]
|
sql/sql_connect.cc:1415(do_handle_one_connection(CONNECT*, bool))[0x55e357bc06ea]
|
sql/sql_connect.cc:1329(handle_one_connection)[0x55e357bc023d]
|
perfschema/pfs.cc:2200(pfs_spawn_thread)[0x55e3588ec2c4]
|
nptl/pthread_create.c:478(start_thread)[0x7f84c4d6c609]
|
|
Query (0x62d0003e84a8): alter server s1 options(host 'server.example.org')
|
In both 10.6 15139c88a8f14c535f6888892f3f6dc3765bc765 and 10.5 868bc463c04948b649d907c731ca126b7f68fe4c: crashes indeed, but fail with ER_CANT_FIND_SYSTEM_REC (1012) and no crash with myisam