Author Topic: Start MySQL server, please wait  (Read 1202 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Start MySQL server, please wait
« on: July 13, 2021, 01:11:42 PM »
CWP stopped working, I try to access the admin panel, root access got the following error:
Code: [Select]
Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

I've already run the command sh /scripts/restart_cwpsrv to restart mysql server, but nothing to go.

Offline
*
Re: Start MySQL server, please wait
« Reply #1 on: July 14, 2021, 04:10:30 PM »
Please check your server's disk usage.

Offline
*
Re: Start MySQL server, please wait
« Reply #2 on: July 15, 2021, 03:57:24 PM »
I believe it's not a disk problem, but here's a print with the information: https://prnt.sc/1bgg2u1

It would be 20GB in total, using 8GB currently.

I don't know if it helps, but I use a CentOS 7

Offline
*
Re: Start MySQL server, please wait
« Reply #3 on: July 15, 2021, 04:08:23 PM »
Consegui mais algumas informações, caso ajude:

Code: [Select]
********************************************
 Welcome to CWP (CentOS WebPanel) server
********************************************

CWP Wiki: http://wiki.centos-webpanel.com
CWP Forum: http://forum.centos-webpanel.com
CWP Support: http://centos-webpanel.com/support-services

 13:04:48 up 2 days,  3:05,  1 user,  load average: 0.32, 0.30, 0.26
USER     TTY      FROM             LOGIN@   IDLE   JCPU   PCPU WHAT
root     pts/0    186.233.221.128  13:04    0.00s  0.02s  0.00s sh /root/.bash_cwp

[root@vps1 ~]# sh /scripts/restart_cwpsrv
[root@vps1 ~]# service mysql restart
Restarting mysql (via systemctl):  Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
                                                           [FAILED]
[root@vps1 ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.36 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: activating (auto-restart) (Result: signal) since Thu 2021-07-15 13:06:35 -03; 2s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 6858 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --basedir=/usr $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
  Process: 6825 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 6824 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 6858 (code=killed, signal=ABRT)

Jul 15 13:06:35 vps1.zkservidores.com systemd[1]: Failed to start MariaDB 10.2.36 database server.
Jul 15 13:06:35 vps1.zkservidores.com systemd[1]: Unit mariadb.service entered failed state.
Jul 15 13:06:35 vps1.zkservidores.com systemd[1]: mariadb.service failed.
[root@vps1 ~]# journalctl -xe
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: :0(__GI_raise)[0x7ffa212a6387]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: :0(__GI_abort)[0x7ffa212a7a78]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x999ac3)[0x55ff6dd70ac3]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9df768)[0x55ff6ddb6768]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9fd9e7)[0x55ff6ddd49e7]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9dc6a8)[0x55ff6ddb36a8]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x97f3bf)[0x55ff6dd563bf]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x94f7ba)[0x55ff6dd267ba]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x9513b5)[0x55ff6dd283b5]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x83e641)[0x55ff6dc15641]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x64)[0x55ff6da7ce54]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x51f0a0)[0x55ff6d8f60a0]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x9a2)[0x55ff6d8f7962]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x46c8c7)[0x55ff6d8438c7]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x4be)[0x55ff6d8498ce]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /lib64/libc.so.6(__libc_start_main+0xf5)[0x7ffa21292555]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: /usr/sbin/mysqld(+0x46653d)[0x55ff6d83d53d]
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: information that should help you find out what is causing the crash.
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Writing a core file...
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Working directory at /var/lib/mysql
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Resource Limits:
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Limit                     Soft Limit           Hard Limit           Units
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max cpu time              unlimited            unlimited            seconds
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max file size             unlimited            unlimited            bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max data size             unlimited            unlimited            bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max stack size            8388608              unlimited            bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max core file size        0                    unlimited            bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max resident set          unlimited            unlimited            bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max processes             62987                62987                processes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max open files            16384                16384                files
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max locked memory         65536                65536                bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max address space         unlimited            unlimited            bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max file locks            unlimited            unlimited            locks
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max pending signals       514862               514862               signals
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max msgqueue size         819200               819200               bytes
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max nice priority         0                    0
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max realtime priority     0                    0
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Max realtime timeout      unlimited            unlimited            us
Jul 15 13:06:46 vps1.zkservidores.com mysqld[6987]: Core pattern: core
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: mariadb.service: main process exited, code=killed, status=6/ABRT
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: Failed to start MariaDB 10.2.36 database server.
-- 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.
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: Unit mariadb.service entered failed state.
Jul 15 13:06:46 vps1.zkservidores.com systemd[1]: mariadb.service failed.
Jul 15 13:06:49 vps1.zkservidores.com named[428]: client @0x7fe1b4042e70 104.169.74.143#80 (pizzaseo.com): query (cache) 'pizzaseo.com/RRSIG/IN' denied

Offline
**
Re: Start MySQL server, please wait
« Reply #4 on: November 21, 2021, 09:53:44 PM »
Wow, this problem has been around since July 2021.  Amazing.
Listen to everything Pixelpadre says.