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 | 2 months ago
  1. 0

    GitHub comment 3560#253633091

    GitHub | 2 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]
  2. 0

    "org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from index" with Version 1.3.162

    Google Groups | 4 years ago | Sanjeev Gour
    org.h2.jdbc.JdbcSQLException: 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', X'aced000573720020636f6d2e63612e63686f7275732e74696d657365726965732e54534172726179018c63d06105fca80200054a0007656e6454696d654900066c656e6774684a0009737461727454696d654c000c636c6f636b4d656d656e746f74002a4c636f6d2f63612f63686f7275732f74696d657365726965732f6e756d657269632f4d656d656e746f3b4c000b646174614d656d656e746f71007e000178700000013dae1d7940000000390000013dad1d20407372003a636f6d2e63612e63686f7275732e74696d657365726965732e6e756d657269632e4e756d62657244656c74614f7574707574244d656d656e746f7390f51c1bf5d3fc0200014c00076d656d656e746f71007e0001787073720038636f6d2e63612e63686f7275732e74696d657365726965732e6e756d657269632e4e756d626572524c454f7574707574244d656d656e746ff49d0987111300c102000549000a63757272656e74496e744a000b63757272656e744c6f6e674900066c656e67746849000473697a654c00076d656d656e746f71007e000178700000000000000000000493e000000038000000437372003c636f6d2e63612e63686f7275732e74696d657365726965732e6e756d657269632e4e756d6265725061636b696e674f7574707574244d656d656e746f40a3b5b30dd1f4770c00007870770400000003737200106a6176612e7574696c2e4269745365746efd887e3934ab210200015b0004626974737400025b4a7870757200025b4a782004b512b1759302000078700000000413c39ed68e90205300000000000124f800000000000000000000000000000000787371007e00077704000000007371007e00097571007e000c000000080202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202000000000000000278')"; SQL statement: DELETE FROM timeseries.metric_data WHERE end_time < ? LIMIT 1000 [90112-168]
  3. 0

    GitHub comment 253#242234204

    GitHub | 3 months ago | cimba007
    java.sql.SQLException: Unable to run insert stmt on object MetricsDoubleTypeDevice(sensorVariable=SensorVariable(id=3, sensor=Sensor(id=2, sensorId=0, type=S_MOTION, name=, lastSeen=1472079176717, node=Node(id=2, eui=20, gatewayTable=GatewayTable(id=1, enabled=true, name=mosquitto, networkType=MY_SENSORS, timestamp=1472065324018, state=UP, statusMessage=Connected Successfully, statusSince=1472078288689, type=MQTT, properties={p=, u=, bh=tcp://localhost:1883, tp=mygateway-in, cid=mycontroller_mqtt_client, ts=mygateway-out}), name=MicrowaveTest, version=Aug 25 2016 | 00:52:22, type=S_ARDUINO_NODE, libVersion=2.0.0, batteryLevel=null, eraseConfig=null, firmware=null, state=UP, lastSeen=1472079174284, rssi=100%|100%, properties={}, parentNodeEui=0, registrationState=REGISTERED), room=null, variableTypes=[Variable 1, Variable 2]), variableType=V_VAR2, metricType=DOUBLE, timestamp=1472079176762, value=1.0, previousValue=4.0, unitType=U_NONE, readOnly=false, offset=0.0, priority=100, graphProperties={color=#ff7f0e, interpolate=linear, subType=line, useGlobal=true, type=lineChart}), timestamp=1472079176762, samples=1, min=1.0, max=1.0, avg=1.0, aggregationType=RAW, timestampFrom=null, timestampTo=null): INSERT INTO `metrics_double_type_device` (`sensorVariableId` ,`timestamp` ,`samples` ,`min` ,`max` ,`avg` ,`aggregationType` ) VALUES (?,?,?,?,?,?,?)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

    Google Groups | 3 months ago | Dave Anonymous
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: DELETE FROM ALARM_HISTORY [50200-192]
  6. 0

    Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

    Google Groups | 3 months ago | Dave Anonymous
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: DELETE FROM ALARM_HISTORY [50200-192]

    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.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