Shinsuke Sugaya
shins****@yahoo*****
2013年 5月 22日 (水) 22:33:36 JST
菅谷です。 ご指摘いただきありがとうございます。 商用版のビルドの方ではそのパージ問題を 解決してリリースしていたので、OSS版にも 反映されていると思っていましたが反映されて いませんでした…。すいません。というわけで fess-server-mysql-8.1.1.zip をリリース物として 更新して置いておきました。 よろしくお願いいたします。 shinsuke 2013/5/22 Masayuki Shibata <mshib****@shima*****>: > 柴田＠亀岡市です。 > > 昨夜、既存の 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 > > _______________________________________________ > Fess-user mailing list > Fess-****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/fess-user
