org.postgresql.util.PSQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Spring JPA cannot connect to Postgresql
    via Stack Overflow by Charbel
    ,
  • Our database had some connectivity problems but was recovered within a few minutes. In the PuppetDB logs I saw: 2015-02-25 20:11:02,872 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 5. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:11,890 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 4. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:20,908 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 3. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:29,926 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 2. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:38,944 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 1. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:45,945 ERROR [c.j.b.ConnectionHandle] Database access problem. Killing off all remaining connections in the connection pool. SQL State = 08001 2015-02-25 20:11:45,945 ERROR [c.j.b.PoolWatchThread] Error in trying to obtain a connection. Retrying in 7000ms org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) ~[puppetdb.jar:na] etc.. As the database recovered, it seemed that PuppetDB recovered without intervention. This was not the case. The KahaDB grew unbounded and facts were not being recorded in PuppetDB. I had to follow the steps in https://docs.puppetlabs.com/puppetdb/latest/trouble_kahadb_corruption.html to recover. Can we ensure that PuppetDB recovers completely with KahaDB when a reconnection happens? If not, I would rather much have PuppetDB detect failures with its use of KahaDB and stop its own process and fail hard rather giving the impression that nothing is wrong until we notice either our disk space is filling up and/or our updates to puppet facts arent being taken. Thanks.
    via by Brian Wong,
  • vRealize Operations Manager 6.0.3 Release Notes
    via by Unknown author,
  • Our database had some connectivity problems but was recovered within a few minutes. In the PuppetDB logs I saw: 2015-02-25 20:11:02,872 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 5. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:11,890 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 4. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:20,908 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 3. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:29,926 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 2. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:38,944 ERROR [c.j.b.h.AbstractConnectionHook] Failed to acquire connection Sleeping for 7000ms and trying again. Attempts left: 1. Exception: java.net.NoRouteToHostException: No route to host 2015-02-25 20:11:45,945 ERROR [c.j.b.ConnectionHandle] Database access problem. Killing off all remaining connections in the connection pool. SQL State = 08001 2015-02-25 20:11:45,945 ERROR [c.j.b.PoolWatchThread] Error in trying to obtain a connection. Retrying in 7000ms org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:225) ~[puppetdb.jar:na] etc.. As the database recovered, it seemed that PuppetDB recovered without intervention. This was not the case. The KahaDB grew unbounded and facts were not being recorded in PuppetDB. I had to follow the steps in https://docs.puppetlabs.com/puppetdb/latest/trouble_kahadb_corruption.html to recover. Can we ensure that PuppetDB recovers completely with KahaDB when a reconnection happens? If not, I would rather much have PuppetDB detect failures with its use of KahaDB and stop its own process and fail hard rather giving the impression that nothing is wrong until we notice either our disk space is filling up and/or our updates to puppet facts arent being taken. Thanks.
    via by Brian Wong,
  • GitHub comment 1184#257761480
    via GitHub by terry19850829
    ,
  • GitHub comment 8#57614329
    via GitHub by jangithub
    ,
    • org.postgresql.util.PSQLException: FATAL: password authentication failed for user "test_java " at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:446)[postgresql-9.4.1211.jre7.jar:9.4.1211.jre7] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:220)[postgresql-9.4.1211.jre7.jar:9.4.1211.jre7]

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    guizmaii
    480 times, last one,
    johnxfly
    4 times, last one,
    iferca
    10 times, last one,
    22 more bugmates