• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue Server Error 500 SQLSTATE[HY000] [2002] No such file or directory

markbro

New Pleskian
Hello Community

I recently decided to give Plesk my support and moved a single business website over.

Some things to know.
1. I used VULTR to get a plesk server on Ubuntu 18.04
2. I upgraded the plan from 2gb to 4GB of RAM - this also increased the disk image size.
3. I may have restarted the server when I shouldn't have
4. I have a snapshot thats 4 days old, but a bunch of info/orders inside woo commerce I need to get back.
5. I kept the server updated and secure as a priority.

I need to work out why I cant get mySQL/MariaDB to start, I've tried every solution I could find, and if it didn't work.
I'm not a server admin, but I can normally figure my own issues out through reading forums.

Ive tried to
1. manually start the sql service with
2. use the repair kit at www.domain.com/repair
3. restart the server
4.

This one has me stumped, I've considered rolling back to the snapshot from 4 days ago, and then restoring from backup I have of Wordpress on Google Drive, but before I do that, I think it would be worth a shot here. So please throw in your 2 cents.

Ive been logging in via console via VULTR and SFTP to check files match with what they should.
Finally Im willing to pay a little bit for some support, but not too much because its a new small business, and I recently lost my life savings.. yep!
Ive been awake 8 hours past my bedtime already trying to fix it.

Im tempted to go down the path of pulling the last data out of wordpress and the databases which I have a copy of via SFTP.
But the problem is Ive never tried to do that, and I need to get the website back up for the public asap.
 
Some info you may want to see

root@webz4biz:~# systemctl status mariadb

● mariadb.service - MariaDB 10.1.48 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2021-09-30 05:13:17 AEST; 1s ago
Docs: man:mysqld(8)
systemd
Process: 28892 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status
Process: 28810 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/ga
Process: 28802 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCES
Process: 28790 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS
Main PID: 28892 (code=exited, status=1/FAILURE)
Status: "Starting Innodb crash recovery"

Sep 30 05:13:16 webz4biz.com systemd[1]: Starting MariaDB 10.1.48 database server...
Sep 30 05:13:17 webz4biz.com mysqld[28892]: 2021-09-30 5:13:17 139644199738496 [Note] /usr/sbin/mysqld (mysqld 10.1.48-
Sep 30 05:13:17 webz4biz.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 30 05:13:17 webz4biz.com systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 30 05:13:17 webz4biz.com systemd[1]: Failed to start MariaDB 10.1.48 database server.
lines 1-17/17 (END)


root@webz4biz:~# journalctl -xe
-- Unit drwebd.service has finished shutting down.
Sep 30 05:16:38 webz4biz.com systemd[1]: Started Plesk Premium Antivirus.
-- Subject: Unit drwebd.service has finished start-up
-- Defined-By: systemd
-- Support: Enterprise open source support | Ubuntu
--
-- Unit drwebd.service has finished starting up.
--
-- The start-up result is RESULT.
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Dr.Web (R) daemon for Linux/Plesk Edition v6.0.2.1
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Copyright (c) Igor Daniloff, 1992-2021
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Doctor Web, Moscow, Russia
Sep 30 05:16:38 webz4biz.com drwebd[7673]: Support service: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:38 webz4biz.com drwebd[7673]: To purchase: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Dr.Web (R) daemon for Linux/Plesk Edition v6.0.2.1
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Copyright (c) Igor Daniloff, 1992-2021
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Doctor Web, Moscow, Russia
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: Support service: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:38 webz4biz.com drwebd.real[7673]: To purchase: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Sep 30 05:16:39 webz4biz.com drwebd[7673]: Key file: /opt/drweb/drweb32.key - Key file was not found! (No such file or d
Sep 30 05:16:39 webz4biz.com drwebd[7673]: A path to a valid license key file was not specified.
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: Key file: /opt/drweb/drweb32.key - Key file was not found! (No such file
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: A path to a valid license key file was not specified.
Sep 30 05:16:39 webz4biz.com drwebd[7673]: Plesk authorization failed: malformed response (no 'response=' field).
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: Plesk authorization failed: malformed response (no 'response=' field).
Sep 30 05:16:39 webz4biz.com drwebd[7673]: Error: Plesk Software not running.
Sep 30 05:16:39 webz4biz.com drwebd.real[7673]: Error: Plesk Software not running.
Sep 30 05:16:39 webz4biz.com systemd[1]: drwebd.service: Main process exited, code=exited, status=255/n/a
Sep 30 05:16:39 webz4biz.com systemd[1]: drwebd.service: Failed with result 'exit-code'.
lines 1989-2017/2017 (END)
 
Back
Top