Return-Path: X-Original-To: apmail-stratos-dev-archive@minotaur.apache.org Delivered-To: apmail-stratos-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6E32210B6F for ; Thu, 20 Feb 2014 09:39:18 +0000 (UTC) Received: (qmail 7671 invoked by uid 500); 20 Feb 2014 09:39:09 -0000 Delivered-To: apmail-stratos-dev-archive@stratos.apache.org Received: (qmail 7614 invoked by uid 500); 20 Feb 2014 09:39:07 -0000 Mailing-List: contact dev-help@stratos.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@stratos.incubator.apache.org Delivered-To: mailing list dev@stratos.incubator.apache.org Received: (qmail 7454 invoked by uid 99); 20 Feb 2014 09:39:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Feb 2014 09:39:02 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of isurup@wso2.com designates 209.85.219.45 as permitted sender) Received: from [209.85.219.45] (HELO mail-oa0-f45.google.com) (209.85.219.45) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Feb 2014 09:38:58 +0000 Received: by mail-oa0-f45.google.com with SMTP id i11so1868582oag.18 for ; Thu, 20 Feb 2014 01:38:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wso2.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=7Uc1ntRYfHtzTlKDUMgbHjA+Cc/f0NrI5d5hSsLzFZE=; b=QEe4fXwR/8vYnQu+cKwslL1MzlIbJjoKdGqXzb5M+DY6eFB1MOEVReMzw85SCDIqnL sb4bF8fTAN/18aJANH/VsSlp9rXSd9aOP/kjtyxsW0byEQtEikeeyLuGB7H8z9SskWLb rLeC/jRMAieXwsv+X4Ak3tuR+wIo6ZNEP5fwE= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=7Uc1ntRYfHtzTlKDUMgbHjA+Cc/f0NrI5d5hSsLzFZE=; b=OwO/EvPqIVH2pr7exd2VE93/tCNK1p59M5VYxInL13tNKpRdN6Moy9IZnUQICxcYw3 jj9cBHOkvdIGzRyYpGnhb5o0WFhV5MACAh9GcIg2Iy+aEY7J2lPoZp09eZ4p1vLAUGsx c5PgTiTQvl+7Lcs8jO3ATWoWfuRZYhtSdcUhllh61DzynsTZFba0ZleHcVKv5W8jwZAb u9l+U5bK6gL6R2EzGo6UOboYOZ9pzouXUVptOV0JMpLgSOt6T84uBnZheKfl5senJs9u e/lEVZcIXpYpMc5hPXztowiU43cfxDeKntDxm/UeQFt3+YxtVpT0W4bS/DyiSoErqWxD NndA== X-Gm-Message-State: ALoCoQmqUiKk1haLm1frjiDK5goqY8PbBf+nHi1yc+a60PROVvqFh/TpCFIyZ0nvxFcHuX1nMpl1 X-Received: by 10.182.65.199 with SMTP id z7mr575587obs.7.1392889117163; Thu, 20 Feb 2014 01:38:37 -0800 (PST) MIME-Version: 1.0 Received: by 10.76.20.79 with HTTP; Thu, 20 Feb 2014 01:32:38 -0800 (PST) In-Reply-To: References: From: Isuru Perera Date: Thu, 20 Feb 2014 15:02:38 +0530 Message-ID: Subject: Re: Unique index or primary key violation When unsubscribing To: dev Content-Type: multipart/alternative; boundary=001a11c1fc2e0a548a04f2d345bd X-Virus-Checked: Checked by ClamAV on apache.org --001a11c1fc2e0a548a04f2d345bd Content-Type: text/plain; charset=ISO-8859-1 I doubt whether this is due to H2 database. On Thu, Feb 20, 2014 at 2:50 PM, Udara Liyanage wrote: > Hi, > > I got the following error from DB when I unsubscribe. I encountered this > very rarely. > > P1 [member] lb1658126935.lb.domain8f725476-8e9c-4d33-b92c-ce6d2e301db0 > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} > TID: [0] [CC] [2014-02-20 09:15:41,713] INFO > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} - > Publishing member terminated event: [service] fresh [cluster] > fresh.fresh.domain [network-partition] ec2 [partition] P1 [member] > fresh.fresh.domainaeb569fa-d70f-4966-a0e5-2c29ffc47382 > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} > TID: [0] [CC] [2014-02-20 09:15:41,729] INFO > {org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl} - > Unregistration of service cluster: fresh.fresh.domain > {org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl} > TID: [0] [CC] [2014-02-20 09:15:41,750] INFO > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} - > Publishing cluster removed event: [service] fresh [cluster] > fresh.fresh.domain > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} > TID: [0] [CC] [2014-02-20 09:15:41,750] INFO > {org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl} - > Unregistration of service cluster: lb1658126935.lb.domain > {org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl} > TID: [0] [CC] [2014-02-20 09:15:41,820] INFO > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} - > Publishing cluster removed event: [service] lb [cluster] > lb1658126935.lb.domain > {org.apache.stratos.cloud.controller.topology.TopologyEventPublisher} > TID: [0] [CC] [2014-02-20 09:15:41,837] ERROR > {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO} - > Concurrent Modification: Failed to put the content into history with the > content id 242. Unique index or primary key violation: "PRIMARY_KEY_7 ON > PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, > REG_TENANT_ID) VALUES (?, ?, ?) [23001-140] > {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO} > org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: > "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, > REG_TENANT_ID) VALUES (?, ?, ?) [23001-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.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:157) > at org.h2.index.PageBtree.find(PageBtree.java:121) > at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:138) > at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:93) > at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:90) > at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:81) > at org.h2.table.RegularTable.addRow(RegularTable.java:116) > at org.h2.command.dml.Insert.insertRows(Insert.java:120) > 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.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionDAO.java:1235) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO.versionResource(JDBCResourceVersionDAO.java:1134) > at > org.wso2.carbon.registry.core.jdbc.VersionRepository.createVersionForResource(VersionRepository.java:210) > at > org.wso2.carbon.registry.core.jdbc.VersionRepository.createSnapshot(VersionRepository.java:87) > at > org.wso2.carbon.registry.core.jdbc.Repository.prepareUpdate(Repository.java:352) > at org.wso2.carbon.registry.core.jdbc.Repository.put(Repository.java:287) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:709) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) > at > org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) > at > org.apache.stratos.cloud.controller.registry.RegistryManager.persist(RegistryManager.java:94) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.persist(CloudControllerServiceImpl.java:424) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.logTermination(CloudControllerServiceImpl.java:893) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.access$300(CloudControllerServiceImpl.java:56) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl$InstanceTerminator.run(CloudControllerServiceImpl.java:512) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) > at java.lang.Thread.run(Thread.java:662) > TID: [0] [CC] [2014-02-20 09:15:41,840] ERROR > {org.apache.stratos.cloud.controller.registry.RegistryManager} - Failed to > persist the cloud controller data in registry. > {org.apache.stratos.cloud.controller.registry.RegistryManager} > org.wso2.carbon.registry.core.exceptions.ConcurrentModificationException: > Failed to put the content into history with the content id 242. Unique > index or primary key violation: "PRIMARY_KEY_7 ON > PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, > REG_TENANT_ID) VALUES (?, ?, ?) [23001-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionDAO.java:1242) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO.versionResource(JDBCResourceVersionDAO.java:1134) > at > org.wso2.carbon.registry.core.jdbc.VersionRepository.createVersionForResource(VersionRepository.java:210) > at > org.wso2.carbon.registry.core.jdbc.VersionRepository.createSnapshot(VersionRepository.java:87) > at > org.wso2.carbon.registry.core.jdbc.Repository.prepareUpdate(Repository.java:352) > at org.wso2.carbon.registry.core.jdbc.Repository.put(Repository.java:287) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:709) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) > at > org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) > at > org.apache.stratos.cloud.controller.registry.RegistryManager.persist(RegistryManager.java:94) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.persist(CloudControllerServiceImpl.java:424) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.logTermination(CloudControllerServiceImpl.java:893) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.access$300(CloudControllerServiceImpl.java:56) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl$InstanceTerminator.run(CloudControllerServiceImpl.java:512) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) > at java.lang.Thread.run(Thread.java:662) > Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key > violation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, > REG_TENANT_ID) VALUES (?, ?, ?) [23001-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.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:157) > at org.h2.index.PageBtree.find(PageBtree.java:121) > at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:138) > at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:93) > at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:90) > at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:81) > at org.h2.table.RegularTable.addRow(RegularTable.java:116) > at org.h2.command.dml.Insert.insertRows(Insert.java:120) > 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.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionDAO.java:1235) > ... 16 more > TID: [0] [CC] [2014-02-20 09:15:41,860] ERROR > {org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl} - > Instance termination failed. MemberContext > [memberId=fresh.fresh.domainaeb569fa-d70f-4966-a0e5-2c29ffc47382, > nodeId=ap-southeast-1/i-b75e239f, clusterId=fresh.fresh.domain, > cartridgeType=fresh, privateIpAddress=10.142.161.150, > publicIpAddress=54.255.27.242, allocatedIpAddress=null, > initTime=1392887630666, lbClusterId=lb1658126935.lb.domain, > networkPartitionId=ec2] > {org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl} > org.apache.stratos.cloud.controller.exception.CloudControllerException: > Failed to persist the cloud controller data in registry. > at > org.apache.stratos.cloud.controller.registry.RegistryManager.persist(RegistryManager.java:102) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.persist(CloudControllerServiceImpl.java:424) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.logTermination(CloudControllerServiceImpl.java:893) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.access$300(CloudControllerServiceImpl.java:56) > at > org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl$InstanceTerminator.run(CloudControllerServiceImpl.java:512) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) > at java.lang.Thread.run(Thread.java:662) > Caused by: > org.wso2.carbon.registry.core.exceptions.ConcurrentModificationException: > Failed to put the content into history with the content id 242. Unique > index or primary key violation: "PRIMARY_KEY_7 ON > PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, > REG_TENANT_ID) VALUES (?, ?, ?) [23001-140] > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionDAO.java:1242) > at > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceVersionDAO.versionResource(JDBCResourceVersionDAO.java:1134) > at > org.wso2.carbon.registry.core.jdbc.VersionRepository.createVersionForResource(VersionRepository.java:210) > at > org.wso2.carbon.registry.core.jdbc.VersionRepository.createSnapshot(VersionRepository.java:87) > at > org.wso2.carbon.registry.core.jdbc.Repository.prepareUpdate(Repository.java:352) > at org.wso2.carbon.registry.core.jdbc.Repository.put(Repository.java:287) > at > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:709) > at > org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465) > at > org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:657) > at > org.apache.stratos.cloud.controller.registry.RegistryManager.persist(RegistryManager.java:94) > ... 7 more > Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key > violation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, > REG_TENANT_ID)"; SQL statement: > INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, > REG_TENANT_ID) VALUES (?, ?, ?) [23001-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.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:157) > at org.h2.index.PageBtree.find(PageBtree.java:121) > at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:138) > at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:93) > at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:90) > at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:81) > at org.h2.table.RegularTable.addRow(RegularTable.java:116) > at org.h2.command.dml.Insert.insertRows(Insert.java:120) > 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.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionDAO.java:1235) > ... 16 more > > > > -- > Udara Liyanage > Software Engineer > WSO2, Inc.: http://wso2.com > lean. enterprise. middleware > > web: http://udaraliyanage.wordpress.com > phone: +94 71 443 6897 > -- Isuru Perera Senior Software Engineer | WSO2, Inc. | http://wso2.com/ Lean . Enterprise . Middleware about.me/chrishantha --001a11c1fc2e0a548a04f2d345bd Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I doubt whether this is due to H2 database.


