spider/bugfix.mdev_20100, spider/bugfix.mdev_20502, spider/bugfix.mdev_26544, spider/bugfix.mdev_26582, spider/bugfix.mdev_27184, spider/bugfix.mdev_27239, spider/bugfix.mdev_27240, spider/bugfix.mdev_29484 fail

spider/bugfix.mdev_26544                 w7 [ fail ]

        Test ended at 2023-08-10 20:52:58

CURRENT_TEST: spider/bugfix.mdev_26544

mysqltest: At line 22: query 'INSERT INTO tbl_a (a) VALUES (0)' failed with wrong errno ER_DBACCESS_DENIED_ERROR (1044): 'Access denied for user ''@'localhost' to database 'auto_test_remote'', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

#

# MDEV-26544 Assertion `part_share->auto_inc_initialized' failed in ha_partition::get_auto_increment on INSERT

#

for master_1

for child2

for child3

connection master_1;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

CREATE TABLE `tbl_a` (

`a` INT AUTO_INCREMENT, KEY(`a`)

) ENGINE=Spider DEFAULT CHARSET=utf8

PARTITION BY LIST COLUMNS (`a`) (

PARTITION `pt1` DEFAULT

);

INSERT INTO tbl_a (a) VALUES (0);

Warnings from just before the error:

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote' 

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote'

 - saving '/var/tmp/mtr/7/log/spider/bugfix.mdev_26544/' to '/var/tmp/mtr/log/bugfix.mdev_26544/'

Retrying test spider/bugfix.mdev_26544, attempt(2/3)...

worker[7] > Restart  - not started

spider/bugfix.mdev_26539                 w3 [ pass ]    328

worker[3] > Restart [mysqld.1.1 - pid: 19807, winpid: 19807] - using different config file

worker[3] > Restart [mysqld.2.1 - pid: 19813, winpid: 19813] - using different config file

spider/bugfix.mdev_26582                 w1 [ fail ]

        Test ended at 2023-08-10 20:52:58

CURRENT_TEST: spider/bugfix.mdev_26582

mysqltest: At line 17: query 'INSERT INTO t VALUES (0)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

#

# MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states

#

CREATE DATABASE IF NOT EXISTS auto_test_local;

USE auto_test_local;

CREATE TABLE t (i CHAR) ENGINE=SPIDER;

INSERT INTO t VALUES (0);

Warnings from just before the error:

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_26582/'

Retrying test spider/bugfix.mdev_26582, attempt(2/3)...

worker[1] > Restart  - not started

spider/bugfix.mdev_27184                 w4 [ fail ]

        Test ended at 2023-08-10 20:52:59

CURRENT_TEST: spider/bugfix.mdev_27184

mysqltest: At line 21: query 'INSERT INTO tbl_a VALUES

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

#

# MDEV-27184 Assertion `(old_top == initial_top (av) && old_size == 0) ||

# ((unsigned long) (old_size) >= MINSIZE && prev_inuse (old_top) &&

# ((unsigned long) old_end & (pagesize - 1)) == 0)' failed,

# Assertion `str.alloced_length() >= str.length() + data_len' failed

#

for master_1

for child2

for child3

connection master_1;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

CREATE TABLE tbl_a (a FLOAT) ENGINE=SPIDER;

INSERT INTO tbl_a VALUES

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE);

Warnings from just before the error:

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/4/log/spider/bugfix.mdev_27184/'

Retrying test spider/bugfix.mdev_27184, attempt(2/3)...

worker[4] > Restart  - not started

spider/bugfix.mdev_27239                 w6 [ fail ]

        Test ended at 2023-08-10 20:52:59

CURRENT_TEST: spider/bugfix.mdev_27239

--- /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.result	2023-06-05 20:45:45.000000000 +0200

+++ /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.reject	2023-08-10 20:52:58.961422042 +0200

@@ -9,10 +9,8 @@

 CREATE TABLE tbl_a (a INT) ENGINE=SPIDER;

 FLUSH TABLE tbl_a WITH READ LOCK;

 Warnings:

-Error	1429	Unable to connect to foreign data source: localhost

-Error	1429	Unable to connect to foreign data source: localhost

-Error	1429	Unable to connect to foreign data source: localhost

-Error	1429	Unable to connect to foreign data source: localhost

+Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'

+Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'

 BEGIN;

 DROP DATABASE auto_test_local;

 for master_1

mysqltest: Result length mismatch

 - skipping '/var/tmp/mtr/6/log/spider/bugfix.mdev_27239/'

