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".
Thanks! Rajith On Fri, Oct 30, 2015 at 3:00 AM, Sagara Gunathunga <[email protected]> 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>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
