Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29420

Galera server hangs when trying to create a Spider table

    XMLWordPrintable

    Details

      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

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ramesh Ramesh Sivaraman
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.