I restarted the server and now I can't start MySQLd service 
MySQLd service failed to start (after restarting server)
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
- Edited
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.
- Best Answerset by galal3336
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
aaPanel_Kern
solved by deleting ./mysql-bin.000025
thanks again
15 days later
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
Hello, this is not the latest log, the time of your server is incorrect?
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
Hello, try to refer to this post to solve it?
https://www.aapanel.com/forum/d/13216-mysqlmariadb-innodb-storage-engine-damage-solution
aaPanel_Kern
gosh youre my lifesaver Kern! Thanks
Ok, watch out for daily backups
if my case how to fix it ?
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
19 days later
please hlep me
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