Retrying test spider/bugfix.mdev_27239, attempt(2/3)...

worker[6] > Restart  - not started

spider/bugfix.mdev_26544                 w7 [ retry-fail ]

        Test ended at 2023-08-10 20:52:59

CURRENT_TEST: spider/bugfix.mdev_26544

mysqltest: At line 22: query 'INSERT INTO tbl_a (a) VALUES (0)' failed with wrong errno ER_DBACCESS_DENIED_ERROR (1044): 'Access denied for user ''@'localhost' to database 'auto_test_remote'', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

#

# MDEV-26544 Assertion `part_share->auto_inc_initialized' failed in ha_partition::get_auto_increment on INSERT

#

for master_1

for child2

for child3

connection master_1;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

CREATE TABLE `tbl_a` (

`a` INT AUTO_INCREMENT, KEY(`a`)

) ENGINE=Spider DEFAULT CHARSET=utf8

PARTITION BY LIST COLUMNS (`a`) (

PARTITION `pt1` DEFAULT

);

INSERT INTO tbl_a (a) VALUES (0);

Warnings from just before the error:

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote' 

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_remote'

 - skipping '/var/tmp/mtr/7/log/spider/bugfix.mdev_26544/'

Test spider/bugfix.mdev_26544 has failed 2 times, no more retries!

worker[7] > Restart  - using different config file

spider/bugfix.mdev_27240                 w2 [ fail ]

        Test ended at 2023-08-10 20:52:59

CURRENT_TEST: spider/bugfix.mdev_27240

mysqltest: At line 18: query 'LOCK TABLE tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

for master_1

for child2

for child3

CREATE DATABASE auto_test_local;

USE auto_test_local;

CREATE TABLE tbl_a (a INT KEY) ENGINE=SPIDER;

SELECT a.z FROM tbl_a AS a,tbl_a b WHERE a.z=b.z;

ERROR 42S22: Unknown column 'a.z' in 'field list'

ALTER TABLE tbl_a CHANGE c c INT;

ERROR 42S22: Unknown column 'c' in 'tbl_a'

LOCK TABLE tbl_a READ;

Warnings from just before the error:

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/2/log/spider/bugfix.mdev_27240/'

Retrying test spider/bugfix.mdev_27240, attempt(2/3)...

worker[2] > Restart  - not started

***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_27240

2023-08-10 20:52:59 6 [Warning] WSREP: handlerton rollback failed, thd 6 565 conf 0 SQL LOCK TABLE tbl_a READ

spider/bugfix.mdev_26582                 w1 [ retry-fail ]

        Test ended at 2023-08-10 20:53:02

CURRENT_TEST: spider/bugfix.mdev_26582

mysqltest: At line 17: query 'INSERT INTO t VALUES (0)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

#

# MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states

#

CREATE DATABASE IF NOT EXISTS auto_test_local;

USE auto_test_local;

CREATE TABLE t (i CHAR) ENGINE=SPIDER;

INSERT INTO t VALUES (0);

Warnings from just before the error:

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_26582/'

Test spider/bugfix.mdev_26582 has failed 2 times, no more retries!

worker[1] > Restart  - using different config file

spider/bugfix.mdev_28854                 w8 [ pass ]    160

worker[8] > Restart [mysqld.1.1 - pid: 20362, winpid: 20362] - using different config file

worker[8] > Restart [mysqld.2.1 - pid: 20386, winpid: 20386] - using different config file

spider/bugfix.mdev_28996                 w5 [ pass ]    460

worker[5] > Restart [mysqld.1.1 - pid: 20388, winpid: 20388] - using different config file

worker[5] > Restart [mysqld.2.1 - pid: 20399, winpid: 20399] - using different config file

spider/bugfix.mdev_27184                 w4 [ retry-fail ]

        Test ended at 2023-08-10 20:53:03

CURRENT_TEST: spider/bugfix.mdev_27184

mysqltest: At line 21: query 'INSERT INTO tbl_a VALUES

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE)' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

#

# MDEV-27184 Assertion `(old_top == initial_top (av) && old_size == 0) ||

# ((unsigned long) (old_size) >= MINSIZE && prev_inuse (old_top) &&

# ((unsigned long) old_end & (pagesize - 1)) == 0)' failed,

# Assertion `str.alloced_length() >= str.length() + data_len' failed

#

for master_1

for child2

for child3

connection master_1;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

CREATE TABLE tbl_a (a FLOAT) ENGINE=SPIDER;

