Is there a separate db configuration for the search feature? Because I am using this postgres db for spacewalk and other spacewalk functionality is not impacted as I have 100 clients using this instance.
Thanks. On Thu, Mar 31, 2016 at 12:41 PM, Sorensen, Paul - (p) <[email protected]> wrote: > 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: [email protected] [mailto: > [email protected]] On Behalf Of Jagga > Sent: Thursday, March 31, 2016 11:32 AM > To: Robert Paschedag > Cc: [email protected] > 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 <[email protected]> > 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 <[email protected]>: > >> > >> Hi Guys, > >> > >> Anyone able to help with this? > >> > >> Thanks! > >> > >>> On Tue, Mar 29, 2016 at 11:55 AM, Jagga Soorma <[email protected]> > 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@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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
