Re: [Dev] {Registry}ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance/apimconfig/repository/comp
Hi Ratha, Ah I think I might know the issue. After dropping the database, you may also need to drop the indexes that we create (explicitly). If this was the case and this is not documented, please report a JIRA. It will help others who face similar issues. Thanks, Senaka. On Tue, Nov 25, 2014 at 8:36 AM, Vijayaratha Vijayasingam wrote: > Hi Senaka; > > I recreated fresh DBs for all DB(conf/gov/am/um/carbon) with different > names, and now i didn't see the issue.. > Thought to find the root cause, since my earlier configurations also i > believe right, so again dropped the DBs and recreated the DBs with the same > name( the names I used in the success case) and I started to face that > issue.. > Changed again DB names and now I don't face that issue..Looks like when I > drop the database, mysql does not drop the DB fully..(Keeps something in > cache?) > > Anyway the issue is sorted out now..Thanks. > > > > > > On 25 November 2014 at 03:52, Senaka Fernando wrote: > >> Hi Ratha, >> >> Looks like the DBs are messed up. I found erros from: >> >> 1. /_system/governance/apimconfig/repository/ >> 2. /_system/apimconfig/repository/transports/mailto >> 3. /_system/config/repository/transports/jms/listener >> >> Can you share the master-datasources.xml as well? Also, did this just >> happen in one setup or did this happen everytime? If you just tried once, >> can you change everything you've called "apiregdbpuppet" and >> "apim_configdb_puppet" to two other names and delete the local H2 DB and >> restart the server with -Dsetup? This should help isolate whether the issue >> is one-time or consistent. >> >> Thanks, >> Senaka. >> >> On Mon, Nov 24, 2014 at 12:56 PM, Vijayaratha Vijayasingam < >> rat...@wso2.com> wrote: >> >>> Hi all; >>> We have mounted registries and getting this issue in a fresh DB. This >>> occurs when we have members defined in cluster.. >>> >>> @senaka ; Do you have any clue what causes this issue? >>> >>> [2014-11-24 13:55:31,419] INFO - NioSelectorPool Using a shared >>> selector for servlet write/read >>> >>> [2014-11-24 13:55:31,461] INFO - TaskServiceImpl Task service starting >>> in CLUSTERED mode... >>> >>> [2014-11-24 13:55:31,471] INFO - RegistryEventingServiceComponent >>> Successfully Initialized Eventing on Registry >>> >>> [2014-11-24 13:55:31,537] INFO - JMXServerManager JMX Service URL : >>> service:jmx:rmi://localhost:4/jndi/rmi://localhost:10002/jmxrmi >>> >>> [2014-11-24 13:55:31,537] INFO - StartupFinalizerServiceComponent >>> Server : WSO2 API Manager-1.7.1 >>> >>> [2014-11-24 13:55:31,538] INFO - StartupFinalizerServiceComponent WSO2 >>> Carbon started in 31 sec >>> >>> [2014-11-24 13:55:31,962] ERROR - JDBCResourceDAO Failed to add resource >>> to path >>> /_system/governance/apimconfig/repository/components/org.wso2.carbon.all-themes/Default. >>> Cannot add or update a child row: a foreign key constraint fails >>> (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` >>> FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` >>> (`REG_PATH_ID`, `REG_TENANT_ID`)) >>> >>> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: >>> Cannot add or update a child row: a foreign key constraint fails >>> (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` >>> FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` >>> (`REG_PATH_ID`, `REG_TENANT_ID`)) >>> >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>> >>> at com.mysql.jdbc.Util.getInstance(Util.java:386) >>> >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) >>> >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) >>> >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) >>> >>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) >>> >>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) >>> >>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) >>> >>> 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.regi
Re: [Dev] {Registry}ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance/apimconfig/repository/comp
Hi Ratha et al, This is quit strange behavior, How is this linked with the elb, Why doesn't the issue appears when the ELB is not up and running? With Regards, On Tue, Nov 25, 2014 at 2:06 PM, Vijayaratha Vijayasingam wrote: > Hi Senaka; > > I recreated fresh DBs for all DB(conf/gov/am/um/carbon) with different > names, and now i didn't see the issue.. > Thought to find the root cause, since my earlier configurations also i > believe right, so again dropped the DBs and recreated the DBs with the same > name( the names I used in the success case) and I started to face that > issue.. > Changed again DB names and now I don't face that issue..Looks like when I > drop the database, mysql does not drop the DB fully..(Keeps something in > cache?) > > Anyway the issue is sorted out now..Thanks. > > > > > > On 25 November 2014 at 03:52, Senaka Fernando wrote: > >> Hi Ratha, >> >> Looks like the DBs are messed up. I found erros from: >> >> 1. /_system/governance/apimconfig/repository/ >> 2. /_system/apimconfig/repository/transports/mailto >> 3. /_system/config/repository/transports/jms/listener >> >> Can you share the master-datasources.xml as well? Also, did this just >> happen in one setup or did this happen everytime? If you just tried once, >> can you change everything you've called "apiregdbpuppet" and >> "apim_configdb_puppet" to two other names and delete the local H2 DB and >> restart the server with -Dsetup? This should help isolate whether the issue >> is one-time or consistent. >> >> Thanks, >> Senaka. >> >> On Mon, Nov 24, 2014 at 12:56 PM, Vijayaratha Vijayasingam < >> rat...@wso2.com> wrote: >> >>> Hi all; >>> We have mounted registries and getting this issue in a fresh DB. This >>> occurs when we have members defined in cluster.. >>> >>> @senaka ; Do you have any clue what causes this issue? >>> >>> [2014-11-24 13:55:31,419] INFO - NioSelectorPool Using a shared >>> selector for servlet write/read >>> >>> [2014-11-24 13:55:31,461] INFO - TaskServiceImpl Task service starting >>> in CLUSTERED mode... >>> >>> [2014-11-24 13:55:31,471] INFO - RegistryEventingServiceComponent >>> Successfully Initialized Eventing on Registry >>> >>> [2014-11-24 13:55:31,537] INFO - JMXServerManager JMX Service URL : >>> service:jmx:rmi://localhost:4/jndi/rmi://localhost:10002/jmxrmi >>> >>> [2014-11-24 13:55:31,537] INFO - StartupFinalizerServiceComponent >>> Server : WSO2 API Manager-1.7.1 >>> >>> [2014-11-24 13:55:31,538] INFO - StartupFinalizerServiceComponent WSO2 >>> Carbon started in 31 sec >>> >>> [2014-11-24 13:55:31,962] ERROR - JDBCResourceDAO Failed to add resource >>> to path >>> /_system/governance/apimconfig/repository/components/org.wso2.carbon.all-themes/Default. >>> Cannot add or update a child row: a foreign key constraint fails >>> (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` >>> FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` >>> (`REG_PATH_ID`, `REG_TENANT_ID`)) >>> >>> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: >>> Cannot add or update a child row: a foreign key constraint fails >>> (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` >>> FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` >>> (`REG_PATH_ID`, `REG_TENANT_ID`)) >>> >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>> >>> at >>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> >>> at >>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >>> >>> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >>> >>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>> >>> at com.mysql.jdbc.Util.getInstance(Util.java:386) >>> >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) >>> >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) >>> >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) >>> >>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) >>> >>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) >>> >>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) >>> >>> at >>> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) >>> >>> 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(
Re: [Dev] {Registry}ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance/apimconfig/repository/comp
Hi Senaka; I recreated fresh DBs for all DB(conf/gov/am/um/carbon) with different names, and now i didn't see the issue.. Thought to find the root cause, since my earlier configurations also i believe right, so again dropped the DBs and recreated the DBs with the same name( the names I used in the success case) and I started to face that issue.. Changed again DB names and now I don't face that issue..Looks like when I drop the database, mysql does not drop the DB fully..(Keeps something in cache?) Anyway the issue is sorted out now..Thanks. On 25 November 2014 at 03:52, Senaka Fernando wrote: > Hi Ratha, > > Looks like the DBs are messed up. I found erros from: > > 1. /_system/governance/apimconfig/repository/ > 2. /_system/apimconfig/repository/transports/mailto > 3. /_system/config/repository/transports/jms/listener > > Can you share the master-datasources.xml as well? Also, did this just > happen in one setup or did this happen everytime? If you just tried once, > can you change everything you've called "apiregdbpuppet" and > "apim_configdb_puppet" to two other names and delete the local H2 DB and > restart the server with -Dsetup? This should help isolate whether the issue > is one-time or consistent. > > Thanks, > Senaka. > > On Mon, Nov 24, 2014 at 12:56 PM, Vijayaratha Vijayasingam < > rat...@wso2.com> wrote: > >> Hi all; >> We have mounted registries and getting this issue in a fresh DB. This >> occurs when we have members defined in cluster.. >> >> @senaka ; Do you have any clue what causes this issue? >> >> [2014-11-24 13:55:31,419] INFO - NioSelectorPool Using a shared selector >> for servlet write/read >> >> [2014-11-24 13:55:31,461] INFO - TaskServiceImpl Task service starting >> in CLUSTERED mode... >> >> [2014-11-24 13:55:31,471] INFO - RegistryEventingServiceComponent >> Successfully Initialized Eventing on Registry >> >> [2014-11-24 13:55:31,537] INFO - JMXServerManager JMX Service URL : >> service:jmx:rmi://localhost:4/jndi/rmi://localhost:10002/jmxrmi >> >> [2014-11-24 13:55:31,537] INFO - StartupFinalizerServiceComponent Server >> : WSO2 API Manager-1.7.1 >> >> [2014-11-24 13:55:31,538] INFO - StartupFinalizerServiceComponent WSO2 >> Carbon started in 31 sec >> >> [2014-11-24 13:55:31,962] ERROR - JDBCResourceDAO Failed to add resource >> to path >> /_system/governance/apimconfig/repository/components/org.wso2.carbon.all-themes/Default. >> Cannot add or update a child row: a foreign key constraint fails >> (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` >> FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` >> (`REG_PATH_ID`, `REG_TENANT_ID`)) >> >> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: >> Cannot add or update a child row: a foreign key constraint fails >> (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` >> FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` >> (`REG_PATH_ID`, `REG_TENANT_ID`)) >> >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> >> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >> >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >> >> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) >> >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >> >> at com.mysql.jdbc.Util.getInstance(Util.java:386) >> >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) >> >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) >> >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) >> >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) >> >> at >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) >> >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) >> >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) >> >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) >> >> 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.session.UserRegistry.putInternal(UserRegistry.java:831) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistry.access$1000(UserRegistry.java:60) >> >> at >> org.wso2.carbon.registry.core.session.UserRegistr
Re: [Dev] {Registry}ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance/apimconfig/repository/comp
Hi Ratha, Looks like the DBs are messed up. I found erros from: 1. /_system/governance/apimconfig/repository/ 2. /_system/apimconfig/repository/transports/mailto 3. /_system/config/repository/transports/jms/listener Can you share the master-datasources.xml as well? Also, did this just happen in one setup or did this happen everytime? If you just tried once, can you change everything you've called "apiregdbpuppet" and "apim_configdb_puppet" to two other names and delete the local H2 DB and restart the server with -Dsetup? This should help isolate whether the issue is one-time or consistent. Thanks, Senaka. On Mon, Nov 24, 2014 at 12:56 PM, Vijayaratha Vijayasingam wrote: > Hi all; > We have mounted registries and getting this issue in a fresh DB. This > occurs when we have members defined in cluster.. > > @senaka ; Do you have any clue what causes this issue? > > [2014-11-24 13:55:31,419] INFO - NioSelectorPool Using a shared selector > for servlet write/read > > [2014-11-24 13:55:31,461] INFO - TaskServiceImpl Task service starting in > CLUSTERED mode... > > [2014-11-24 13:55:31,471] INFO - RegistryEventingServiceComponent > Successfully Initialized Eventing on Registry > > [2014-11-24 13:55:31,537] INFO - JMXServerManager JMX Service URL : > service:jmx:rmi://localhost:4/jndi/rmi://localhost:10002/jmxrmi > > [2014-11-24 13:55:31,537] INFO - StartupFinalizerServiceComponent Server > : WSO2 API Manager-1.7.1 > > [2014-11-24 13:55:31,538] INFO - StartupFinalizerServiceComponent WSO2 > Carbon started in 31 sec > > [2014-11-24 13:55:31,962] ERROR - JDBCResourceDAO Failed to add resource > to path > /_system/governance/apimconfig/repository/components/org.wso2.carbon.all-themes/Default. > Cannot add or update a child row: a foreign key constraint fails > (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` > FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` > (`REG_PATH_ID`, `REG_TENANT_ID`)) > > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Cannot add or update a child row: a foreign key constraint fails > (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` > FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` > (`REG_PATH_ID`, `REG_TENANT_ID`)) > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > > at com.mysql.jdbc.Util.getInstance(Util.java:386) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) > > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) > > 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.session.UserRegistry.putInternal(UserRegistry.java:831) > > at > org.wso2.carbon.registry.core.session.UserRegistry.access$1000(UserRegistry.java:60) > > at > org.wso2.carbon.registry.core.session.UserRegistry$11.run(UserRegistry.java:807) > > at > org.wso2.carbon.registry.core.session.UserRegistry$11.run(UserRegistry.java:804) > > at java.security.AccessController.doPrivileged(Native Method) > > at > org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:804) > > at > org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.put(MountHandler.java:293) > > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503) > > at > org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.put(UserDefinedHandlerManager.java:205) > > at > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:981) > > at > org.wso2.carbon.registry.core.jdbc.Embedded
[Dev] {Registry}ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance/apimconfig/repository/comp
Hi all; We have mounted registries and getting this issue in a fresh DB. This occurs when we have members defined in cluster.. @senaka ; Do you have any clue what causes this issue? [2014-11-24 13:55:31,419] INFO - NioSelectorPool Using a shared selector for servlet write/read [2014-11-24 13:55:31,461] INFO - TaskServiceImpl Task service starting in CLUSTERED mode... [2014-11-24 13:55:31,471] INFO - RegistryEventingServiceComponent Successfully Initialized Eventing on Registry [2014-11-24 13:55:31,537] INFO - JMXServerManager JMX Service URL : service:jmx:rmi://localhost:4/jndi/rmi://localhost:10002/jmxrmi [2014-11-24 13:55:31,537] INFO - StartupFinalizerServiceComponent Server : WSO2 API Manager-1.7.1 [2014-11-24 13:55:31,538] INFO - StartupFinalizerServiceComponent WSO2 Carbon started in 31 sec [2014-11-24 13:55:31,962] ERROR - JDBCResourceDAO Failed to add resource to path /_system/governance/apimconfig/repository/components/org.wso2.carbon.all-themes/Default. Cannot add or update a child row: a foreign key constraint fails (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` (`REG_PATH_ID`, `REG_TENANT_ID`)) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`apiregdbpuppet`.`reg_resource`, CONSTRAINT `REG_RESOURCE_FK_BY_PATH_ID` FOREIGN KEY (`REG_PATH_ID`, `REG_TENANT_ID`) REFERENCES `REG_PATH` (`REG_PATH_ID`, `REG_TENANT_ID`)) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) 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.session.UserRegistry.putInternal(UserRegistry.java:831) at org.wso2.carbon.registry.core.session.UserRegistry.access$1000(UserRegistry.java:60) at org.wso2.carbon.registry.core.session.UserRegistry$11.run(UserRegistry.java:807) at org.wso2.carbon.registry.core.session.UserRegistry$11.run(UserRegistry.java:804) at java.security.AccessController.doPrivileged(Native Method) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:804) at org.wso2.carbon.registry.core.jdbc.handlers.builtin.MountHandler.put(MountHandler.java:293) at org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503) at org.wso2.carbon.registry.core.jdbc.handlers.UserDefinedHandlerManager.put(UserDefinedHandlerManager.java:205) at org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:981) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697) at org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:508) at org.wso2.carbon.registry.core.session.UserRegistry.putInternal(UserRegistry.java:831) at org.wso2.carbon.registry.core.session.UserRegistry.access$1000(UserRegistry.java:60) at org.wso2.carbon.registry.core.session.UserRegistry$11.run(UserRegistry.java:807) at org.wso2.carbon.registry.core.session.UserRegistry$11.run(UserRegistry.java:804) at java.security.AccessController.doPrivileged(Native Method) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:804) at org.wso2.carbon.theme.mgt.util.ThemeUtil.transferAllThemesToRegistry(ThemeUtil.java:122) at org.wso2.carbon.theme.mgt.util.ThemeUtil.loadResourceThemes(ThemeUtil.java:175) at org.wso2.carbon.theme.mgt.internal.TenantThemeMgtServiceComponent.activate(T