Bug #112118 Free list record 11234 is above rec heap top 8812 - MySQL Server Not Starting
Submitted: 19 Aug 2023 23:34 Modified: 21 Aug 2023 13:08
Reporter: Ashish Jain Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.34 OS:Other (AlmaLinux v8.8.0 STANDARD kvm)
Assigned to: CPU Architecture:x86

[19 Aug 2023 23:34] Ashish Jain
Description:
MySql is not starting, keeps on crashing, we are attaching the complete log file

2023-08-19T22:48:34.908326Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2023-08-19T22:48:34.908373Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-08-19T22:48:34.908523Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-08-19T22:48:34.908539Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 28849
2023-08-19T22:48:34.909376Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-08-19T22:48:34.909405Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2023-08-19T22:48:34.920222Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=3221225472. Please use innodb_redo_log_capacity instead.
2023-08-19T22:48:34.921854Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-08-19T22:48:36.388792Z 1 [ERROR] [MY-012719] [InnoDB] Free list record 11234 is above rec heap top 8812
 len 16384; hex 290a3ece00000004ffffffffffffffff0000003952d3389d45bf0000000000000000000006140002

How to repeat:
We can restart the mysql service to repeat the process.
[19 Aug 2023 23:36] Ashish Jain
Complete Error Log

Attachment: mysql-error-log.txt (text/plain), 158.89 KiB.

[19 Aug 2023 23:37] Ashish Jain
Our Configuration File

Attachment: Configuration.txt (text/plain), 1.64 KiB.

[21 Aug 2023 13:08] MySQL Verification Team
HI Mr. Jain,

Thank you for your bug report.

However, this is not a bug.

The error message clearly shows that you are out of memory or the memory is too segmented for the memory that needs to be allocated.

Beside that, you should also fix all the warnings that you see in MySQL log.

Most important of all is that this is not a bug in MySQL software. We do not support WHM/Cpanel, nor do we support Almalinux and WHM/Cpanel. Due to those reasons we can not repeat the problems that you are experiencing.

You should instead as for the support from your hosting provider.

Unsupported.