Issue DB query failed: SQLSTATE[HY000] [2002] No such file or directory

[perezhuguet]

Server operating system version

Ubuntu

Plesk version and microupdate number

18.0.64

I have been trying to solve this problem since yesterday, but there is no way.
Can someone please give me a hand?

Thank you so much

 

[Martin Dias]

Check over SSH the following commands:

# service mariadb status
# df -h
# df -i

And provide us the output.

Also, what did you try to do already?

 

[perezhuguet]

Check over SSH the following commands:

# service mariadb status
# df -h
# df -i

And provide us the output.

Also, what did you try to do already?

Thank you very much for your response.
I attach screenshots of what I get when typing these commands.

I've been having this problem since Thursday and without sleeping.

Right now, what I'm looking for is someone who can solve it for me because I don't see a way out.

Thanks for the help

 

[manni]

Your Screenshots miss the end of Lines

 

[Raul A.]

Try this comand and provide the output:

journalctl --output=cat -xeu mariadb

 

[Kaspar]

Right now, what I'm looking for is someone who can solve it for me because I don't see a way out.

Don't hesitate to open a ticket with Plesk support via support.plesk.com to let the Plesk support engineers help you. Support is included with your license if you bought it directly from Plesk. Otherwise, if you got your license from a reseller (for example you provider), you can gets a separate support subscription (of which the first month is free): How to get support directly from Plesk?

 

[perezhuguet]

Try this comand and provide the output:

journalctl --output=cat -xeu mariadb

Don't hesitate to open a ticket with Plesk support via support.plesk.com to let the Plesk support engineers help you. Support is included with your license if you bought it directly from Plesk. Otherwise, if you got your license from a reseller (for example you provider), you can gets a separate support subscription (of which the first month is free): How to get support directly from Plesk?

thanks for the response.
Currently my provider is not Plesk directly (which will be soon) and I cannot ask them for help

So if you know of any way to contact them and have them review it, I would appreciate it. Meanwhile I'm still looking for options.

 

[perezhuguet]

Don't hesitate to open a ticket with Plesk support via support.plesk.com to let the Plesk support engineers help you. Support is included with your license if you bought it directly from Plesk. Otherwise, if you got your license from a reseller (for example you provider), you can gets a separate support subscription (of which the first month is free): How to get support directly from Plesk?

Try this comand and provide the output:

journalctl --output=cat -xeu mariadb

thanks for the response.
This is what the screen shows.

 

[Raul A.]

The issue is above line 54. Your screenshot has only the shutdown part. You might have an InnoDB corruption.

 

[perezhuguet]

Thanks

 

[Raul A.]

Sorry for the previous command. Please try
the following:

journalctl -n100 --no-pager -xeu mariadb

 

[Kaspar]

So if you know of any way to contact them and have them review it, I would appreciate it. Meanwhile I'm still looking for options.

Read the information on the link in my previous post.

 

[perezhuguet]

Thank you all for helping me.
The level of saturation with this problem has been such that I have decided to format the server and start from scratch.
In the end, when I fixed one thing, another appeared. I managed to start it at 3:00 p.m. and at 6:00 p.m. it was down again, which is why I decided to start from scratch.
Thank you all very much for the contributions.
,