Re: [External] Facing error frequently on tomcat app server

The above logs just shows tomcat has some issue connecting to postgresql
server, but not helpful beyond that.
There may be a few things to check.

i guess the list here is good for reference to check
https://stackoverflow.com/questions/15806083/org-postgresql-util-psqlexception-the-connection-attempt-failed

Also, do you connect to postgresql server directly or via some pooling like
pgbouncer?

Regards,
Vijay

On Mon, Jan 28, 2019 at 1:28 PM lakshmikanth chintakindi <
lakshmikanth_ch(at)optum(dot)com> wrote:

> Hi Team,
>
>
>
> We are facing issue frequently on one of the tomcat app server with the
> below error.
>
> After restarting the JVM the issue will resolves and again it occurs after
> 1-2days.Could you please help on this below postgres error.
>
>
>
> *Db server*
>
> postgres --version
>
> postgres (PostgreSQL) 10.3
>
>
>
> *App Server*
>
> Server version: Apache Tomcat/6.0.29
>
> Server built: July 19 2010 1458
>
> Server number: 6.0.0.29
>
> OS Name: Linux
>
> OS Version: 2.6.32-754.3.5.el6.x86_64
>
> Architecture: amd64
>
> JVM Version: 1.8.0_121-b13
>
> JVM Vendor: Oracle Corporation
>
>
>
>
>
> Jan 26, 2019 3:27:51 AM org.postgresql.Driver connect
>
> SEVERE: Connection error:
>
> org.postgresql.util.PSQLException: The connection attempt failed.
>
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
>
> at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>
> at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
>
> at org.postgresql.Driver.makeConnection(Driver.java:450)
>
> at org.postgresql.Driver.connect(Driver.java:252)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
>
> at com.uhg.ihr.jedi.database.DataSource.<init>(DataSource.java:31)
>
> at
> com.uhg.ihr.jedi.database.SqlDatabase.newDataSource(SqlDatabase.java:400)
>
> at
> com.uhg.ihr.jedi.database.SqlDatabase.<init>(SqlDatabase.java:170)
>
> at
> com.uhg.ihr.jedi.database.postgresql.PostgresqlDatabase.<init>(PostgresqlDatabase.java:99)
>
> at com.uhg.ihr.jedi.database.Database.open(Database.java:145)
>
> at com.uhg.ihr.jedi.database.Database.open(Database.java:157)
>
> at
> com.uhg.ihr.cache.resourcepool.DatabasePool.createResourceImpl(DatabasePool.java:226)
>
> at
> com.uhg.ihr.cache.resourcepool.DatabasePool.createResourceImpl(DatabasePool.java:32)
>
> at
> com.uhg.ihr.cache.resourcepool.ResourcePool.createResource(ResourcePool.java:349)
>
> at
> com.uhg.ihr.cache.resourcepool.ResourcePool.get(ResourcePool.java:217)
>
> at
> com.uhg.ihr.cache.resourcepool.BoundedResourcePool.get(BoundedResourcePool.java:78)
>
> at
> com.uhg.ihr.service.mq.fair.DefaultFairQueueComponentQueue.getFairCount(DefaultFairQueueComponentQueue.java:46)
>
> at
> com.uhg.ihr.service.message.fair.DefaultFairHealthDataMessageQueueService$ComponentQueueMonitorTask.adjustFeederThreadPool(DefaultFairHealthDataMessageQueueService.java:251)
>
> at java.util.ArrayList.forEach(ArrayList.java:1249)
>
> at
> com.uhg.ihr.service.message.fair.DefaultFairHealthDataMessageQueueService$ComponentQueueMonitorTask.run(DefaultFairHealthDataMessageQueueService.java:217)
>
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>
> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
>
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
>
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>
> at java.lang.Thread.run(Thread.java:745)
>
> Caused by: java.io.EOFException
>
> at org.postgresql.core.PGStream.receiveChar(PGStream.java:290)
>
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:418)
>
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
>
> ... 28 more
>
>
>
> Thanks and Regards,
>
> Lakshmikanth.Ch
>
> Mob:- 7044546234
>
>
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity
> to which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
>