anh @nguyenoanh ơi,
mình cũng bị lỗi Error establishing a database connection khi update version.
đã chạy thử lệnh này:
và kết quả:
Code: Select all[root@vpssim ~]# systemctl restart mariadb.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
2) VPS Vultr 5$, Check Server status thông số như sau:
Code: Select all- Disc Free: 16018 MB
-------------------------------------------------------------------------
PHP Status: Running
PHP version: 7.1.18
Nginx Status: Running
nginx version: nginx/1.13.8
MySQL Status: Stopped
-------------------------------------------------------------------------
PhpmyAdmin Link: On
File Manager: Installed | Domain: mydomain.com
Net2FTP: Not Install
NetData: Not Install
-------------------------------------------------------------------------
Zend Opcache: On | Ram Usage: 40 MB | Auto Clear Time: 60 S
Memcached: Not Install
Redis: Not Install
-------------------------------------------------------------------------
CSF Firewall: Installed but Disable
-------------------------------------------------------------------------
Auto Run VPSSIM (Khi Login SSH): TAT
-------------------------------------------------------------------------
eMail thong bao Login: BAT | eMail: myemail
-------------------------------------------------------------------------
Total Website: 2 | Website Has Data: 2
=========================================================================
Connections to: 80 Port: 9 | 443 Port: 0
=========================================================================
Server Uptime: 25 min - CPU Load Average: 0.00 0.02 0.04
RAM: 991 MB - Free: 397 MB - Cached: 729 MB || Free buffers: MB
Swap: 0 MB - Swap free: 0 MB
3) Sau đó e chạy lệnh:
và kết quả:
Code: Select all[root@vpssim ~]#
● mariadb.service - MariaDB 10.2.15 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Thu 2018-05-31 06:26:16 UTC; 47s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 7304 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 7070 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 7068 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 7304 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
May 31 06:26:16 vpssim.paid2adsmg.com mysqld[7304]: 2018-05-31 6:26:16 13984...
May 31 06:26:16 vpssim.paid2adsmg.com mysqld[7304]: 2018-05-31 6:26:16 13984...
May 31 06:26:16 vpssim.paid2adsmg.com mysqld[7304]: 2018-05-31 6:26:16 13984...
May 31 06:26:16 vpssim.paid2adsmg.com mysqld[7304]: 2018-05-31 6:26:16 13984...
May 31 06:26:16 vpssim.paid2adsmg.com mysqld[7304]: 2018-05-31 6:26:16 13984...
May 31 06:26:16 vpssim.paid2adsmg.com mysqld[7304]: 2018-05-31 6:26:16 13984...
May 31 06:26:16 vpssim.paid2adsmg.com systemd[1]: mariadb.service: main proce...
May 31 06:26:16 vpssim.paid2adsmg.com systemd[1]: Failed to start MariaDB 10....
May 31 06:26:16 vpssim.paid2adsmg.com systemd[1]: Unit mariadb.service entere...
May 31 06:26:16 vpssim.paid2adsmg.com systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.
và
Code: Select all[root@vpssim ~]# journalctl -xe
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com mysqld[7304]: 2018-05-31 6:26:16 13984468
May 31 06:26:16 vpssim.yourdomain.com.com systemd[1]: mariadb.service: main process
May 31 06:26:16 vpssim.yourdomain.com.com systemd[1]: Failed to start MariaDB 10.2.1
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
May 31 06:26:16 vpssim.yourdomain.com.com systemd[1]: Unit mariadb.service entered f
May 31 06:26:16 vpssim.yourdomain.com.com systemd[1]: mariadb.service failed.
May 31 06:26:16 vpssim.yourdomain.com.com polkitd[446]: Unregistered Authentication
lines 2416-2446/2446 (END)