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
