aaP_ngthanhdo78 today is a bad day, my Mysql suddenly stopped working, causing all websites to hang, I tried backing up but it still doesn't work, can you help me. The log file is confusing 🙁 Thank you so much
aaPanel_Kern aaP_ngthanhdo78 Hi, please check the mysql log: cat /www/server/data/*.err|grep -i -C 10 error
aaP_ngthanhdo78 2023-07-05 23:18:16 0 [Note] InnoDB: 128 rollback segments are active. 2023-07-05 23:18:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-07-05 23:18:16 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-07-05 23:18:16 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB. 2023-07-05 23:18:16 0 [Note] InnoDB: 10.7.3 started; log sequence number 1748157596; transaction id 164121 2023-07-05 23:18:16 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool 2023-07-05 23:18:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-07-05 23:18:16 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. 2023-07-05 23:18:16 0 [Note] Server socket created on IP: '0.0.0.0'. 2023-07-05 23:18:16 0 [Note] Server socket created on IP: '::'. 2023-07-05 23:18:16 0 [ERROR] Can't start server : Bind on unix socket: Address already in use 2023-07-05 23:18:16 0 [ERROR] Do you already have another server running on socket: /tmp/mysql.sock ? 2023-07-05 23:18:16 0 [ERROR] Aborting Warning: Memory not freed: 280 230705 23:18:16 mysqld_safe mysqld from pid file /www/server/data/localhost.localdomain.pid ended
aaPanel_Kern Hello, the log shows that the mysql port is used, please check whether your port is used repeatedly netstat -tulnp|grep mysql && ps aux|grep mysql aaP_ngthanhdo78 This has nothing to do with nginx openlitespeed