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

Corruption errors upon creation or usage of Federated table with vector key

    XMLWordPrintable

Details

    Description

      When a Federated/FederatedX table is created with an explicit vector key, it returns errors, which is fine, but the errors themselves aren't great:

      bb-11.6-MDEV-32887-vector eff6bc39fcb6e1f691fa08b153d9ea44b9f77b54

      MariaDB [test]> CREATE TABLE t_fed (a VECTOR(1) NOT NULL, VECTOR(a)) ENGINE=FEDERATED CONNECTION = 's/t';
      ERROR 1 (HY000): server name: '' doesn't exist!
      MariaDB [test]> show warnings;
      +---------+------+---------------------------------------------------------------------+
      | Level   | Code | Message                                                             |
      +---------+------+---------------------------------------------------------------------+
      | Error   |    1 | server name: '' doesn't exist!                                      |
      | Error   |    1 | Can't create/write to file '' (Errcode: 14 "Bad address")           |
      | Warning | 1030 | Got error 1 "Operation not permitted" from storage engine FEDERATED |
      +---------+------+---------------------------------------------------------------------+
      

      When a FederatedX table is created via table discovery, it succeeds, and similar errors are produced later upon an attempt to use the key:

      INSTALL SONAME 'ha_federatedx';
       
      eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT);
       
      CREATE TABLE t1 (a VECTOR(1) NOT NULL, VECTOR(a));
      CREATE TABLE t1_fed ENGINE=FEDERATED CONNECTION = 's/t1';
      SHOW CREATE TABLE t1_fed;
      SELECT * FROM t1_fed ORDER BY VEC_DISTANCE_EUCLIDEAN(a,0x00000000) LIMIT 1;
      SHOW WARNINGS;
      

      SELECT * FROM t1_fed ORDER BY VEC_DISTANCE_EUCLIDEAN(a,0x00000000) LIMIT 1;
      mysqltest: At line 8: query 'SELECT * FROM t1_fed ORDER BY VEC_DISTANCE_EUCLIDEAN(a,0x00000000) LIMIT 1' failed: <Unknown> (1): server name: '' doesn't exist!
      SHOW WARNINGS;
      Level	Code	Message
      Error	1	server name: '' doesn't exist!
      Error	1	Can't create/write to file '' (Errcode: 14 "Bad address")
      Error	1034	Index for table 't1_fed' is corrupt; try to repair it
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              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.