[debian-mysql] Bug#996028: #996028 InnoDB: corrupted TRX_NO after upgrading to 10.3.31

[Jan Korbel]

Hello.

Same here after mariadb update

  1:10.3.29-0+deb10u1 -> 1:10.3.31-0+deb10u1

After downgrade there is no corruptions.

We have i386 arch with amd64 kernel.

Regards,

JK

211010 17:47:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2021-10-10 17:47:31 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-10-10 17:47:31 0 [Note] /usr/sbin/mysqld (mysqld 10.3.31-MariaDB-0+deb10u1) starting as process 23378 ...
2021-10-10 17:47:31 0 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
2021-10-10 17:47:31 0 [Note] InnoDB: Using Linux native AIO
2021-10-10 17:47:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-10-10 17:47:31 0 [Note] InnoDB: Uses event mutexes
2021-10-10 17:47:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-10-10 17:47:31 0 [Note] InnoDB: Number of pools: 1
2021-10-10 17:47:31 0 [Note] InnoDB: Using generic crc32 instructions
2021-10-10 17:47:31 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-10-10 17:47:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-10-10 17:47:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-10-10 17:47:31 0 [ERROR] InnoDB: corrupted TRX_NO 733a383a234a652d
2021-10-10 17:47:31 0 [Note] InnoDB: Retry with innodb_force_recovery=5
2021-10-10 17:47:31 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2021-10-10 17:47:32 0 [Note] InnoDB: Starting shutdown...
2021-10-10 17:47:32 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-10-10 17:47:32 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-10-10 17:47:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-10-10 17:47:32 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-10-10 17:47:32 0 [ERROR] Aborting