I’m trying to use
library/mysql:5.7 as a database image for my CI testing. Part of that process involves setting up test fixture data in the system based on a predefined dataset (literally just a bunch of SQL files read from disk) on every run.
The problem is that it seems like CircleCI is caching the Docker image between runs; when I try and run a build, I get a SQL error complaining that I’m trying to add the same table multiple times, which isn’t what I want. I can get around this by adding
DROP DATABASE statements to every test, but that isn’t ideal given how it should be recreating the container on every new build…
(As an aside, I built my process out using the local CLI and that behaviour doesn’t exist there)