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] > <javascript:_e(%7B%7D,'cvml','[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] >> <javascript:_e(%7B%7D,'cvml','[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] >>> <javascript:_e(%7B%7D,'cvml','[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] >>>> <javascript:_e(%7B%7D,'cvml','[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] >>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> >>>> Cc: Evanthika Amarasiri <[email protected] >>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>>, WSO2 >>>> Developers' List <[email protected] >>>> <javascript:_e(%7B%7D,'cvml','[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] >>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>>>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: >>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Sun, Sep 8, 2013 at 7:44 PM, Senaka Fernando <[email protected] >>>>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] >>>>>>>>>>>>> <javascript:_e(%7B%7D,'cvml','[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] <javascript:_e(%7B%7D,'cvml','[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] <javascript:_e(%7B%7D,'cvml','[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] <javascript:_e(%7B%7D,'cvml','[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; ext: 51736*; > > > *M: +44 782 741 1966Linked-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
