求助：ERROR! MySQL server PID file could not be found!

fortop

服務器出現故障，重啟之後MySQL出錯，請幫忙看看，謝謝！

[root@ls-412734-7810-7810 ~]# lnmp restart

+-------------------------------------------+

|    Manager for LNMP, Written by Licess    |

+-------------------------------------------+

|              https://lnmp.org             |

+-------------------------------------------+

Stoping LNMP...

Stoping nginx...  done

ERROR! MySQL server PID file could not be found!

Gracefully shutting down php-fpm . done

Starting LNMP...

Starting nginx...  done

Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/ls-412734-7810-7810.pid).

Starting php-fpm  done

[root@ls-412734-7810-7810 ~]#

附最後100行錯誤日志:

[root@ls-412734-7810-7810 ~]# tail -n 100 /usr/local/mysql/var/ls-412734-7810-7810.err

2022-11-05T23:26:50.729579Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled

2022-11-05T23:26:50.729650Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.30) starting as process 5210 ...

2022-11-05T23:26:50.734182Z 0 [Warning] You need to use --log-bin to make --binlog-format work.

2022-11-05T23:26:50.743235Z 0 [Note] InnoDB: PUNCH HOLE support available

2022-11-05T23:26:50.743277Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2022-11-05T23:26:50.743280Z 0 [Note] InnoDB: Uses event mutexes

2022-11-05T23:26:50.743282Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2022-11-05T23:26:50.743284Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2022-11-05T23:26:50.743287Z 0 [Note] InnoDB: Using Linux native AIO

2022-11-05T23:26:50.743674Z 0 [Note] InnoDB: Number of pools: 1

2022-11-05T23:26:50.743751Z 0 [Note] InnoDB: Using CPU crc32 instructions

2022-11-05T23:26:50.745067Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M

2022-11-05T23:26:50.775017Z 0 [Note] InnoDB: Completed initialization of buffer pool

2022-11-05T23:26:50.780634Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2022-11-05T23:26:50.791368Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2022-11-05T23:26:50.976604Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2022-11-05T23:26:50.976702Z 0 [Note] InnoDB: Setting file '/usr/local/mysql/var/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2022-11-05T23:26:50.993291Z 0 [Note] InnoDB: File '/usr/local/mysql/var/ibtmp1' size is now 12 MB.

2022-11-05T23:26:50.994016Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2022-11-05T23:26:50.994030Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2022-11-05T23:26:50.994641Z 0 [Note] InnoDB: Waiting for purge to start

2022-11-05T23:26:51.044822Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 4337342370277

2022-11-05T23:26:51.071625Z 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/var/ib_buffer_pool

2022-11-05T23:26:51.081194Z 0 [Note] Plugin 'FEDERATED' is disabled.

2022-11-05T23:26:51.221088Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221106  7:26:51

2022-11-05T23:26:51.237204Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.

2022-11-05T23:26:51.237233Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.

2022-11-05T23:26:51.238064Z 0 [Warning] CA certificate ca.pem is self signed.

2022-11-05T23:26:51.264751Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.

2022-11-05T23:26:51.264986Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2022-11-05T23:26:51.265067Z 0 [Note] IPv6 is available.

2022-11-05T23:26:51.265077Z 0 [Note]   - '::' resolves to '::';

2022-11-05T23:26:51.265109Z 0 [Note] Server socket created on IP: '::'.

2022-11-05T23:26:51.266424Z 0 [ERROR] Can't start server : Bind on unix socket: Address already in use

2022-11-05T23:26:51.266437Z 0 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?

2022-11-05T23:26:51.266448Z 0 [ERROR] Aborting

fortop

接上段：

2022-11-05T23:26:51.266460Z 0 [Note] Binlog end

2022-11-05T23:26:51.266574Z 0 [Note] Shutting down plugin 'ngram'

2022-11-05T23:26:51.266578Z 0 [Note] Shutting down plugin 'partition'

2022-11-05T23:26:51.266581Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2022-11-05T23:26:51.266584Z 0 [Note] Shutting down plugin 'ARCHIVE'

2022-11-05T23:26:51.266585Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2022-11-05T23:26:51.266644Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2022-11-05T23:26:51.266648Z 0 [Note] Shutting down plugin 'MyISAM'

