Hi all, We are seeing the same issue in our AS cluster based on Carbon 4.3.0. We have a 3 instance cluster with 3 workers + 2 mgt nodes fronted by ELB. And as mentioned in this thread the h2 db url is same in all 3 worker nodes (even though they are in different nodes eg: /home/ubuntu/carbon_test/as/worker/) which seem to result in this issue intermittently.
We need this fixed asap before Carbon 4.3.0 RC release. Can we know the status of the fix? I believe the related JIRA is https://wso2.org/jira/browse/CARBON-14224. Thanks. /Gayashan On Fri, Oct 10, 2014 at 11:50 AM, Shavantha Weerasinghe <[email protected]> wrote: > Hi All > > I came across the same exception while testing an ESB cluster setup with > elb fronting manager and 2 worker nodes > > > [2014-10-10 11:40:40,391] DEBUG - SourceHandler http-incoming-1: Input > ready > [2014-10-10 11:40:40,392] DEBUG - SourceHandler http-incoming-1: Content > decoder [chunk-coded; completed: true] > [2014-10-10 11:40:40,413] DEBUG - ServerWorker Starting a new Server > Worker instance > [2014-10-10 11:40:40,871] ERROR - JDBCResourceDAO Failed to add resource > to path /. Referential integrity constraint violation: > "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, > REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL > statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: > "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, > REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL > statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getRegistry(EmbeddedRegistryService.java:447) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getRegistry(EmbeddedRegistryService.java:464) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.initializeTenant(RegistryCoreServiceComponent.java:271) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.access$200(RegistryCoreServiceComponent.java:83) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent$TenantDeploymentListenerImpl.loadTenantRegistry(RegistryCoreServiceComponent.java:873) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:294) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > [2014-10-10 11:40:40,891] FATAL - UserRegistry Failed to add the root > collection to the coreRegistry. > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to add > resource to path /. Referential integrity constraint violation: > "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, > REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL > statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1410) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getRegistry(EmbeddedRegistryService.java:447) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getRegistry(EmbeddedRegistryService.java:464) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.initializeTenant(RegistryCoreServiceComponent.java:271) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.access$200(RegistryCoreServiceComponent.java:83) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent$TenantDeploymentListenerImpl.loadTenantRegistry(RegistryCoreServiceComponent.java:873) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:294) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > ... 22 more > [2014-10-10 11:40:40,892] ERROR - RegistryCoreServiceComponent Unable to > initialize registry for tenant 1. > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to add > the root collection to the coreRegistry. > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:419) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getRegistry(EmbeddedRegistryService.java:447) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getRegistry(EmbeddedRegistryService.java:464) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.initializeTenant(RegistryCoreServiceComponent.java:271) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent.access$200(RegistryCoreServiceComponent.java:83) > at > org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent$TenantDeploymentListenerImpl.loadTenantRegistry(RegistryCoreServiceComponent.java:873) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:294) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: > Failed to add resource to path /. Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1410) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > ... 20 more > Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > ... 22 more > [2014-10-10 11:40:40,897] ERROR - JDBCResourceDAO Failed to add resource > to path /. Referential integrity constraint violation: > "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, > REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL > statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: > "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, > REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL > statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:292) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getConfigSystemRegistry(EmbeddedRegistryService.java:485) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:297) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > [2014-10-10 11:40:40,897] FATAL - UserRegistry Failed to add the root > collection to the coreRegistry. > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to add > resource to path /. Referential integrity constraint violation: > "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, > REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL > statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1410) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:292) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getConfigSystemRegistry(EmbeddedRegistryService.java:485) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:297) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > ... 19 more > [2014-10-10 11:40:40,899] ERROR - TenantAxisUtils Error occurred while > running deployment for tenant tenant.com > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to add > the root collection to the coreRegistry. > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:419) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:292) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getConfigSystemRegistry(EmbeddedRegistryService.java:485) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:297) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: > Failed to add resource to path /. Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1410) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > ... 17 more > Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > ... 19 more > [2014-10-10 11:40:40,900] ERROR - NativeWorkerPool Uncaught exception > java.lang.RuntimeException: Cannot create tenant ConfigurationContext for > tenant tenant.com > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:137) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:203) > at > org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:79) > at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > at > org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:403) > at > org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) > at > org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) > 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:662) > Caused by: java.lang.Exception: Error occurred while running deployment > for tenant > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:361) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) > ... 9 more > Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: > Failed to add the root collection to the coreRegistry. > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:419) > at > org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) > at > org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:292) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getConfigSystemRegistry(EmbeddedRegistryService.java:485) > at > org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:297) > ... 10 more > Caused by: org.wso2.carbon.registry.core.exceptions.RegistryException: > Failed to add resource to path /. Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1410) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) > at > org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:375) > ... 17 more > Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint > violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN > KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, > REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, > REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, > ?, ?) [23002-140] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:167) > at org.h2.message.DbException.get(DbException.java:144) > at > org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) > at > org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) > at org.h2.table.Table.fireConstraints(Table.java:801) > at org.h2.table.Table.fireAfterRow(Table.java:818) > at org.h2.command.dml.Insert.insertRows(Insert.java:122) > at org.h2.command.dml.Insert.update(Insert.java:82) > at org.h2.command.CommandContainer.update(CommandContainer.java:70) > at org.h2.command.Command.executeUpdate(Command.java:199) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) > ... 19 more > [2014-10-10 11:41:40,452] DEBUG - SourceHandler http-incoming-1: Timeout > [2014-10-10 11:41:40,453] WARN - SourceHandler Connection time out after > request is read: http-incoming-1 > [2014-10-10 11:41:40,453] DEBUG - SourceConnections Shutting down > connection forcefully http-incoming-1 > [2014-10-10 11:41:40,453] DEBUG - LoggingNHttpServerConnection > http-incoming-1: Shutdown connection > [2014-10-10 11:41:40,453] DEBUG - SourceHandler http-incoming-1: Closed > [2014-10-10 11:41:40,454] DEBUG - SourceHandler http-incoming-1: > Keep-Alive connection was closed: http-incoming-1 > [2014-10-10 11:41:40,454] DEBUG - SourceConnections Shutting down > connection forcefully http-incoming-1 > [2014-10-10 11:41:40,454] DEBUG - LoggingNHttpServerConnection > http-incoming-1: Shutdown connection > > > regards, > > Shavantha Weerasinghe > Senior Software Engineer QA > WSO2, Inc. > lean.enterprise.middleware. > http://wso2.com > http://wso2.org > Tel : 94 11 214 5345 > Fax :94 11 2145300 > > > On Mon, Mar 10, 2014 at 12:47 PM, Thilina Piyasundara <[email protected]> > wrote: > >> Hi, >> >> I'm getting this when I try to cluster two wso2 appservers. >> >> Both are on '*/mnt/wso2as-5.2.0*' in two separate virtual servers. >> >> >> >> TID: [0] [AS] [2014-03-09 23:42:58,460] ERROR >> {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO} - Failed to add >> resource to path /. Referential integrity constraint violation: >> "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, >> REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL >> statement: >> INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, >> REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, >> REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?) [23002-140] {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO} >> org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: >> "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, >> REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL >> statement: >> INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, >> REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, >> REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?) [23002-140] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >> at org.h2.message.DbException.get(DbException.java:167) >> at org.h2.message.DbException.get(DbException.java:144) >> at >> org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) >> at >> org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) >> at org.h2.table.Table.fireConstraints(Table.java:801) >> at org.h2.table.Table.fireAfterRow(Table.java:818) >> at org.h2.command.dml.Insert.insertRows(Insert.java:122) >> at org.h2.command.dml.Insert.update(Insert.java:82) >> at org.h2.command.CommandContainer.update(CommandContainer.java:70) >> at org.h2.command.Command.executeUpdate(Command.java:199) >> at >> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) >> at >> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:365) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:292) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getConfigSystemRegistry(EmbeddedRegistryService.java:485) >> at >> org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:295) >> at >> org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) >> at >> org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.setTenantAccessed(TenantAxisUtils.java:161) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.setTenantAccessed(TenantLazyLoaderValve.java:112) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:87) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:724) >> TID: [0] [AS] [2014-03-09 23:42:58,461] FATAL >> {org.wso2.carbon.registry.core.session.UserRegistry} - Failed to add the >> root collection to the coreRegistry. >> {org.wso2.carbon.registry.core.session.UserRegistry} >> org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to add >> resource to path /. Referential integrity constraint violation: >> "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN KEY(REG_PATH_ID, >> REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, REG_TENANT_ID)"; SQL >> statement: >> INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, >> REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, >> REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?) [23002-140] >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1410) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addRoot(JDBCResourceDAO.java:445) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.addRootCollection(UserRegistry.java:365) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:299) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:226) >> at >> org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:205) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getUserRegistry(EmbeddedRegistryService.java:427) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getSystemRegistry(EmbeddedRegistryService.java:292) >> at >> org.wso2.carbon.registry.core.jdbc.EmbeddedRegistryService.getConfigSystemRegistry(EmbeddedRegistryService.java:485) >> at >> org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.createTenantConfigurationContext(TenantAxisUtils.java:295) >> at >> org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.getTenantConfigurationContext(TenantAxisUtils.java:135) >> at >> org.wso2.carbon.core.multitenancy.utils.TenantAxisUtils.setTenantAccessed(TenantAxisUtils.java:161) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.setTenantAccessed(TenantLazyLoaderValve.java:112) >> at >> org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:87) >> at >> org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) >> at >> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >> at >> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:724) >> Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint >> violation: "REG_RESOURCE_FK_BY_PATH_ID: PUBLIC.REG_RESOURCE FOREIGN >> KEY(REG_PATH_ID, REG_TENANT_ID) REFERENCES PUBLIC.REG_PATH(REG_PATH_ID, >> REG_TENANT_ID)"; SQL statement: >> INSERT INTO REG_RESOURCE (REG_PATH_ID, REG_NAME, REG_MEDIA_TYPE, >> REG_CREATOR, REG_CREATED_TIME, REG_LAST_UPDATOR, REG_LAST_UPDATED_TIME, >> REG_DESCRIPTION, REG_TENANT_ID, REG_UUID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, >> ?, ?) [23002-140] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >> at org.h2.message.DbException.get(DbException.java:167) >> at org.h2.message.DbException.get(DbException.java:144) >> at >> org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:329) >> at >> org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:271) >> at org.h2.table.Table.fireConstraints(Table.java:801) >> at org.h2.table.Table.fireAfterRow(Table.java:818) >> at org.h2.command.dml.Insert.insertRows(Insert.java:122) >> at org.h2.command.dml.Insert.update(Insert.java:82) >> at org.h2.command.CommandContainer.update(CommandContainer.java:70) >> at org.h2.command.Command.executeUpdate(Command.java:199) >> at >> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141) >> at >> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127) >> at >> org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addResourceWithoutContentId(JDBCResourceDAO.java:1391) >> ... 26 more >> >> >> >> >> *On both master datasource XML*. >> >> <datasource> >> <name>WSO2_CARBON_DB</name> >> <description>The datasource used for registry and user >> manager</description> >> <jndiConfig> >> <name>jdbc/WSO2CarbonDB</name> >> </jndiConfig> >> <definition type="RDBMS"> >> <configuration> >> >> <url>jdbc:h2:/mnt/wso2as-5.2.0/repository/database/WSO2CARBON_DB;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=60000</url> >> ... >> <datasource> >> <name>WSO2_USERSTORE_DB</name> >> <description>The datasource used for user >> manager</description> >> <jndiConfig> >> <!-- name>jdbc/WSO2AppfacUserDB</name --> >> <name>jdbc/userstore</name> >> </jndiConfig> >> <definition type="RDBMS"> >> <configuration> >> <url>jdbc:mysql:// >> mysql_2.example.com:3306/userstore?autoReconnect=true</url> >> ... >> <datasource> >> <name>WSO2_REGISTRY_DB</name> >> <description>The datasource used for registry</description> >> <jndiConfig> >> <!-- name>jdbc/WSO2AppfacRegDB</name --> >> <name>jdbc/governance</name> >> </jndiConfig> >> <definition type="RDBMS"> >> <configuration> >> <url>jdbc:mysql:// >> mysql_1.example.com:3306/registry?autoReconnect=true</url> >> ... >> <datasource> >> <name>WSO2_APPSERVER_CONFIG_DB</name> >> <description>The datasource used for appserver config >> registry</description> >> <jndiConfig> >> <name>jdbc/appserver_config</name> >> </jndiConfig> >> <definition type="RDBMS"> >> <configuration> >> <url>jdbc:mysql:// >> mysql_1.example.com:3306/appserver_config?autoReconnect=true</url> >> >> >> *On registory.xml.* >> >> <currentDBConfig>wso2registry</currentDBConfig> >> <readOnly>false</readOnly> >> <enableCache>true</enableCache> >> <registryRoot>/</registryRoot> >> >> <dbConfig name="wso2registry"> >> <dataSource>jdbc/WSO2CarbonDB</dataSource> >> </dbConfig> >> >> <handler >> class="org.wso2.carbon.appfactory.registry.handler.ReferenceHandler"> >> <property name="systemVariable">stage</property> >> <filter >> class="org.wso2.carbon.registry.core.jdbc.handlers.filters.URLMatcher"> >> <property >> name="pattern">/_system/governance/.*</property> >> </filter> >> </handler> >> >> >> <dbConfig name="governance"> >> <dataSource>jdbc/governance</dataSource> >> </dbConfig> >> >> <remoteInstance url="https://registryernance.cloud-test.wso2.com";> >> <id>governance</id> >> <dbConfig>governance</dbConfig> >> <readOnly>false</readOnly> >> <registryRoot>/</registryRoot> >> <enableCache>true</enableCache> >> </remoteInstance> >> >> <mount path="/_system/governance" overwrite="true"> >> <instanceId>governance</instanceId> >> <targetPath>/_system/governance</targetPath> >> </mount> >> >> >> <dbConfig name="config"> >> <dataSource>jdbc/appserver_config</dataSource> >> </dbConfig> >> >> <remoteInstance url="https://registryernance.cloud-test.wso2.com";> >> <id>config</id> >> <dbConfig>config</dbConfig> >> <readOnly>false</readOnly> >> <registryRoot>/</registryRoot> >> <enableCache>true</enableCache> >> </remoteInstance> >> >> <mount path="/_system/config" overwrite="true"> >> <instanceId>config</instanceId> >> <targetPath>/_system/appserver_config</targetPath> >> </mount> >> >> >> >> Thanks and regards, >> >> Thilina Piyasundara >> Systems Engineer >> >> (DevOps) >> M: 071-775-0006 >> >> >> Blog: blog.thilina.org >> >> WSO2, Inc. >> >> <http://wso2.com/> >> lean . enterprise . middleware >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Gayashan Amarasinghe* Software Engineer | Platform TG WSO2, Inc. | http://wso2.com lean. enterprise. middleware Mobile : +94718314517 Blog : gayashan-a.blogspot.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
