[Spacewalk-list] Search feature not working
Sorensen, Paul - (p)
pauls at telenav.com
Thu Mar 31 19:41:06 UTC 2016
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.
Postgres connection refused - this would be your primary issue.
-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jagga
Sent: Thursday, March 31, 2016 11:32 AM
To: Robert Paschedag
Cc: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Search feature not working
Definitely not. I have a hunch that this never worked since we moved our Postgres db to a external server.
Thanks.
> On Mar 31, 2016, at 11:17 AM, Robert Paschedag <robert.paschedag at web.de> wrote:
>
> Is there a maximum number of connections reached while trying to access the external database?
>
> Regards
> Robert
> Am 31.03.2016 19:24 schrieb Jagga Soorma <jagga13 at gmail.com>:
>>
>> 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!
>>
>>
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list