Devkinsta_db not starting

I have a problem with devkinsta_db I am running ubuntu 23.10. Everything has been great up until now. I cannot get into the container to even try and troubleshoot the problem. Is there a trick to get the container to start and stay up so I can troubleshoot it?

I had a problem with privileges and can say it all started there. Now I have no databases and websites that need their databases :frowning:

May you share which version of DevKinsta you’re using?

Also, any info on your Docker setup might be helpful, and, you mentioned “a problem with privileges”.

May you explain further please?

Also, if possible, please detail what have you tried on your end to restart the container and whether there are any error messages displayed when you do so.

Finally, may you PM the main.log file as that may provide us with additional info logged by your DevKinsta instance.

You can use the guide linked below to find the logs:

Many thanks for getting back to me.

the images appear to be using 1.3.6 - I cannot say what version the application is because it is not fully starting up and there is no indication on the window that loads the app of what the version is.

The privelige problem I am referring to is that I set root@% to have access on a custom database that I had created. The adminer tool crashed and when I tried to get back in I found that all the databases had disappeared and I could no longer set priveleges that would bring them back. Including removing the previously added.

When I start the containers devkinsta_db stops instantly so I cannot even get into the container to try and troubleshoot the problem.

the application does not produce an error code. It only says errors.

image

mail.log for todays date… It is too long to post it all.

