Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
Whilst Galera is not meant to support Spider, attempts to use it should not hang the server or cause other issues. Instead, Galera should produce some error message when attempting to create a Spider table. Please replace socket with actual socket in your instance.
10.10.0-opt>INSTALL PLUGIN spider SONAME 'ha_spider.so';
|
Query OK, 0 rows affected (0.123 sec)
|
|
10.10.0-opt>CREATE USER spider@localhost IDENTIFIED BY 'PWD123';
|
Query OK, 0 rows affected (0.035 sec)
|
|
10.10.0-opt>GRANT ALL ON test.* TO spider@localhost;
|
Query OK, 0 rows affected (0.037 sec)
|
|
10.10.0-opt>CREATE server srv FOREIGN DATA wrapper mysql options (socket '/test/GAL_MD080822-mariadb-10.10.0-linux-x86_64-opt/node1/node1_socket.sock', DATABASE 'test', USER 'spider', PASSWORD 'PWD123');
|
Query OK, 0 rows affected (0.031 sec)
|
|
10.10.0-opt>CREATE TABLE t (c INT);
|
Query OK, 0 rows affected (0.047 sec)
|
|
10.10.0-opt>SET GLOBAL spider_same_server_link=ON;
|
Query OK, 0 rows affected (0.000 sec)
|
|
10.10.0-opt>CREATE TABLE t_s (c INT) ENGINE=Spider COMMENT='wrapper "mysql", srv "srv", TABLE "t"';
|
Processlist info
| 12 | root | localhost | test | Query | 626 | creating table | CREATE TABLE t_s (c INT) ENGINE=Spider COMMENT='wrapper "mysql", srv "srv", TABLE "t"' | 0.000 |
|
| 13 | system user | | NULL | Query | 626 | Waiting to execute in isolation | create table if not exists mysql.spider_link_failed_log( db_name char(64) not null default '', tab | 0.000 |
|
| 14 | system user | | NULL | Daemon | NULL | Spider table background statistics action handler | NULL | 0.000 |
|
Attachments
Issue Links
- duplicates
-
MDEV-29602 Galera debug build crashes when the spider plugin is enabled
- Closed