suzuk****@towaw*****
suzuk****@towaw*****
2012年 6月 22日 (金) 10:39:56 JST
失礼いたします。鈴木と申します。
０時過ぎにメモリ不足エラー、一般エラーが発生し、それ以降Tomcat再起動するまで
クロールしない事象が発生しています。
回避方法があれば、お教えいただければ幸いです
・bin/setenv.[sh|bat] で -Xmx1024m に変更
・webapps/fess/WEB-INF/classes/fess.dicon で -Xmx1024mに変更
・クロールのスケジュールを9時から18時に設定
を実施しました。
3月に導入してから1ヶ月くらいは大丈夫だったのですが、4月以降発生するようになっ
てしまいました。
fess.outに下のログが書かれています。
2012-06-21 00:37:43,046 [chronos-pool-4-thread-1] ERROR org.seasar.extension
.dbcp.impl.ConnectionWrapperImpl - 一般エラー: "java.lang.NullPointerExcepti
on"
General error: "java.lang.NullPointerException" [50000-156]
org.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.NullPointerException"
General error: "java.lang.NullPointerException" [50000-156]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at org.h2.store.PageStore.readPage(PageStore.java:1246)
at org.h2.store.PageStore.getPage(PageStore.java:701)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:144)
at org.h2.index.PageBtreeIndex.removeAllRows(PageBtreeIndex.java:260)
at org.h2.index.PageBtreeIndex.truncate(PageBtreeIndex.java:251)
at org.h2.table.RegularTable.truncate(RegularTable.java:389)
at org.h2.result.ResultTempTable.dropTable(ResultTempTable.java:146)
at org.h2.result.ResultTempTable.closeChild(ResultTempTable.java:123)
at org.h2.result.ResultTempTable.close(ResultTempTable.java:133)
at org.h2.result.LocalResult.close(LocalResult.java:381)
at org.h2.engine.Session.closeTemporaryResults(Session.java:1131)
at org.h2.command.Command.stop(Command.java:139)
at org.h2.command.Command.executeUpdate(Command.java:241)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
... 1 more
at org.h2.engine.SessionRemote.done(SessionRemote.java:538)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:183)
at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1420)
at org.h2.jdbc.JdbcConnection.rollback(JdbcConnection.java:462)
at
org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.closeReally(ConnectionWrapperImpl.java:125)
at
org.seasar.extension.dbcp.impl.ConnectionPoolImpl.release(ConnectionPoolImpl.java:456)
at
org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.release(ConnectionWrapperImpl.java:163)
at
org.seasar.extension.dbcp.impl.XAResourceWrapperImpl.release(XAResourceWrapperImpl.java:74)
at
org.seasar.extension.dbcp.impl.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:138)
at
org.seasar.extension.jta.XAResourceWrapper.rollback(XAResourceWrapper.java:76)
at
org.seasar.extension.jta.TransactionImpl.rollbackResources(TransactionImpl.java:416)
at
org.seasar.extension.jta.TransactionImpl.rollback(TransactionImpl.java:390)
at
org.seasar.extension.jta.AbstractTransactionManagerImpl.rollback(AbstractTransactionManagerImpl.java:106)
at
org.seasar.extension.jta.UserTransactionImpl.rollback(UserTransactionImpl.java:64)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.end(JTATransactionManagerAdapter.java:175)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:68)
at
org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.deleteBefore(CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.java)
at jp.sf.fess.task.DailyTask.doExecute(DailyTask.java:76)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.$$doExecute$$invokeSuperMethod$$(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.doExecute(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218)
at
org.seasar.chronos.core.delegate.MethodInvoker.invoke(MethodInvoker.java:341)
at
org.seasar.chronos.core.delegate.MethodInvoker$1.call(MethodInvoker.java:178)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2012-06-21 00:37:59,349 [chronos-pool-4-thread-1] ERROR org.seasar.extension
.dbcp.impl.ConnectionWrapperImpl - 一般エラー: "java.lang.NullPointerExcepti
on"
General error: "java.lang.NullPointerException" [50000-156]
org.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.NullPointerException"
General error: "java.lang.NullPointerException" [50000-156]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at org.h2.store.PageStore.readPage(PageStore.java:1246)
at org.h2.store.PageStore.getPage(PageStore.java:701)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:144)
at org.h2.index.PageBtreeIndex.removeAllRows(PageBtreeIndex.java:260)
at org.h2.index.PageBtreeIndex.truncate(PageBtreeIndex.java:251)
at org.h2.table.RegularTable.truncate(RegularTable.java:389)
at org.h2.result.ResultTempTable.dropTable(ResultTempTable.java:146)
at org.h2.result.ResultTempTable.closeChild(ResultTempTable.java:123)
at org.h2.result.ResultTempTable.close(ResultTempTable.java:133)
at org.h2.result.LocalResult.close(LocalResult.java:381)
at org.h2.engine.Session.closeTemporaryResults(Session.java:1131)
at org.h2.command.Command.stop(Command.java:139)
at org.h2.command.Command.executeUpdate(Command.java:241)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
... 1 more
at org.h2.engine.SessionRemote.done(SessionRemote.java:538)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:183)
at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1420)
at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:349)
at
org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.closeReally(ConnectionWrapperImpl.java:131)
at
org.seasar.extension.dbcp.impl.ConnectionPoolImpl.release(ConnectionPoolImpl.java:456)
at
org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.release(ConnectionWrapperImpl.java:163)
at
org.seasar.extension.dbcp.impl.XAResourceWrapperImpl.release(XAResourceWrapperImpl.java:74)
at
org.seasar.extension.dbcp.impl.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:138)
at
org.seasar.extension.jta.XAResourceWrapper.rollback(XAResourceWrapper.java:76)
at
org.seasar.extension.jta.TransactionImpl.rollbackResources(TransactionImpl.java:416)
at
org.seasar.extension.jta.TransactionImpl.rollback(TransactionImpl.java:390)
at
org.seasar.extension.jta.AbstractTransactionManagerImpl.rollback(AbstractTransactionManagerImpl.java:106)
at
org.seasar.extension.jta.UserTransactionImpl.rollback(UserTransactionImpl.java:64)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.end(JTATransactionManagerAdapter.java:175)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:68)
at
org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.deleteBefore(CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.java)
at jp.sf.fess.task.DailyTask.doExecute(DailyTask.java:76)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.$$doExecute$$invokeSuperMethod$$(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.doExecute(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218)
at
org.seasar.chronos.core.delegate.MethodInvoker.invoke(MethodInvoker.java:341)
at
org.seasar.chronos.core.delegate.MethodInvoker$1.call(MethodInvoker.java:178)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2012-06-21 00:37:59,349 [chronos-pool-4-thread-1] ERROR org.seasar.extension
.jta.TransactionImpl - [ESSR0017]例外が発生しました。理由はorg.h2.jdbc.JdbcS
QLException: 一般エラー:
"java.lang.NullPointerException"
General error: "java.lang.NullPointerException" [50000-156]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at org.h2.store.PageStore.readPage(PageStore.java:1246)
at org.h2.store.PageStore.getPage(PageStore.java:701)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:144)
at org.h2.index.PageBtreeIndex.removeAllRows(PageBtreeIndex.java:260)
at org.h2.index.PageBtreeIndex.truncate(PageBtreeIndex.java:251)
at org.h2.table.RegularTable.truncate(RegularTable.java:389)
at org.h2.result.ResultTempTable.dropTable(ResultTempTable.java:146)
at org.h2.result.ResultTempTable.close(ResultTempTable.java:136)
at org.h2.result.LocalResult.close(LocalResult.java:381)
at org.h2.engine.Session.closeTemporaryResults(Session.java:1131)
at org.h2.command.Command.stop(Command.java:139)
at org.h2.command.Command.executeUpdate(Command.java:241)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
... 1 more
org.seasar.framework.exception.SXAException: [ESSR0017]例外が発生しました。
理由はorg.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.NullPointerExcept
ion"
General error: "java.lang.NullPointerException" [50000-156]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at org.h2.store.PageStore.readPage(PageStore.java:1246)
at org.h2.store.PageStore.getPage(PageStore.java:701)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:144)
at org.h2.index.PageBtreeIndex.removeAllRows(PageBtreeIndex.java:260)
at org.h2.index.PageBtreeIndex.truncate(PageBtreeIndex.java:251)
at org.h2.table.RegularTable.truncate(RegularTable.java:389)
at org.h2.result.ResultTempTable.dropTable(ResultTempTable.java:146)
at org.h2.result.ResultTempTable.close(ResultTempTable.java:136)
at org.h2.result.LocalResult.close(LocalResult.java:381)
at org.h2.engine.Session.closeTemporaryResults(Session.java:1131)
at org.h2.command.Command.stop(Command.java:139)
at org.h2.command.Command.executeUpdate(Command.java:241)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
... 1 more
at
org.seasar.extension.dbcp.impl.DBXAResourceImpl.doRollback(DBXAResourceImpl.java:87)
at
org.seasar.extension.jta.xa.AbstractXAResource.rollback(AbstractXAResource.java:267)
at
org.seasar.extension.dbcp.impl.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:136)
at
org.seasar.extension.jta.XAResourceWrapper.rollback(XAResourceWrapper.java:76)
at
org.seasar.extension.jta.TransactionImpl.rollbackResources(TransactionImpl.java:416)
at
org.seasar.extension.jta.TransactionImpl.rollback(TransactionImpl.java:390)
at
org.seasar.extension.jta.AbstractTransactionManagerImpl.rollback(AbstractTransactionManagerImpl.java:106)
at
org.seasar.extension.jta.UserTransactionImpl.rollback(UserTransactionImpl.java:64)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.end(JTATransactionManagerAdapter.java:175)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:68)
at
org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.deleteBefore(CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.java)
at jp.sf.fess.task.DailyTask.doExecute(DailyTask.java:76)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.$$doExecute$$invokeSuperMethod$$(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.doExecute(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218)
at
org.seasar.chronos.core.delegate.MethodInvoker.invoke(MethodInvoker.java:341)
at
org.seasar.chronos.core.delegate.MethodInvoker$1.call(MethodInvoker.java:178)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.NullPointerE
xception"
General error: "java.lang.NullPointerException" [50000-156]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
at org.h2.store.PageStore.readPage(PageStore.java:1246)
at org.h2.store.PageStore.getPage(PageStore.java:701)
at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:144)
at org.h2.index.PageBtreeIndex.removeAllRows(PageBtreeIndex.java:260)
at org.h2.index.PageBtreeIndex.truncate(PageBtreeIndex.java:251)
at org.h2.table.RegularTable.truncate(RegularTable.java:389)
at org.h2.result.ResultTempTable.dropTable(ResultTempTable.java:146)
at org.h2.result.ResultTempTable.close(ResultTempTable.java:136)
at org.h2.result.LocalResult.close(LocalResult.java:381)
at org.h2.engine.Session.closeTemporaryResults(Session.java:1131)
at org.h2.command.Command.stop(Command.java:139)
at org.h2.command.Command.executeUpdate(Command.java:241)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
... 1 more
at org.h2.engine.SessionRemote.done(SessionRemote.java:538)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:183)
at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1420)
at org.h2.jdbc.JdbcConnection.rollback(JdbcConnection.java:462)
at
org.seasar.extension.dbcp.impl.DBXAResourceImpl.doRollback(DBXAResourceImpl.java:84)
... 33 more
2012-06-21 00:37:59,957 [chronos-pool-4-thread-1] ERROR
jp.sf.fess.task.DailyTask - Failed to purge crawling sessions.
org.seasar.dbflute.exception.SQLFailureException: Look! Read the message
below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The SQL failed to execute!
[Advice]
Please confirm the SQLException message.
[SQLState]
90108
[ErrorCode]
90108
[SQLException]
org.seasar.framework.exception.SSQLException
[ESSR0072]SQLで例外(SQL=[delete from CRAWLING_SESSION_INFO
where ID in (
select dfloc.ID
from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID
= dfrel_0.ID
where dfrel_0.CREATED_TIME < ?
)], Message=[90108], ErrorCode=90108, SQLState={3})が発生しました
[NextException]
org.h2.jdbc.JdbcSQLException
メモリが不足しています
Out of memory.; SQL statement:
delete from CRAWLING_SESSION_INFO
where ID in (
select dfloc.ID
from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID
= dfrel_0.ID
where dfrel_0.CREATED_TIME < ?
) [90108-156]
[ConditionBean]
jp.sf.fess.db.cbean.CrawlingSessionInfoCB
[Statement]
org.seasar.extension.jdbc.impl.PreparedStatementWrapper
[Display SQL]
delete from CRAWLING_SESSION_INFO
where ID in (
select dfloc.ID
from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID
= dfrel_0.ID
where dfrel_0.CREATED_TIME < '2012-05-22 00:00:26.239'
)
* * * * * * * * * */
at
org.seasar.dbflute.exception.handler.SQLExceptionHandler.throwSQLFailureException(SQLExceptionHandler.java:106)
at
org.seasar.dbflute.exception.handler.SQLExceptionHandler.handleSQLException(SQLExceptionHandler.java:75)
at
org.seasar.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.handleSQLException(TnAbstractBasicSqlHandler.java:245)
at
org.seasar.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.executeUpdate(TnAbstractBasicSqlHandler.java:286)
at
org.seasar.dbflute.s2dao.sqlhandler.TnCommandContextHandler.doExecute(TnCommandContextHandler.java:80)
at
org.seasar.dbflute.s2dao.sqlhandler.TnCommandContextHandler.execute(TnCommandContextHandler.java:61)
at
org.seasar.dbflute.s2dao.sqlcommand.TnQueryDeleteDynamicCommand.execute(TnQueryDeleteDynamicCommand.java:60)
at
org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.executeSql(BehaviorCommandInvoker.java:339)
at
org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.dispatchInvoking(BehaviorCommandInvoker.java:172)
at
org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.invoke(BehaviorCommandInvoker.java:138)
at
org.seasar.dbflute.bhv.AbstractBehaviorReadable.invoke(AbstractBehaviorReadable.java:871)
at
jp.sf.fess.db.bsbhv.BsCrawlingSessionInfoBhv.delegateQueryDelete(BsCrawlingSessionInfoBhv.java:1383)
at
jp.sf.fess.db.bsbhv.BsCrawlingSessionInfoBhv.doQueryDelete(BsCrawlingSessionInfoBhv.java:978)
at
jp.sf.fess.db.bsbhv.BsCrawlingSessionInfoBhv.varyingQueryDelete(BsCrawlingSessionInfoBhv.java:1208)
at
jp.sf.fess.service.CrawlingSessionService.deleteBefore(CrawlingSessionService.java:259)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.$$deleteBefore$$invokeSuperMethod$$(CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.java)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
at
org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
at
org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:50)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4$$MethodInvocation$$deleteBefore7.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.deleteBefore(CrawlingSessionService$$EnhancedByS2AOP$$17a77a4.java)
at jp.sf.fess.task.DailyTask.doExecute(DailyTask.java:76)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.$$doExecute$$invokeSuperMethod$$(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at
jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$11a04d5.doExecute(DailyTask$$EnhancedByS2AOP$$11a04d5.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:218)
at
org.seasar.chronos.core.delegate.MethodInvoker.invoke(MethodInvoker.java:341)
at
org.seasar.chronos.core.delegate.MethodInvoker$1.call(MethodInvoker.java:178)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外
(SQL=[delete from CRAWLING_SESSION_INFO
where ID in (
select dfloc.ID
from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID
= dfrel_0.ID
where dfrel_0.CREATED_TIME < ?
)], Message=[90108], ErrorCode=90108, SQLState={3})が発生しました
at
org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:72)
at
org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:67)
at
org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:91)
at
org.seasar.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.executeUpdate(TnAbstractBasicSqlHandler.java:284)
... 39 more
Caused by: org.h2.jdbc.JdbcSQLException: メモリが不足しています
Out of memory.; SQL statement:
delete from CRAWLING_SESSION_INFO
where ID in (
select dfloc.ID
from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID
= dfrel_0.ID
where dfrel_0.CREATED_TIME < ?
) [90108-156]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:273)
at org.h2.command.Command.executeUpdate(Command.java:216)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.OutOfMemoryError: Java heap space
at org.h2.util.StringUtils.getCache(StringUtils.java:49)
at org.h2.util.StringUtils.cache(StringUtils.java:875)
at org.h2.value.ValueString.get(ValueString.java:123)
at org.h2.store.Data.readValue(Data.java:757)
at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:598)
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:64)
at org.h2.index.IndexCursor.next(IndexCursor.java:235)
at org.h2.table.TableFilter.next(TableFilter.java:352)
at org.h2.command.dml.Select.queryFlat(Select.java:512)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:617)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.expression.ConditionInSelect.getValue(ConditionInSelect.java:45)
at org.h2.expression.Expression.getBooleanValue(Expression.java:180)
at org.h2.command.dml.Delete.update(Delete.java:71)
at org.h2.command.CommandContainer.update(CommandContainer.java:71)
at org.h2.command.Command.executeUpdate(Command.java:212)
... 3 more
at org.h2.engine.SessionRemote.done(SessionRemote.java:538)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:183)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
at
org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:89)
... 40 more
以上