-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Affects Version/s: 1.0.3
-
Component/s: Database Support
I hosted jira and stash toggether and start having the follow error on jira instance when indexing: Caused by: org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (FATAL: connection limit exceeded for non-superusers)
I open an terminal and search in postgresql for connections with the query:
select * from pg_stat_activity ;
The search results in 74 connections refining the search with select * from pg_stat_activity where datname = 'stash' return 64 connection a lot of idle connections is returned, and no one is using the stash instance.
I using stash 1.0.3 with postgresql 8.4 and ubuntu 10.04