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

'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.10
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      AIX

      Description

      Two tests, both repeatably on AIX

      connect.upddex

      connect.updelx                           w4 [ fail ]
              Test ended at 2021-06-17 05:54:43
       
      CURRENT_TEST: connect.updelx
      mysqltest: In included file "/home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/updelx.inc": 
      included from /home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/updelx.test at line 66:
      At line 1: query 'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT
       
      The result from queries just before the failure was:
      < snip >
      id
      7
      8
      10
      DELETE FROM t1 WHERE id IN (7,10);
      SELECT * FROM t1;
      id      msg
      8       updated
      DELETE FROM t1 WHERE id = 8;
      SELECT * FROM t1;
      id      msg
      DROP TABLE t1;
      # DBF table
      CREATE TABLE t1 (
      id INT(4) KEY NOT NULL,
      msg VARCHAR(16))
      ENGINE=CONNECT TABLE_TYPE=DBF BLOCK_SIZE=12;
      Warnings:
      Warning 1105    No file name. Table will use t1.dbf
      DELETE FROM t1;
       
      More results from queries before failure can be found in /home/mdborg/build-mariadb-server/mysql-test/var/4/log/updelx.log
       
       - saving '/home/mdborg/build-mariadb-server/mysql-test/var/4/log/connect.updelx/' to '/home/mdborg/build-mariadb-server/mysql-test/var/log/connect.updelx/'
      

      connect.grant

      connect.grant                            w2 [ fail ]
              Test ended at 2021-06-17 05:54:38
       
      CURRENT_TEST: connect.grant
      /home/mdborg/build-mariadb-server/client/mysqltest: Error on delete of '/home/mdborg/build-mariadb-server/mysql-test/var/2/mysqld.1/data//test/t1.BIN' (Errcode: 2 "No such file or directory")
      /home/mdborg/build-mariadb-server/client/mysqltest: Error on delete of '/home/mdborg/build-mariadb-server/mysql-test/var/2/mysqld.1/data//test/t1.CSV' (Errcode: 2 "No such file or directory")
      mysqltest: In included file "/home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/grant.inc": 
      included from /home/mdborg/mariadb-server/storage/connect/mysql-test/connect/t/grant.test at line 87:
      At line 15: query 'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT
       
      The result from queries just before the failure was:
      < snip >
      CREATE USER user@localhost;
      GRANT ALL PRIVILEGES ON *.* TO user@localhost;
      REVOKE FILE ON *.* FROM user@localhost;
      connect user,localhost,user,,;
      connection user;
      SELECT user();
      user()
      user@localhost
      CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF;
      Warnings:
      Warning 1105    No file name. Table will use t1.dbf
      INSERT INTO t1 VALUES (10);
      SELECT * FROM t1;
      a
      10
      UPDATE t1 SET a=20;
      SELECT * FROM t1;
      a
      20
      DELETE FROM t1;
       
      More results from queries before failure can be found in /home/mdborg/build-mariadb-server/mysql-test/var/2/log/grant.log
       
       - saving '/home/mdborg/build-mariadb-server/mysql-test/var/2/log/connect.grant/' to '/home/mdborg/build-mariadb-server/mysql-test/var/log/connect.grant/'
      
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration