Close db connections when no longer needed

NCEAS / metadig-webapp

Web service for interacting with the MDQ Engine API

1 stars 2 forks source link

Close db connections when no longer needed #12

Closed gothub closed 4 years ago

gothub commented 4 years ago

In order to retrieve assessment reports and graphs, the metadig-webapp creates a metadig-controller instance, which opens the metadig database. These connections are not released when the services are done with them, which is causing pg_bouncer to product the error 'org.postgresql.util.PSQLException: ERROR: query_wait_timeout [edu.ucsb.nceas.mdqengine.store.DatabaseStore'

gothub commented 4 years ago

Fixed in commit 2e71e4c20e53f0258ef86067cba2c08ea98db905