INSERT INTO tbl_a VALUES

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE),

(0xF5A7),(0xF5A8),(0xF5A9),(0xF5AA),(0xF5AB),(0xF5AC),(0xF5AD),(0xF5AE);

Warnings from just before the error:

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/4/log/spider/bugfix.mdev_27184/'

Test spider/bugfix.mdev_27184 has failed 2 times, no more retries!

worker[4] > Restart  - using different config file

spider/bugfix.mdev_27239                 w6 [ retry-fail ]

        Test ended at 2023-08-10 20:53:03

CURRENT_TEST: spider/bugfix.mdev_27239

--- /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.result	2023-06-05 20:45:45.000000000 +0200

+++ /usr/share/mariadb-test/plugin/spider/spider/bugfix/r/mdev_27239.reject	2023-08-10 20:53:03.133709092 +0200

@@ -9,10 +9,8 @@

 CREATE TABLE tbl_a (a INT) ENGINE=SPIDER;

 FLUSH TABLE tbl_a WITH READ LOCK;

 Warnings:

-Error	1429	Unable to connect to foreign data source: localhost

-Error	1429	Unable to connect to foreign data source: localhost

-Error	1429	Unable to connect to foreign data source: localhost

-Error	1429	Unable to connect to foreign data source: localhost

+Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'

+Error	1044	Access denied for user ''@'localhost' to database 'auto_test_local'

 BEGIN;

 DROP DATABASE auto_test_local;

 for master_1

mysqltest: Result length mismatch

 - skipping '/var/tmp/mtr/6/log/spider/bugfix.mdev_27239/'

Test spider/bugfix.mdev_27239 has failed 2 times, no more retries!

spider/bugfix.mdev_29008                 w3 [ pass ]    295

worker[6] > Restart  - using different config file

worker[3] > Restart [mysqld.1.1 - pid: 20445, winpid: 20445] - using different config file

worker[3] > Restart [mysqld.2.1 - pid: 20488, winpid: 20488] - using different config file

spider/bugfix.mdev_29011                 w7 [ pass ]    283

worker[7] > Restart [mysqld.1.1 - pid: 20496, winpid: 20496] - using different config file

worker[7] > Restart [mysqld.2.1 - pid: 20502, winpid: 20502] - using different config file

spider/bugfix.mdev_27240                 w2 [ retry-fail ]

        Test ended at 2023-08-10 20:53:03

CURRENT_TEST: spider/bugfix.mdev_27240

mysqltest: At line 18: query 'LOCK TABLE tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

for master_1

for child2

for child3

CREATE DATABASE auto_test_local;

USE auto_test_local;

CREATE TABLE tbl_a (a INT KEY) ENGINE=SPIDER;

SELECT a.z FROM tbl_a AS a,tbl_a b WHERE a.z=b.z;

ERROR 42S22: Unknown column 'a.z' in 'field list'

ALTER TABLE tbl_a CHANGE c c INT;

ERROR 42S22: Unknown column 'c' in 'tbl_a'

LOCK TABLE tbl_a READ;

Warnings from just before the error:

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/2/log/spider/bugfix.mdev_27240/'

Test spider/bugfix.mdev_27240 has failed 2 times, no more retries!

worker[2] > Restart  - using different config file

***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_27240

2023-08-10 20:53:03 6 [Warning] WSREP: handlerton rollback failed, thd 6 646 conf 0 SQL LOCK TABLE tbl_a READ

spider/bugfix.mdev_29484                 w1 [ fail ]

        Test ended at 2023-08-10 20:53:04

CURRENT_TEST: spider/bugfix.mdev_29484

mysqltest: At line 32: query 'LOCK TABLES tbl_b READ, tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

< snip >

child2_2

child2_3

for child3

connection child2_1;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

