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 <[email protected]> wrote: > > > 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 > > -- 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
