org.h2.message.DbException: File corrupted while reading record: "type: 202". Possible solution: use the recovery tool [90030-163] block: 0 storageId: 46 recordLength: 5 valueId: 4 -- dump: .... INSERT INTO O_46 VALUES(STRINGDECODE('\u0654q8\u02ac-xM/\u07e0\u7900\u04d7'), X'30d9441622ef', 2, NULL) [21002-163]

nabble.com | 4 months ago
  1. 0

    H2 Database - recovery tool issues

    nabble.com | 4 months ago
    org.h2.message.DbException: File corrupted while reading record: "type: 202". Possible solution: use the recovery tool [90030-163] block: 0 storageId: 46 recordLength: 5 valueId: 4 -- dump: .... INSERT INTO O_46 VALUES(STRINGDECODE('\u0654q8\u02ac-xM/\u07e0\u7900\u04d7'), X'30d9441622ef', 2, NULL) [21002-163]
  2. 0

    recovery tool issues

    Google Groups | 4 years ago | naseh
    org.h2.message.DbException: File corrupted while reading record: "type: 202". Possible solution: use the recovery tool [90030-163] block: 0 storageId: 46 recordLength: 5 valueId: 4 -- dump: .... INSERT INTO O_46 VALUES(STRINGDECODE('\u0654q8\u02ac-xM/\u07e0\u7900\u04d7'), X'30d9441622ef', 2, NULL) [21002-163]
  3. 0

    GitHub comment 193#45418501

    GitHub | 2 years ago | shilad
    org.h2.message.DbException: IO Exception: "java.io.IOException: File not found: ../integration-tests/backup/redirect.zip"; "../integration-tests/backup/redirect.zip" [90031-174]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MVCC + Multithreaded

    Google Groups | 2 years ago | Rami Ojares
    org.h2.message.DbException: IO Exception: ""java.io.IOException: java.nio.BufferUnderflowException"" [90028-186]"; "lob: null table: -3 id: 21742" [90031-186]
  6. 0

    H2 corrupted DB

    Google Groups | 2 years ago | Osvaldas Ziukas
    org.h2.message.DbException: General error: "java.lang.IllegalStateException: Reading from cache:nio:/home/gmps/mobile/database/localDb_v3.66.mv.db failed; file length 589824 read length 384 at 639611 [1.4.187/1]" [50000-187]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.h2.message.DbException

      File corrupted while reading record: "type: 202". Possible solution: use the recovery tool [90030-163] block: 0 storageId: 46 recordLength: 5 valueId: 4 -- dump: .... INSERT INTO O_46 VALUES(STRINGDECODE('\u0654q8\u02ac-xM/\u07e0\u7900\u04d7'), X'30d9441622ef', 2, NULL) [21002-163]

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      RunScript.main
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      2. org.h2.message.DbException.get(DbException.java:169)
      3. org.h2.message.DbException.get(DbException.java:146)
      4. org.h2.message.DbException.get(DbException.java:135)
      5. org.h2.command.dml.Insert.prepare(Insert.java:226)
      6. org.h2.command.Parser.prepareCommand(Parser.java:218)
      7. org.h2.engine.Session.prepareLocal(Session.java:415)
      8. org.h2.engine.Session.prepareCommand(Session.java:364)
      9. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1121)
      10. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:164)
      11. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
      12. org.h2.tools.RunScript.process(RunScript.java:253)
      13. org.h2.tools.RunScript.process(RunScript.java:186)
      14. org.h2.tools.RunScript.process(RunScript.java:317)
      15. org.h2.tools.RunScript.runTool(RunScript.java:140)
      16. org.h2.tools.RunScript.main(RunScript.java:68)
      16 frames