「サーバーが混んでいます」org.h2.jdbc.JdbcSQLException: Deadlock detected. The current transaction was rolled back. Details: Session #61 (user: GSESSION) is waiting to lock PUBLIC.SML_SMEIS while locking PUBLIC.SML_JMEIS (shared).Session #41 (user: GSESSION) is waiting to lock PUBLIC.SML_JMEIS while locking PUBLIC.SML_SMEIS (exclusive). [40001-75] at org.h2.message.Message.getSQLException(Message.java:103) at org.h2.message.Message.getSQLException(Message.java:114) at org.h2.message.Message.getSQLException(Message.java:77) at org.h2.table.TableData.doLock(TableData.java:402) at org.h2.table.TableData.lock(TableData.java:351) at org.h2.command.dml.Insert.update(Insert.java:95) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:205) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:137) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:126) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at jp.groupsession.v2.sml.dao.SmlJmeisDao.insert(SmlJmeisDao.java:166) at jp.groupsession.v2.sml.sml020kn.Sml020knBiz.insertMailData(Sml020knBiz.java:636) at jp.groupsession.v2.sml.sml020kn.Sml020knAction.__doSend(Sml020knAction.java:253) at jp.groupsession.v2.sml.sml020kn.Sml020knAction.executeSmail(Sml020knAction.java:104) at jp.groupsession.v2.sml.AbstractSmlAction.executeAction(AbstractSmlAction.java:59) at jp.groupsession.v2.struts.AbstractGsAction.execute(AbstractGsAction.java:123) at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) at org.apache.struts.chain.commands.AbstractExecuteAction.execute
誤って、別にスレッドを作ってしまいました。すみませんでした。(AbstractExecuteAction.java:67) at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at jp.co.sjts.util.http.filter.FilterEncoding.doFilter(FilterEncoding.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595)
自信はありませんが。{catalina_home}/ webapps/gsession2/WEB-INF/conf/dataSource.xmlの <maxActive>1</maxActive> <maxIdle>1</maxIdle>を <maxActive>10</maxActive> <maxIdle>4</maxIdle>にしてみてはどうでしょうか？
ご返答ありがとうございます。お教え頂いた設定で、しばらく運用してみたいと思います。> 自信はありませんが。> {catalina_home}/ webapps/gsession2/WEB-INF/conf/dataSource.xml> の> <maxActive>1</maxActive>> <maxIdle>1</maxIdle>> を> <maxActive>10</maxActive>> <maxIdle>4</maxIdle>> にしてみてはどうでしょうか？>
<!-- 通常使用 --> <datasource> <id>GsDataSource</id> <driverClassName>org.h2.Driver</driverClassName> <username>gsession</username> <password>gsession</password> <defaultAutoCommit>false</defaultAutoCommit> <defaultReadOnly>false</defaultReadOnly> <maxActive>10</maxActive> <maxIdle>4</maxIdle> <maxWait>3000</maxWait> <validationQuery></validationQuery>こちらの <maxActive>10</maxActive> <maxIdle>4</maxIdle>部分を <maxActive>20</maxActive> <maxIdle>8</maxIdle>と修正でした。採番用は、 <maxActive>1</maxActive> <maxIdle>1</maxIdle>のままでないと誤作動しますね。
お疲れ様です。検証用のサーバーを構築して、これから動作テストするところでした。お教えいただいた設定箇所を変更して、やってみます。ありがとうございました。> こちらの> <maxActive>10</maxActive>> <maxIdle>4</maxIdle>> 部分を> <maxActive>20</maxActive>> <maxIdle>8</maxIdle>> と修正でした。> > 採番用は、> <maxActive>1</maxActive>> <maxIdle>1</maxIdle>> のままでないと誤作動しますね。
vertical_align_top