Mysql Failing To Start while (apache and php fpm are running fine)

Keywords: LAMP/MAMP/WAMP - Microsoft Azure - Technical issue - Application configuration

bndiagnostic ID: dce0c191-b4c7-b4bb-a40e-9485697a548d

bndiagnostic output:

? Apache: Found possible issues
? Processes: Found possible issues
? Mysql: Found possible issues
https://docs.bitnami.com/general/apps/wordpress/troubleshooting/debug-errors-apache/
https://docs.bitnami.com/bch/apps/moodle/troubleshooting/deny-connections-bots-apache/
https://docs.bitnami.com/general/how-to/troubleshoot-permission-issues/

bndiagnostic failure reason: The documentation did not make any significant change

Description:
After Server Run out of space the mysql stopped and after adding more space to server mysql still failing to start

Hi @r.daccache ,

I think the binlog files got corrupted when you ran out of space. You can see in the MySQL’s log file that there was an error regarding the binlog, then the space problem and now it can’t find the binlog.index

2022-04-07T10:55:01.292966Z 26275238 [ERROR] [MY-011072] [Server] Binary logging not possible. Message: An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Hence aborting    the server..
10:55:01 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x7fc890a07b50
...
2022-04-07T16:54:47.608541Z 151986 [ERROR] [MY-000035] [Server] Disk is full writing './binlog.000110' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in   600 secs.
2022-04-07T16:55:29.135834Z 152033 [ERROR] [MY-000035] [Server] Disk is full writing './test/webservice_create_log.MYD' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs.       Message reprinted in 600 secs.
...
2022-04-07T20:48:26.423334Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-04-07T20:48:26.423472Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.22)  Source distribution.
mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)

I suggest you disable the binlog parameter and purge the files to be able to start the server again. You can enable this feature later if required

https://docs.bitnami.com/aws/infrastructure/mysql/troubleshooting/disable-binary-logging-mysql/

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.