Too many database connections

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 1.1
    • 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

            Assignee:
            Bryan Turner (Inactive)
            Reporter:
            Giovanni Silva
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: