BUG #12810: database conection drop

From: gowridhar(dot)madu(at)firstdata(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12810: database conection drop
Date: 2015-02-26 18:17:19
Message-ID: 20150226181719.2527.84633@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12810
Logged by: gowridhar
Email address: gowridhar(dot)madu(at)firstdata(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message william.welter 2015-02-27 02:00:29 Re: BUG #12799: libpq - SSL pqsecure_read() doesn't clean openssl error queue before reading
Previous Message rmelendo 2015-02-26 16:29:25 BUG #12808: BDR lock adding Postgis extension in one node