org.h2.jdbc.JdbcSQLException: Feature not supported: "Restore page store recovery SQL script can only be restored to a PageStore file"; SQL statement: INSERT INTO O_149 VALUES(410165, '76b7e4b2-f05-ea5be9262d', 0, READ_CLOB_DB(1579471, 280), '', 'completed', TIMESTAMP '2016-10-03 18:55:26.985', TIMESTAMP '2016-10-03 18:55:28.994', 2009, '', '', 1, '{}', NULL, '', 10, -1303851243) -- (410165, '76b7e4b2-ad-eb7a5be9262d', 0, PUBLIC.READ_CLOB_DB(15771, 280), '', 'completed', TIMESTAMP '2016-10-03 18:55:26.985', TIMESTAMP '2016-10-03 18:55:28.994', 2009, '', '', 1, '{}', NULL, '', 10, -1303851243) [50100-192]

GitHub | pratapsingh | 6 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    GitHub comment 3560#253633091

    GitHub | 6 months ago | pratapsingh
    org.h2.jdbc.JdbcSQLException: Feature not supported: "Restore page store recovery SQL script can only be restored to a PageStore file"; SQL statement: INSERT INTO O_149 VALUES(410165, '76b7e4b2-f05-ea5be9262d', 0, READ_CLOB_DB(1579471, 280), '', 'completed', TIMESTAMP '2016-10-03 18:55:26.985', TIMESTAMP '2016-10-03 18:55:28.994', 2009, '', '', 1, '{}', NULL, '', 10, -1303851243) -- (410165, '76b7e4b2-ad-eb7a5be9262d', 0, PUBLIC.READ_CLOB_DB(15771, 280), '', 'completed', TIMESTAMP '2016-10-03 18:55:26.985', TIMESTAMP '2016-10-03 18:55:28.994', 2009, '', '', 1, '{}', NULL, '', 10, -1303851243) [50100-192]

    Root Cause Analysis

    1. org.h2.jdbc.JdbcSQLException

      Feature not supported: "Restore page store recovery SQL script can only be restored to a PageStore file"; SQL statement: INSERT INTO O_149 VALUES(410165, '76b7e4b2-f05-ea5be9262d', 0, READ_CLOB_DB(1579471, 280), '', 'completed', TIMESTAMP '2016-10-03 18:55:26.985', TIMESTAMP '2016-10-03 18:55:28.994', 2009, '', '', 1, '{}', NULL, '', 10, -1303851243) -- (410165, '76b7e4b2-ad-eb7a5be9262d', 0, PUBLIC.READ_CLOB_DB(15771, 280), '', 'completed', TIMESTAMP '2016-10-03 18:55:26.985', TIMESTAMP '2016-10-03 18:55:28.994', 2009, '', '', 1, '{}', NULL, '', 10, -1303851243) [50100-192]

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      Recover.readClobDb
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
      2. org.h2.message.DbException.get(DbException.java:179)
      3. org.h2.message.DbException.get(DbException.java:155)
      4. org.h2.tools.Recover.verifyPageStore(Recover.java:227)
      5. org.h2.tools.Recover.readClobDb(Recover.java:239)
      5 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    4. H2 Database Engine
      RunScript.main
      1. org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:481)
      2. org.h2.expression.JavaFunction.getValue(JavaFunction.java:38)
      3. org.h2.command.dml.Insert.insertRows(Insert.java:143)
      4. org.h2.command.dml.Insert.update(Insert.java:114)
      5. org.h2.command.CommandContainer.update(CommandContainer.java:98)
      6. org.h2.command.Command.executeUpdate(Command.java:258)
      7. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
      8. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
      9. org.h2.tools.RunScript.process(RunScript.java:260)
      10. org.h2.tools.RunScript.process(RunScript.java:190)
      11. org.h2.tools.RunScript.process(RunScript.java:328)
      12. org.h2.tools.RunScript.runTool(RunScript.java:141)
      13. org.h2.tools.RunScript.main(RunScript.java:68)
      13 frames