So far the setup works very fine using the database with nodejs. I've put it all on circleci, the tests are run via mocha and outputs junit
Fresh database (meaning just created it and ran migrations, no tests yet), the tests pass with no problems. Then, after 2/3 or so deployments, it stop passing and I get stuck with 'unknown relation "xxx"...'
Deleting the db, re-running migrations, redeploying, the tests pass again.
So far it seems that running the tests 'deteriorate' the database after time and it required to make it fresh again. I just have no clue from where it can come from.
I do clean each tables (deleting all records) via a beforehook for each tests, but nothing that particular besides it
Experienced help apreciated
Best.
Maybe you can try db.sync({ force: true }) after/before tests so it can drop tables before recreating them.