CREATE TABLE tbl_a (

a INT

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

connection master_1;

CREATE DATABASE auto_test_local;

USE auto_test_local;

CREATE TABLE tbl_a (

a INT

) ENGINE=Spider DEFAULT CHARSET=utf8 COMMENT='table "tbl_a", srv "s_2_1"';

CREATE TABLE tbl_b (

a INT

) ENGINE=Spider DEFAULT CHARSET=utf8;

LOCK TABLES tbl_a WRITE;

LOCK TABLES tbl_b READ, tbl_a READ;

More results from queries before failure can be found in /var/tmp/mtr/1/log/mdev_29484.log

Warnings from just before the error:

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_29484/'

Retrying test spider/bugfix.mdev_29484, attempt(2/3)...

worker[1] > Restart  - not started

worker[1] > Restart  - not started

***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_29484

2023-08-10 20:53:04 6 [Warning] WSREP: handlerton rollback failed, thd 6 584 conf 0 SQL LOCK TABLES tbl_b READ, tbl_a READ

spider/bugfix.mdev_29562                 w8 [ pass ]    299

worker[8] > Restart [mysqld.1.1 - pid: 20922, winpid: 20922] - using different config file

worker[8] > Restart [mysqld.2.1 - pid: 20938, winpid: 20938] - using different config file

spider/bugfix.mdev_29653                 w4 [ pass ]    337

worker[4] > Restart [mysqld.1.1 - pid: 20959, winpid: 20959] - using different config file

worker[4] > Restart [mysqld.2.1 - pid: 21008, winpid: 21008] - using different config file

spider/bugfix.mdev_30191                 w6 [ pass ]    290

worker[6] > Restart [mysqld.1.1 - pid: 20992, winpid: 20992] - using different config file

worker[6] > Restart [mysqld.2.1 - pid: 21015, winpid: 21015] - using different config file

spider/bugfix.mdev_29644                 w5 [ pass ]    640

worker[5] > Restart [mysqld.1.1 - pid: 21033, winpid: 21033] - using different config file

worker[5] > Restart [mysqld.2.1 - pid: 21065, winpid: 21065] - using different config file

spider/bugfix.quick_mode_2               w2 [ pass ]    706

worker[2] > Restart [mysqld.1.1 - pid: 21014, winpid: 21014] - using different config file

worker[2] > Restart [mysqld.2.1 - pid: 21023, winpid: 21023] - using different config file

worker[2] > Restart [mysqld.2.2 - pid: 21037, winpid: 21037] - using different config file

spider/bugfix.quick_mode_0               w3 [ pass ]    658

worker[3] > Restart [mysqld.1.1 - pid: 21082, winpid: 21082] - using different config file

worker[3] > Restart [mysqld.2.1 - pid: 21099, winpid: 21099] - using different config file

worker[3] > Restart [mysqld.2.2 - pid: 21110, winpid: 21110] - using different config file

spider/bugfix.mdev_29484                 w1 [ retry-fail ]

        Test ended at 2023-08-10 20:53:14

CURRENT_TEST: spider/bugfix.mdev_29484

mysqltest: At line 32: query 'LOCK TABLES tbl_b READ, tbl_a READ' failed with wrong errno ER_SPECIFIC_ACCESS_DENIED_ERROR (1227): 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of ER_CONNECT_TO_FOREIGN_DATA_SOURCE (1429)...

The result from queries just before the failure was:

< snip >

child2_2

child2_3

for child3

connection child2_1;

CREATE DATABASE auto_test_remote;

USE auto_test_remote;

CREATE TABLE tbl_a (

a INT

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

connection master_1;

CREATE DATABASE auto_test_local;

USE auto_test_local;

CREATE TABLE tbl_a (

a INT

) ENGINE=Spider DEFAULT CHARSET=utf8 COMMENT='table "tbl_a", srv "s_2_1"';

CREATE TABLE tbl_b (

a INT

) ENGINE=Spider DEFAULT CHARSET=utf8;

LOCK TABLES tbl_a WRITE;

LOCK TABLES tbl_b READ, tbl_a READ;

More results from queries before failure can be found in /var/tmp/mtr/1/log/mdev_29484.log

Warnings from just before the error:

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 

Error 1044 Access denied for user ''@'localhost' to database 'auto_test_local' 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Error 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

 - skipping '/var/tmp/mtr/1/log/spider/bugfix.mdev_29484/'

Test spider/bugfix.mdev_29484 has failed 2 times, no more retries!

spider/bugfix.quick_mode_1               w7 [ pass ]    716

worker[1] > Restart  - using different config file

worker[1] > Restart  - using different config file

worker[7] > Restart [mysqld.1.1 - pid: 21088, winpid: 21088] - using different config file

worker[7] > Restart [mysqld.2.1 - pid: 21095, winpid: 21095] - using different config file

worker[7] > Restart [mysqld.2.2 - pid: 21104, winpid: 21104] - using different config file

***Warnings generated in error logs during shutdown after running tests: spider/bugfix.mdev_29484

2023-08-10 20:53:13 6 [Warning] WSREP: handlerton rollback failed, thd 6 729 conf 0 SQL LOCK TABLES tbl_b READ, tbl_a READ