Mariadb doesn't start the mysql server in docker

[DARKBOW923]

Hello guys,

Basically i made a docker-compose.yml:

`version: "3.9"
services:
mariadb:
image: mariadb:latest
deploy:
placement:
constraints: [node.role == worker]
replicas: 1
tty: true
ports:
- 3333:3306
networks:
- red_mariadb
volumes:
- volumen1234:/var/lib/mysql/
environment:
- MARIADB_ROOT_PASSWORD=smx
- MARIADB_USER=smx

volumes:
volumen1234:
driver: local
driver_opts:
type: "nfs"
o: "addr=192.168.56.25,rw,vers=3"
device: ":/export/mariadb"

networks:
red_mariadb:
external: true`
As you can see, the docker is correct, however when i try to enter mysql it says the following error:

ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)

And if i look at the logs, i see this error:

2022-05-21 17:44:53 0 [ERROR] mariadbd: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 37. Will retry for 30 seconds

Any help? I'm using mariadb official image for docker.

[grooverdan]

this error, almost always, is another mariadb container running on the same volume.

[DARKBOW923]

this error, almost always, is another mariadb container running on the same volume.

Its not, i just have only a mariadb container.

[grooverdan]

$ podman run --rm mariadb perror 37
OS error code  37:  No locks available

So its looking more like your nfs storage doesn't have a locking service running or its somehow disabled. There's currently no mariadb option to skip the locking on Aria control files.

[masiton]

Why is this closed? I'm encountering the same thing, there is no workaround?

[grooverdan]

please provide details of a the environment which it occurs along with container logs.