[2024-08-19 09:36:05.027] [info] [setWpVersions] last wp version: 6.6.1
[2024-08-19 09:36:05.154] [info] [setWslVolumePath] set wsl path
[2024-08-19 09:36:05.154] [info] [isWslMode] check if docker runs on wsl mode
[2024-08-19 09:36:05.247] [info] [getDevKinstaPath] get DevKinsta path
[2024-08-19 09:36:05.247] [info] [isWslMode] check if docker runs on wsl mode
[2024-08-19 09:36:05.247] [info] [cleanSiteList] Update site list
[2024-08-19 09:36:05.463] [info] [dockerUtil/getImage] Get Docker image, name: kinsta/devkinsta_nginx:1.3.6
[2024-08-19 09:36:05.463] [info] [dockerUtil/isImageUpToDate] Check if ‘kinsta/devkinsta_nginx’ Docker image is up to date
[2024-08-19 09:36:05.468] [info] [dockerUtil/getImage] Get Docker image, name: kinsta/devkinsta_fpm:1.3.6
[2024-08-19 09:36:05.468] [info] [dockerUtil/isImageUpToDate] Check if ‘kinsta/devkinsta_fpm’ Docker image is up to date
[2024-08-19 09:36:05.479] [info] [dockerUtil/getImage] Get Docker image, name: kinsta/devkinsta_db:1.3.6
[2024-08-19 09:36:05.479] [info] [dockerUtil/isImageUpToDate] Check if ‘kinsta/devkinsta_db’ Docker image is up to date
[2024-08-19 09:36:05.483] [info] [dockerUtil/getImage] Get Docker image, name: kinsta/devkinsta_adminer:1.3.6
[2024-08-19 09:36:05.483] [info] [dockerUtil/isImageUpToDate] Check if ‘kinsta/devkinsta_adminer’ Docker image is up to date
[2024-08-19 09:36:05.487] [info] [dockerUtil/getImage] Get Docker image, name: kinsta/devkinsta_mailhog:1.3.6
[2024-08-19 09:36:05.487] [info] [dockerUtil/isImageUpToDate] Check if ‘kinsta/devkinsta_mailhog’ Docker image is up to date
[2024-08-19 09:36:05.652] [info] [dockerUtil/isNetworkExists] Check if ‘devkinsta_network’ is exist
[2024-08-19 09:36:05.727] [info] [dockerUtil/isContainerExists] Check if ‘devkinsta_db’ container exists
[2024-08-19 09:36:05.734] [info] [dockerUtil/isContainerImageUpToDate] Check if ‘devkinsta_db’ container image is up to date
[2024-08-19 09:36:05.734] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:05.736] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_db
[2024-08-19 09:36:05.736] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:05.737] [info] [dockerUtil/isVolumeExists] Check if ‘devkinsta_db_data’ volume is exist
[2024-08-19 09:36:05.737] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:05.737] [info] [createDbContainer] MariaDB container exists on host, with id devkinsta_db, will use port 15100.
[2024-08-19 09:36:05.836] [info] [dockerUtil/isContainerExists] Check if ‘devkinsta_adminer’ container exists
[2024-08-19 09:36:05.842] [info] [dockerUtil/isContainerImageUpToDate] Check if ‘devkinsta_adminer’ container image is up to date
[2024-08-19 09:36:05.842] [info] [dockerUtil/getContainer] Get ‘devkinsta_adminer’ Docker container
[2024-08-19 09:36:05.895] [info] [dockerUtil/isContainerExists] Check if ‘devkinsta_mailhog’ container exists
[2024-08-19 09:36:05.901] [info] [dockerUtil/isContainerImageUpToDate] Check if ‘devkinsta_mailhog’ container image is up to date
[2024-08-19 09:36:05.901] [info] [dockerUtil/getContainer] Get ‘devkinsta_mailhog’ Docker container
[2024-08-19 09:36:05.958] [info] [dockerUtil/isContainerExists] Check if ‘devkinsta_fpm’ container exists
[2024-08-19 09:36:05.964] [info] [dockerUtil/isContainerImageUpToDate] Check if ‘devkinsta_fpm’ container image is up to date
[2024-08-19 09:36:05.964] [info] [dockerUtil/getContainer] Get ‘devkinsta_fpm’ Docker container
[2024-08-19 09:36:05.968] [info] [getDevKinstaPath] get DevKinsta path
[2024-08-19 09:36:05.968] [info] [isWslMode] check if docker runs on wsl mode
[2024-08-19 09:36:06.037] [info] [dockerUtil/isContainerExists] Check if ‘devkinsta_nginx’ container exists
[2024-08-19 09:36:06.043] [info] [dockerUtil/isContainerImageUpToDate] Check if ‘devkinsta_nginx’ container image is up to date
[2024-08-19 09:36:06.043] [info] [dockerUtil/getContainer] Get ‘devkinsta_nginx’ Docker container
[2024-08-19 09:36:06.045] [info] [getDevKinstaPath] get DevKinsta path
[2024-08-19 09:36:06.045] [info] [isWslMode] check if docker runs on wsl mode
[2024-08-19 09:36:06.208] [info] [startDockerContainers] Recreate container? { protocol: { http: false, https: false } }
[2024-08-19 09:36:06.209] [info] [dockerUtil/startContainer] Start ‘devkinsta_nginx’ container
[2024-08-19 09:36:06.209] [info] [dockerUtil/getContainer] Get ‘devkinsta_nginx’ Docker container
[2024-08-19 09:36:06.210] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_nginx
[2024-08-19 09:36:06.210] [info] [dockerUtil/getContainer] Get ‘devkinsta_nginx’ Docker container
[2024-08-19 09:36:06.215] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_nginx
[2024-08-19 09:36:06.215] [info] [dockerUtil/getContainer] Get ‘devkinsta_nginx’ Docker container
[2024-08-19 09:36:06.271] [info] [dockerUtil/startContainer] Start ‘devkinsta_fpm’ container
[2024-08-19 09:36:06.271] [info] [dockerUtil/getContainer] Get ‘devkinsta_fpm’ Docker container
[2024-08-19 09:36:06.271] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_fpm
[2024-08-19 09:36:06.271] [info] [dockerUtil/getContainer] Get ‘devkinsta_fpm’ Docker container
[2024-08-19 09:36:06.276] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_fpm
[2024-08-19 09:36:06.276] [info] [dockerUtil/getContainer] Get ‘devkinsta_fpm’ Docker container
[2024-08-19 09:36:06.545] [info] [dockerUtil/startContainer] Start ‘devkinsta_db’ container
[2024-08-19 09:36:06.545] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:06.545] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_db
[2024-08-19 09:36:06.545] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:07.049] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_db
[2024-08-19 09:36:07.049] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:07.121] [info] [dockerUtil/startContainer] Start ‘devkinsta_adminer’ container
[2024-08-19 09:36:07.121] [info] [dockerUtil/getContainer] Get ‘devkinsta_adminer’ Docker container
[2024-08-19 09:36:07.121] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_adminer
[2024-08-19 09:36:07.121] [info] [dockerUtil/getContainer] Get ‘devkinsta_adminer’ Docker container
[2024-08-19 09:36:07.125] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_adminer
[2024-08-19 09:36:07.125] [info] [dockerUtil/getContainer] Get ‘devkinsta_adminer’ Docker container
[2024-08-19 09:36:07.175] [info] [dockerUtil/startContainer] Start ‘devkinsta_mailhog’ container
[2024-08-19 09:36:07.176] [info] [dockerUtil/getContainer] Get ‘devkinsta_mailhog’ Docker container
[2024-08-19 09:36:07.176] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_mailhog
[2024-08-19 09:36:07.176] [info] [dockerUtil/getContainer] Get ‘devkinsta_mailhog’ Docker container
[2024-08-19 09:36:07.180] [info] [dockerUtil/getContainerStatus] Check container status. containerId: devkinsta_mailhog
[2024-08-19 09:36:07.180] [info] [dockerUtil/getContainer] Get ‘devkinsta_mailhog’ Docker container
[2024-08-19 09:36:07.230] [info] [dockerUtil/getContainer] Get ‘devkinsta_nginx’ Docker container
[2024-08-19 09:36:07.231] [info] [getDevKinstaPath] get DevKinsta path
[2024-08-19 09:36:07.231] [info] [isWslMode] check if docker runs on wsl mode
[2024-08-19 09:36:07.236] [info] [watchDocker] Container: devkinsta_nginx, status: exec_create: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.236] [info] [watchDocker] Container: devkinsta_nginx, status: exec_create: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.246] [info] [watchDocker] Container: devkinsta_nginx, status: exec_start: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.246] [info] [watchDocker] Container: devkinsta_nginx, status: exec_start: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.237] [info] [watchDocker] Container: devkinsta_nginx, status: exec_create: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.249] [info] [watchDocker] Container: devkinsta_nginx, status: exec_start: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.237] [info] [watchDocker] Container: devkinsta_nginx, status: exec_create: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.250] [info] [watchDocker] Container: devkinsta_nginx, status: exec_start: /bin/sh -c rm -rf /www/kinsta/htpasswd/*
[2024-08-19 09:36:07.352] [info] [watchDocker] Container: devkinsta_nginx, status: exec_die
[2024-08-19 09:36:07.352] [info] [watchDocker] Container: devkinsta_nginx, status: exec_die
[2024-08-19 09:36:07.352] [info] [watchDocker] Container: devkinsta_nginx, status: exec_die
[2024-08-19 09:36:07.352] [info] [watchDocker] Container: devkinsta_nginx, status: exec_die
[2024-08-19 09:36:07.353] [info] [containerExec] Command ‘rm -rf /www/kinsta/htpasswd/*’ on devkinsta_nginx finished with exit code 0
[2024-08-19 09:36:31.298] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:31.298] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:31.307] [error] Error: (HTTP code 409) container stopped/paused - Container 5141ec2a714d32b0e30f7c59cf5d093d8aa2f08007cc8d8b68784d6977525dc4 is not running
at /opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:323:17
at getCause (/opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:353:7)
at Modem.buildPayload (/opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:322:5)
at IncomingMessage. (/opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:294:14)
at IncomingMessage.emit (node:events:525:35)
at IncomingMessage.emit (node:domain:489:12)
at endReadableNT (node:internal/streams/readable:1359:12)
at process.processTicksAndRejections (node:internal/process/task_queues:82:21)
[2024-08-19 09:36:56.210] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:56.210] [info] [dockerUtil/getContainer] Get ‘devkinsta_db’ Docker container
[2024-08-19 09:36:56.214] [error] Error: (HTTP code 409) container stopped/paused - Container 5141ec2a714d32b0e30f7c59cf5d093d8aa2f08007cc8d8b68784d6977525dc4 is not running
at /opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:323:17
at getCause (/opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:353:7)
at Modem.buildPayload (/opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:322:5)
at IncomingMessage. (/opt/DevKinsta/resources/app.asar/node_modules/docker-modem/lib/modem.js:294:14)
at IncomingMessage.emit (node:events:525:35)
at IncomingMessage.emit (node:domain:489:12)
at endReadableNT (node:internal/streams/readable:1359:12)
at process.processTicksAndRejections (node:internal/process/task_queues:82:21)

also when starting the docker container interactively

robert@B450-AORUS-ELITE:~$ docker start devkinsta_db
devkinsta_db
robert@B450-AORUS-ELITE:~$ docker start -i devkinsta_db
2024-08-19 09:07:27+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.17+maria~ubu2004 started.
2024-08-19 09:07:27+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2024-08-19 09:07:27+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.17+maria~ubu2004 started.
2024-08-19 09:07:27+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-08-19 09:07:27+00:00 [Note] [Entrypoint]: MariaDB upgrade (mysql_upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-08-19 9:07:27 0 [Note] mysqld (mysqld 10.5.17-MariaDB-1:10.5.17+maria~ubu2004) starting as process 1 …
robert@B450-AORUS-ELITE:~$ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1766de986112 kinsta/devkinsta_adminer:1.3.6 “docker-php-entrypoi…” 43 hours ago Up 43 hours 0.0.0.0:15200->8080/tcp, :::15200->8080/tcp devkinsta_adminer
5141ec2a714d kinsta/devkinsta_db:1.3.6 “docker-entrypoint.s…” 43 hours ago Exited (1) 15 seconds ago devkinsta_db
bb2dd8cf39e4 kinsta/devkinsta_nginx:1.3.6 “/docker-entrypoint.…” 2 days ago Up 44 hours 0.0.0.0:443->443/tcp, :::443->443/tcp, 80/tcp, 0.0.0.0:39945->39945/tcp, :::39945->39945/tcp devkinsta_nginx
a7501789e46f kinsta/devkinsta_fpm:1.3.6 “/usr/local/sbin/kin…” 2 days ago Up 44 hours 9000-9006/tcp devkinsta_fpm
66116f78dbfc kinsta/devkinsta_mailhog:1.3.6 “MailHog” 2 days ago Up 44 hours 0.0.0.0:10501->1025/tcp, :::10501->1025/tcp, 0.0.0.0:15400->8025/tcp, :::15400->8025/tcp devkinsta_mailhog

I can also see that my databases are there so that is something at least

Hello @Robert_Craig :wave:

In order to make any kind of assessment we need to try and get errors. Is there a way you can run the command docker logs devkinsta_db and take a screenshot of the output?

Also, if you try to create and start a container in Docker what happens?

Kind regards,

2024-08-19 14:14:30 0 [Note] mysqld (mysqld 10.5.17-MariaDB-1:10.5.17+maria~ubu2004) starting as process 1 …
2024-08-19 14:15:31+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.17+maria~ubu2004 started.
2024-08-19 14:15:31+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
2024-08-19 14:15:31+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.5.17+maria~ubu2004 started.
2024-08-19 14:15:31+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-08-19 14:15:31+00:00 [Note] [Entrypoint]: MariaDB upgrade (mysql_upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-08-19 14:15:31 0 [Note] mysqld (mysqld 10.5.17-MariaDB-1:10.5.17+maria~ubu2004) starting as process 1 …

over and over again

docker can create and start containers no problem at all. It is specifically the devkinsta_db container that is broken and wont start

Hi @Robert_Craig

I’ve configured a VirtualBox Machine (DevKinsta + Docker engine on Ubuntu) on my Windows PC to closely match your setup. Based on the screenshots you provided, it seems that the devkinsta_db container is continuously attempting to start but failing. I recommend force stopping and then deleting the devkinsta_db container, as it seems it is already misconfigured. When DevKinsta is restarted, the app will automatically recreate the devkinsta_db container. Deleting only the devkinsta_db container should also preserve your local site database data since this data is mounted separately in the Docker Volume.

I hope that deleting and recreating the devkinsta_db container will help resolve the issue.

Below are the Docker commands I used to stop and delete the devkinsta_db container.

Stop the container: docker stop devkinsta_db
Remove the container: docker rm devkinsta_db

Other related commands:
List of the docker containers: docker ps -a
List of the docker volumes: docker volume list

Let us know how it goes! :crossed_fingers:

Thank you for taking the time to do that. I know this a free tool and I use it in earnest every day. But I couldnt no longer stand the outage. I decided yesterday to remove all of the application and reinstall so that I could get up and running again.

I can say I tried your method several times without success however. As I said previously. I commited a user called root@% and that is where the problems began. The database could not bring up the mysql database and therefor was unable to ascertain any credentials or databases. Hope that helps in the understanding.

You may close the thread and thanks again.

Love DevKinsta - great product.

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.