MySQLd service failed to start (after restarting server)
Hello, please check if there are any files in this directory?
ls -l /www/server/data
i have reintsall aapanel
pls how can i stop this its genereting itself and its eating up my storage
aaP_olaniyi
mysql8 close binary log
Added in the configuration：
skip-log-bin=1
#log-bin=mysql-bin
#binlog_format=mixed
expire_logs_days=3
binlog_expire_logs_seconds = 600000
aaPanel_Kern i dont understand please
after adding i can delete them right?
It cannot be deleted. It is recommended that you let it be deleted automatically.
its still creating more
Hello, what is your mysql version? Do you want to configure automatic deletion of configuration? Do you want to restart mysql after configuration?
aaPanel_Kern got error again 
2023-09-26T04:02:51.321754Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2023-09-26T04:02:51.321912Z 0 [Warning] '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-09-26T04:02:51.321915Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2023-09-26T04:02:51.321939Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2023-09-26T04:02:51.321963Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.43-log) starting as process 9222 ...
2023-09-26T04:02:51.332264Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-09-26T04:02:51.332304Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-09-26T04:02:51.332307Z 0 [Note] InnoDB: Uses event mutexes
2023-09-26T04:02:51.332310Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-09-26T04:02:51.332313Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-09-26T04:02:51.332446Z 0 [Note] InnoDB: Number of pools: 1
2023-09-26T04:02:51.332517Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-09-26T04:02:51.412394Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2023-09-26T04:02:51.413321Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-09-26T04:02:51.413333Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-09-26T04:02:51.413746Z 0 [Note] InnoDB: Waiting for purge to start
2023-09-26T04:02:51.463949Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 1876267808
2023-09-26T04:02:51.463973Z 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2023-09-26T04:02:51.464187Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2023-09-26T04:02:51.464376Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-09-26T04:02:51.464452Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230926 4:02:51
mysqld: File './mysql-bin.000188' not found (Errcode: 2 - No such file or directory)
2023-09-26T04:02:51.465220Z 0 [ERROR] Failed to open log (file './mysql-bin.000188', errno 2)
2023-09-26T04:02:51.465227Z 0 [ERROR] Could not open log file
2023-09-26T04:02:51.465237Z 0 [ERROR] Can't init tc log
2023-09-26T04:02:51.465242Z 0 [ERROR] Aborting
2023-09-26T04:02:51.465270Z 0 [Note] Binlog end
2023-09-26T04:02:51.465323Z 0 [Note] Shutting down plugin 'ngram'
2023-09-26T04:02:51.465329Z 0 [Note] Shutting down plugin 'partition'
2023-09-26T04:02:51.465334Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2023-09-26T04:02:51.465338Z 0 [Note] Shutting down plugin 'ARCHIVE'
2023-09-26T04:02:51.465343Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-09-26T04:02:51.465446Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2023-09-26T04:02:51.465452Z 0 [Note] Shutting down plugin 'MyISAM'
2023-09-26T04:02:51.465467Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
jaac
Try to delete ./mysql-bin.000188 from the content of this /www/server/data/mysql-bin.index file, and then restart mysql. Can it be solved?
It can be operated in the "File" interface of the panel
cp /www/server/data/mysql-bin.index /www/server/data/mysql-bin.index_
/etc/init.d/mysqld restart
Execute the command Check out what mysql-bin files are in your directory
ls /www/server/data/mysql-bin*
Ahhh found it! Thanks again aaPanel_Kern
2023-12-05 8:13:08 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-05 8:13:08 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1210674,1210674
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring malformed log record at LSN 1210674
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring corrupted file-level record at LSN 1210674
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring corrupted page identifier at LSN 1210674
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring malformed log record at LSN 1210692
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring malformed log record at LSN 1210692
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring unknown log record at LSN 1210722
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring unknown log record at LSN 1210722
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring unknown log record at LSN 1210722
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring unknown log record at LSN 1210722
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring unknown log record at LSN 1210722
2023-12-05 8:13:08 0 [Warning] InnoDB: Ignoring malformed log record at LSN 1210722
2023-12-05 8:13:08 0 [Note] InnoDB: At LSN: 1270601: unable to open file ./larapanel/#sql-alter-591f-1d7.ibd for tablespace 108
2023-12-05 8:13:08 0 [Note] InnoDB: At LSN: 1283573: unable to open file ./larapanel/#sql-ib123.ibd for tablespace 106
2023-12-05 8:13:08 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT at 1210674 between the checkpoint 1210674 and the end 2729257.
2023-12-05 8:13:08 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-12-05 8:13:08 0 [Note] InnoDB: Starting shutdown...
2023-12-05 8:13:09 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-12-05 8:13:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-12-05 8:13:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-05 8:13:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-12-05 8:13:09 0 [ERROR] Aborting
231205 08:13:09 mysqld_safe mysqld from pid file /www/server/data/fdserv3.pid ended
I had the same problem, mariadb suddenly stopped and couldn't be started again. please help me regarding this error. Thanks
Hello, the table space is damaged. It is recommended that you ask a recovery company to help you deal with it.
Is there any other way to retrieve the database in it?
aaPanel_Kern Is there any other way to retrieve the database in it?
This is a table space that is damaged and needs to be restored.