老师,我将项目部署到阿里云上,通过后台xadmin写入数据的过程中,app挂掉,然后我使用mysql命令,出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
错误,然后我使用sudo systemctl start mariadb
命令重启数据库,但是光标一直闪,没反应。
然后查看journalctl -xe
,
6月 12 09:20:54 iZ2zegr0etgjoah54yj5bfZ sshd[25200]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=85.209.0>
6月 12 09:20:54 iZ2zegr0etgjoah54yj5bfZ sshd[25200]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
6月 12 09:20:54 iZ2zegr0etgjoah54yj5bfZ sshd[25199]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=85.209.0>
6月 12 09:20:54 iZ2zegr0etgjoah54yj5bfZ sshd[25199]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
6月 12 09:20:56 iZ2zegr0etgjoah54yj5bfZ sshd[25200]: Failed password for root from 85.209.0.6 port 17002 ssh2
6月 12 09:20:56 iZ2zegr0etgjoah54yj5bfZ sshd[25199]: Failed password for root from 85.209.0.6 port 15010 ssh2
6月 12 09:21:00 iZ2zegr0etgjoah54yj5bfZ sshd[25200]: Connection closed by authenticating user root 85.209.0.6 port 17002 [preauth]
6月 12 09:21:00 iZ2zegr0etgjoah54yj5bfZ sshd[25199]: Connection closed by authenticating user root 85.209.0.6 port 15010 [preauth]
6月 12 09:23:27 iZ2zegr0etgjoah54yj5bfZ systemd[1]: mariadb.service: State 'stop-sigterm' timed out. Skipping SIGKILL.
6月 12 09:24:57 iZ2zegr0etgjoah54yj5bfZ sudo[25209]: root : TTY=pts/0 ; PWD=/var/log ; USER=root ; COMMAND=/bin/systemctl start mariadb
6月 12 09:24:57 iZ2zegr0etgjoah54yj5bfZ sudo[25209]: pam_systemd(sudo:session): Cannot create session: Already running in a session or user slice
6月 12 09:24:57 iZ2zegr0etgjoah54yj5bfZ sudo[25209]: pam_unix(sudo:session): session opened for user root by root(uid=0)
6月 12 09:28:27 iZ2zegr0etgjoah54yj5bfZ systemd[1]: mariadb.service: State 'stop-final-sigterm' timed out. Skipping SIGKILL. Entering failed mode.
6月 12 09:28:27 iZ2zegr0etgjoah54yj5bfZ systemd[1]: mariadb.service: Failed with result 'timeout'.
6月 12 09:28:27 iZ2zegr0etgjoah54yj5bfZ systemd[1]: Failed to start MariaDB 10.3 database server.
请问该怎么解决这个问题呢?
带你彻底掌握Scrapy,用Django+Elasticsearch搭建搜索引擎
了解课程