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

Spider attempts localhost TCP/IP connection, even when none is specified.

    XMLWordPrintable

    Details

      Description

      Execute on first instance:

      INSTALL PLUGIN spider SONAME 'ha_spider.so';
      CREATE TABLE t (c INT) ENGINE=SPIDER COMMENT='WRAPPER "mariadb",  TABLE "t", SOCKET "/your_path/socket.sock"';
      INSERT INTO t VALUES (1);
      

      Then, if the table t on the secondary instance is SPIDER, the result will be:

      10.8.0 ccdf5711a8fff0cd610a91fdcf37c8ff1182878c (Optimized)

      10.8.0-opt>INSERT INTO t3 VALUES (1);
      ERROR 1429 (HY000): Unable to connect to foreign data source: localhost
      

      Note that it is trying to make a TCP/IP connection to localhost rather than using the socket.

      The same happens when using CREATE SERVER with SOCKET specified.

      10.2, 10.3 Presumed affected. Tested 10.4 and 10.8, same result.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Reporter:
              Roel Roel Van de Paar
              Votes:
              0 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.