On Thu, Feb 20, 20= 14 at 2:50 PM, Udara Liyanage <udara@wso2.com> wrote:
Hi,

I go= t the following error from DB when I unsubscribe. I encountered this very r= arely.

P1 [member] lb1658126935.lb.domain8f725476-8e9c-4d= 33-b92c-ce6d2e301db0 {org.apache.stratos.cloud.controller.topology.Topology= EventPublisher}
TID: [0] [CC] [2014-02-20 09:15:41,713] =A0INFO {org.apache.stratos.cl= oud.controller.topology.TopologyEventPublisher} - =A0Publishing member term= inated event: [service] fresh [cluster] fresh.fresh.domain [network-partiti= on] ec2 [partition] P1 [member] fresh.fresh.domainaeb569fa-d70f-4966-a0e5-2= c29ffc47382 {org.apache.stratos.cloud.controller.topology.TopologyEventPubl= isher}
TID: [0] [CC] [2014-02-20 09:15:41,729] =A0INFO {org.apache.stratos.cl= oud.controller.impl.CloudControllerServiceImpl} - =A0Unregistration of serv= ice cluster: fresh.fresh.domain {org.apache.stratos.cloud.controller.impl.C= loudControllerServiceImpl}
TID: [0] [CC] [2014-02-20 09:15:41,750] =A0INFO {org.apache.stratos.cl= oud.controller.topology.TopologyEventPublisher} - =A0Publishing cluster rem= oved event: [service] fresh [cluster] fresh.fresh.domain {org.apache.strato= s.cloud.controller.topology.TopologyEventPublisher}
TID: [0] [CC] [2014-02-20 09:15:41,750] =A0INFO {org.apache.stratos.cl= oud.controller.impl.CloudControllerServiceImpl} - =A0Unregistration of serv= ice cluster: lb1658126935.lb.domain {org.apache.stratos.cloud.controller.im= pl.CloudControllerServiceImpl}
TID: [0] [CC] [2014-02-20 09:15:41,820] =A0INFO {org.apache.stratos.cl= oud.controller.topology.TopologyEventPublisher} - =A0Publishing cluster rem= oved event: [service] lb [cluster] lb1658126935.lb.domain {org.apache.strat= os.cloud.controller.topology.TopologyEventPublisher}
TID: [0] [CC] [2014-02-20 09:15:41,837] ERROR {org.wso2.carbon.registr= y.core.jdbc.dao.JDBCResourceVersionDAO} - =A0Concurrent Modification: Faile= d to put the content into history with the content id 242. Unique index or = primary key violation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(RE= G_CONTENT_ID, REG_TENANT_ID)"; SQL statement:
INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, REG= _TENANT_ID) VALUES (?, ?, ?) [23001-140] {org.wso2.carbon.registry.core.jdb= c.dao.JDBCResourceVersionDAO}
org.h2.jdbc.JdbcSQLException: Uniqu= e index or primary key violation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT= _HISTORY(REG_CONTENT_ID, REG_TENANT_ID)"; SQL statement:
INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, REG= _TENANT_ID) VALUES (?, ?, ?) [23001-140]
at org.h2.message.DbException.getJdbcSQLException(DbEx= ception.java:327)
at org.h2.message.DbExcep= tion.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.index.BaseIndex= .getDuplicateKeyException(BaseIndex.java:157)
at org.h2.index.PageBtree.find(PageBtree.java:121= )
at org.h2.index.PageBtree= Leaf.addRow(PageBtreeLeaf.java:138)
at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:= 93)
at org.h2.index.PageBtree= Index.addRow(PageBtreeIndex.java:90)
at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:81)=
at org.h2.table.RegularTa= ble.addRow(RegularTable.java:116)
at org.h2.command.dml.Insert.insertRows(Insert.java:120)
at org.h2.command.dml.Ins= ert.update(Insert.java:82)
= at org.h2.command.CommandContainer.update(CommandContainer.java:70)<= /div>
at org.h2.command.Command= .executeUpdate(Command.java:199)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(Jdb= cPreparedStatement.java:141)
at org.h2.jdbc.JdbcPrepar= edStatement.executeUpdate(JdbcPreparedStatement.java:127)
at org.wso2.carbon.registry.core.jdbc= .dao.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionDAO.java:1235= )
at org.wso2.carbon.regist= ry.core.jdbc.dao.JDBCResourceVersionDAO.versionResource(JDBCResourceVersion= DAO.java:1134)
at or= g.wso2.carbon.registry.core.jdbc.VersionRepository.createVersionForResource= (VersionRepository.java:210)
at org.wso2.carbon.regist= ry.core.jdbc.VersionRepository.createSnapshot(VersionRepository.java:87)
at org.wso2.carbon.reg= istry.core.jdbc.Repository.prepareUpdate(Repository.java:352)
at org.wso2.carbon.regist= ry.core.jdbc.Repository.put(Repository.java:287)
at org.wso2.carbon.registry.core.jdbc.Embedded= Registry.put(EmbeddedRegistry.java:709)
at org.wso2.carbon.regist= ry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465)
=
at org.wso2.carbon.regist= ry.core.session.UserRegistry.put(UserRegistry.java:657)
at org.apache.stratos.clo= ud.controller.registry.RegistryManager.persist(RegistryManager.java:94)
at org.apache.stratos.c= loud.controller.impl.CloudControllerServiceImpl.persist(CloudControllerServ= iceImpl.java:424)
at org.apache.stratos.clo= ud.controller.impl.CloudControllerServiceImpl.logTermination(CloudControlle= rServiceImpl.java:893)
at org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.a= ccess$300(CloudControllerServiceImpl.java:56)
at org.apache.stratos.clo= ud.controller.impl.CloudControllerServiceImpl$InstanceTerminator.run(CloudC= ontrollerServiceImpl.java:512)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Thread= PoolExecutor.java:895)
at java.util.concurrent.T= hreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:6= 62)
TID: [0] [CC] [2014-02-20 09:15:41,840] ERROR {org.apache.stratos.clou= d.controller.registry.RegistryManager} - =A0Failed to persist the cloud con= troller data in registry. {org.apache.stratos.cloud.controller.registry.Reg= istryManager}
org.wso2.carbon.registry.core.exceptions.ConcurrentModificationExcepti= on: Failed to put the content into history with the content id 242. Unique = index or primary key violation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_H= ISTORY(REG_CONTENT_ID, REG_TENANT_ID)"; SQL statement:
INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, REG= _TENANT_ID) VALUES (?, ?, ?) [23001-140]
at org.wso2.carbon.registry.core.jdbc.dao.JDBCResource= VersionDAO.versionContent(JDBCResourceVersionDAO.java:1242)
at org.wso2.carbon.regist= ry.core.jdbc.dao.JDBCResourceVersionDAO.versionResource(JDBCResourceVersion= DAO.java:1134)
at or= g.wso2.carbon.registry.core.jdbc.VersionRepository.createVersionForResource= (VersionRepository.java:210)
at org.wso2.carbon.regist= ry.core.jdbc.VersionRepository.createSnapshot(VersionRepository.java:87)
at org.wso2.carbon.reg= istry.core.jdbc.Repository.prepareUpdate(Repository.java:352)
at org.wso2.carbon.regist= ry.core.jdbc.Repository.put(Repository.java:287)
at org.wso2.carbon.registry.core.jdbc.Embedded= Registry.put(EmbeddedRegistry.java:709)
at org.wso2.carbon.regist= ry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465)
=
at org.wso2.carbon.regist= ry.core.session.UserRegistry.put(UserRegistry.java:657)
at org.apache.stratos.clo= ud.controller.registry.RegistryManager.persist(RegistryManager.java:94)
at org.apache.stratos.c= loud.controller.impl.CloudControllerServiceImpl.persist(CloudControllerServ= iceImpl.java:424)
at org.apache.stratos.clo= ud.controller.impl.CloudControllerServiceImpl.logTermination(CloudControlle= rServiceImpl.java:893)
at org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.a= ccess$300(CloudControllerServiceImpl.java:56)
at org.apache.stratos.clo= ud.controller.impl.CloudControllerServiceImpl$InstanceTerminator.run(CloudC= ontrollerServiceImpl.java:512)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Thread= PoolExecutor.java:895)
at java.util.concurrent.T= hreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:6= 62)
Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key v= iolation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID,= REG_TENANT_ID)"; SQL statement:
INSERT INTO REG_CONTENT_HIS= TORY (REG_CONTENT_ID, REG_CONTENT_DATA, REG_TENANT_ID) VALUES (?, ?, ?) [23= 001-140]
at org.h2.message.DbExcep= tion.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.ja= va:167)
at org.h2.message.DbExcep= tion.get(DbException.java:144)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.jav= a:157)
at org.h2.index.PageBtree= .find(PageBtree.java:121)
<= /span>at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:138)
at org.h2.index.PageBtree= Leaf.addRowTry(PageBtreeLeaf.java:93)
at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java= :90)
at org.h2.index.PageBtree= Index.add(PageBtreeIndex.java:81)
at org.h2.table.RegularTable.addRow(RegularTable.java:116)
at org.h2.command.dml.Ins= ert.insertRows(Insert.java:120)
at org.h2.command.dml.Insert.update(Insert.java:82)
at org.h2.command.Command= Container.update(CommandContainer.java:70)
at org.h2.command.Command.executeUpdate(Command.java= :199)
at org.h2.jdbc.JdbcPrepar= edStatement.executeUpdateInternal(JdbcPreparedStatement.java:141)
at org.h2.jdbc.JdbcPreparedSt= atement.executeUpdate(JdbcPreparedStatement.java:127)
at org.wso2.carbon.regist= ry.core.jdbc.dao.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionD= AO.java:1235)
... 16= more
TID: [0] [CC] [2014-02-20 09:15:41,860] ERROR {org.apache.stratos.clou= d.controller.impl.CloudControllerServiceImpl} - =A0Instance termination fai= led. MemberContext [memberId=3Dfresh.fresh.domainaeb569fa-d70f-4966-a0e5-2c= 29ffc47382, nodeId=3Dap-southeast-1/i-b75e239f, clusterId=3Dfresh.fresh.dom= ain, cartridgeType=3Dfresh, privateIpAddress=3D10.142.161.150, publicIpAddr= ess=3D54.255.27.242, allocatedIpAddress=3Dnull, initTime=3D1392887630666, l= bClusterId=3Dlb1658126935.lb.domain, networkPartitionId=3Dec2] {org.apache.= stratos.cloud.controller.impl.CloudControllerServiceImpl}
org.apache.stratos.cloud.controller.exception.CloudControllerException= : Failed to persist the cloud controller data in registry.
at org.apache.stratos.cloud.controll= er.registry.RegistryManager.persist(RegistryManager.java:102)
at org.apache.stratos.clo= ud.controller.impl.CloudControllerServiceImpl.persist(CloudControllerServic= eImpl.java:424)
at o= rg.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl.logTermi= nation(CloudControllerServiceImpl.java:893)
at org.apache.stratos.clo= ud.controller.impl.CloudControllerServiceImpl.access$300(CloudControllerSer= viceImpl.java:56)
at= org.apache.stratos.cloud.controller.impl.CloudControllerServiceImpl$Instan= ceTerminator.run(CloudControllerServiceImpl.java:512)
at java.util.concurrent.T= hreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoo= lExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(T= hread.java:662)
Caused by: org.wso2.carbon.registry.core.exceptio= ns.ConcurrentModificationException: Failed to put the content into history = with the content id 242. Unique index or primary key violation: "PRIMA= RY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID, REG_TENANT_ID)"= ; SQL statement:
INSERT INTO REG_CONTENT_HISTORY (REG_CONTENT_ID, REG_CONTENT_DATA, REG= _TENANT_ID) VALUES (?, ?, ?) [23001-140]
at org.wso2.carbon.registry.core.jdbc.dao.JDBCResource= VersionDAO.versionContent(JDBCResourceVersionDAO.java:1242)
at org.wso2.carbon.regist= ry.core.jdbc.dao.JDBCResourceVersionDAO.versionResource(JDBCResourceVersion= DAO.java:1134)
at or= g.wso2.carbon.registry.core.jdbc.VersionRepository.createVersionForResource= (VersionRepository.java:210)
at org.wso2.carbon.regist= ry.core.jdbc.VersionRepository.createSnapshot(VersionRepository.java:87)
at org.wso2.carbon.reg= istry.core.jdbc.Repository.prepareUpdate(Repository.java:352)
at org.wso2.carbon.regist= ry.core.jdbc.Repository.put(Repository.java:287)
at org.wso2.carbon.registry.core.jdbc.Embedded= Registry.put(EmbeddedRegistry.java:709)
at org.wso2.carbon.regist= ry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465)
=
at org.wso2.carbon.regist= ry.core.session.UserRegistry.put(UserRegistry.java:657)
at org.apache.stratos.clo= ud.controller.registry.RegistryManager.persist(RegistryManager.java:94)
... 7 more
Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key v= iolation: "PRIMARY_KEY_7 ON PUBLIC.REG_CONTENT_HISTORY(REG_CONTENT_ID,= REG_TENANT_ID)"; SQL statement:
INSERT INTO REG_CONTENT_HIS= TORY (REG_CONTENT_ID, REG_CONTENT_DATA, REG_TENANT_ID) VALUES (?, ?, ?) [23= 001-140]
at org.h2.message.DbExcep= tion.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.ja= va:167)
at org.h2.message.DbExcep= tion.get(DbException.java:144)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.jav= a:157)
at org.h2.index.PageBtree= .find(PageBtree.java:121)
<= /span>at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:138)
at org.h2.index.PageBtree= Leaf.addRowTry(PageBtreeLeaf.java:93)
at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java= :90)
at org.h2.index.PageBtree= Index.add(PageBtreeIndex.java:81)
at org.h2.table.RegularTable.addRow(RegularTable.java:116)
at org.h2.command.dml.Ins= ert.insertRows(Insert.java:120)
at org.h2.command.dml.Insert.update(Insert.java:82)
at org.h2.command.Command= Container.update(CommandContainer.java:70)
at org.h2.command.Command.executeUpdate(Command.java= :199)
at org.h2.jdbc.JdbcPrepar= edStatement.executeUpdateInternal(JdbcPreparedStatement.java:141)
at org.h2.jdbc.JdbcPreparedSt= atement.executeUpdate(JdbcPreparedStatement.java:127)
at org.wso2.carbon.regist= ry.core.jdbc.dao.JDBCResourceVersionDAO.versionContent(JDBCResourceVersionD= AO.java:1235)
... 16= more



--



--
Isuru Perera
Senior Software Engineer | WSO2, Inc. | http://wso2.com= /
Lean . Enterprise . Middleware

about.me/chrishantha
--001a11c1fc2e0a548a04f2d345bd--