[MDEV-14889] Server fails to start because of aria_log_control-file Created: 2018-01-08  Updated: 2018-01-08  Resolved: 2018-01-08

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.2.11, 10.2.12
Fix Version/s: 10.2.12

Type: Bug Priority: Major
Reporter: Alex Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: aria, aria_log_control, log, logs, startup
Environment:

Cent OS 7.4

Attachments: HTML File aria_log_control    
Issue Links:
Duplicate
is duplicated by MDEV-14337 mysqld_safe may suppress error messag... Closed
is duplicated by MDEV-14488 logging not happening on spider branc... Closed
is duplicated by MDEV-14644 MariaDB 10.2.11 breaks binary logging... Closed
is duplicated by MDEV-14714 mysqld writes status information on H... Closed

 Description   

Like in MDEV-7218 the server fails to start with "File size bigger than expected":

2018-01-08  9:45:33 140239529691264 [ERROR] mysqld: Got error 'File size bigger than expected' when trying to use aria control file '/var/lib/mysql/aria_log_control'
 
2018-01-08  9:45:33 140239529691264 [ERROR] Plugin 'Aria' init function returned error.
 
2018-01-08  9:45:33 140239529691264 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
 
...
 
2018-01-08  9:45:36 140239529691264 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
 
2018-01-08  9:45:36 140239529691264 [ERROR] Aborting

However, the filesize of aria_log_control is only 3241 Bytes (not 2.5 GB as in MDEV-7218):

-rw-rw---- 1 mysql mysql      40960 Jan  8 09:40 aria_log.00000001
 
-rw-rw---- 1 mysql mysql       3241 Jan  8 09:40 aria_log_control

Attached is the aria_log_control-file. Problem occured in 10.2.11 as well as 10.2.12.

Workaround:

cd /var/lib/mysql/
 
mv aria_log_control aria_log_control.old
 
systemctl start mysql



 Comments   
Comment by Sergei Golubchik [ 2018-01-08 ]

It is caused by MDEV-14488, fixed in 10.2.12.

See, your aria_log_control is corrupted, it contains error log messages inside. It happened in 10.2.11, and upgrading to 10.2.12 didn't help, because the file already was corrupted by 10.2.11.

Comment by Alex [ 2018-01-08 ]

I was already wondering why the log-messages are stored in this file. Thanks!

I can confirm that there are no log-messages in aria_log_control after removal and starting 10.2.12.

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