Hi,
I am trying to install ODK aggregate on MAC OSX 10.6.8
I have created postgres db using generated sql and deployed it on
Tomcat 7.
But ODKAggregate web app fails to start. it gives following error.
org.postgresql.util.PSQLException: FATAL: sorry, too many clients
already
see the log below.
I get the same error when I try to connect odk_prod from terminal when
tomcat is running.
Am I missing any security config? need your help.
Thanks,
Mallik
Nov 18, 2011 8:23:23 PM
org.opendatakit.common.security.spring.RoleHierarchyImpl
refreshReachableGrantedAuthorities
INFO: Executing: refreshReachableGrantedAuthorities
Nov 18, 2011 8:23:23 PM org.slf4j.impl.JCLLoggerAdapter error
SEVERE: Failed to acquire connection. Sleeping for 7000ms. Attempts
left: 5
org.postgresql.util.PSQLException: FATAL: sorry, too many clients
already
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:
291)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:
108)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:
66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:
125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:
30)
at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:
22)
at
org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:
30)
at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:
24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:
256)
at
com.jolbox.bonecp.ConnectionHandle.obtainInternalConnection(ConnectionHandle.java:
211)
at com.jolbox.bonecp.ConnectionHandle.(ConnectionHandle.java:
170)
at com.jolbox.bonecp.BoneCP.(BoneCP.java:371)
at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:
150)
at
com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:
112)
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:
111)
at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:
77)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
572)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:
636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:
665)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:
673)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:
713)
at
org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.updateRelation(DatastoreImpl.java:
308)
at
org.opendatakit.common.persistence.engine.pgres.DatastoreImpl.assertRelation(DatastoreImpl.java:
380)
at
org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.assertRelation(GrantedAuthorityHierarchyTable.java:
115)
at
org.opendatakit.common.security.spring.GrantedAuthorityHierarchyTable.getEntireGrantedAuthorityHierarchy(GrantedAuthorityHierarchyTable.java:
186)
at
org.opendatakit.common.security.spring.RoleHierarchyImpl.buildRolesReachableInOneStepMap(RoleHierarchyImpl.java:
464)
at
org.opendatakit.common.security.spring.RoleHierarchyImpl.refreshReachableGrantedAuthorities(RoleHierarchyImpl.java:
281)
at
org.opendatakit.common.security.spring.RoleHierarchyImpl.afterPropertiesSet(RoleHierarchyImpl.java:
132)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:
1477)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:
1417)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:
519)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:
456)
at org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:291)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:
222)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
288)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
190)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:
580)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:
895)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:
425)
at
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:
276)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:
197)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:
47)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
4723)
at org.apache.catalina.core.StandardContext
$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext
$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor
$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor
$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)