I restarted the server and now I can't start MySQLd service

galal3336 Hi Use the ssh tool to execute the command and check the mysql error log: cat /www/server/data/*.err|grep -i -C 10 error

aaPanel_Kern mysqld: File './mysql-bin.000025' not found (OS errno 2 - No such file or directory) 2023-07-25T02:42:46.623943Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 2023-07-25T02:42:46.625214Z 0 [ERROR] [MY-010041] [Server] Can't init tc log 2023-07-25T02:42:46.627527Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-25T02:42:47.662117Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.

aaPanel_Kern solved by deleting ./mysql-bin.000025 thanks again

I have the same problem This is the log /www/server/mysql/bin/mysqld(+0x66df6e)[0x558e0d302f6e] /www/server/mysql/bin/mysqld(+0x66e453)[0x558e0d303453] /www/server/mysql/bin/mysqld( Z20buf_page_io_completeP10buf_page_tb+0x2d6)[0x558e0df67b56] /www/server/mysql/bin/mysqld(+0x12fca0c)[0x558e0df91a0c] /www/server/mysql/bin/mysqld( Z13buf_read_pageRK9page_id_tRK11page_size_t+0x73)[0x558e0df921b3] /www/server/mysql/bin/mysqld( Z16buf_page_get_genRK9page_id_tRK11page_size_tmP11buf_block_tmPKcmP5mtr_tb+0x46f)[0x558e0df65c9f] /www/server/mysql/bin/mysqld( Z31trx_rseg_get_n_undo_tablespacesPm+0x13d)[0x558e0df0063d] /www/server/mysql/bin/mysqld(+0x1238523)[0x558e0decd523] /www/server/mysql/bin/mysqld( Z34innobase_start_or_create_for_mysqlv+0x2bd4)[0x558e0ded0c14] /www/server/mysql/bin/mysqld(+0x110185e)[0x558e0dd9685e] /www/server/mysql/bin/mysqld( Z24ha_initialize_handlertonP13st_plugin_int+0x59)[0x558e0d3905c9] /www/server/mysql/bin/mysqld(+0xc7d656)[0x558e0d912656] /www/server/mysql/bin/mysqld( Z40plugin_register_builtin_and_init_core_sePiPPc+0x1ec)[0x558e0d914a8c] /www/server/mysql/bin/mysqld( Z11mysqld_mainiPPc+0xb90)[0x558e0d33c380] /lib/x86_64-linux-gnu/libc.so.6(+0x29d90)[0x14fb0a658d90] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x80)[0x14fb0a658e40] /www/server/mysql/bin/mysqld(_start+0x25)[0x558e0d3316f5]

Hello, use the ssh tool to execute the command to see if there is any error? cat /www/server/data/*.err|grep -i -C 10 error jaac

Hello, this is not the latest log, the time of your server is incorrect? jaac

aaPanel_Kern Im not sure I was just run the command you gave to me

I suggest you check whether you have modified the mysql log configuration? Check the mysql log for errors jaac

MySQLd service failed to start (after restarting server)

aaP_olaniyi

how can i reinstall mysql?

aaP_olaniyi

i restart my server then mysql fail to start

aaPanel_Kern

Please check whether the mysql configuration file has changed the database storage directory?

aaP_olaniyi

i dont change anything

aaPanel_Kern

It is recommended that you check this file /etc/my.cnf

aaP_olaniyi

aaPanel_Kern cant find it

aaPanel_Kern

aaP_olaniyi

aaPanel_Kern

Hello, please check if there are any files in this directory?
ls -l /www/server/data

aaP_olaniyi

i have reintsall aapanel

pls how can i stop this its genereting itself and its eating up my storage

aaPanel_Kern

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

aaP_olaniyi

aaPanel_Kern i dont understand please

aaP_olaniyi

after adding i can delete them right?

aaPanel_Kern

It cannot be deleted. It is recommended that you let it be deleted automatically.

aaP_olaniyi

its still creating more

aaP_olaniyi

aaPanel_Kern

Hello, what is your mysql version? Do you want to configure automatic deletion of configuration? Do you want to restart mysql after configuration?

aaP_olaniyi

jaac

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'

aaPanel_Kern

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*

jaac

aaPanel_Kern

I cant find this ./mysql-bin.000188

jaac

Ahhh found it! Thanks again aaPanel_Kern

« Previous Page Next Page »