Shinsuke Sugaya
shins****@yahoo*****
2012年 6月 22日 (金) 16:17:27 JST
菅谷です。 クロール対象のドキュメント数やクロールのスレッド数は どれくらいでしょうか？スレッド数が多い場合に大きな ドキュメントを同時に読みだしたりすると、一時的に 大量なメモリが必要になり、メモリ不足になります。 あとは、デフォルトの H2 では、ひとつのクロール設定で 数万ドキュメントのクロールが限界かと思います。 よろしくお願いいたします。 菅谷 2012/6/22 <suzuk****@towaw*****>: > 失礼いたします。鈴木と申します。 > > ０時過ぎにメモリ不足エラー、一般エラーが発生し、それ以降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 > > 以上 > > _______________________________________________ > Fess-user mailing list > Fess-****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/fess-user