[prev in list] [next in list] [prev in thread] [next in thread]
List: wsf-java-dev
Subject: Re: [Dev] [G-Reg 5.1.0 ] Sample populator throws exceptions on console
From: Rajith Roshan <rajithr () wso2 ! com>
Date: 2015-10-30 7:57:02
Message-ID: CAL=cp-eH85pOt5haEDpPBfHfMiBtROEZbMh+mOdNhud2Su1=vg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Sagara,
According to the discussion had with the Chandana, can we change that value
only to run sample, rather than changing it in product level.
Rajith!
Thanks
On Fri, Oct 30, 2015 at 12:44 PM, Sagara Gunathunga <sagara@wso2.com> wrote:
>
>
> On Fri, Oct 30, 2015 at 12:42 PM, Rajith Roshan <rajithr@wso2.com> wrote:
>
> > Hi Sagara,
> >
> > These exceptions occurs when large number of wsdls are uploaded at once
> > using batch upload. As a workaround we should wait some time (5 mins) for
> > indexing processes to finish after server startup and
> > we should increase the "maxActive" connections from 80 to 120 in "master
> > datasources.xml".
> >
>
> Do we have any negative impact if we set maxActive= 120 as default value
> ?
>
> Thanks !
>
> >
> > Thanks!
> > Rajith
> >
> > On Fri, Oct 30, 2015 at 3:00 AM, Sagara Gunathunga <sagara@wso2.com>
> > wrote:
> >
> > >
> > > Hi Rajith,
> > >
> > > While running populator.sh I'm getting large number of exceptions as
> > > follows, may be there is no real impact to functionalities but this is not
> > > nice and unpleasant specially considering first user experience, can we
> > > implement some ordering through the script and avoid these exceptions ?
> > >
> > >
> > > Session #99 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_ASSOCIATION
> > > while locking PUBLIC.REG_RESOURCE (exclusive), PUBLIC.REG_CONTENT
> > > (exclusive), PUBLIC.REG_PROPERTY (exclusive), PUBLIC.REG_RESOURCE_PROPERTY
> > > (exclusive).
> > >
> > > Session #105 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE
> > > while locking PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:
> > >
> > > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=?
> > > AND REG_TENANT_ID=? [40001-140]
> > >
> > > org.h2.jdbc.JdbcSQLException: Deadlock detected. The current transaction
> > > was rolled back. Details: "
> > >
> > > Session #99 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_ASSOCIATION
> > > while locking PUBLIC.REG_RESOURCE (exclusive), PUBLIC.REG_CONTENT
> > > (exclusive), PUBLIC.REG_PROPERTY (exclusive), PUBLIC.REG_RESOURCE_PROPERTY
> > > (exclusive).
> > >
> > > Session #105 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE
> > > while locking PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:
> > >
> > > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=?
> > > AND REG_TENANT_ID=? [40001-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.table.RegularTable.doLock(RegularTable.java:457)
> > >
> > > at org.h2.table.RegularTable.lock(RegularTable.java:404)
> > >
> > > at org.h2.table.TableFilter.lock(TableFilter.java:139)
> > >
> > > at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
> > >
> > > at org.h2.command.dml.Query.query(Query.java:241)
> > >
> > > at org.h2.command.CommandContainer.query(CommandContainer.java:80)
> > >
> > > at org.h2.command.Command.executeQuery(Command.java:132)
> > >
> > > at
> > > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:197)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:147)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:156)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java:134)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedRegistry.java:644)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkRetentionLock(RetentionHandler.java:113)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkWriteLock(RetentionHandler.java:92)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.RetentionHandler.put(RetentionHandler.java:40)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.persistServiceResource(SOAPServiceMediaTypeHandler.java:475)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.put(SOAPServiceMediaTypeHandler.java:354)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.utils.CommonUtil.addSoapService(CommonUtil.java:605)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.utils.WSDLProcessor.addWSDLToRegistry(WSDLProcessor.java:336)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler.addWSDLFromZip(ZipWSDLMediaTypeHandler.java:506)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadWSDLTask.doProcessing(ZipWSDLMediaTypeHandler.java:1090)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.doWork(ZipWSDLMediaTypeHandler.java:979)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.run(ZipWSDLMediaTypeHandler.java:934)
> > >
> > > at
> > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> > >
> > > at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> > >
> > > at
> > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> > >
> > > at
> > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> > >
> > > at java.lang.Thread.run(Thread.java:745)
> > >
> > > [2015-10-30 02:33:29,132] ERROR
> > > {org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler} -
> > > An error occurred while uploading
> > > file:///Users/sagara/Downloads/wso2greg-5.1.0-SNAPSHOT/tmp/wsdl6238299896492668954/wsdl_new.gar_FILES/info.wsdl
> > >
> > > org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to
> > > check the existence of the resource
> > > /_system/governance/trunk/soapservices/eu/dataaccess/footballpool/1.0.0/Info.
> > > Deadlock detected. The current transaction was rolled back. Details: "
> > >
> > > Session #99 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_ASSOCIATION
> > > while locking PUBLIC.REG_RESOURCE (exclusive), PUBLIC.REG_CONTENT
> > > (exclusive), PUBLIC.REG_PROPERTY (exclusive), PUBLIC.REG_RESOURCE_PROPERTY
> > > (exclusive).
> > >
> > > Session #105 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE
> > > while locking PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:
> > >
> > > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=?
> > > AND REG_TENANT_ID=? [40001-140]
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:206)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:147)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:156)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java:134)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedRegistry.java:644)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkRetentionLock(RetentionHandler.java:113)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkWriteLock(RetentionHandler.java:92)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.RetentionHandler.put(RetentionHandler.java:40)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.persistServiceResource(SOAPServiceMediaTypeHandler.java:475)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.put(SOAPServiceMediaTypeHandler.java:354)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.utils.CommonUtil.addSoapService(CommonUtil.java:605)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.utils.WSDLProcessor.addWSDLToRegistry(WSDLProcessor.java:336)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler.addWSDLFromZip(ZipWSDLMediaTypeHandler.java:506)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadWSDLTask.doProcessing(ZipWSDLMediaTypeHandler.java:1090)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.doWork(ZipWSDLMediaTypeHandler.java:979)
> > >
> > > at
> > > org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.run(ZipWSDLMediaTypeHandler.java:934)
> > >
> > > at
> > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> > >
> > > at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> > >
> > > at
> > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> > >
> > > at
> > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> > >
> > > at java.lang.Thread.run(Thread.java:745)
> > >
> > > Caused by: org.h2.jdbc.JdbcSQLException: Deadlock detected. The current
> > > transaction was rolled back. Details: "
> > >
> > > Session #99 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_ASSOCIATION
> > > while locking PUBLIC.REG_RESOURCE (exclusive), PUBLIC.REG_CONTENT
> > > (exclusive), PUBLIC.REG_PROPERTY (exclusive), PUBLIC.REG_RESOURCE_PROPERTY
> > > (exclusive).
> > >
> > > Session #105 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE
> > > while locking PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:
> > >
> > > SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=?
> > > AND REG_TENANT_ID=? [40001-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.table.RegularTable.doLock(RegularTable.java:457)
> > >
> > > at org.h2.table.RegularTable.lock(RegularTable.java:404)
> > >
> > > at org.h2.table.TableFilter.lock(TableFilter.java:139)
> > >
> > > at org.h2.command.dml.Select.queryWithoutCache(Select.java:554)
> > >
> > > at org.h2.command.dml.Query.query(Query.java:241)
> > >
> > > at org.h2.command.CommandContainer.query(CommandContainer.java:80)
> > >
> > > at org.h2.command.Command.executeQuery(Command.java:132)
> > >
> > > at
> > > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
> > >
> > > at
> > > org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:197)
> > >
> > > ... 26 more
> > >
> > >
> > >
> > > Thanks !
> > > --
> > > Sagara Gunathunga
> > >
> > > Architect; WSO2, Inc.; http://wso2.com
> > > V.P Apache Web Services; http://ws.apache.org/
> > > Linkedin; http://www.linkedin.com/in/ssagara
> > > Blog ; http://ssagara.blogspot.com
> > >
> > >
> >
> >
> > --
> > Rajith Roshan
> > Software Engineer, WSO2 Inc.
> > Mobile: +94-72-642-8350 <%2B94-71-554-8430>
> >
>
>
>
> --
> Sagara Gunathunga
>
> Architect; WSO2, Inc.; http://wso2.com
> V.P Apache Web Services; http://ws.apache.org/
> Linkedin; http://www.linkedin.com/in/ssagara
> Blog ; http://ssagara.blogspot.com
>
>
--
Rajith Roshan
Software Engineer, WSO2 Inc.
Mobile: +94-72-642-8350 <%2B94-71-554-8430>
[Attachment #5 (text/html)]
<div dir="ltr">Hi Sagara,<div><br></div><div>According to the discussion had with the \
Chandana, can we change that value only to run sample, rather than changing it in \
product level.</div><div><br></div><div>Rajith!</div><div>Thanks</div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 30, 2015 at 12:44 PM, \
Sagara Gunathunga <span dir="ltr"><<a href="mailto:sagara@wso2.com" \
target="_blank">sagara@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div \
class="gmail_quote"><span class="">On Fri, Oct 30, 2015 at 12:42 PM, Rajith Roshan \
<span dir="ltr"><<a href="mailto:rajithr@wso2.com" \
target="_blank">rajithr@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div \
dir="ltr">Hi Sagara,<div><br></div><div>These exceptions occurs when large number of \
wsdls are uploaded at once using batch upload. As a workaround we should wait some \
time (5 mins) for indexing processes to finish after server startup and \
</div><div>we should increase the "maxActive" connections from 80 to 120 in \
"master datasources.xml".</div></div></blockquote><div><br></div></span><div>Do \
we have any negative impact if we set maxActive= 120 as default value ? \
</div><div><br></div><div>Thanks ! </div><div><div class="h5"><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div \
dir="ltr"><div><br></div><div>Thanks!</div><div>Rajith</div></div><div \
class="gmail_extra"><div><div><br><div class="gmail_quote">On Fri, Oct 30, 2015 at \
3:00 AM, Sagara Gunathunga <span dir="ltr"><<a href="mailto:sagara@wso2.com" \
target="_blank">sagara@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div \
dir="ltr"><div><br></div>Hi Rajith, <div><br></div><div>While running populator.sh \
I'm getting large number of exceptions as follows, may be there is no real impact \
to functionalities but this is not nice and unpleasant specially considering first \
user experience, can we implement some ordering through the script and avoid these \
exceptions ? </div>
<div><br clear="all"><div><br></div><div>
<p><span>Session #99 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_ASSOCIATION \
while locking PUBLIC.REG_RESOURCE (exclusive), PUBLIC.REG_CONTENT (exclusive), \
PUBLIC.REG_PROPERTY (exclusive), PUBLIC.REG_RESOURCE_PROPERTY (exclusive).</span></p> \
<p><span>Session #105 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE while \
locking PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:</span></p> \
<p><span>SELECT REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND \
REG_TENANT_ID=? [40001-140]</span></p> <p><span>org.h2.jdbc.JdbcSQLException: \
Deadlock detected. The current transaction was rolled back. Details: \
"</span></p> <p><span>Session #99 (user: WSO2CARBON) is waiting to lock \
PUBLIC.REG_ASSOCIATION while locking PUBLIC.REG_RESOURCE (exclusive), \
PUBLIC.REG_CONTENT (exclusive), PUBLIC.REG_PROPERTY (exclusive), \
PUBLIC.REG_RESOURCE_PROPERTY (exclusive).</span></p> <p><span>Session #105 (user: \
WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE while locking \
PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:</span></p> <p><span>SELECT \
REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND REG_TENANT_ID=? \
[40001-140]</span></p> <p><span><span> </span>at \
org.h2.message.DbException.getJdbcSQLException(DbException.java:327)</span></p> \
<p><span><span> </span>at \
org.h2.message.DbException.get(DbException.java:167)</span></p> \
<p><span><span> </span>at \
org.h2.message.DbException.get(DbException.java:144)</span></p> \
<p><span><span> </span>at \
org.h2.table.RegularTable.doLock(RegularTable.java:457)</span></p> \
<p><span><span> </span>at \
org.h2.table.RegularTable.lock(RegularTable.java:404)</span></p> \
<p><span><span> </span>at \
org.h2.table.TableFilter.lock(TableFilter.java:139)</span></p> \
<p><span><span> </span>at \
org.h2.command.dml.Select.queryWithoutCache(Select.java:554)</span></p> \
<p><span><span> </span>at org.h2.command.dml.Query.query(Query.java:241)</span></p> \
<p><span><span> </span>at \
org.h2.command.CommandContainer.query(CommandContainer.java:80)</span></p> \
<p><span><span> </span>at \
org.h2.command.Command.executeQuery(Command.java:132)</span></p> \
<p><span><span> </span>at \
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:197)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:147)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:156)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java:134)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedRegistry.java:644)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkRetentionLock(RetentionHandler.java:113)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkWriteLock(RetentionHandler.java:92)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.RetentionHandler.put(RetentionHandler.java:40)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.persistServiceResource(SOAPServiceMediaTypeHandler.java:475)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.put(SOAPServiceMediaTypeHandler.java:354)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.utils.CommonUtil.addSoapService(CommonUtil.java:605)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.utils.WSDLProcessor.addWSDLToRegistry(WSDLProcessor.java:336)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler.addWSDLFromZip(ZipWSDLMediaTypeHandler.java:506)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadWSDLTask.doProcessing(ZipWSDLMediaTypeHandler.java:1090)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.doWork(ZipWSDLMediaTypeHandler.java:979)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.run(ZipWSDLMediaTypeHandler.java:934)</span></p>
<p><span><span> </span>at \
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)</span></p> \
<p><span><span> </span>at \
java.util.concurrent.FutureTask.run(FutureTask.java:262)</span></p> \
<p><span><span> </span>at \
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</span></p>
<p><span><span> </span>at \
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</span></p>
<p><span><span> </span>at java.lang.Thread.run(Thread.java:745)</span></p>
<p><span>[2015-10-30 02:33:29,132] ERROR \
{org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler} - An error \
occurred while uploading \
file:///Users/sagara/Downloads/wso2greg-5.1.0-SNAPSHOT/tmp/wsdl6238299896492668954/wsdl_new.gar_FILES/info.wsdl</span></p>
<p><span>org.wso2.carbon.registry.core.exceptions.RegistryException: Failed to check \
the existence of the resource \
/_system/governance/trunk/soapservices/eu/dataaccess/footballpool/1.0.0/Info. \
Deadlock detected. The current transaction was rolled back. Details: \
"</span></p> <p><span>Session #99 (user: WSO2CARBON) is waiting to lock \
PUBLIC.REG_ASSOCIATION while locking PUBLIC.REG_RESOURCE (exclusive), \
PUBLIC.REG_CONTENT (exclusive), PUBLIC.REG_PROPERTY (exclusive), \
PUBLIC.REG_RESOURCE_PROPERTY (exclusive).</span></p> <p><span>Session #105 (user: \
WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE while locking \
PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:</span></p> <p><span>SELECT \
REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND REG_TENANT_ID=? \
[40001-140]</span></p> <p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:206)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:147)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.resourceExists(JDBCResourceDAO.java:156)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.Repository.resourceExists(Repository.java:134)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.resourceExists(EmbeddedRegistry.java:644)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkRetentionLock(RetentionHandler.java:113)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.RetentionHandler.checkWriteLock(RetentionHandler.java:92)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.RetentionHandler.put(RetentionHandler.java:40)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.persistServiceResource(SOAPServiceMediaTypeHandler.java:475)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.SOAPServiceMediaTypeHandler.put(SOAPServiceMediaTypeHandler.java:354)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerManager.put(HandlerManager.java:2503)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.handlers.HandlerLifecycleManager.put(HandlerLifecycleManager.java:957)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:697)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.utils.CommonUtil.addSoapService(CommonUtil.java:605)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.utils.WSDLProcessor.addWSDLToRegistry(WSDLProcessor.java:336)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler.addWSDLFromZip(ZipWSDLMediaTypeHandler.java:506)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadWSDLTask.doProcessing(ZipWSDLMediaTypeHandler.java:1090)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.doWork(ZipWSDLMediaTypeHandler.java:979)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.extensions.handlers.ZipWSDLMediaTypeHandler$UploadTask.run(ZipWSDLMediaTypeHandler.java:934)</span></p>
<p><span><span> </span>at \
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)</span></p> \
<p><span><span> </span>at \
java.util.concurrent.FutureTask.run(FutureTask.java:262)</span></p> \
<p><span><span> </span>at \
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)</span></p>
<p><span><span> </span>at \
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</span></p>
<p><span><span> </span>at java.lang.Thread.run(Thread.java:745)</span></p>
<p><span>Caused by: org.h2.jdbc.JdbcSQLException: Deadlock detected. The current \
transaction was rolled back. Details: "</span></p> <p><span>Session #99 (user: \
WSO2CARBON) is waiting to lock PUBLIC.REG_ASSOCIATION while locking \
PUBLIC.REG_RESOURCE (exclusive), PUBLIC.REG_CONTENT (exclusive), PUBLIC.REG_PROPERTY \
(exclusive), PUBLIC.REG_RESOURCE_PROPERTY (exclusive).</span></p> <p><span>Session \
#105 (user: WSO2CARBON) is waiting to lock PUBLIC.REG_RESOURCE while locking \
PUBLIC.REG_ASSOCIATION (exclusive)."; SQL statement:</span></p> <p><span>SELECT \
REG_VERSION FROM REG_RESOURCE WHERE REG_PATH_ID=? AND REG_NAME=? AND REG_TENANT_ID=? \
[40001-140]</span></p> <p><span><span> </span>at \
org.h2.message.DbException.getJdbcSQLException(DbException.java:327)</span></p> \
<p><span><span> </span>at \
org.h2.message.DbException.get(DbException.java:167)</span></p> \
<p><span><span> </span>at \
org.h2.message.DbException.get(DbException.java:144)</span></p> \
<p><span><span> </span>at \
org.h2.table.RegularTable.doLock(RegularTable.java:457)</span></p> \
<p><span><span> </span>at \
org.h2.table.RegularTable.lock(RegularTable.java:404)</span></p> \
<p><span><span> </span>at \
org.h2.table.TableFilter.lock(TableFilter.java:139)</span></p> \
<p><span><span> </span>at \
org.h2.command.dml.Select.queryWithoutCache(Select.java:554)</span></p> \
<p><span><span> </span>at org.h2.command.dml.Query.query(Query.java:241)</span></p> \
<p><span><span> </span>at \
org.h2.command.CommandContainer.query(CommandContainer.java:80)</span></p> \
<p><span><span> </span>at \
org.h2.command.Command.executeQuery(Command.java:132)</span></p> \
<p><span><span> </span>at \
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)</span></p>
<p><span><span> </span>at \
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.getVersion(JDBCResourceDAO.java:197)</span></p>
<p><span><span> </span>... 26 \
more</span></p></div><div><br></div><div><br></div><div><br></div><div>Thanks ! \
</div><span><font color="#888888">-- <br><div><div dir="ltr"><div><div \
dir="ltr">Sagara Gunathunga<br><br>Architect; WSO2, Inc.; <a href="http://wso2.com" \
target="_blank">http://wso2.com</a><br>V.P Apache Web Services; <a \
href="http://ws.apache.org/" target="_blank">http://ws.apache.org/</a><br>Linkedin; \
<a href="http://www.linkedin.com/in/ssagara" \
target="_blank">http://www.linkedin.com/in/ssagara</a><br>Blog ; <a \
href="http://ssagara.blogspot.com" \
target="_blank">http://ssagara.blogspot.com</a><br><br></div></div></div></div> \
</font></span></div></div> </blockquote></div><br><br \
clear="all"><div><br></div></div></div><span><font color="#888888">-- <br><div><div \
dir="ltr"><div><div dir="ltr"><div>Rajith Roshan<br></div><span><font \
color="#888888">Software Engineer, WSO2 Inc.<br>
Mobile: <a href="tel:%2B94-71-554-8430" value="+94715548430" \
target="_blank">+94-7<font color="#888888">2</font>-<font \
color="#888888">642</font>-8<font \
color="#888888">350</font></a></font></span></div></div></div></div> \
</font></span></div> </blockquote></div></div></div><div><div class="h5"><br><br \
clear="all"><div><br></div>-- <br><div><div dir="ltr"><div><div dir="ltr">Sagara \
Gunathunga<br><br>Architect; WSO2, Inc.; <a href="http://wso2.com" \
target="_blank">http://wso2.com</a><br>V.P Apache Web Services; <a \
href="http://ws.apache.org/" target="_blank">http://ws.apache.org/</a><br>Linkedin; \
<a href="http://www.linkedin.com/in/ssagara" \
target="_blank">http://www.linkedin.com/in/ssagara</a><br>Blog ; <a \
href="http://ssagara.blogspot.com" \
target="_blank">http://ssagara.blogspot.com</a><br><br></div></div></div></div> \
</div></div></div></div> </blockquote></div><br><br clear="all"><div><br></div>-- \
<br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Rajith \
Roshan<br></div><span><font color="#888888">Software Engineer, WSO2 \
Inc.<br>
Mobile: <a href="tel:%2B94-71-554-8430" value="+94715548430" \
target="_blank">+94-7<font color="#888888">2</font>-<font \
color="#888888">642</font>-8<font \
color="#888888">350</font></a></font></span></div></div></div></div> </div>
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic