ganos****@gmail*****
ganos****@gmail*****
2011年 6月 5日 (日) 13:05:05 JST
菅谷様
お世話になっております。
fessを利用させていただいている、がのすと申します。
現在、fess4.1のSNAPSHOT(5月中旬頃にダウンロードしたもの)を使
ってインデックス作成のテストを行ってみておりますが、SQL関係
のエラーメッセージが発生して、更新が止まってしまうことが度々
発生するようです。
また、障害URLの削除を行う時も、ほぼ同様のエラーが発生して、
障害URLの削除ができない状態となります。
エラーメッセージ(添付ファイル)を軽く見ていると、インデックス
に存在しない行を削除しようとしたために、エラー発生したと読み
取れます。
何らかの原因でインデックス登録に失敗したため、存在しない情報
を削除しようとした時にエラーになっているという認識で合ってお
りますでしょうか？
●環境
Windows 7 Ultimate SP1(64bit)
※Windows 7 Pro(32bit)のPCでも同様のエラーが度々発生。
JDK 6 Update 24
fess-server-4.1.0-SNAPSHOT(5月中旬にダウンロードしたもの)
上記、SNAPSHOTテスト時のエラーケースとして、とりあえずご報告
させていただきました。
何かの参考になれば幸いです。
以上、よろしくお願いいたします。
-------------- next part --------------
2011-06-05 02:21:09,675 [http-8080-2] ERROR jp.sf.fess.interceptor.FessActionMessagesThrowsInterceptor - System error occured.
org.seasar.dbflute.exception.SQLFailureException: Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The SQL failed to execute!
[Advice]
Please confirm the SQLException message.
[SQLState]
90112
[ErrorCode]
90112
[SQLException]
org.seasar.framework.exception.SSQLException
[ESSR0072]SQLで例外(SQL=[delete from FAILURE_URL
where ID in (
select dfloc.ID
from FAILURE_URL dfloc
)], Message=[90112], ErrorCode=90112, SQLState={3})が発生しました
[NextException]
org.h2.jdbc.JdbcSQLException
インデックス "PUBLIC.IDX_FAILURE_URL_FOR_LIST: ( /* key:3512 */ 3512, 'file:/e:/hogehoge.txt', 'Robot-20110527233659-1-1', 'org.seasar.robot.MaxLengthExceededException', STRINGDECODE('org.seasar.robot.MaxLengthExceededException: The content length (79410112 byte) is over 10485760 byte. The url is file:/e:/hogehoge.txt\r\n\tat org.seasar.robot.client.fs.FileSystemClient.doGet(FileSystemClient.java:112)\r\n\tat org.seasar.robot.S2RobotThread.run(S2RobotThread.java:167)\r\n\tat java.lang.Thread.run(Thread.java:662)\r\n'), 3, TIMESTAMP '2011-05-28 00:04:30.467', NULL, 1)" から削除を試みましたが、行が見つかりません
Row not found when trying to delete from index "PUBLIC.IDX_FAILURE_URL_FOR_LIST: ( /* key:3512 */ 3512, 'file:/e:/hogehoge.txt', 'Robot-20110527233659-1-1', 'org.seasar.robot.MaxLengthExceededException', STRINGDECODE('org.seasar.robot.MaxLengthExceededException: The content length (79410112 byte) is over 10485760 byte. The url is file:/e:/hogehoge.txt\r\n\tat org.seasar.robot.client.fs.FileSystemClient.doGet(FileSystemClient.java:112)\r\n\tat org.seasar.robot.S2RobotThread.run(S2RobotThread.java:167)\r\n\tat java.lang.Thread.run(Thread.java:662)\r\n'), 3, TIMESTAMP '2011-05-28 00:04:30.467', NULL, 1)"; SQL statement:
delete from FAILURE_URL
where ID in (
select dfloc.ID
from FAILURE_URL dfloc
) [90112-147]
[ConditionBean]
jp.sf.fess.db.cbean.FailureUrlCB
[Statement]
org.seasar.extension.jdbc.impl.PreparedStatementWrapper
[Display SQL]
delete from FAILURE_URL
where ID in (
select dfloc.ID
from FAILURE_URL dfloc
)
* * * * * * * * * */
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.BsFailureUrlBhv.delegateQueryDelete(BsFailureUrlBhv.java:1377)
at jp.sf.fess.db.bsbhv.BsFailureUrlBhv.doQueryDelete(BsFailureUrlBhv.java:981)
at jp.sf.fess.db.bsbhv.BsFailureUrlBhv.varyingQueryDelete(BsFailureUrlBhv.java:1207)
at jp.sf.fess.service.FailureUrlService.deleteAll(FailureUrlService.java:84)
at jp.sf.fess.service.FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc.$$deleteAll$$invokeSuperMethod$$(FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc.java)
at jp.sf.fess.service.FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc$$MethodInvocation$$deleteAll0.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.FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc$$MethodInvocation$$deleteAll0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at jp.sf.fess.service.FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc$$MethodInvocation$$deleteAll0.proceed(MethodInvocationClassGenerator.java)
at jp.sf.fess.service.FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc.deleteAll(FailureUrlService$$EnhancedByS2AOP$$5fc1c9dc.java)
at jp.sf.fess.action.admin.FailureUrlAction.deleteall(FailureUrlAction.java:30)
at jp.sf.fess.action.admin.FailureUrlAction$$EnhancedByS2AOP$$18c07930.$$deleteall$$invokeSuperMethod$$(FailureUrlAction$$EnhancedByS2AOP$$18c07930.java)
at jp.sf.fess.action.admin.FailureUrlAction$$EnhancedByS2AOP$$18c07930$$MethodInvocation$$deleteall0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:79)
at jp.sf.fess.interceptor.FessActionMessagesThrowsInterceptor.invoke(FessActionMessagesThrowsInterceptor.java:37)
at jp.sf.fess.action.admin.FailureUrlAction$$EnhancedByS2AOP$$18c07930$$MethodInvocation$$deleteall0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:56)
at jp.sf.fess.action.admin.FailureUrlAction$$EnhancedByS2AOP$$18c07930$$MethodInvocation$$deleteall0.proceed(MethodInvocationClassGenerator.java)
at jp.sf.fess.action.admin.FailureUrlAction$$EnhancedByS2AOP$$18c07930.deleteall(FailureUrlAction$$EnhancedByS2AOP$$18c07930.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.struts.action.ActionWrapper.execute(ActionWrapper.java:139)
at org.seasar.struts.action.ActionWrapper.execute(ActionWrapper.java:87)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.seasar.struts.action.S2RequestProcessor.process(S2RequestProcessor.java:132)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.mobylet.core.http.MobyletFilter.processFilter(MobyletFilter.java:110)
at org.mobylet.core.http.MobyletFilter.doFilter(MobyletFilter.java:74)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.seasar.struts.filter.RoutingFilter.forward(RoutingFilter.java:219)
at org.seasar.struts.filter.RoutingFilter.doFilter(RoutingFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at jp.sf.fess.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:111)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.mobylet.core.http.MobyletFilter.processFilter(MobyletFilter.java:110)
at org.mobylet.core.http.MobyletFilter.doFilter(MobyletFilter.java:74)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[delete from FAILURE_URL
where ID in (
select dfloc.ID
from FAILURE_URL dfloc
)], Message=[90112], ErrorCode=90112, 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)
... 86 more
Caused by: org.h2.jdbc.JdbcSQLException: インデックス "PUBLIC.IDX_FAILURE_URL_FOR_LIST: ( /* key:3512 */ 3512, 'file:/e:/hogehoge.txt', 'Robot-20110527233659-1-1', 'org.seasar.robot.MaxLengthExceededException', STRINGDECODE('org.seasar.robot.MaxLengthExceededException: The content length (79410112 byte) is over 10485760 byte. The url is file:/e:/hogehoge.txt\r\n\tat org.seasar.robot.client.fs.FileSystemClient.doGet(FileSystemClient.java:112)\r\n\tat org.seasar.robot.S2RobotThread.run(S2RobotThread.java:167)\r\n\tat java.lang.Thread.run(Thread.java:662)\r\n'), 3, TIMESTAMP '2011-05-28 00:04:30.467', NULL, 1)" から削除を試みましたが、行が見つかりません
Row not found when trying to delete from index "PUBLIC.IDX_FAILURE_URL_FOR_LIST: ( /* key:3512 */ 3512, 'file:/e:/hogehoge.txt', 'Robot-20110527233659-1-1', 'org.seasar.robot.MaxLengthExceededException', STRINGDECODE('org.seasar.robot.MaxLengthExceededException: The content length (79410112 byte) is over 10485760 byte. The url is file:/e:/hogehoge.txt\r\n\tat org.seasar.robot.client.fs.FileSystemClient.doGet(FileSystemClient.java:112)\r\n\tat org.seasar.robot.S2RobotThread.run(S2RobotThread.java:167)\r\n\tat java.lang.Thread.run(Thread.java:662)\r\n'), 3, TIMESTAMP '2011-05-28 00:04:30.467', NULL, 1)"; SQL statement:
delete from FAILURE_URL
where ID in (
select dfloc.ID
from FAILURE_URL dfloc
) [90112-147]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:222)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:234)
at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:165)
at org.h2.table.RegularTable.removeRow(RegularTable.java:360)
at org.h2.command.dml.Delete.update(Delete.java:74)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:201)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:300)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Thread.java:662)
at org.h2.engine.SessionRemote.done(SessionRemote.java:543)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:184)
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)
... 87 more
-------------- next part --------------
2011-05-25 09:30:12,439 [main] WARN jp.sf.fess.exec.Crawler - Interrupted a crawl task.
org.seasar.robot.dbflute.exception.SQLFailureException: Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The SQL failed to execute!
[Advice]
Please confirm the SQLException message.
[SQLState]
HY000
[ErrorCode]
50000
[SQLException]
org.seasar.framework.exception.SSQLException
[ESSR0072]SQLで例外(SQL=[delete from URL_QUEUE
], Message=[50000], ErrorCode=HY000, SQLState={3})が発生しました
[NextException]
org.h2.jdbc.JdbcSQLException
一般エラー: "java.lang.ArrayIndexOutOfBoundsException: 272"
General error: "java.lang.ArrayIndexOutOfBoundsException: 272"; SQL statement:
delete from URL_QUEUE
[50000-147]
[OutsideSql]
org/seasar/robot/db/exbhv/UrlQueueBhv_deleteBySessionId.sql
[Statement]
org.seasar.extension.jdbc.impl.PreparedStatementWrapper
[Display SQL]
delete from URL_QUEUE
* * * * * * * * * */
at org.seasar.robot.dbflute.exception.handler.SQLExceptionHandler.throwSQLFailureException(SQLExceptionHandler.java:106)
at org.seasar.robot.dbflute.exception.handler.SQLExceptionHandler.handleSQLException(SQLExceptionHandler.java:75)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.handleSQLException(TnAbstractBasicSqlHandler.java:246)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.executeUpdate(TnAbstractBasicSqlHandler.java:287)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnBasicUpdateHandler.doExecute(TnBasicUpdateHandler.java:47)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnBasicParameterHandler.execute(TnBasicParameterHandler.java:47)
at org.seasar.robot.dbflute.s2dao.sqlcommand.TnAbstractTwoWaySqlCommand.execute(TnAbstractTwoWaySqlCommand.java:58)
at org.seasar.robot.dbflute.bhv.core.BehaviorCommandInvoker.executeSql(BehaviorCommandInvoker.java:339)
at org.seasar.robot.dbflute.bhv.core.BehaviorCommandInvoker.dispatchInvoking(BehaviorCommandInvoker.java:172)
at org.seasar.robot.dbflute.bhv.core.BehaviorCommandInvoker.invoke(BehaviorCommandInvoker.java:138)
at org.seasar.robot.dbflute.bhv.outsidesql.OutsideSqlBasicExecutor.invoke(OutsideSqlBasicExecutor.java:292)
at org.seasar.robot.dbflute.bhv.outsidesql.OutsideSqlBasicExecutor.execute(OutsideSqlBasicExecutor.java:208)
at org.seasar.robot.db.exbhv.UrlQueueBhv.deleteAll(UrlQueueBhv.java:39)
at org.seasar.robot.service.impl.DBUrlQueueServiceImpl.deleteAll(DBUrlQueueServiceImpl.java:138)
at org.seasar.robot.service.impl.DBUrlQueueServiceImpl$$EnhancedByS2AOP$$4eda1515.$$deleteAll$$invokeSuperMethod$$(DBUrlQueueServiceImpl$$EnhancedByS2AOP$$4eda1515.java)
at org.seasar.robot.service.impl.DBUrlQueueServiceImpl$$EnhancedByS2AOP$$4eda1515$$MethodInvocation$$deleteAll4.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 org.seasar.robot.service.impl.DBUrlQueueServiceImpl$$EnhancedByS2AOP$$4eda1515$$MethodInvocation$$deleteAll4.proceed(MethodInvocationClassGenerator.java)
at org.seasar.robot.service.impl.DBUrlQueueServiceImpl$$EnhancedByS2AOP$$4eda1515.deleteAll(DBUrlQueueServiceImpl$$EnhancedByS2AOP$$4eda1515.java)
at jp.sf.fess.helper.FileSystemIndexHelper.crawl(FileSystemIndexHelper.java:370)
at jp.sf.fess.exec.Crawler.doCrawl(Crawler.java:251)
at jp.sf.fess.exec.Crawler.main(Crawler.java:152)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[delete from URL_QUEUE
], Message=[50000], ErrorCode=HY000, 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.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.executeUpdate(TnAbstractBasicSqlHandler.java:285)
... 20 more
Caused by: org.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.ArrayIndexOutOfBoundsException: 272"
General error: "java.lang.ArrayIndexOutOfBoundsException: 272"; SQL statement:
delete from URL_QUEUE
[50000-147]
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.table.RegularTable.removeRow(RegularTable.java:378)
at org.h2.command.dml.Delete.update(Delete.java:74)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:201)
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)
... 21 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 272
at org.h2.index.PageBtree.getRow(PageBtree.java:172)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:220)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:234)
at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:165)
at org.h2.table.RegularTable.removeRow(RegularTable.java:360)
... 27 more
-------------- next part --------------
2011-05-22 14:54:26,789 [IndexUpdater] ERROR jp.sf.fess.solr.IndexUpdater - IndexUpdater is terminated.
org.seasar.robot.dbflute.exception.SQLFailureException: Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The SQL failed to execute!
[Advice]
Please confirm the SQLException message.
[SQLState]
90112
[ErrorCode]
90112
[SQLException]
org.seasar.framework.exception.SSQLException
[ESSR0072]SQLで例外(SQL=[update ACCESS_RESULT set SESSION_ID = ?, RULE_ID = ?, URL = ?, PARENT_URL = ?, STATUS = ?, HTTP_STATUS_CODE = ?, METHOD = ?, MIME_TYPE = ?, CONTENT_LENGTH = ?, EXECUTION_TIME = ?, LAST_MODIFIED = ?, CREATE_TIME = ?
where ID = ?], Message=[90112], ErrorCode=90112, SQLState={3})が発生しました
[NextException]
org.h2.jdbc.JdbcBatchUpdateException
インデックス "PUBLIC.IDX_ACCESS_RESULT_SESSION_ID_AND_URL: ( /* key:19311 */ 19311, '20110522105012-1', 'defaultRule', 'file:/e:/hogehoge/fugafuga.zip', 'file:/e:/hogehoge/', 0, 200, 'GET', 'application/zip', 39038, 3, TIMESTAMP '2003-12-14 09:38:02.0', TIMESTAMP '2011-05-22 14:50:58.334')" から削除を試みましたが、行が見つかりません
Row not found when trying to delete from index "PUBLIC.IDX_ACCESS_RESULT_SESSION_ID_AND_URL: ( /* key:19311 */ 19311, '20110522105012-1', 'defaultRule', 'file:/e:/hogehoge/fugafuga.zip', 'file:/e:/hogehoge/', 0, 200, 'GET', 'application/zip', 39038, 3, TIMESTAMP '2003-12-14 09:38:02.0', TIMESTAMP '2011-05-22 14:50:58.334')"; SQL statement:
update ACCESS_RESULT set SESSION_ID = ?, RULE_ID = ?, URL = ?, PARENT_URL = ?, STATUS = ?, HTTP_STATUS_CODE = ?, METHOD = ?, MIME_TYPE = ?, CONTENT_LENGTH = ?, EXECUTION_TIME = ?, LAST_MODIFIED = ?, CREATE_TIME = ?
where ID = ? [90112-147]
[NextNextException]
org.h2.jdbc.JdbcSQLException
インデックス "PUBLIC.IDX_ACCESS_RESULT_SESSION_ID_AND_URL: ( /* key:19311 */ 19311, '20110522105012-1', 'defaultRule', 'file:/e:/hogehoge/fugafuga.zip', 'file:/e:/hogehoge/', 0, 200, 'GET', 'application/zip', 39038, 3, TIMESTAMP '2003-12-14 09:38:02.0', TIMESTAMP '2011-05-22 14:50:58.334')" から削除を試みましたが、行が見つかりません
Row not found when trying to delete from index "PUBLIC.IDX_ACCESS_RESULT_SESSION_ID_AND_URL: ( /* key:19311 */ 19311, '20110522105012-1', 'defaultRule', 'file:/e:/hogehoge/fugafuga.zip', 'file:/e:/hogehoge/', 0, 200, 'GET', 'application/zip', 39038, 3, TIMESTAMP '2003-12-14 09:38:02.0', TIMESTAMP '2011-05-22 14:50:58.334')"; SQL statement:
update ACCESS_RESULT set SESSION_ID = ?, RULE_ID = ?, URL = ?, PARENT_URL = ?, STATUS = ?, HTTP_STATUS_CODE = ?, METHOD = ?, MIME_TYPE = ?, CONTENT_LENGTH = ?, EXECUTION_TIME = ?, LAST_MODIFIED = ?, CREATE_TIME = ?
where ID = ? [90112-147]
[Statement]
org.seasar.extension.jdbc.impl.PreparedStatementWrapper
[Display SQL]
update ACCESS_RESULT set SESSION_ID = '20110522105012-1', RULE_ID = 'defaultRule', URL = 'file:/e:/hogehoge/bokaboka.zip', PARENT_URL = 'file:/e:/hogehoge/', STATUS = 9999, HTTP_STATUS_CODE = 200, METHOD = 'GET', MIME_TYPE = 'application/zip', CONTENT_LENGTH = 249805, EXECUTION_TIME = 18, LAST_MODIFIED = '2003-12-14 12:15:14.000', CREATE_TIME = '2011-05-22 14:50:59.050'
where ID = 19320
* * * * * * * * * */
at org.seasar.robot.dbflute.exception.handler.SQLExceptionHandler.throwSQLFailureException(SQLExceptionHandler.java:106)
at org.seasar.robot.dbflute.exception.handler.SQLExceptionHandler.handleSQLException(SQLExceptionHandler.java:75)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.handleSQLException(TnAbstractBasicSqlHandler.java:246)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnAbstractBatchHandler.executeBatch(TnAbstractBatchHandler.java:341)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnAbstractBatchHandler.executeBatch(TnAbstractBatchHandler.java:99)
at org.seasar.robot.dbflute.s2dao.sqlcommand.TnBatchUpdateDynamicCommand.doExecute(TnBatchUpdateDynamicCommand.java:65)
at org.seasar.robot.dbflute.s2dao.sqlcommand.TnUpdateEntityDynamicCommand.execute(TnUpdateEntityDynamicCommand.java:79)
at org.seasar.robot.dbflute.bhv.core.BehaviorCommandInvoker.executeSql(BehaviorCommandInvoker.java:339)
at org.seasar.robot.dbflute.bhv.core.BehaviorCommandInvoker.dispatchInvoking(BehaviorCommandInvoker.java:172)
at org.seasar.robot.dbflute.bhv.core.BehaviorCommandInvoker.invoke(BehaviorCommandInvoker.java:138)
at org.seasar.robot.dbflute.bhv.AbstractBehaviorReadable.invoke(AbstractBehaviorReadable.java:902)
at org.seasar.robot.db.bsbhv.BsAccessResultBhv.delegateBatchUpdateNonstrict(BsAccessResultBhv.java:1278)
at org.seasar.robot.db.bsbhv.BsAccessResultBhv.delegateBatchUpdate(BsAccessResultBhv.java:1270)
at org.seasar.robot.db.bsbhv.BsAccessResultBhv.doBatchUpdate(BsAccessResultBhv.java:760)
at org.seasar.robot.db.bsbhv.BsAccessResultBhv.batchUpdate(BsAccessResultBhv.java:753)
at org.seasar.robot.service.impl.DBDataServiceImpl.update(DBDataServiceImpl.java:223)
at org.seasar.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$470898b.$$update$$invokeSuperMethod$$(DBDataServiceImpl$$EnhancedByS2AOP$$470898b.java)
at org.seasar.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$470898b$$MethodInvocation$$update2.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 org.seasar.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$470898b$$MethodInvocation$$update2.proceed(MethodInvocationClassGenerator.java)
at org.seasar.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$470898b.update(DBDataServiceImpl$$EnhancedByS2AOP$$470898b.java)
at jp.sf.fess.solr.IndexUpdater.cleanupAccessResults(IndexUpdater.java:396)
at jp.sf.fess.solr.IndexUpdater.run(IndexUpdater.java:195)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[update ACCESS_RESULT set SESSION_ID = ?, RULE_ID = ?, URL = ?, PARENT_URL = ?, STATUS = ?, HTTP_STATUS_CODE = ?, METHOD = ?, MIME_TYPE = ?, CONTENT_LENGTH = ?, EXECUTION_TIME = ?, LAST_MODIFIED = ?, CREATE_TIME = ?
where ID = ?], Message=[90112], ErrorCode=90112, 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.executeBatch(PreparedStatementWrapper.java:191)
at org.seasar.robot.dbflute.s2dao.sqlhandler.TnAbstractBatchHandler.executeBatch(TnAbstractBatchHandler.java:339)
... 21 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: インデックス "PUBLIC.IDX_ACCESS_RESULT_SESSION_ID_AND_URL: ( /* key:19311 */ 19311, '20110522105012-1', 'defaultRule', 'file:/e:/hogehoge/fugafuga.zip', 'file:/e:/hogehoge/', 0, 200, 'GET', 'application/zip', 39038, 3, TIMESTAMP '2003-12-14 09:38:02.0', TIMESTAMP '2011-05-22 14:50:58.334')" から削除を試みましたが、行が見つかりません
Row not found when trying to delete from index "PUBLIC.IDX_ACCESS_RESULT_SESSION_ID_AND_URL: ( /* key:19311 */ 19311, '20110522105012-1', 'defaultRule', 'file:/e:/hogehoge/fugafuga.zip', 'file:/e:/hogehoge/', 0, 200, 'GET', 'application/zip', 39038, 3, TIMESTAMP '2003-12-14 09:38:02.0', TIMESTAMP '2011-05-22 14:50:58.334')"; SQL statement:
update ACCESS_RESULT set SESSION_ID = ?, RULE_ID = ?, URL = ?, PARENT_URL = ?, STATUS = ?, HTTP_STATUS_CODE = ?, METHOD = ?, MIME_TYPE = ?, CONTENT_LENGTH = ?, EXECUTION_TIME = ?, LAST_MODIFIED = ?, CREATE_TIME = ?
where ID = ? [90112-147]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1105)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeBatch(PreparedStatementWrapper.java:189)
... 22 more
2011-05-22 14:54:26,789 [IndexUpdater] INFO jp.sf.fess.solr.IndexUpdater - [EXEC TIME] index update time: 11584550ms