[MDEV-28732] aria_log.control file architecture Created: 2022-06-02  Updated: 2022-11-29  Resolved: 2022-11-29

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Storage Engine - Aria
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Yoo WooSung Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

I am using aria engine.
Occasionally, when restarting mariadb in the process of using the application, the operation fails with the following error even though no special work has been done.
"mysqld: Got error 'Missing valid id at start of file. File is not a valid aria control file' when trying to use aria control file"

I solved the situation by deleting the aria_log.000000x and aria_log.control files in that situation.

However, from the point of view of a novice user, it is unclear what exactly the aria_log.control file and the aria_log.000000x file do, making them worry about whether they can be deleted.

Is there any factor in deleting the above two files that puts me in danger of not being able to use the data in the DB I have?

Or is it a file that doesn't cause any major problems if I delete it?



 Comments   
Comment by Ian Gilfillan [ 2022-11-29 ]

I have added a section to https://mariadb.com/kb/en/aria-storage-engine/#missing-valid-id that should clarify. Deleting as you did was probably the best course of action in the circumstances. If the log file is continually being corrupted, please create a separate bug report with full details.

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