Wednesday, 2 November 2022

Mysql docker container not working

One day, all of sudden, Mysql db in my local does not work. I am using mysql docker container. Check docker container status, I can see it restarts continuely. Look at docker-compose file, and I see this line

restart: on-failure

Ok, it restarts because of failure. Try to container log

docker logs -f  docker_mysql_1

There is a line in log

InnoDB: Error number 28 means 'No space left on device'

Ah, run of space. Here is how to solve this problem

  • list all dangling volumes
    docker volume ls -qf dangling=true
  • remove these volues
    docker volume rm $(docker volume ls -qf dangling=true)
  • restart container

Before delete the volume, you can check which containers are using it

docker ps -a --filter volume=VOLUME_NAME

Find container details

docker container inspect container_id

No comments:

Post a Comment