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
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