2022-11-05T23:26:51.266667Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2022-11-05T23:26:51.266671Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2022-11-05T23:26:51.266673Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2022-11-05T23:26:51.266675Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2022-11-05T23:26:51.266676Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2022-11-05T23:26:51.266678Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2022-11-05T23:26:51.266679Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2022-11-05T23:26:51.266680Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2022-11-05T23:26:51.266682Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2022-11-05T23:26:51.266684Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2022-11-05T23:26:51.266685Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2022-11-05T23:26:51.266687Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2022-11-05T23:26:51.266688Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2022-11-05T23:26:51.266690Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2022-11-05T23:26:51.266691Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2022-11-05T23:26:51.266693Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2022-11-05T23:26:51.266694Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2022-11-05T23:26:51.266696Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2022-11-05T23:26:51.266701Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2022-11-05T23:26:51.266703Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2022-11-05T23:26:51.266705Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2022-11-05T23:26:51.266706Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2022-11-05T23:26:51.266708Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2022-11-05T23:26:51.266709Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2022-11-05T23:26:51.266711Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2022-11-05T23:26:51.266712Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2022-11-05T23:26:51.266714Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2022-11-05T23:26:51.266715Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2022-11-05T23:26:51.266717Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2022-11-05T23:26:51.266718Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2022-11-05T23:26:51.266720Z 0 [Note] Shutting down plugin 'InnoDB'

2022-11-05T23:26:51.307886Z 0 [Note] InnoDB: FTS optimize thread exiting.

2022-11-05T23:26:51.308068Z 0 [Note] InnoDB: Starting shutdown...

2022-11-05T23:26:51.408482Z 0 [Note] InnoDB: Dumping buffer pool(s) to /usr/local/mysql/var/ib_buffer_pool

2022-11-05T23:26:51.408970Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 221106  7:26:51

2022-11-05T23:26:52.631933Z 0 [Note] InnoDB: Shutdown completed; log sequence number 4337342370296

2022-11-05T23:26:52.632867Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2022-11-05T23:26:52.632892Z 0 [Note] Shutting down plugin 'MEMORY'

2022-11-05T23:26:52.632897Z 0 [Note] Shutting down plugin 'CSV'

2022-11-05T23:26:52.632900Z 0 [Note] Shutting down plugin 'sha256_password'

2022-11-05T23:26:52.632902Z 0 [Note] Shutting down plugin 'mysql_native_password'

2022-11-05T23:26:52.633030Z 0 [Note] Shutting down plugin 'binlog'

2022-11-05T23:26:52.633303Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

licess

日志中显示3306端口被占用，说明mysql已经再运行或mysql进程已经死掉并未结束或者端口被其他程序占用

fortop

萬分感激

fortop

萬分感激

fortop

萬分感激！具體處理或解決方法可否介紹一下？

fortop

查了一下，沒有發現端口被佔用（或使用）。


