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)

iskiie

how to fix?

aaPanel_Kern

Hi, have you done anything? Or did the server lose power? Prompt mysql-bin.000584 file does not exist
Try to delete ./mysql-bin.000584 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

iskiie

aaP_nikita.kudryashov

@"aaPanel_Kern" Hi, please help me. MySQL is not included, "mysqld service failed to start" is not included

aaPanel_Kern

aaP_nikita.kudryashov

Caused by insufficient server space, please take a snapshot backup of the server and clean up useless files.

aaP_delario

aaPanel_Kern

Hello
I'm facing the some issue

Here my error log when type the command
cat /www/server/data/*.err|grep -i -C 10 error
👇️
https://traff.co/54r3BgM9

aaPanel_Kern

Hello, it says that the table space is broken. It is recommended to find a professional data recovery company to help you recover.

aaP_delario

aaP_sabbirhossen1357928046

how to fix this problem

aaP_sabbirhossen1357928046

help me sir

aaPanel_Kern

Hello, what problem did you encounter? Mysql cannot be started?
Is it normal to use this command to start once: /etc/init.d/mysqld start
If it is abnormal, please check the log: cat /www/server/data/*.err|grep -i -C 10 error

aaP_sabbirhossen1357928046

aaP_alimousa13

im delete ./mysql-bin.000025 from the content and i still have that issues

aaP_alimousa13

hello its stop every 5 mints after restart why its not running what is the issues

aaP_hareeshnarayan1982

aaP_alimousa13 you should check the logs for details.

aaP_alimousa13

its no any error in logs

aaP_alimousa13

hello any solutions for that ?

aaP_hareeshnarayan1982

aaP_alimousa13 you have to check log tab not slow log tab.

aaP_alimousa13

hello any solutions for that ?

aaP_alimousa13

aaP_hareeshnarayan1982

aaP_alimousa13

if you don't know on how to setup DB, better to consult an expert or refer mysql document. You are using * as your bind address? if you want to allow all host, bind it with 0.0.0.0. and then try to restart

aaP_alimousa13

????

aaP_hareeshnarayan1982

aaP_alimousa13
MySQL will stop, if there is any issue in configuration. Check thoroughly your configuration and make sure they all are valid by referring with Mysql docs.

« Previous Page Next Page »