Connection pool does not create connections

Dmitrii Apanasevich

Hi!

I have faced with this problem on production server. JIRA becomes unavailable.

Query

select * from pg_stat_activity

returns only one connection.

PostgreSQL 9.2 and JIRA 5.0.4 run on the same server.

My dbconfig:

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>postgres72</database-type>
  <schema-name>public</schema-name>
  <jdbc-datasource>
    <url>jdbc:postgresql://localhost:5432/jiradb</url>
    <driver-class>org.postgresql.Driver</driver-class>
    <username>***</username>
    <password>***</password>
    <pool-size>50</pool-size>
    <validation-query>select version();</validation-query>
    <validation-query-timeout>2</validation-query-timeout>
    <min-evictable-idle-time-millis>10000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>50000</time-between-eviction-runs-millis>

    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>50</pool-remove-abandoned-timeout>
    <pool-test-while-idle>true</pool-test-while-idle>
    <pool-prepared-statements>true</pool-prepared-statements>
  </jdbc-datasource>
</jira-database-config>

There are no exceptions in log file concerned with connection pool.

What is the problem?

I need to decrease some parameter?

Dmitrii Apanasevich

Well, I have found in GC log concurrent mode failure. Also found that at the time the xml-backup service worked.

I turned off this service, as recommended here https://confluence.atlassian.com/display/JIRA/Automating+JIRA+Backups

I will look further.