Postgres database connections are jumbled up after running tests and restarting the application

[priornix]

Postgres database connections are jumbled up after running lein repl and lein test consecutively, reloading the database namespace and restarting the application.

Luminus version: 2.9.11.60
Clojure version: 1.8.0
Java version: 1.8.0_131

Steps to reproduce

1. Create a new luminus project with +postgres profile
2. Modify profiles.clj to point to the dev and test databases.
3. Run lein repl and (start) the application.
4. Load the database namespace and create a new user:

=> (require '[foobar.db.core :as db])
=> (db/create-user! {:id "ha" :first_name "ha" :last_name "ha" :email "ha" :pass "ha" })`

5. Verify that the user exists:

=> (db/get-user {:id "ha"})
{:admin nil :email "ha" :first_name "ha" :id "ha" :is_active nil :last_login nil :last_name "ha" :pass "ha"}

6. On another terminal window, start lein test and wait till the test is completed.
7. Reload the database namespace and restart the application

=> (require '[foobar.db.core :as db] :reload)
=> (restart)

8. The created user can no longer be found:

=> (db/get-user {:id "ha"})
nil

9. The database connection is now pointing to the one specified in the test profile instead of dev. To verify, add a new user using create-user!, the new user now appears in the test database, which is incorrect.

[yogthos]

I think the issue might be caused by the fact that the .lein-env file is regenerated when the test profile is run and the changes are picked up from there.

[yogthos]

One solution would be to not restart env in the restart function:

(defn start []
  (mount/start-without #'app.core/repl-server
                       #'app.config/env))

(defn stop []
  (mount/stop-except #'app.core/repl-server
                     #'app.config/env))

[yogthos]

I finally got around to resolving this. The new template no longer uses profiles.clj to track environment variables. Instead, there are two separate files called dev-config.edn and test-config.edn for tracking dev and test configurations respectively.