• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Resolved 500 Plesk\Exception\Database

StefanoSudati

New Pleskian
Hi All
Big problem :(

DB query failed: SQLSTATE[HY000] [2002] No such file or directory
TypePlesk\Exception\Database
MessageDB query failed: SQLSTATE[HY000] [2002] No such file or directory
FileMysql.php
Line64


SSH

# plesk db

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
exit status 1

# service mariadb status -l

● mariadb.service - MariaDB 10.3.27 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: deactivating (final-sigterm) (Result: exit-code)
Docs: man:mysqld(8)
systemd
Process: 3522 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3523 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3525 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, s
Process: 3587 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 3587 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Tasks: 3 (limit: 1144)
Memory: 76.0M
CGroup: /system.slice/mariadb.service
└─777 /usr/sbin/mysqld

Jan 15 13:21:38 cloud.xxx.com systemd[1]: Starting MariaDB 10.3.27 database server...
Jan 15 13:21:38 cloud.xxx.com systemd[1]: mariadb.service: Found left-over process 777 (mysqld) in control group while starting unit. Ignoring.
Jan 15 13:21:38 cloud.xxx.com systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Jan 15 13:21:38 cloud.xxx.com mysqld[3587]: 2021-01-15 13:21:38 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 3587 ...
Jan 15 13:21:38 cloud.xxx.com mysqld[3587]: 2021-01-15 13:21:38 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32183)
Jan 15 13:22:15 cloud.xxx.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 15 13:37:15 cloud.xxx.com systemd[1]: mariadb.service: State 'stop-sigterm' timed out. Skipping SIGKILL.


What can i do?
 
Last edited:
I am sorry to bother u but I have a problem with plesk and I cannot have access to server. I would appreciate your help if u can help me.
The problem discribed here :
MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\Exception\Database
But I dont know what to do to fix it.
 
Back
Top