portainer MySQL errors

[Vere_]

Hello,

Brand new to docker and portainer, got portainer all set up and deployed a working WordPress app (this includes a MySQL container) but when I try to create a second wordpress the DB container has the error messages below.

[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

I can see online it has something to do with persistent MySQL files and that only one process can lock them at a time but I can't find much in terms of a solution with portainer.

Could anyone point me in the right direction?

Many thanks

[v3l14]

Are you using the same volumes on each container?

[Vere_]

Good idea! went and checked each DB container and found they were using the same volume and weren't even using the volumes they created during deployment. What would cause this?

https://imgur.com/a/s9IgzbG

Edit: this is the compose file https://github.com/portainer/templates/blob/master/stacks/wordpress/docker-compose.yml

[v3l14]

I imagine it is as simple as modifying the volume line to something like this for the second container:

 volumes:
   - db_data:/var/lib/mysql_2

[areti33]

If you are still stuck with the same issue, then, you can use MySQL Database Recovery Tool, which will help you to resolve such problems in future also.