We have missed this email. Sorry about it. We will provide logs tomorrow after trying out the scenario once again.
Regards, Evanthika Amarasiri Senior Technical Lead - Quality Assurance Mobile: +94773125935 Blog: evanthika.blogspot.com wso2.com lean.enterprise.middleware On Wed, Aug 12, 2015 at 7:55 PM, KasunG Gajasinghe <[email protected]> wrote: > Hi, > > Did we get these logs? We'd like to have a look at it. > > Thanks > > On Thu, Jun 18, 2015 at 6:21 AM, Evanthika Amarasiri <[email protected]> > wrote: > >> Hello Senaka, >> >> On Thursday, June 18, 2015, Senaka Fernando <[email protected]> wrote: >> >>> Hi Evanthika, >>> >>> Oh! after all these years, :). I believe we can forget about this and >>> you'll not get it for the next 2 years? :). >>> >>> I doubt it :) >> >> >>> Anyway lets see what can be done here. Can you'll please do a favor? Can >>> you'll turn on the JDBC logs (with the log4jdbc driver) and then share >>> those log files please? As Sumedha said last, we'll need to see what gets >>> passed onto the DB when this happens and logs can give a lot of insight. >>> >> Sure. We'll do that and share the logs with you. >> >> Regards, >> Evanthika >> >> >>> Thanks, >>> Senaka. >>> >>> On Wed, Jun 17, 2015 at 7:11 PM, Evanthika Amarasiri <[email protected] >>> > wrote: >>> >>>> Observed the same issue with AM 1.9.0 packs today when the local DBs >>>> were pointed to H2 (with absolute paths). Any reason why this is happening? >>>> >>>> Regards, >>>> Evanthika >>>> >>>> On Wed, Jun 17, 2015 at 3:41 PM, Asanthi Kulasinghe <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> The same error could be reproduced on the ESB 4.9.0 Test setup (1 >>>>> Manager and 2 worker nodes fronted by Nginx, DB - Oracle ) when invoking a >>>>> proxy service. >>>>> >>>>> When the issue was reproduced >>>>> 1. The local registry was pointed to the default H2 DB >>>>> 2. Database URL was defined with the absolute path as suggested under >>>>> [1] >>>>> >>>>> Could get rid of the error by pointing the local registry to an Oracle >>>>> DB as suggested in this thread >>>>> >>>>> >>>>> [1] https://wso2.org/jira/browse/CARBON-14224 >>>>> >>>>> On Wed, Jun 17, 2015 at 3:23 PM, Evanthika Amarasiri < >>>>> [email protected]> wrote: >>>>> >>>>>> >>>>>> Regards, >>>>>> Evanthika Amarasiri >>>>>> Senior Technical Lead - Quality Assurance >>>>>> Mobile: +94773125935 >>>>>> Blog: evanthika.blogspot.com >>>>>> >>>>>> wso2.com lean.enterprise.middleware >>>>>> >>>>>> ---------- Forwarded message ---------- >>>>>> From: Senaka Fernando <[email protected]> >>>>>> Date: Tue, Sep 10, 2013 at 4:25 PM >>>>>> Subject: Re: [Dev] Getting a Constraint Violation Exception when >>>>>> invoking an API in the gateway worker >>>>>> To: Sumedha Rubasinghe <[email protected]> >>>>>> Cc: Evanthika Amarasiri <[email protected]>, WSO2 Developers' List < >>>>>> [email protected]> >>>>>> >>>>>> >>>>>> Hi Sumedha, >>>>>> >>>>>> Yes, but why would this work on one DB and not on another? That's >>>>>> what's puzzling. >>>>>> >>>>>> Thanks, >>>>>> Senaka. >>>>>> >>>>>> >>>>>> On Tue, Sep 10, 2013 at 10:16 AM, Sumedha Rubasinghe < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> We should take a look @ data going into the insert & decide if those >>>>>>> actually violate 'REG_RESOURCE_FK_BY_PATH_ID' constraint. >>>>>>> >>>>>>> >>>>>>> On Mon, Sep 9, 2013 at 10:39 PM, Senaka Fernando <[email protected]> >>>>>>> wrote: >>>>>>> >>>>>>>> Hi all, >>>>>>>> >>>>>>>> Now that's a convincing issue as to H2 not having proper stability. >>>>>>>> If this is consistently reproducible, we should probably get in contact >>>>>>>> with the H2 folks and get their feedback and see how to resolve this, >>>>>>>> but >>>>>>>> we should also make it a point to update the production guidelines. >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Senaka. >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Sep 9, 2013 at 10:25 AM, Evanthika Amarasiri < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> We've seen this as well with H2. See [1]. Once we moved to mySQL, >>>>>>>>> we did not encounter the same. >>>>>>>>> >>>>>>>>> [1] - https://wso2.org/jira/browse/CARBON-14224 >>>>>>>>> >>>>>>>>> Evanthika Amarasiri >>>>>>>>> Senior Technical Lead - Quality Assurance >>>>>>>>> Mobile: +94773125935 >>>>>>>>> >>>>>>>>> wso2.com Lean Enterprise Middleware >>>>>>>>> >>>>>>>>> >>>>>>>>> On Sun, Sep 8, 2013 at 11:44 PM, Senaka Fernando <[email protected]> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi Shelan, Amila, >>>>>>>>>> >>>>>>>>>> Well it might be H2, but it also might be the sequence of steps >>>>>>>>>> that lead to this. We probably can ensure all DBs are cleaned or try >>>>>>>>>> the >>>>>>>>>> same in a similar setup with no data in any DB (UM, Remote Registry >>>>>>>>>> DB and >>>>>>>>>> Local Registry DB). >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>> Senaka. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Sun, Sep 8, 2013 at 9:58 PM, Shelan Perera <[email protected]> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> Hi Amila, >>>>>>>>>>> >>>>>>>>>>> Could you please try using mysql database (another database) >>>>>>>>>>> replacing H2 and try. We have seen this behavior with H2 database >>>>>>>>>>> in some >>>>>>>>>>> setups and did not appear when moved to mysql. (So we can be sure >>>>>>>>>>> that this >>>>>>>>>>> is not a problem of H2) >>>>>>>>>>> >>>>>>>>>>> Thanks >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Sun, Sep 8, 2013 at 8:57 PM, Amila De Silva <[email protected]> >>>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Sun, Sep 8, 2013 at 7:44 PM, Senaka Fernando < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi Amila, >>>>>>>>>>>>> >>>>>>>>>>>>> Configuration looks good. Got a few questions regarding the >>>>>>>>>>>>> worker's setup. >>>>>>>>>>>>> >>>>>>>>>>>>> 1. Did you first create the tenant on the manager and then >>>>>>>>>>>>> setup the worker? >>>>>>>>>>>>> >>>>>>>>>>>> Tenant was created after setting up both the worker and >>>>>>>>>>>> manager. However the tenant was created in the key manager, which >>>>>>>>>>>> also have >>>>>>>>>>>> the same mounting configs. >>>>>>>>>>>> >>>>>>>>>>>>> 2. Did you take a copy of the manager's DB and setup the >>>>>>>>>>>>> worker (for the local H2 database)? >>>>>>>>>>>>> >>>>>>>>>>>> A fresh APIM pack was used for creating the worker. The first >>>>>>>>>>>> few times this error was encountered, the local H2 db was deleted >>>>>>>>>>>> and >>>>>>>>>>>> re-created. >>>>>>>>>>>> >>>>>>>>>>>>> 3. Was the config/governance registry Database previously or >>>>>>>>>>>>> parallely used for some other deployment? >>>>>>>>>>>>> >>>>>>>>>>>> These databases are exclusively used this particular setup. >>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>>> Also, please look into what Sumedha is mentioning. >>>>>>>>>>>>> >>>>>>>>>>>>> Thanks, >>>>>>>>>>>>> Senaka. >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Sun, Sep 8, 2013 at 10:11 AM, Amila De Silva < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi Senaka, >>>>>>>>>>>>>> Mounts were created for both Config and Governance spaces. I >>>>>>>>>>>>>> have attached the configurations files of the failing node. >>>>>>>>>>>>>> >>>>>>>>>>>>>> AmilaD >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Sat, Sep 7, 2013 at 10:07 PM, Senaka Fernando < >>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi Amila, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> This is most probably a result of improper mounting >>>>>>>>>>>>>>> configurations. Can you please explain how the mounts were >>>>>>>>>>>>>>> setup and how >>>>>>>>>>>>>>> the registry databases were configured? >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thanks, >>>>>>>>>>>>>>> Senaka. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Sat, Sep 7, 2013 at 12:40 AM, Amila De Silva < >>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>> I'm getting the following exception when invoking an API in >>>>>>>>>>>>>>>> a distributed APIM setup. In the deployment, we have two >>>>>>>>>>>>>>>> gateway nodes, one >>>>>>>>>>>>>>>> serving as a manager and the other as the worker. Published >>>>>>>>>>>>>>>> APIs are first >>>>>>>>>>>>>>>> deployed on the manager node and then propagated to the worker >>>>>>>>>>>>>>>> node >>>>>>>>>>>>>>>> through the svn deployment synchronizer. >>>>>>>>>>>>>>>> This was only observed when invoking an API created by a >>>>>>>>>>>>>>>> tenant. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> [2013-09-06 18:41:29,653] 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: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.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:196) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:77) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:337) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:378) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:184) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >>>>>>>>>>>>>>>> Source) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >>>>>>>>>>>>>>>> Source) >>>>>>>>>>>>>>>> at java.lang.Thread.run(Unknown Source) >>>>>>>>>>>>>>>> [2013-09-06 18:41:29,656] 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: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.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:196) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:77) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:337) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:378) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:184) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >>>>>>>>>>>>>>>> Source) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >>>>>>>>>>>>>>>> Source) >>>>>>>>>>>>>>>> at java.lang.Thread.run(Unknown Source) >>>>>>>>>>>>>>>> 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) >>>>>>>>>>>>>>>> ... 20 more >>>>>>>>>>>>>>>> [2013-09-06 18:41:29,657] ERROR - TenantAxisUtils Error >>>>>>>>>>>>>>>> occurred while running deployment for tenant foo1.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:399) >>>>>>>>>>>>>>>> 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.MultitenantMessageReceiver.processRequest(MultitenantMessageReceiver.java:196) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.wso2.carbon.core.multitenancy.MultitenantMessageReceiver.receive(MultitenantMessageReceiver.java:77) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processNonEntityEnclosingRESTHandler(ServerWorker.java:337) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:378) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:184) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown >>>>>>>>>>>>>>>> Source) >>>>>>>>>>>>>>>> at >>>>>>>>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown >>>>>>>>>>>>>>>> Source) >>>>>>>>>>>>>>>> at java.lang.Thread.run(Unknown Source) >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> *Amila De Silva* >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> *Software Engineer* >>>>>>>>>>>>>>>> WSO2 Inc. >>>>>>>>>>>>>>>> mobile :(+94) 775119302 >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> * <http://us13.wso2con.com/> * >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *Senaka Fernando* >>>>>>>>>>>>>>> Senior Technical Lead; WSO2 Inc.; http://wso2.com >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> * Member; Apache Software Foundation; http://apache.org >>>>>>>>>>>>>>> <http://apache.org>E-mail: senaka AT wso2.com >>>>>>>>>>>>>>> <http://wso2.com>**P: >>>>>>>>>>>>>>> +1 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *M: +94 77 322 1818 <%2B94%2077%20322%201818> Linked-In: >>>>>>>>>>>>>>> http://linkedin.com/in/senakafernando >>>>>>>>>>>>>>> <http://linkedin.com/in/senakafernando>*Lean . Enterprise . >>>>>>>>>>>>>>> Middleware >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> *Amila De Silva* >>>>>>>>>>>>>> >>>>>>>>>>>>>> *Software Engineer* >>>>>>>>>>>>>> WSO2 Inc. >>>>>>>>>>>>>> mobile :(+94) 775119302 >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> >>>>>>>>>>>>> * <http://us13.wso2con.com/> * >>>>>>>>>>>>> >>>>>>>>>>>>> *Senaka Fernando* >>>>>>>>>>>>> Senior Technical Lead; WSO2 Inc.; http://wso2.com >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> * Member; Apache Software Foundation; http://apache.org >>>>>>>>>>>>> <http://apache.org>E-mail: senaka AT wso2.com >>>>>>>>>>>>> <http://wso2.com>**P: >>>>>>>>>>>>> +1 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> *M: +94 77 322 1818 <%2B94%2077%20322%201818> Linked-In: >>>>>>>>>>>>> http://linkedin.com/in/senakafernando >>>>>>>>>>>>> <http://linkedin.com/in/senakafernando>*Lean . Enterprise . >>>>>>>>>>>>> Middleware >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Amila De Silva* >>>>>>>>>>>> >>>>>>>>>>>> *Software Engineer* >>>>>>>>>>>> WSO2 Inc. >>>>>>>>>>>> mobile :(+94) 775119302 >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Dev mailing list >>>>>>>>>>>> [email protected] >>>>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> *Shelan Perera* >>>>>>>>>>> >>>>>>>>>>> Senior Software Engineer >>>>>>>>>>> Integration Technology Group >>>>>>>>>>> *WSO2, Inc. : wso2.com <http://wso2.com>* >>>>>>>>>>> lean.enterprise.middleware. >>>>>>>>>>> >>>>>>>>>>> *Blog* : blog.shelan.org >>>>>>>>>>> *Linked-i*n : >>>>>>>>>>> http://www.linkedin.com/pub/shelan-perera/a/194/465 >>>>>>>>>>> *Twitter* : https://twitter.com/#!/shelan >>>>>>>>>>> >>>>>>>>>>> *Mobile* : +94 772 604 402 >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> * <http://us13.wso2con.com/> * >>>>>>>>>> >>>>>>>>>> *Senaka Fernando* >>>>>>>>>> Senior Technical Lead; WSO2 Inc.; http://wso2.com >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> * Member; Apache Software Foundation; http://apache.org >>>>>>>>>> <http://apache.org>E-mail: senaka AT wso2.com <http://wso2.com>**P: >>>>>>>>>> +1 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> *M: +94 77 322 1818 <%2B94%2077%20322%201818> Linked-In: >>>>>>>>>> http://linkedin.com/in/senakafernando >>>>>>>>>> <http://linkedin.com/in/senakafernando>*Lean . Enterprise . >>>>>>>>>> Middleware >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Dev mailing list >>>>>>>>>> [email protected] >>>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> * <http://us13.wso2con.com/> * >>>>>>>> >>>>>>>> *Senaka Fernando* >>>>>>>> Senior Technical Lead; WSO2 Inc.; http://wso2.com >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> * Member; Apache Software Foundation; http://apache.org >>>>>>>> <http://apache.org>E-mail: senaka AT wso2.com <http://wso2.com>**P: >>>>>>>> +1 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >>>>>>>> >>>>>>>> >>>>>>>> *M: +94 77 322 1818 <%2B94%2077%20322%201818> Linked-In: >>>>>>>> http://linkedin.com/in/senakafernando >>>>>>>> <http://linkedin.com/in/senakafernando>*Lean . Enterprise . >>>>>>>> Middleware >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Dev mailing list >>>>>>>> [email protected] >>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> /sumedha >>>>>>> m: +94 773017743 >>>>>>> b : bit.ly/sumedha >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> * <http://us13.wso2con.com/> * >>>>>> >>>>>> *Senaka Fernando* >>>>>> Senior Technical Lead; WSO2 Inc.; http://wso2.com >>>>>> >>>>>> >>>>>> >>>>>> * Member; Apache Software Foundation; http://apache.org >>>>>> <http://apache.org>E-mail: senaka AT wso2.com <http://wso2.com>**P: >>>>>> +1 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >>>>>> >>>>>> >>>>>> *M: +94 77 322 1818 <%2B94%2077%20322%201818> Linked-In: >>>>>> http://linkedin.com/in/senakafernando >>>>>> <http://linkedin.com/in/senakafernando>*Lean . Enterprise . >>>>>> Middleware >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Asanthi Kulasinghe* >>>>> WSO2 Inc; http://www.wso2.com/. >>>>> Mobile: +94777355522 >>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> >>> >>> *[image: http://wso2.com] <http://wso2.com>Senaka Fernando* >>> Solutions Architect; WSO2 Inc.; http://wso2.com >>> >>> >>> >>> *Member; Apache Software Foundation; http://apache.org >>> <http://apache.org>E-mail: senaka AT wso2.com <http://wso2.com>**P: +1 >>> 408 754 7388 <%2B1%20408%20754%207388>; ext: 51736*; >>> >>> >>> *M: +44 782 741 1966 <%2B44%20782%20741%201966>Linked-In: >>> http://linkedin.com/in/senakafernando >>> <http://linkedin.com/in/senakafernando>*Lean . Enterprise . Middleware >>> >> >> >> -- >> Regards, >> Evanthika Amarasiri >> Senior Technical Lead - Quality Assurance >> Mobile: +94773125935 >> Blog: evanthika.blogspot.com >> >> wso2.com lean.enterprise.middleware >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > > *Kasun Gajasinghe*Senior Software Engineer, WSO2 Inc. > email: kasung AT spamfree wso2.com > linked-in: http://lk.linkedin.com/in/gajasinghe > blog: http://kasunbg.org > > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
