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

galal3336 Try to delete ./mysql-bin.000025 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

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)

jaac

aaPanel_Kern
gosh youre my lifesaver Kern! Thanks

aaPanel_Kern

Ok, watch out for daily backups

jaac

lutfifuadi

if my case how to fix it ?

aaPanel_Kern

lutfifuadi
Hello, what have you done? Try the server to do a snapshot backup and then operate
please use the root authority to execute the command
Is it normal to try to move the file away?
cd /www/server/data/ mv ibdata1 /tmp/ibdata1.bak mv ib_logfile0 /tmp/ib_logfile0.bak mv ib_logfile1 /tmp/ib_logfile1.bak /etc/init.d/mysqld restart

aaP_olaniyi

please hlep me

aaPanel_Kern

Hi, please describe your problem in detail.
If you delete the prompted directory by mistake, please find a professional company to help you restore important data
If there is no database, you can reinstall mysql

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

« Previous Page Next Page »