+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              https://lnmp.org             |
+-------------------------------------------+
Stoping LNMP...
Stoping nginx...  done
ERROR! MySQL server PID file could not be found!
Gracefully shutting down php-fpm . done
Starting LNMP...
Starting nginx...  done
Starting MySQL..... ERROR! The server quit without updating PID file (/usr/local/mysql/var/ls-412734-7810-7810.pid).
Starting php-fpm  done
[root@ls-412734-7810-7810 ~]# netstat -ntuap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
tcp        0      0 0.0.0.0:5355            0.0.0.0:*               LISTEN      3016/systemd-resolv
tcp        0      0 127.0.0.1:6379          0.0.0.0:*               LISTEN      2530/redis-server 1
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      14711/nginx: master
tcp        0      0 0.0.0.0:21              0.0.0.0:*               LISTEN      2522/pure-ftpd      
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      2519/sshd           
tcp        0      0 0.0.0.0:443             0.0.0.0:*               LISTEN      14711/nginx: master
tcp        0      0 146.196.52.7:443        39.32.32.3:50013        ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:443        66.249.71.219:45689     TIME_WAIT   -                  
tcp        0      0 146.196.52.7:443        66.249.71.221:61010     ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:80         58.153.114.94:54441     ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:443        66.249.79.55:60857      ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:22         146.59.87.70:36444      ESTABLISHED 15505/sshd: root [p
tcp        0   1432 146.196.52.7:22         58.153.114.94:53870     ESTABLISHED 6492/sshd: root [pr
tcp        0      0 146.196.52.7:443        131.153.240.2:42990     TIME_WAIT   -                  
tcp        0  47043 146.196.52.7:443        39.32.32.3:50012        ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:443        114.119.139.181:44329   TIME_WAIT   -                  
tcp        0      0 146.196.52.7:443        158.132.13.116:51693    ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:443        131.153.240.2:42980     TIME_WAIT   -                  
tcp        0      0 146.196.52.7:443        114.119.130.18:48861    TIME_WAIT   -                  
tcp        0      0 146.196.52.7:443        66.249.71.219:44694     TIME_WAIT   -                  
tcp        0      0 146.196.52.7:443        66.249.79.45:62106      TIME_WAIT   -                  
tcp        0      0 146.196.52.7:80         58.153.114.94:54373     TIME_WAIT   -                  
tcp        0      0 146.196.52.7:443        66.249.71.223:54402     ESTABLISHED 14712/nginx: worker
tcp        0      0 146.196.52.7:443        66.249.71.217:42120     TIME_WAIT   -                  
tcp6       0      0 :::5355                 :::*                    LISTEN      3016/systemd-resolv
tcp6       0      0 :::21                   :::*                    LISTEN      2522/pure-ftpd      
tcp6       0      0 :::22                   :::*                    LISTEN      2519/sshd           
udp        0      0 127.0.0.53:53           0.0.0.0:*                           3016/systemd-resolv
udp        0      0 127.0.0.1:323           0.0.0.0:*                           2457/chronyd        
udp        0      0 0.0.0.0:5355            0.0.0.0:*                           3016/systemd-resolv
udp6       0      0 ::1:323                 :::*                                2457/chronyd        
udp6       0      0 :::5355                 :::*                                3016/systemd-resolv
[root@ls-412734-7810-7810 ~]#

licess

fortop 发表于 2022-11-6 17:14
查了一下，沒有發現端口被佔用（或使用）。

ps aux 看一下进程
或reboot重启一下

fortop

licess 发表于 2022-11-7 08:38
ps aux 看一下进程
或reboot重启一下

已經嘗試Reboot了服務器，但都沒有變化，因為無法上載附件，我將PS AUX及錯誤日志放在網頁上，麻煩軍哥幫忙看一下，了解一下確實原因及可以如何處理，非常感謝！
PS Aux結果：
http://www.arting.com/downloads/ps-aux.txt

錯誤日志：
http://www.arting.com/downloads/error.log

fortop

licess 发表于 2022-11-7 08:38
ps aux 看一下进程
或reboot重启一下

附完整版錯誤日志：
http://www.arting.com/downloads/ls-412734-7810-7810.err

licess

fortop 发表于 2022-11-7 12:58
已經嘗試Reboot了服務器，但都沒有變化，因為無法上載附件，我將PS AUX及錯誤日志放在網頁上，麻煩軍哥幫 ...

rm -f /tmp/mysql.sock
/etc/init.d/mysql start

fortop

licess 发表于 2022-11-8 09:53
rm -f /tmp/mysql.sock
/etc/init.d/mysql start

還是不成
還是不成

Last failed login: Tue Nov  8 06:49:59 CST 2022 from 177.47.93.71 on ssh:notty
There were 2828 failed login attempts since the last successful login.
Last login: Mon Nov  7 12:41:22 2022 from 58.153.114.94
[root@ls-412734-7810-7810 ~]# \cp -r -a  /usr/local/nginx/*  /home/wwwroot/default/ScreenMyAdmin/upload/nginx/
cp: target '/home/wwwroot/default/ScreenMyAdmin/upload/nginx/' is not a directory
[root@ls-412734-7810-7810 ~]# \cp -r -a  /usr/local/nginx/*  /home/wwwroot/default/ScreenMyAdmin/upload/nginx/
[root@ls-412734-7810-7810 ~]# rm -f /tmp/mysql.sock
[root@ls-412734-7810-7810 ~]# /etc/init.d/mysql start
Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/ls-412734-7810-7810.pid).
[root@ls-412734-7810-7810 ~]#

licess

fortop 发表于 2022-11-8 10:54
還是不成
還是不成

通过目前已有信息看无法确定