Re: [ERROR] mysqld: Aria engine: log initialization failed
Exactly the same Aria bug occurred on another server after a storage issue. Removing the aria_log_control file allowed MariaDB 5.2.9 to start again. I'll upload another collection of data files to FTP.

Launchpad bug id: 884728

The problem can still be seen while trying to read logs:

• unpack launchpad_884728_by_Dreas_example_2.tgz,
• cd to the created 'aria' folder,
• run aria_read_log.
  A non-debug version fails with "Aria engine: log initialization failed .. Can't init loghandler (0)"; a debug version fails with "translog_init_with_table: Assertion `sure_page <= last_page' failed".

However, there is no indication of how the corrupted logs were produced. Knowing the history, chances are that it happened due to a power failure or a hardware failure. I suppose if we want to do anything at all about the bug, it's to check that the failure is really caused by the log being corrupted and not by the contents.

The problem with a mysteriously corrupt control file has been seen by a user again, in 10.1; thus re-opening (previously it was closed as a possible duplicate of MDEV-727, but that one is about a debug assertion failure, so we cannot be certain it is the same).

Tried to reproduce this with the given logs, but worked in 10.1 for me.

Without an log that allows me to reproduce this or access to a machine
that fail, it's not much that I can do

Seen again in 10.1.33

I'm not sure why it wasn't reproducible for monty, I'm still getting the same assertion on the same data with the current 10.1:

elenst@ws:/data/bld/10.1/aria$ ../bin/aria_read_log -d

aria_read_log: /data/src/10.1/storage/maria/ma_loghandler.c:3815: translog_init_with_table: Assertion `sure_page <= last_page' failed.

Aborted (core dumped)

Thread 1 (Thread 0x7efe3ab515c0 (LWP 18493)):

#0  0x00007efe390aafcf in raise () from /lib/x86_64-linux-gnu/libc.so.6

#1  0x00007efe390ac3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6

#2  0x00007efe390a3e37 in __assert_fail_base () from /lib/x86_64-linux-gnu/libc.so.6

#3  0x00007efe390a3ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#4  0x000056318fb47aa1 in translog_init_with_table (directory=0x56318fc8c377 ".", log_file_max_size=1073741824, server_version=0, server_id=0, pagecache=0x5631909e4400 <maria_log_pagecache_var>, flags=0, readonly=1 '\001', init_table_func=0x56318fb3ecc3 <translog_table_init>, no_errors=0 '\000') at /data/src/10.1/storage/maria/ma_loghandler.c:3815

#5  0x000056318fb1d2aa in main (argc=0, argv=0x5631926341b0) at /data/src/10.1/storage/maria/maria_read_log.c:87

However, now non-debug version produces an additional more descriptive error message:

$ /data/bld/10.1-rel/bin/aria_read_log -d

/data/bld/10.1-rel/bin/aria_read_log: Unexpected end-of-file found when reading file './aria_log.00000005' (Errcode: 175 "File too short; Expected more data in file")

/data/bld/10.1-rel/bin/aria_read_log: Aria engine: log initialization failed

Can't init loghandler (0)

aria_read_log: FAILED

Probably problem with the operating system. Issue disappeared after OS update