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

Unknown error 1430 on selecting from federated table for which the base table was changed, and 'Got an error writing communication packets' on shutdown

    XMLWordPrintable

Details

    Description

      If we run this SQL:

      INSTALL SONAME 'ha_federatedx.so';
      CREATE USER federatedx@localhost IDENTIFIED BY '';
      CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',DATABASE 'test',user 'federatedx',PASSWORD'');
      CREATE TABLE t2 (c INT,c2 BLOB) ENGINE=InnoDB;
      CREATE TABLE t CONNECTION='srv/t2' ENGINE=FEDERATED;
      DROP TABLE IF EXISTS t2;
      CREATE TABLE t2 (c INT) ENGINE=InnoDB;
      INSERT INTO t2 VALUES();
      SELECT * FROM t WHERE c>0;
      

      We get:

      10.11.1 50c5743adc87e1cdec1431a02558f6540fe5a6d5 (Debug)

      10.11.1-dbg>SELECT * FROM t WHERE c>0;
      ERROR 1296 (HY000): Got error 10000 'Error on remote system: 1054: Unknown column 'c2' in 'field list'' from FEDERATE
      

      If we add only a key to column c in table t2, i.e.

      CREATE TABLE t2 (c INT KEY,c2 BLOB) ENGINE=InnoDB;
      

      And rerun the full testcase, we get:

      10.11.1 50c5743adc87e1cdec1431a02558f6540fe5a6d5 (Debug)

      10.11.1-dbg>SELECT * FROM t WHERE c>0;
      ERROR 1030 (HY000): Got error 1430 "Unknown error 1430" from storage engine FEDERATED
      

      In the error log we only see:

      10.11.1 50c5743adc87e1cdec1431a02558f6540fe5a6d5 (Debug)

      2022-11-01 15:14:22 0 [ERROR] mysqld: Got an error writing communication packets
      

      And this on shutdown (delayed).

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.