Error establishing a database connection

Today I was trying to open the website I have been working on and I this error: “Error establishing a database connection”

And when I tried to access “./wp-admin” I get this:

Also, when accessing to the database manager I get this error:

Imgur

I tried restarting PC, restarting docker and devkinsta, close it and open again, but nothing.

Help please, this website has a lot of progress and I don’t want to lost everything.

I just erased every container and image, restarted devkinsta an got this notification in windows.

Imgur

Now It gives me this error.

As you can see, DevKinsta has configured the database and everything was working ok! But now, I can’t access the website, and the database looks to be GONE! Please don’t tell me my database has been deleted.

Today I was trying to open the website I have been working on and I this error: “Error establishing a database connection”

Now I get this when I tried to access the database manager.

Imgur

I tried restarting PC, restarting docker and devkinsta, close it and open again, but nothing.

Help please, this website has a lot of progress and I don’t want to lost everything.

Also, I just erased every container and image, restarted devkinsta an got this notification in windows.

Imgur

Now It gives me this error.

And my database is gone

Hi @hcmendez . Welcome to DevKinsta! I’m sorry to hear you’re having trouble. Let’s see if we can figure out what happened here.

Could you tell me if your files exist within c:\User\Hen_1\DevKinsta? Do you see your sites under the public directory?

Hello, thanks for answering, that directory exists and this is the content inside:

And on the public directory:

Would you be able to provide a screenshot of Docker as well?

I’ll throw in my $.02 here also - same thing is happening to me after the most recent update.
I am on Mac OS X -

I am sort of happy to hear I am not the only facing this issue - it just started after the automatic update that installed 04/19/2021

I can “fix” it - the same way - tear down DevKinsta as well as Docker - and throw in a re-boot to ensure I am starting over again.
Then I have to recreate the site - and re upload the DB
but shortly there after - it will go boom

Do you mean, deleting the created site, creating it again with the same name and db?

Yes - I can recover (sort of) by re-creating the site. HOWEVER - be sure to copy/backup your site’s folder before deleting (because devKinsta wipes it out!)

BUT this doesn’t fix the underlying problem - it is clear that something changed for the worse in the latest update.

Tried that, didn’t work. Too bad for DevKinsta that this issues are happening. I just lost a 3 weeks work for an unknown reason they don’t even know why. This database problems are probably the most important ones, if your database gets deleted, everything will get deleted as well. No matter what you do. This issue comes from DevKinsta and not from other place. I don’t really thing docker might caused and issue, because the database is managed by DevKinsta. I trusted in this tool but it’s just disappointing.

Note - one of my database keeps disappearing.

It appears to be related to typing this command in wp-cli (but not always!)
wp db reset --yes
I know it fails when the response I get is:
www-data@edeeeb29b62d:/www/kinsta/public/homesites$ wp db reset --yes
ERROR 1006 (HY000) at line 1: Can’t create database ‘homesites’ (errno: 28 “No space left on device”)

I then need to delete this site from devKinsta, and restart my computer (restarting docker). Looking at the Docker console - I see that the Mailhog container has exited - but the rest of the containers are still running (see screenshot - Dropbox - Screen Shot 2021-04-25 at 5.48.54 PM.png - Simplify your life )

This behavior is “new” as of the Version 1.1.5 (1.1.5.1559) of devKinsta

@onebigidea I’m sorry to hear you’re still having trouble. To clarify on that WP CLI command, that’s to completely drop the database and create a new one. Don’t do that unless you’re attempting to delete your database. If you’re looking to reset your database, it’d be best to keep the database in place and instead go into the database manager and drop all the tables.

Thanks - I’ll modify our procedures accordingly.