[MDEV-17864] Run regular crash recovery tests for Aria tables (system and user tables) Created: 2018-11-28  Updated: 2019-07-07  Resolved: 2019-07-07

Status: Closed
Project: MariaDB Server
Component/s: Tests
Fix Version/s: N/A

Type: Task Priority: Critical
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17912 Aria with encryption fails upon crash... Stalled
relates to MDEV-17913 Encrypted transactional Aria tables r... Closed

 Description   

We have crash recovery tests, but those mainly target InnoDB. Aria is only involved in 10.4 to the extent that the server with Aria system tables starts after the crash.

We'll run similar tests but with Aria tables instead of InnoDB. Data creation needs to be adjusted, pre-crash DML can remain basically the same, after-recovery checks might need to be adjusted, post-crash DML/DDL can remain the same.

The tests are to be run in Travis regularly (daily at first, weekly after GA) along with other various tests.

MDEV-16421 - Make system tables crash safe

 Comments   
Comment by Elena Stepanova [ 2018-11-30 ]

Added a first small set of tests:

    - --grammar=conf/mariadb/oltp-transactional.yy --gendata=conf/mariadb/oltp-aria.zz
 
    - --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp-aria.zz
 
    - --grammar=conf/mariadb/generic-dml.yy --gendata=conf/mariadb/oltp-aria.zz
 
    - --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --engine=Aria

each in 3 variations:

- as is
 
- --gendata-advanced --vcols --default-storage-engine=Aria
 
- --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin

all with CrashRestart reporter.

Also need to add encrypted version.

Comment by Elena Stepanova [ 2018-11-30 ]

CrashRestart reporter didn't work well, switched to CrashUpgrade scenario (same basedir), adjusted configuration, added runs with encryption and group commit.

Comment by Elena Stepanova [ 2019-07-07 ]

Tests are being run regularly and are mostly saturated due to the amount of existing bugs (see MDEV-19813 for more details).

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