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

Spider install SQL does not replicate to replica, and replica halts

    XMLWordPrintable

Details

    Description

      Place the test in the main suite, for example, as spider suites could lead to Bug in test case: '$SERVER_MYPORT_2' not initialized. Check the test's .cnf file.

      --source include/master-slave.inc
      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      CREATE TABLE t (c INT) ENGINE=Spider;
      --error ER_CONNECT_TO_FOREIGN_DATA_SOURCE
      INSERT INTO t VALUES (1);
      --sync_slave_with_master
      SELECT * FROM t;
      --source include/rpl_end.inc
      

      Leads to:

      11.5.0 3f9182126c64bcec359bebe9ebad2a0e559b13e2 (Debug)

      Slave_IO_Running	Yes
      Slave_SQL_Running	No
      ...
      Last_Errno	1286
      Last_Error	Error 'Unknown storage engine 'Spider'' on query. Default database: 'test'. Query: 'CREATE TABLE t (c INT) ENGINE=Spider'
      

      Attachments

        Activity

          People

            ycp Yuchen Pei
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.