Hi Evanthika, As long as your local DB is running it should not be an issue I believe. Does this happen always or just once? Also, was this the only SQL exception that you got?
Thanks, Senaka. On Wed, Apr 4, 2012 at 2:02 PM, Evanthika Amarasiri <[email protected]>wrote: > I have pointed all DBs to mySQL. The configuration files are attached to > the JIRA. > > Regards, > Evanthika > > > > On Wed, Apr 4, 2012 at 1:58 PM, Sumedha Rubasinghe <[email protected]>wrote: > >> Were you pointing to an outside database or using the embedded one? >> >> >> On Wed, Apr 4, 2012 at 1:53 PM, Evanthika Amarasiri >> <[email protected]>wrote: >> >>> Hi all, >>> >>> I came across [1], while setting up a registry mount with latest WSO2 >>> ESB. The configuration files used (in both ESB and G-Reg instances) are >>> attached to the JIRA. >>> >>> [1] - https://wso2.org/jira/browse/CARBON-12819 >>> * >>> *[2012-04-04 12:13:55,518] ERROR - JDBCResourceDAO Failed to get child >>> paths of /_system/governance/permission/admin/manage. Cannot get a >>> connection, pool error Timeout waiting for idle object >>> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, >>> pool error Timeout waiting for idle object >>> at >>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) >>> >>> at >>> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillChildren(JDBCResourceDAO.java:766) >>> >>> at >>> org.wso2.carbon.registry.core.CollectionImpl.getContent(CollectionImpl.java:297) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.get(MountHandler.java:386) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.get(HandlerManager.java:2444) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.get(UserDefinedHandlerManager.java:200) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.get(HandlerLifecycleManager.java:959) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.get(EmbeddedRegistry.java:512) >>> >>> at >>> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.get(CacheBackedRegistry.java:133) >>> >>> at >>> org.wso2.carbon.registry.core.session.UserRegistry.get(UserRegistry.java:514) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.addPermissions(UserMgtInitializer.java:68) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.start(UserMgtInitializer.java:43) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtDSComponent.activate(UserMgtDSComponent.java:49) >>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> >>> at java.lang.reflect.Method.invoke(Method.java:601) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:252) >>> >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >>> >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:346) >>> >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:588) >>> >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:196) >>> >>> at >>> org.eclipse.equinox.internal.ds.Resolver.buildNewlySatisfied(Resolver.java:441) >>> >>> at >>> org.eclipse.equinox.internal.ds.Resolver.enableComponents(Resolver.java:213) >>> >>> at >>> org.eclipse.equinox.internal.ds.SCRManager.performWork(SCRManager.java:800) >>> at >>> org.eclipse.equinox.internal.ds.SCRManager$QueuedJob.dispatch(SCRManager.java:767) >>> >>> at org.eclipse.equinox.internal.ds.WorkThread.run(WorkThread.java:89) >>> at >>> org.eclipse.equinox.internal.util.impl.tpt.threadpool.Executor.run(Executor.java:70) >>> >>> Caused by: java.util.NoSuchElementException: Timeout waiting for idle >>> object >>> at >>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1167) >>> >>> at >>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) >>> >>> ... 28 more >>> [2012-04-04 12:13:55,529] ERROR - UserMgtInitializer While adding >>> management permission :: Resource does not exist at path >>> /_system/governance/permission/admin/manage >>> org.wso2.carbon.registry.core.exceptions.ResourceNotFoundException: >>> Resource does not exist at path /_system/governance/permission/admin/manage >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.get(MountHandler.java:437) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.get(HandlerManager.java:2444) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.get(UserDefinedHandlerManager.java:200) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.get(HandlerLifecycleManager.java:959) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.get(EmbeddedRegistry.java:512) >>> >>> at >>> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.get(CacheBackedRegistry.java:133) >>> >>> at >>> org.wso2.carbon.registry.core.session.UserRegistry.get(UserRegistry.java:514) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.addPermissions(UserMgtInitializer.java:68) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.start(UserMgtInitializer.java:43) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtDSComponent.activate(UserMgtDSComponent.java:49) >>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> >>> at java.lang.reflect.Method.invoke(Method.java:601) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:252) >>> >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >>> >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:346) >>> >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:588) >>> >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:196) >>> >>> at >>> org.eclipse.equinox.internal.ds.Resolver.buildNewlySatisfied(Resolver.java:441) >>> >>> at >>> org.eclipse.equinox.internal.ds.Resolver.enableComponents(Resolver.java:213) >>> >>> at >>> org.eclipse.equinox.internal.ds.SCRManager.performWork(SCRManager.java:800) >>> at >>> org.eclipse.equinox.internal.ds.SCRManager$QueuedJob.dispatch(SCRManager.java:767) >>> >>> at org.eclipse.equinox.internal.ds.WorkThread.run(WorkThread.java:89) >>> at >>> org.eclipse.equinox.internal.util.impl.tpt.threadpool.Executor.run(Executor.java:70) >>> >>> Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: >>> Failed to get child paths of /_system/governance/permission/admin/manage. >>> Cannot get a connection, pool error Timeout waiting for idle object >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillChildren(JDBCResourceDAO.java:790) >>> >>> at >>> org.wso2.carbon.registry.core.CollectionImpl.getContent(CollectionImpl.java:297) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.get(MountHandler.java:386) >>> >>> ... 24 more >>> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a >>> connection, pool error Timeout waiting for idle object >>> at >>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) >>> >>> at >>> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillChildren(JDBCResourceDAO.java:766) >>> >>> ... 26 more >>> Caused by: java.util.NoSuchElementException: Timeout waiting for idle >>> object >>> at >>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1167) >>> >>> at >>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) >>> >>> ... 28 more >>> [2012-04-04 12:13:55,530] ERROR - UserMgtDSComponent While adding >>> management permission :: Resource does not exist at path >>> /_system/governance/permission/admin/manage >>> java.lang.Exception: While adding management permission :: Resource does >>> not exist at path /_system/governance/permission/admin/manage >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.addPermissions(UserMgtInitializer.java:94) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.start(UserMgtInitializer.java:43) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtDSComponent.activate(UserMgtDSComponent.java:49) >>> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>> >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> >>> at java.lang.reflect.Method.invoke(Method.java:601) >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:252) >>> >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) >>> >>> at >>> org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:346) >>> >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:588) >>> >>> at >>> org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:196) >>> >>> at >>> org.eclipse.equinox.internal.ds.Resolver.buildNewlySatisfied(Resolver.java:441) >>> >>> at >>> org.eclipse.equinox.internal.ds.Resolver.enableComponents(Resolver.java:213) >>> >>> at >>> org.eclipse.equinox.internal.ds.SCRManager.performWork(SCRManager.java:800) >>> at >>> org.eclipse.equinox.internal.ds.SCRManager$QueuedJob.dispatch(SCRManager.java:767) >>> >>> at org.eclipse.equinox.internal.ds.WorkThread.run(WorkThread.java:89) >>> at >>> org.eclipse.equinox.internal.util.impl.tpt.threadpool.Executor.run(Executor.java:70) >>> >>> Caused by: >>> org.wso2.carbon.registry.core.exceptions.ResourceNotFoundException: >>> Resource does not exist at path /_system/governance/permission/admin/manage >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.get(MountHandler.java:437) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.get(HandlerManager.java:2444) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.get(UserDefinedHandlerManager.java:200) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.get(HandlerLifecycleManager.java:959) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.get(EmbeddedRegistry.java:512) >>> >>> at >>> org.wso2.carbon.registry.core.caching.CacheBackedRegistry.get(CacheBackedRegistry.java:133) >>> >>> at >>> org.wso2.carbon.registry.core.session.UserRegistry.get(UserRegistry.java:514) >>> >>> at >>> org.wso2.carbon.user.mgt.internal.UserMgtInitializer.addPermissions(UserMgtInitializer.java:68) >>> >>> ... 17 more >>> Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: >>> Failed to get child paths of /_system/governance/permission/admin/manage. >>> Cannot get a connection, pool error Timeout waiting for idle object >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillChildren(JDBCResourceDAO.java:790) >>> >>> at >>> org.wso2.carbon.registry.core.CollectionImpl.getContent(CollectionImpl.java:297) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.get(MountHandler.java:386) >>> >>> ... 24 more >>> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a >>> connection, pool error Timeout waiting for idle object >>> at >>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) >>> >>> at >>> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) >>> >>> at >>> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.fillChildren(JDBCResourceDAO.java:766) >>> >>> ... 26 more >>> Caused by: java.util.NoSuchElementException: Timeout waiting for idle >>> object >>> at >>> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1167) >>> >>> at >>> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) >>> >>> * >>> >>> >>> Evanthika Amarasiri* >>> Technical Lead - *Quality Assurance* >>> Member, Management Committee - *Platform Technologies* >>> E-mail: *evanthika AT **wso2.com* >>> >>> Mobile: *+94773125935* >>> Linked-In: *http://lk.linkedin.com/in/evanthika* >>> Blog: *http://evanthika.blogspot.com/* >>> >>> wso2.com *Lean Enterprise Middleware* >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> /sumedha >> +94 773017743 >> > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Senaka Fernando* Product Manager - WSO2 Governance Registry; Associate Technical Lead; WSO2 Inc.; http://wso2.com* Member; Apache Software Foundation; http://apache.org E-mail: senaka AT wso2.com **P: +1 408 754 7388; ext: 51736*; *M: +94 77 322 1818 Linked-In: http://linkedin.com/in/senakafernando *Lean . Enterprise . Middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
