Hi, I did testing on inbound in tenant mode and experience the following error.
Setup: Manager and two worker nodes. Mounted registry and using mysql. Steps done. 1) Create tenant in management node. 2) Login as tenant. 3) Create an inbound for tenant. 4) Will get the following error in worker nodes. Reason for the this :- When inbound is created it'll create a task that loads the tenant. Following error happens when loading tenants initially. Any idea? [2015-04-09 22:58:02,054] ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance. 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.add(JDBCResourceDAO.java:454) at org.wso2.carbon.registry.core.jdbc.Repository.add(Repository.java:1059) at org.wso2.carbon.registry.core.jdbc.Repository.put(Repository.java:305) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:709) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:508) at org.wso2.carbon.registry.core.utils.RegistryUtils.addBaseCollectionStructure(RegistryUtils.java:724) at org.wso2.carbon.registry.core.session.UserRegistry.addSystemCollections(UserRegistry.java:356) at org.wso2.carbon.registry.core.session.UserRegistry.init(UserRegistry.java:330) at org.wso2.carbon.registry.core.session.UserRegistry.access$100(UserRegistry.java:60) at org.wso2.carbon.registry.core.session.UserRegistry$2.run(UserRegistry.java:248) at java.security.AccessController.doPrivileged(Native Method) at org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:245) at org.wso2.carbon.registry.core.session.UserRegistry.<init>(UserRegistry.java:224) 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.utils.RegistryUtils.initializeTenant(RegistryUtils.java:1152) at org.wso2.carbon.registry.core.internal.RegistryCoreServiceComponent$TenantDeploymentListenerImpl.loadTenantRegistry(RegistryCoreServiceComponent.java:866) 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.mediation.ntask.internal.NtaskService.loadTenant(NtaskService.java:161) at org.wso2.carbon.mediation.ntask.NTaskAdapter.checkLoadTenant(NTaskAdapter.java:87) at org.wso2.carbon.mediation.ntask.NTaskAdapter.init(NTaskAdapter.java:59) at org.wso2.carbon.ntask.core.impl.TaskQuartzJobAdapter.execute(TaskQuartzJobAdapter.java:66) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) 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:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) Best Regards, Malaka Silva Senior Tech Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/ http://www.wso2.com/about/team/malaka-silva/ <http://wso2.com/about/team/malaka-silva/> Save a tree -Conserve nature & Save the world for your future. Print this email only if it is absolutely necessary.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
