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]

Samebug tips1

Check if you're not creating unused SQL entities, as it might cause this exception.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web1474

  • via GitHub by pratapsingh
    , 9 months ago
    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
  • Row not found when trying to delete from index "TIMESERIES.IDX_METRIC_DATA_START_TIME*: ( /* key:18158 */ 43848, TIMESTAMP '2013-03-27 18:30:00.0', TIMESTAMP '2013-03-27 23:10:00.0
  • NULL not allowed for column "ID"; SQL statement: INSERT INTO systemuser (systemuseridnr, editby, failedloginattempts, firstname, lastedittime, lastfailedlogindate, lastlogindate, lastname, systemusername, password, phone, statusnr
  • Stack trace

    • 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(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.tools.Recover.verifyPageStore(Recover.java:227) at org.h2.tools.Recover.readClobDb(Recover.java:239) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:481) at org.h2.expression.JavaFunction.getValue(JavaFunction.java:38) at org.h2.command.dml.Insert.insertRows(Insert.java:143) at org.h2.command.dml.Insert.update(Insert.java:114) at org.h2.command.CommandContainer.update(CommandContainer.java:98) at org.h2.command.Command.executeUpdate(Command.java:258) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158) at org.h2.tools.RunScript.process(RunScript.java:260) at org.h2.tools.RunScript.process(RunScript.java:190) at org.h2.tools.RunScript.process(RunScript.java:328) at org.h2.tools.RunScript.runTool(RunScript.java:141) at org.h2.tools.RunScript.main(RunScript.java:68)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 2 weeks ago
    6 times, 2 weeks ago
    34 times, 1 month ago
    4 times, 1 month ago
    Unknown user
    Once, 1 month ago
    143 more bugmates