Backup cause Internal Server Error - java.io.IOException: This archives contains unclosed entries. #964
Comments
|
データサイズを見ると、何かおかしい気がしますね。 本稼働させる場合は、組み込みDBではなく、PostgreSQLに切り替えを推奨しています。 PostgreSQLへの切り替えは以下の情報を参照願います。 https://service-knowledge.support-project.org/open.knowledge/view/45 |
|
ご回答ありがとうございます。PostgreSQLへの移行作業を試してみたいと思います。 参考までに org.h2.tools.Recover の実行結果http://www.h2database.com/html/advanced.html#using_recover_tool Version: 1.4.196 の場合Ver.1.4.183 の場合 (${tomcat}/webapps/knowledge/WEB-INF/lib以下にあったもの)
knowledge_db.mv.txtの中身※1.4.183, 1.4.196両方同じ出力
|
|
PosgtgreSQLへの移行ですが、画面上はForbiddenエラーが発生し移行が完了できません。 h2 databeseが起因の問題と思われ、関連するissueは以下ではないかと感じています DataのExportは成功するので、現状Import機能頼み or h2 databaseの上記issueの対応頼みの状況です。 当面は、破損したDBのKnowledgeはReadOnlyの運用にして、別のKnowledgeを建てようかと思っています。 |
|
1.10 -> 1.12 migration cause error below.
service database version: 1.11.1 latest database version: 1.12.1 at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48) at org.support.project.aop.Intercepter.invoke(Intercepter.java:182) at org.support.project.knowledge.dao.KnowledgesDao_$$_jvst475_3.executeQueryList(KnowledgesDao_$$_jvst475_3.java) at org.support.project.knowledge.dao.gen.GenKnowledgesDao.selectAllWidthPager(GenKnowledgesDao.java:136) at org.support.project.knowledge.dao.KnowledgesDao_$$_jvst475_3._d50selectAllWidthPager(KnowledgesDao_$$_jvst475_3.java) at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48) at org.support.project.aop.Intercepter.invoke(Intercepter.java:174) at org.support.project.knowledge.dao.KnowledgesDao_$$_jvst475_3.selectAllWidthPager(KnowledgesDao_$$_jvst475_3.java) at org.support.project.knowledge.logic.AggregateLogic.doSetViewCountToKnowledge(AggregateLogic.java:460) at org.support.project.knowledge.logic.AggregateLogic_$$_jvst475_2._d18doSetViewCountToKnowledge(AggregateLogic_$$_jvst475_2.java) at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48) at org.support.project.aop.Intercepter.invoke(Intercepter.java:174) at org.support.project.knowledge.logic.AggregateLogic_$$_jvst475_2.doSetViewCountToKnowledge(AggregateLogic_$$_jvst475_2.java) at org.support.project.knowledge.logic.AggregateLogic.doSetViewCountToKnowledge(AggregateLogic.java:110) at org.support.project.knowledge.logic.AggregateLogic_$$_jvst475_2._d17doSetViewCountToKnowledge(AggregateLogic_$$_jvst475_2.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.support.project.ormapping.transaction.Transaction.invoke(Transaction.java:48) at org.support.project.aop.Intercepter.invoke(Intercepter.java:174) at org.support.project.knowledge.logic.AggregateLogic_$$_jvst475_2.doSetViewCountToKnowledge(AggregateLogic_$$_jvst475_2.java) at org.support.project.knowledge.logic.AggregateLogic.startAggregate(AggregateLogic.java:69) at org.support.project.knowledge.logic.AggregateLogic_$$_jvst475_2._d28startAggregate(AggregateLogic_$$_jvst475_2.java) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.support.project.aop.Intercepter.invoke(Intercepter.java:192) at org.support.project.knowledge.logic.AggregateLogic_$$_jvst475_2.startAggregate(AggregateLogic_$$_jvst475_2.java) at org.support.project.knowledge.deploy.v1_11_0.Migrate_1_11_2.doMigrate(Migrate_1_11_2.java:21) at org.support.project.knowledge.deploy.InitDB.doMigrate(InitDB.java:195) at org.support.project.knowledge.deploy.InitDB.start(InitDB.java:189) at org.support.project.knowledge.deploy.InitDB.main(InitDB.java:111) Caused by: org.h2.jdbc.JdbcSQLException: 入出力例外: "java.io.IOException: org.h2.message.DbException: 入出力例外: ""java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]"" IO Exception: ""java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]"" [90028-196]"; "lob: null table: -3 id: 9198816" IO Exception: "java.io.IOException: org.h2.message.DbException: 入出力例外: ""java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]"" IO Exception: ""java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]"" [90028-196]"; "lob: null table: -3 id: 9198816" [90031-196] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convertIOException(DbException.java:330) at org.h2.value.ValueLobDb.getString(ValueLobDb.java:296) at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:314) at org.support.project.ormapping.common.ResultSetLoader.load(ResultSetLoader.java:104) ... 62 more Caused by: java.io.IOException: org.h2.message.DbException: 入出力例外: "java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]" IO Exception: "java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]" [90028-196] at org.h2.message.DbException.convertToIOException(DbException.java:364) at org.h2.store.LobStorageRemoteInputStream.read(LobStorageRemoteInputStream.java:73) at java.io.BufferedInputStream.read1(BufferedInputStream.java:284) at java.io.BufferedInputStream.read(BufferedInputStream.java:345) at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284) at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326) at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178) at java.io.InputStreamReader.read(InputStreamReader.java:184) at java.io.BufferedReader.fill(BufferedReader.java:161) at java.io.BufferedReader.read1(BufferedReader.java:212) at java.io.BufferedReader.read(BufferedReader.java:286) at org.h2.util.IOUtils.copyAndCloseInput(IOUtils.java:216) at org.h2.util.IOUtils.readStringAndClose(IOUtils.java:323) at org.h2.value.ValueLobDb.getString(ValueLobDb.java:286) ... 64 more Caused by: org.h2.message.DbException: 入出力例外: "java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]" IO Exception: "java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]" [90028-196] at org.h2.message.DbException.convert(DbException.java:283) at org.h2.engine.SessionRemote.done(SessionRemote.java:636) at org.h2.engine.SessionRemote.readLob(SessionRemote.java:786) at org.h2.store.LobStorageRemoteInputStream.read(LobStorageRemoteInputStream.java:71) ... 76 more Caused by: org.h2.jdbc.JdbcSQLException: 入出力例外: "java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]" IO Exception: "java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50]" [90028-196] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:287) at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:220) at org.h2.server.TcpServerThread.run(TcpServerThread.java:160) at java.lang.Thread.run(Thread.java:745) Caused by: java.io.IOException: Block not found in id [1, -49, 2, -115, 102] [1.4.196/50] at org.h2.mvstore.StreamStore$Stream.read(StreamStore.java:515) at java.io.FilterInputStream.read(FilterInputStream.java:133) at org.h2.server.TcpServerThread$CachedInputStream.read(TcpServerThread.java:561) at org.h2.util.IOUtils.readFully(IOUtils.java:345) at org.h2.server.TcpServerThread.process(TcpServerThread.java:472) at org.h2.server.TcpServerThread.run(TcpServerThread.java:158) ... 1 more Caused by: java.lang.IllegalStateException: Block 13069 not found [1.4.196/50] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765) at org.h2.mvstore.StreamStore.getBlock(StreamStore.java:437) at org.h2.mvstore.StreamStore$Stream.nextBuffer(StreamStore.java:552) at org.h2.mvstore.StreamStore$Stream.read(StreamStore.java:509) ... 6 more at org.h2.engine.SessionRemote.done(SessionRemote.java:629) ... 78 more Processing has been completed. [status]1 |
|
Thank you for your detailed information. I think that it problem from H2Database. 詳細な情報をありがとうございます。組み込みDBに使っているH2Databaseに問題があるようですね。 |
|
Thank you for your reply. I want you to consider to develop below functions.
|
|
I will provide a feature to ignore errors during data migration to Postgres. |
|
Thank you for your reply.
Yes. I think it's enough to try next step to recover our knowledge. Thank you very much again for your proposal. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
データベースのバックアップが失敗します。
ちなみに
knowledge_db.mv.dbは、14.27 GB
投稿数は140と、投稿数の割にデータ量が大きい感があります
動作環境は
OS X Yosemite (10.10.5)
Memory: 16GB
空き: 98.14GB
The text was updated successfully, but these errors were encountered: