BUG #12810: database conection drop - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      12810
Logged by:          gowridhar
Email address:      gowridhar.madu@firstdata.com
PostgreSQL version: 9.3.5
Operating system:   SUSE Linux
Description:

i have running gerrit code review tool using postgres backend. I see in
tomcat logs database connection dropping. even increased pool connections
and no luck.
all postgres and git and gerrit on same box.

[2015-02-26 08:21:31,061] ERROR com.google.gerrit.sshd.BaseCommand :
Internal server error (user rveerama account 1000047) during git-upload-pack
'/FIRSTAPI_APP'
com.google.inject.ProvisionException: Guice provision errors:

1) Cannot open ReviewDb
  at
com.google.gerrit.server.util.ThreadLocalRequestContext$1.provideReviewDb(ThreadLocalRequestContext.java:70)
  while locating com.google.gerrit.reviewdb.server.ReviewDb

1 error
    at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:1014)
    at com.google.gerrit.sshd.commands.Upload.runImpl(Upload.java:52)
    at
com.google.gerrit.sshd.AbstractGitCommand.service(AbstractGitCommand.java:101)
    at
com.google.gerrit.sshd.AbstractGitCommand.access$000(AbstractGitCommand.java:32)
    at
com.google.gerrit.sshd.AbstractGitCommand$1.run(AbstractGitCommand.java:70)
    at com.google.gerrit.sshd.BaseCommand$TaskThunk.run(BaseCommand.java:442)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
    at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
    at com.google.gerrit.server.git.WorkQueue$Task.run(WorkQueue.java:364)
    at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.google.gwtorm.server.OrmException: Cannot open database
connection
    at com.google.gwtorm.jdbc.Database.newConnection(Database.java:130)
    at com.google.gwtorm.jdbc.JdbcSchema.<init>(JdbcSchema.java:40)
    at
com.google.gerrit.reviewdb.server.ReviewDb_Schema_GwtOrm$$22.<init>(Unknown
Source)
    at
com.google.gerrit.reviewdb.server.ReviewDb_Schema_GwtOrm$$22_Factory_GwtOrm$$23.open(Unknown
Source)
    at com.google.gwtorm.jdbc.Database.open(Database.java:122)
    at
com.google.gerrit.server.config.RequestScopedReviewDbProvider.get(RequestScopedReviewDbProvider.java:45)
    at
com.google.gerrit.server.config.RequestScopedReviewDbProvider.get(RequestScopedReviewDbProvider.java:27)
    at
com.google.gerrit.server.util.ThreadLocalRequestContext$1.provideReviewDb(ThreadLocalRequestContext.java:70)
    at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.google.inject.internal.ProviderMethod.get(ProviderMethod.java:105)
    at
com.google.inject.internal.ProviderInternalFactory.provision(ProviderInternalFactory.java:86)
    at

com.google.inject.internal.InternalFactoryToInitializableAdapter.provision(InternalFactoryToInitializableAdapter.java:55)
    at
com.google.inject.internal.ProviderInternalFactory.circularGet(ProviderInternalFactory.java:66)
    at
com.google.inject.internal.InternalFactoryToInitializableAdapter.get(InternalFactoryToInitializableAdapter.java:47)
    at
com.google.inject.internal.InjectorImpl$3$1.call(InjectorImpl.java:1005)
    at
com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1051)
    at com.google.inject.internal.InjectorImpl$3.get(InjectorImpl.java:1001)
    ... 13 more
Caused by: java.sql.SQLException: Cannot get a connection, general error
    at
org.apache.tomcat.dbcp.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:130)
    at
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
    at com.google.gwtorm.jdbc.Database.newConnection(Database.java:128)
    ... 31 more
Caused by: java.lang.InterruptedException
    at

java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2017)
    at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2052)
    at
org.apache.tomcat.dbcp.pool2.impl.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:523)
    at
org.apache.tomcat.dbcp.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435)
    at
org.apache.tomcat.dbcp.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:358)
    at
org.apache.tomcat.dbcp.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:118)
    ... 33 more