(from osdn.net/users/kou22005)
初めて投稿させて頂きます。よろしくお願い致します。
Fess9.4(H2 Database)を利用し、2ヶ月ほど運用させて頂いております。ファイルシステムクロールのジョブログで以下のエラーが出ており、その後ジョブが停止してしまっていたのですが、どのようなエラーなのか、どのように対策すべきか、ご教授頂けますと幸いです。
2015-09-01 08:50:30,947 [Robot-20150901063001-1-13] ERROR Crawling Exception at file:/Z:/…xxxx.docx
org.codelibs.robot.dbflute.exception.SQLFailureException: Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Failed to bind the value.
[Advice]
Read the SQLException message.
[SQLState]
90007
[ErrorCode]
90007
[SQLException]
org.seasar.framework.exception.SSQLException
[ESSR0072]SQLで例外(SQL=[insert into ACCESS_RESULT_DATA (ID, TRANSFORMER_NAME, DATA, ENCODING)
values (?, ?, ?, ?)], Message=[90007], ErrorCode=90007, SQLState={3})が発生しました
[NextException]
org.h2.jdbc.JdbcSQLException
オブジェクトはすでに閉じられています
The object is already closed [90007-181]
[Bound Value]
[B@16eac28
[Behavior]
DBDataServiceImpl.store():78 -> AccessResultDataBhv.insert()
[Display SQL]
insert into ACCESS_RESULT_DATA (ID, TRANSFORMER_NAME, DATA, ENCODING)
values (46937, ‘fessTikaTransformer’, ‘[B@16eac28’, ‘UTF-8’)
-
-
-
-
-
-
-
-
- */
at org.codelibs.robot.dbflute.exception.handler.SQLExceptionHandler.throwSQLFailureException(SQLExceptionHandler.java:106)
at org.codelibs.robot.dbflute.exception.handler.SQLExceptionHandler.handleSQLException(SQLExceptionHandler.java:63)
at org.codelibs.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.handleSQLException(TnAbstractBasicSqlHandler.java:370)
at org.codelibs.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.bindArgs(TnAbstractBasicSqlHandler.java:121)
at org.codelibs.robot.dbflute.s2dao.sqlhandler.TnAbstractEntityHandler.execute(TnAbstractEntityHandler.java:102)
at org.codelibs.robot.dbflute.s2dao.sqlhandler.TnAbstractEntityHandler.execute(TnAbstractEntityHandler.java:88)
at org.codelibs.robot.dbflute.s2dao.sqlcommand.TnInsertEntityDynamicCommand.doExecute(TnInsertEntityDynamicCommand.java:84)
at org.codelibs.robot.dbflute.s2dao.sqlcommand.TnInsertEntityDynamicCommand.execute(TnInsertEntityDynamicCommand.java:60)
at org.codelibs.robot.dbflute.bhv.core.BehaviorCommandInvoker.executeSql(BehaviorCommandInvoker.java:414)
at org.codelibs.robot.dbflute.bhv.core.BehaviorCommandInvoker.dispatchInvoking(BehaviorCommandInvoker.java:233)
at org.codelibs.robot.dbflute.bhv.core.BehaviorCommandInvoker.invoke(BehaviorCommandInvoker.java:159)
at org.codelibs.robot.dbflute.bhv.AbstractBehaviorReadable.invoke(AbstractBehaviorReadable.java:1324)
at org.codelibs.robot.db.bsbhv.BsAccessResultDataBhv.delegateInsert(BsAccessResultDataBhv.java:1442)
at org.codelibs.robot.db.bsbhv.BsAccessResultDataBhv.doInsert(BsAccessResultDataBhv.java:593)
at org.codelibs.robot.db.bsbhv.BsAccessResultDataBhv.insert(BsAccessResultDataBhv.java:586)
at org.codelibs.robot.service.impl.DBDataServiceImpl.store(DBDataServiceImpl.java:78)
at org.codelibs.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$745d7.$$store$$invokeSuperMethod$$(DBDataServiceImpl$$EnhancedByS2AOP$$745d7.java)
at org.codelibs.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$745d7$$MethodInvocation$$store3.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.codelibs.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$745d7$$MethodInvocation$$store3.proceed(MethodInvocationClassGenerator.java)
at org.codelibs.robot.service.impl.DBDataServiceImpl$$EnhancedByS2AOP$$745d7.store(DBDataServiceImpl$$EnhancedByS2AOP$$745d7.java)
at org.codelibs.robot.processor.impl.DefaultResponseProcessor.processResult(DefaultResponseProcessor.java:132)
at org.codelibs.robot.processor.impl.DefaultResponseProcessor.process(DefaultResponseProcessor.java:83)
at org.codelibs.robot.S2RobotThread.processResponse(S2RobotThread.java:401)
at org.codelibs.robot.S2RobotThread.run(S2RobotThread.java:190)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[insert into ACCESS_RESULT_DATA (ID, TRANSFORMER_NAME, DATA, ENCODING)
values (?, ?, ?, ?)], Message=[90007], ErrorCode=90007, 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.setBinaryStream(PreparedStatementWrapper.java:408)
at org.codelibs.robot.dbflute.s2dao.valuetype.basic.BinaryType.bindValue(BinaryType.java:90)
at org.codelibs.robot.dbflute.s2dao.sqlhandler.TnAbstractBasicSqlHandler.bindArgs(TnAbstractBasicSqlHandler.java:113)
… 24 more
Caused by: org.h2.jdbc.JdbcSQLException: オブジェクトはすでに閉じられています
The object is already closed [90007-181]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.store.LobStorageMap.createBlob(LobStorageMap.java:128)
at org.h2.jdbc.JdbcConnection.createBlob(JdbcConnection.java:1827)
at org.h2.jdbc.JdbcPreparedStatement.setBinaryStream(JdbcPreparedStatement.java:920)
at org.h2.jdbc.JdbcPreparedStatement.setBinaryStream(JdbcPreparedStatement.java:943)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.setBinaryStream(PreparedStatementWrapper.java:406)
… 26 more
- */
-
-
-
-
-
-
-