[MDEV-20441] ER_CRASHED_ON_USAGE (Table is marked as crashed and should be repaired) upon update on versioned Aria table Created: 2019-08-28  Updated: 2020-04-03  Resolved: 2019-12-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria, Versioned Tables
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.3.21, 10.4.11

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: affects-tests

Issue Links:
Relates
relates to MDEV-21471 ER_CRASHED_ON_USAGE upon UPDATE FOR P... Closed

 Description   

CREATE TABLE t1 (a VARCHAR(8), s TIMESTAMP(6) AS ROW START, e TIMESTAMP(6) AS ROW END, PERIOD FOR SYSTEM_TIME (s,e)) ENGINE=Aria ROW_FORMAT=Fixed WITH SYSTEM VERSIONING;
INSERT INTO t1 (a) VALUES ('foo');
UPDATE t1 SET a = 'bar';
 
# Cleanup
DROP TABLE t1;

10.3 b96e4424

mysqltest: At line 3: query 'UPDATE t1 SET a = 'bar'' failed: 1194: Table 't1' is marked as crashed and should be repaired

Reproducible on earlier versions as well.
Couldn't reproduce without ROW_FORMAT=Fixed.
Possibly unrelated to versioning, but I couldn't make a test case without it.



 Comments   
Comment by Elena Stepanova [ 2019-08-28 ]

I'm setting it to critical because it badly affects tests, unrelated corruption bugs can stay unnoticed.

Comment by Oleksandr Byelkin [ 2019-12-01 ]

OK to push

Generated at Thu Feb 08 08:59:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.