[Spacewalk-list] Search feature not working

[Jagga Soorma]

Hi Guys,

Anyone able to help with this?

Thanks!

On Tue, Mar 29, 2016 at 11:55 AM, Jagga Soorma <jagga13 at gmail.com> wrote:

> Hi Guys,
>
> I need to search for a package on spacewalk and I was getting a unable to
> connect to service error message so I manually started the rhn-search
> service which seemed to have died.  Now when I search it does not come up
> with any packages and I see the following message in my
> rhn_search_daemon.log:
>
> (I am using a external postgres db and have been using spacewalk for
> awhile now without any issues, just haven't searched for a package)
>
> --
> INFO   | jvm 1    | 2016/03/29 11:52:54 | Mar 29, 2016 11:52:54 AM
> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
> INFO   | jvm 1    | 2016/03/29 11:52:54 | WARNING:
> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 4dc756a8 --
> 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    | 2016/03/29 11:52:54 |
> 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    | 2016/03/29 11:52:54 |     at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:215)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.jdbc3g.Jdbc3gConnection.<init>(Jdbc3gConnection.java:24)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.Driver.makeConnection(Driver.java:410)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.Driver.connect(Driver.java:280)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)
> INFO   | jvm 1    | 2016/03/29 11:52:54 | Caused by:
> java.net.ConnectException: Connection refused
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> java.net.PlainSocketImpl.socketConnect(Native Method)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> java.net.Socket.connect(Socket.java:579)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.core.PGStream.<init>(PGStream.java:61)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)
> INFO   | jvm 1    | 2016/03/29 11:52:54 |     ... 14 more
> INFO   | jvm 1    | 2016/03/29 11:52:54 |
> --
>
> I see the correct entries for my postgres db in /etc/rhn/rhn.conf.  Am I
> missing something else that needs to be checked or changed when using a
> external postgresdb for rhn-search to work?
>
> Thanks!
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160331/970c6dd5/attachment.htm>