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
