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 *

Ready to take action?

I'm looking forward to discuss your projects and goals!
Feel free to reach out using the contact details below.

Marinus Klasen

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

  • GitHub
  • LinkedIn
  • Twitter

Have you read?

  • Storing private data with SSH on WPEngine sitesDecember 15, 2022
  • Get the HTML content of a block edit page or post in WordPressNovember 30, 2022
  • Rename Coupon code text to Discount code in WoocommerceNovember 3, 2022
  • Background-size cover in mPDFOctober 22, 2022
  • WordPress.com SSH & duplicating a WordPress.com website locallyOctober 11, 2022

Copyright © 2023 · Marinus Klasen | Webdesign by Team Rood