Masayuki Shibata
mshib****@shima*****
2013年 5月 22日 (水) 09:26:33 JST
柴田＠亀岡市です。
昨夜、既存の Fess7 のクロール範囲を Fess8 MySQL 版でやっ
てみたところ、以下のようなエラーが出ました。
同じ内容で
Failed to purge search logs.
Failed to purge user info.
...も引き続き発生しています。
purge とのことで、インデックス作成には影響ないのかも知れ
ません (その後もクロールは継続していました) が、念のため
お知らせしておきます。
その２時間後くらいに
java.lang.OutOfMemoryError: Java heap space
...が発生し、インデックス作成が中断されましたが、これは
Fess7 のときにも発生していたのを、負荷を落とすなど微妙な
バランスでエラーにならなくして使っておりましたので、こち
らについては、今から調整してみようと思います。
６万件のドキュメント中、３万件超までは進みましたので、も
う一歩というところまで来た感じです。
2013-05-22 00:00:30,418 [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]
42000
[ErrorCode]
1064
[SQLException]
org.seasar.framework.exception.SSQLException
[ESSR0072]SQLで例外(SQL=[delete from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID = dfrel_0.ID
where dfrel_0.EXPIRED_TIME < ?], Message=[1064], ErrorCode=42000, SQLState={3})が発生しました
[NextException]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID ' at line 1
[ConditionBean]
jp.sf.fess.db.cbean.CrawlingSessionInfoCB
[Display SQL]
delete from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID = dfrel_0.ID
where dfrel_0.EXPIRED_TIME < '2013-05-22 00:00:30.369'
* * * * * * * * * */
at org.seasar.dbflute.exception.handler.SQLExceptionHandler.throwSQLFailureException(SQLExceptionHandler.java:116)
at org.seasar.dbflute.exception.handler.SQLExceptionHandler.handleSQLException(SQLExceptionHandler.java:81)
at org.seasar.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.handleSQLException(TnAbstractBasicSqlHandler.java:359)
at org.seasar.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.executeUpdate(TnAbstractBasicSqlHandler.java:474)
at org.seasar.dbflute.s2dao.sqlhandler.TnCommandContextHandler.doExecute(TnCommandContextHandler.java:79)
at org.seasar.dbflute.s2dao.sqlhandler.TnCommandContextHandler.execute(TnCommandContextHandler.java:60)
at org.seasar.dbflute.s2dao.sqlcommand.TnQueryDeleteDynamicCommand.execute(TnQueryDeleteDynamicCommand.java:61)
at org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.executeSql(BehaviorCommandInvoker.java:412)
at org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.dispatchInvoking(BehaviorCommandInvoker.java:233)
at org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.invoke(BehaviorCommandInvoker.java:159)
at org.seasar.dbflute.bhv.AbstractBehaviorReadable.invoke(AbstractBehaviorReadable.java:1180)
at jp.sf.fess.db.bsbhv.BsCrawlingSessionInfoBhv.delegateQueryDelete(BsCrawlingSessionInfoBhv.java:1078)
at jp.sf.fess.db.bsbhv.BsCrawlingSessionInfoBhv.doQueryDelete(BsCrawlingSessionInfoBhv.java:775)
at jp.sf.fess.db.bsbhv.BsCrawlingSessionInfoBhv.varyingQueryDelete(BsCrawlingSessionInfoBhv.java:983)
at jp.sf.fess.service.CrawlingSessionService.deleteBefore(CrawlingSessionService.java:273)
at jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$29f40a61.$$deleteBefore$$invokeSuperMethod$$(CrawlingSessionService$$EnhancedByS2AOP$$29f40a61.java)
at jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$29f40a61$$MethodInvocation$$deleteBefore5.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$$29f40a61$$MethodInvocation$$deleteBefore5.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$29f40a61$$MethodInvocation$$deleteBefore5.proceed(MethodInvocationClassGenerator.java)
at jp.sf.fess.service.CrawlingSessionService$$EnhancedByS2AOP$$29f40a61.deleteBefore(CrawlingSessionService$$EnhancedByS2AOP$$29f40a61.java)
at jp.sf.fess.task.DailyTask.doExecute(DailyTask.java:83)
at jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$7e217dc8.$$doExecute$$invokeSuperMethod$$(DailyTask$$EnhancedByS2AOP$$7e217dc8.java)
at jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$7e217dc8$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$7e217dc8$$MethodInvocation$$doExecute0.proceed(MethodInvocationClassGenerator.java)
at jp.sf.fess.task.DailyTask$$EnhancedByS2AOP$$7e217dc8.doExecute(DailyTask$$EnhancedByS2AOP$$7e217dc8.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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:342)
at org.seasar.chronos.core.delegate.MethodInvoker$1.call(MethodInvoker.java:177)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[delete from CRAWLING_SESSION_INFO dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID = dfrel_0.ID
where dfrel_0.EXPIRED_TIME < ?], Message=[1064], ErrorCode=42000, 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:467)
... 39 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dfloc
left outer join CRAWLING_SESSION dfrel_0 on dfloc.CRAWLING_SESSION_ID ' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:89)
... 40 more