The test spider.alter_server fails when run in parallel

./mysql-test/mtr --parallel=2 --force --max-test-fail=0 spider.alter_server{,}

spider.alter_server                      w1 [ fail ]

        Test ended at 2025-10-02 16:37:26

CURRENT_TEST: spider.alter_server

mysqltest: In included file "/home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/../include/../include/init_spider.inc":

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/../include/init_master_1.inc at line 2:

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/test_init.inc at line 12:

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/alter_server.test at line 4:

At line 82: query 'CREATE SERVER s_1 FOREIGN DATA WRAPPER mysql OPTIONS (

HOST 'localhost',

DATABASE 'auto_test_local',

USER 'root',

PASSWORD '',

SOCKET '$MASTER_1_MYSOCK'

    )' failed: ER_FOREIGN_SERVER_EXISTS (1476): Cannot create foreign server 's_1' as it already exists

The result from queries just before the failure was:

for master_1

 - saving '/home/ycp/source/mariadb-server/10.11/build/mysql-test/var/1/log/spider.alter_server/' to '/home/ycp/source/mariadb-server/10.11/build/mysql-test/var/log/spider.alter_server/'

spider.alter_server                      w2 [ fail ]

        Test ended at 2025-10-02 16:37:26

CURRENT_TEST: spider.alter_server

mysqltest: In included file "/home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/../include/../include/clean_up_spider.inc":

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/../include/../include/deinit_spider.inc at line 2:

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/../include/deinit_master_1.inc at line 2:

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/test_deinit.inc at line 5:

included from /home/ycp/source/mariadb-server/10.11/src/storage/spider/mysql-test/spider/t/alter_server.test at line 26:

At line 4: query 'DROP FUNCTION IF EXISTS spider_bg_direct_sql' failed: <Unknown> (2013): Lost connection to server during query

The result from queries just before the failure was:

< snip >

Socket

/tmp/1234567890_1234567890_1234567890_1234567890_1234567890_1234567890.sock

create table t2 (c int);

alter SERVER srv OPTIONS (DATABASE 'test');

create table t1 (c int) ENGINE=Spider

COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"';

insert into t1 values (1), (2), (3);

select * from t1;

c

1

2

3

select * from t2;

c

1

2

3

drop table t1, t2;

drop server srv;

for master_1

More results from queries before failure can be found in /home/ycp/source/mariadb-server/10.11/build/mysql-test/var/2/log/alter_server.log