[Spacewalk-list] rhn-search fails connection to PostgreSQL POST 2.1 upgrade

[Jeremy Davis]

Hello List,

I have a Spacewalk 2.1 installation that was just upgraded from 2.0 that
rhn-search fails to start after the upgrade. I get the following error in
the logs. Any ideas as to what could be the issue? rhn-search is running on
the same server as tomcat and taskomatic and everything seems to be working
fine with those services connecting to our external PostgreSQL database.
This is a clean install of 2.0 that was upgraded to 2.1. Everything was
working before the upgrade. No errors were seen during the upgarde process
everything went really well. Maybe a little too well as it was really fast!
:)

INFO   | jvm 1    | 2014/03/07 14:39:34 | WARNING:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 5ff54855 --
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to
acquire a needed new resource, we failed to succeed more than the maximum
number of allowed acquisition attempts (30). Last acquisition attempt
exception:
INFO   | jvm 1    | 2014/03/07 14:39:34 |
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting TCP/IP
connections.
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.Driver.makeConnection(Driver.java:410)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.Driver.connect(Driver.java:280)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
INFO   | jvm 1    | 2014/03/07 14:39:34 | Caused by:
java.net.ConnectException: Connection refused
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.PlainSocketImpl.socketConnect(Native Method)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:385)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.Socket.connect(Socket.java:546)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
java.net.Socket.connect(Socket.java:495)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.core.PGStream.<init>(PGStream.java:60)
INFO   | jvm 1    | 2014/03/07 14:39:34 | at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101)
INFO   | jvm 1    | 2014/03/07 14:39:34 | ... 15 more
INFO   | jvm 1    | 2014/03/07 14:39:34 | Mar 7, 2014 2:39:34 PM
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run

Thank you for your time and have a great day!

Regards,
Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140307/997bb208/attachment.htm>