On Fri, Oct 30, 2015 at 12:42 PM, Rajith Roshan <[email protected]> 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 <[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> > -- 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
