You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using joplin.repl/reset to roll back and migrate changes to a postgresql db and it doesn't close the connections it opens. I quickly reach my connection limit and have to force kill my postgres instance.
My joplin.edn config defines my only database with {:type :sql, :url "jdbc:postgresql://localhost:5432/my-database?user=postgres&password=postgres"}
I have a separate psql client open to the postgres instance and run select * from pg_stat_database;. The numbackends which are connections to my database goes up by 10 each time I run reset (I have 5 roll backs and 5 migrations so presumably one new connection for each). Running joplin.repl/rollback and joplin.repl/migrate separately correctly closes all connections.
The text was updated successfully, but these errors were encountered:
bmfisher
changed the title
Joplin.repl/reset doesn't close connections
Joplin.repl/reset and Joplin.repl/seed don't close connections
Jul 24, 2020
Using
joplin.repl/reset
to roll back and migrate changes to a postgresql db and it doesn't close the connections it opens. I quickly reach my connection limit and have to force kill my postgres instance.My
joplin.edn
config defines my only database with{:type :sql, :url "jdbc:postgresql://localhost:5432/my-database?user=postgres&password=postgres"}
I have a separate psql client open to the postgres instance and run
select * from pg_stat_database;
. Thenumbackends
which are connections to my database goes up by 10 each time I run reset (I have 5 roll backs and 5 migrations so presumably one new connection for each). Runningjoplin.repl/rollback
andjoplin.repl/migrate
separately correctly closes all connections.The text was updated successfully, but these errors were encountered: