Marinus Klasen

Marinus Klasen

  • Development
  • Consultancy
  • Developer Resources
  • Blog
  • Contact

August 12, 2022

Mariadb in docker fails to start, keeps restarting

Marinus Klasen

Lately I’ve seen errors in my local development environments:

mariadbd failed while attempting to check config
mkv2-db      | 	command was: mariadbd --verbose --help --log-bin-index=/tmp/tmp.ty9vQzLxEx
mkv2-db      | 	Can't initialize timers

This causes my database container to get stuck in a restarting loop.

The fix? Downgrade the mariadb version!

The database part of docker compose was configured like this:

services:
  db:
    container_name: ${NAME}-db
    image: mariadb
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_PASSWORD}
      MYSQL_DATABASE: ${DB_NAME}
      MYSQL_USER: ${DB_USER}
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - "./app/data/db:/var/lib/mysql"
    expose:
      - "3306"
    restart: unless-stopped

The version used on my system is mariadb 10.8.3, apparently that version can cause issues like this. After setting the image to mariadb:10.8.2 instead of mariadb, the issue was resolved!

services:
  db:
    container_name: ${NAME}-db
    image: mariadb:10.8.2
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_PASSWORD}
      MYSQL_DATABASE: ${DB_NAME}
      MYSQL_USER: ${DB_USER}
      MYSQL_PASSWORD: ${DB_PASSWORD}
    volumes:
      - "./app/data/db:/var/lib/mysql"
    expose:
      - "3306"
    restart: unless-stopped

Hope that helps you as well,

Happy developing!

About Marinus Klasen

Marinus has been working in software/web development for more than a decade. Since 2020 his attention shifted on sharing knowledge and developing products and tools for sharing knowledge.

Marinus Klasen on Twitter

This site runs on Cloudways.
It's fast isn't it?
Cloudways offers high-quality, fast and affordable hosting.

Learn more

Need a hand? Post your project and hire me and other top notch developers on Codeable.

Hire me on Codeable

Comments

  1. Dill says

    January 5, 2023 at 12:35 pm

    thanks, you saved my week. I was trying to figured out what is happening, but nothing was working for me.

    Reply
    • Marinus Klasen says

      January 5, 2023 at 12:40 pm

      Haha, beautiful! Glad I was able to help 🙂

      Thanks for leaving a comment,

      / Marinus

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Get in touch

Contact me using the details below

Marinus Klasen

Wilhelmina van Pruisenweg 35, 2595 AN Den Haag

[email protected]
twitter.com/marinusklasen
linkedin.com/in/marinusklasen

  • GitHub
  • LinkedIn
  • Twitter

Have you read?

  • Delete a pending user from WordPressOctober 31, 2023
  • Disable the ‘Password Changed’ Email notification in WordPress with a filterAugust 30, 2023
  • A-Frame: Change an objects color on hoverAugust 24, 2023
  • Connecting to a Cloudways application with VSCodeAugust 15, 2023
  • Force refresh PHP-FPM or Litespeed cacheAugust 4, 2023

Copyright © 2023 · Marinus Klasen | Webdesign by Team Rood