Hi Jason, some questions:
- Have you scheduled nightly data mart process? - Are you running multiple dhis instances on the same database server? - What is your current max_connections setting in postgresql.conf? Lars On Wed, Apr 9, 2014 at 2:02 PM, Jason Phillips <[email protected]> wrote: > Hi all, > > > > Our Db Server / Postgresql appears to be having connection slot issues - a > catalina log extract example below: > > > > WARN 2014-04-09 11:43:34,299 > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@7127652d -- > 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: (BasicResourcePool.java > [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0]) > > org.postgresql.util.PSQLException: FATAL: remaining connection slots are > reserved for non-replication superuser connections > > at > org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:471) > > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112) > > at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) > > at > org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) > > at > org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) > > at > org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) > > at > org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) > > at > org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) > > at org.postgresql.Driver.makeConnection(Driver.java:393) > > at org.postgresql.Driver.connect(Driver.java:267) > > at > com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) > > at > com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) > > at > com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) > > at > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) > > at > com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) > > at > com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) > > at > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) > > > > > > Is the solution just as simple as increasing the number of max slots, > along with the shmmax? > > Has anyone else had this sort of config issue, and if so, are there any > stats to be used as guideline for the number of connections generated by a > set number of users in DHIS2? i.e. how does one plan for this sort of > thing? > > > > Kind regards, > > > > *Jason Phillips* > > > > [image: Description: cid:[email protected]] > > Software & Information Systems > > *Health Information Systems Programme* > > ----------------------------------------------------- > Email: [email protected] > > Mobile : 072 9737250 > Landline: 021 7120170 > Fax: 021 7120170 > Skype: jason.n.phillips > > > > This message may contain privileged and confidential information intended > only for the person or entity to which it is addressed. Any review, > retransmission, dissemination, copy or other use of, or taking of any > action in reliance upon this information by persons or entities other than > the intended recipient, is prohibited. If you received this message in > error, please notify the sender immediately by e-mail, facsimile or > telephone and thereafter delete the material from any computer. Any views > expressed in this message are those of the individual sender, except where > the sender specifically states them to be the view of the entity > transmitting the message. > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
<<inline: image001.png>>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
