MySQL error message

[rpgoldman]

Just restarted and I see this message in docker compose logs:

server_mysql_1     | ERROR 1064 (42000) at line 14: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET_GLOBAL max_connections = 1000' at line 1

No idea what this means, or if this has always been there, I'm afraid, but thought it worth a report.

[haz]

Related to #66 , can you manage to wipe the db data, and try a fresh build?

I had super weird behaviour when I was trying to upgrade packages and think it was due to a mismatch in cached database details.

[haz]

Should note that my version upgrades a lot. Including the MySQL base image: main...haz:planning-as-a-service:main#diff-384e92019121a5f7537238f61bc89717e9a9bde9af213a6a8aea7a703f3c9136R65

[rpgoldman]

Can you tell me how to wipe the db data? I shut down the PaaS system with docker compose down and then restarted the DB server (only) with docker compose up mysql. That gets the mysql container started, but in a state where mysql is running and I cannot delete the db data files (in /var/lib/mysql/), because they are in use.
I need to stop the mysql daemon but... I don't know how! 🤦🏻 The only recipes I know use service or systemctl and that doesn't seem to be how this image works it. I checked the mysql image docs but they say nothing about how to shutdown a running server in a container.

[haz]

Oy! Never tried from within the image. Always a sudo rm -rf db_data or whatever on the outside. Will have a look tonight if I can't get a work-around in the Makefile route, as suggested in #66