• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • 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.

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