[MDEV-25945] 'DELETE FROM t1' failed: 1296: Got error 174 'DBF file t1.dbf is corrupted' from CONNECT Created: 2021-06-17  Updated: 2021-06-17

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.5.10
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Unresolved Votes: 0
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/'


Generated at Thu Feb 08 09:41:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.