服務器出現故障,重啟之後MySQL出錯,請幫忙看看,謝謝!
[root@ls-412734-7810-7810 ~]# lnmp restart +-------------------------------------------+ | Manager for LNMP, Written by Licess | +-------------------------------------------+ +-------------------------------------------+ 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
|