Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

macOS - Dockerize MySQL service connection refused, crashes upon use

Using mysql(v8.0.21) image with mac docker-desktop (v4.2.0, Docker-Engine v20.10.10)

As soon service up:

  • entrypoints ready
  • innoDB initialization done
  • ready for connection

But as soon try to run the direct script(query) it crashes, refused to connect (also from phpmyadmin) and restarted again.

  1. terminal log
  2. connection refused for phpMyAdmin

In the logs we are able to see an Error:

[ERROR] [MY-011947] [InnoDB] Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory

The error we are able to see into log is not an issue, as it is fixed and updated by InnoDB already, here is the reference below:

https://jira.mariadb.org/browse/MDEV-11840


Note: docker-compose file we are pretty much sure that, there is no error as same is working fine for windows as well ubuntu, but the issue is only for macOS.

like image 720
sheerazabbas Avatar asked Sep 02 '25 10:09

sheerazabbas


1 Answers

Thanks @NicoHaase and @Patrick for going through the question and suggestions.

Found the reason for connection refused and crashing, posting answer so that it maybe helpful for others.

It was actually due to docker-desktop macOS client there was by default 2GB Memory was allocated as Resource, and for our scenario it was required more than that.

We just allocate more memory according to our requirement and it was just started working perfectly fine.

For resource allocation:

  • open docker-desktop preferences
  • resources > advanced docker-desktop resources allocation
like image 101
sheerazabbas Avatar answered Sep 04 '25 00:09

sheerazabbas