I am curious what might be the reason to try the addition of
MV_Store=FALSE to your connection URL,
but that option has been removed a while ago (at v. 1.4.200 ?), and MVStore
is the only storage engine available in H2.
On Monday, July 11, 2022 at 11:43:47 AM UTC-4 ronjos...@gmail.com wrote:
> Hello ,
>
> I am working with the H2 2.1.214 and I want to add MV_Store=FALSE to my
> JDBC Connection string.
> can you please tell me how its done ?
>
> Currently I am adding it
>
>
> jdbc:h2:file:databasePath/dbName;MV_STORE=FALSE;LOCK_TIMEOUT=1800000;MAX_COMPACT_TIME=10000
>
> and it is giving me ' General error:
> "java.lang.UnsupportedOperationException"'.
> Thanks
> On Thursday, June 23, 2022 at 10:44:43 AM UTC+5:30 kapoor.s...@gmail.com
> wrote:
>
>> I have some more logs. please see below
>>
>>
>> 2022-06-23 08:43:23 database: disconnecting session #3
>> 2022-06-23 08:43:23 database: closing /Volumes/Macintosh HD -
>> Data/Projects/informixhq-server/server/h2db
>> 2022-06-23 08:43:23 lock: 2 shared read unlock SYS
>> 2022-06-23 08:43:23 lock: 1 shared read unlock SYS
>> 2022-06-23 08:43:23 database: closed
>> 2022-06-23 08:43:23 database: disconnected session #3
>> 2022-06-23 08:43:23 database: opening /Volumes/Macintosh HD -
>> Data/Projects/informixhq-server/server/h2db (build 210)
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for SYS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for
>> INFORMIX_SERVER_GROUPS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVER_GROUPS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SYSTEM_REPORTS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for SYSTEM_REPORTS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for ALERTING_INCIDENTS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for ALERTING_INCIDENTS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USERS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for USERS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for SENSOR_TYPES
>> 2022-06-23 08:43:23 lock: 1 exclusive added for SENSOR_TYPES
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for
>> ALERTING_CRITERIA_VIOLATIONS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for
>> ALERTING_CRITERIA_VIOLATIONS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_PERMISSIONS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_PERMISSIONS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for
>> USER_ALERT_MESSENGERS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_MESSENGERS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for DASHBOARDS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for DASHBOARDS
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for USER_ALERT_SERVICES
>> 2022-06-23 08:43:23 lock: 1 exclusive added for USER_ALERT_SERVICES
>> 2022-06-23 08:43:23 lock: 1 exclusive requesting for INFORMIX_SERVERS
>> 2022-06-23 08:43:23 lock: 1 exclusive added for INFORMIX_SERVERS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock SYS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVER_GROUPS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock SYSTEM_REPORTS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_INCIDENTS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock USERS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock SENSOR_TYPES
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock ALERTING_CRITERIA_VIOLATIONS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_PERMISSIONS
>> *2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_MESSENGERS *
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock DASHBOARDS
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock USER_ALERT_SERVICES
>> 2022-06-23 08:43:23 lock: 1 exclusive unlock INFORMIX_SERVERS
>> 2022-06-23 08:43:23 database: opened /Volumes/Macintosh HD -
>> Data/Projects/informixhq-server/server/h2db
>> 2022-06-23 08:43:23 database: connecting session #3 to /Volumes/Macintosh
>> HD - Data/Projects/informixhq-server/server/h2db
>> 2022-06-23 08:43:23 jdbc[3]:
>> /*SQL */SET TRACE_LEVEL_FILE 3;
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/Connection conn2679 =
>> DriverManager.getConnection("jdbc:h2:file:./h2db;TRACE_LEVEL_FILE=3", "",
>> "");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/PreparedStatement prep947 = conn2679.prepareStatement("update
>> informix_servers set alias = ?, hostname = ?, service_name = ?, port = ?,
>> monitor_user = ?, monitor_password = ?, admin_user = ?, admin_password = ?,
>> group_id = ?, profile = ?, alerts = ?, properties = ?, agent_config = ?,
>> password_secret_Key = ?, server_type = ? where id = 11");
>> 2022-06-23 08:43:23 jdbc[3]: Table : potential plan item cost
>> 10,390 index PUBLIC.INFORMIX_SERVERS.tableScan
>> 2022-06-23 08:43:23 jdbc[3]: Table : potential plan item cost
>> 230 index PUBLIC.PRIMARY_KEY_3
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(1, "FUN1");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(2, "localhost");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(3, null);
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setObject(4, x);
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(5, "informix");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(6,
>> "47E8rRcSCgt12fTZ3b60sZrLVx911PoDS7YrFYHU43QiR3t/1A==");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(7, "informix");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setString(8,
>> "z+owAPTcqQE7qx1sX5Ij2qDXiQl2QdNeEXTQJ0Pz61iPvb61FQ==");
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setLong(9, 0L);
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setBytes(10,
>> org.h2.util.StringUtils.convertHexToBytes("ae0200000473656e736f727300a0020000033000610000000274797065001700000068615f7472616e73616374696f6e5f6c6174656e6379001272756e496e74657276616c000f000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000100033100550000000274797065000b00000068615f6c616774696d65001272756e496e74657276616c003c000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c65640001000332005e0000000274797065001400000068615f6c6f676963616c5f6c6f675f72617465001272756e496e74657276616c000f000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c65640001000333005f0000000274797065001500000068615f636f6e6e656374696f6e5f737461747573001272756e496e74657276616c003c000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000100033400650000000274797065001b00000068615f617070726f78696d6174655f6c6f675f6261636b6c6f67001272756e496e74657276616c000f000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000100033500580000000274797065000e00000068615f6170706c795f72617465001272756e496e74657276616c0005000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000000033600560000000274797065000c00000068615f776f726b6c6f6164001272756e496e74657276616c003c000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c65640001000000"));
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setBytes(11,
>> org.h2.util.StringUtils.convertHexToBytes("2100000004616c657274730005000000000464697361626c656400050000000000"));
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setBytes(12,
>> org.h2.util.StringUtils.convertHexToBytes("0500000000"));
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setBytes(13,
>> org.h2.util.StringUtils.convertHexToBytes("50000000127265706f7369746f72795365727665724964000100000000000000026461746162617365000600000068716d6f6e000a6167656e74436f6e6e656374696f6e50726f706572746965730000"));
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setObject(14, x);
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.setObject(15, x);
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.executeUpdate();
>> 2022-06-23 08:43:23 lock: 3 shared write requesting for INFORMIX_SERVERS
>> 2022-06-23 08:43:23 lock: 3 shared write ok INFORMIX_SERVERS
>> 2022-06-23 08:43:23 jdbc[3]:
>> /*SQL l:284 #:1 t:1*/update informix_servers set alias = ?, hostname = ?,
>> service_name = ?, port = ?, monitor_user = ?, monitor_password = ?,
>> admin_user = ?, admin_password = ?, group_id = ?, profile = ?, alerts = ?,
>> properties = ?, agent_config = ?, password_secret_Key = ?, server_type = ?
>> where id = 11 {1: 'FUN1', 2: 'localhost', 3: NULL, 4: 6090, 5: 'informix',
>> 6: '47E8rRcSCgt12fTZ3b60sZrLVx911PoDS7YrFYHU43QiR3t/1A==', 7: 'informix',
>> 8: 'z+owAPTcqQE7qx1sX5Ij2qDXiQl2QdNeEXTQJ0Pz61iPvb61FQ==', 9: CAST(0 AS
>> BIGINT), 10:
>> X'ae0200000473656e736f727300a0020000033000610000000274797065001700000068615f7472616e73616374696f6e5f6c6174656e6379001272756e496e74657276616c000f000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000100033100550000000274797065000b00000068615f6c616774696d65001272756e496e74657276616c003c000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c65640001000332005e0000000274797065001400000068615f6c6f676963616c5f6c6f675f72617465001272756e496e74657276616c000f000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c65640001000333005f0000000274797065001500000068615f636f6e6e656374696f6e5f737461747573001272756e496e74657276616c003c000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000100033400650000000274797065001b00000068615f617070726f78696d6174655f6c6f675f6261636b6c6f67001272756e496e74657276616c000f000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000100033500580000000274797065000e00000068615f6170706c795f72617465001272756e496e74657276616c0005000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c6564000000033600560000000274797065000c00000068615f776f726b6c6f6164001272756e496e74657276616c003c000000000000001064617461526574656e74696f6e496e74657276616c001e0000000864697361626c65640001000000',
>>
>> 11: X'2100000004616c657274730005000000000464697361626c656400050000000000',
>> 12: X'0500000000', 13:
>> X'50000000127265706f7369746f72795365727665724964000100000000000000026461746162617365000600000068716d6f6e000a6167656e74436f6e6e656374696f6e50726f706572746965730000',
>>
>> 14:
>> CAST(X'aced00057372001f6a617661782e63727970746f2e737065632e5365637265744b6579537065635b470b66e230614d0200024c0009616c676f726974686d7400124c6a6176612f6c616e672f537472696e673b5b00036b65797400025b427870740003414553757200025b42acf317f8060854e0020000787000000010150d49c6152ac53bf23ea2daff16dbda'
>>
>> AS JAVA_OBJECT), 15:
>> X'2b000000027365727665725479706500090000005374616e6461726400086973526561644f6e6c79000000'};
>> 2022-06-23 08:43:23 lock: 3 shared write unlock INFORMIX_SERVERS
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/prep947.close();
>>
>>
>>
>>
>> 2022-06-23 08:43:23 jdbc[3]:
>> /**/conn2679.close();
>> 2022-06-23 08:43:23 lock: 3 shared read unlock SYS
>> 2022-06-23 08:43:23 database: disconnecting session #3
>> 2022-06-23 08:43:23 database: closing /Volumes/Macintosh HD -
>> Data/Projects/informixhq-server/server/h2db
>> 2022-06-23 08:43:23 lock: 2 shared read unlock SYS
>> 2022-06-23 08:43:23 lock: 1 shared read unlock SYS
>> 2022-06-23 08:43:24 database: closed
>> 2022-06-23 08:43:24 database: disconnected session #3
>> 2022-06-23 08:43:29 database: opening /Volumes/Macintosh HD -
>> Data/Projects/informixhq-server/server/h2db (build 210)
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for SYS
>> 2022-06-23 08:43:29 lock: 1 exclusive added for SYS
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for
>> INFORMIX_SERVER_GROUPS
>> 2022-06-23 08:43:29 lock: 1 exclusive added for INFORMIX_SERVER_GROUPS
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for INFORMIX_SERVERS
>> 2022-06-23 08:43:29 lock: 1 exclusive added for INFORMIX_SERVERS
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for SYSTEM_REPORTS
>> 2022-06-23 08:43:29 lock: 1 exclusive added for SYSTEM_REPORTS
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for ALERTING_INCIDENTS
>> 2022-06-23 08:43:29 lock: 1 exclusive added for ALERTING_INCIDENTS
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for USERS
>> 2022-06-23 08:43:29 lock: 1 exclusive added for USERS
>> 2022-06-23 08:43:29 lock: 1 exclusive requesting for SENSOR_TYPES
>> 2022-06-23 08:43:29 lock: 1 exclusive added for SENSOR_TYPES
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock SYS
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock INFORMIX_SERVER_GROUPS
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock INFORMIX_SERVERS
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock SYSTEM_REPORTS
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock ALERTING_INCIDENTS
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock USERS
>> 2022-06-23 08:43:29 lock: 1 exclusive unlock SENSOR_TYPES
>> 2022-06-23 08:43:29 database: opened /Volumes/Macintosh HD -
>> Data/Projects/informixhq-server/server/h2db
>> 2022-06-23 08:43:29 database: connecting session #3 to /Volumes/Macintosh
>> HD - Data/Projects/informixhq-server/server/h2db
>> 2022-06-23 08:43:29 jdbc[3]:
>> /*SQL */SET TRACE_LEVEL_FILE 3;
>> 2022-06-23 08:43:29 jdbc[3]:
>> /**/Connection conn2680 =
>> DriverManager.getConnection("jdbc:h2:file:./h2db;TRACE_LEVEL_FILE=3", "",
>> "");
>> 2022-06-23 08:43:29 jdbc[3]:
>> /**/Statement stat1734 = conn2680.createStatement();
>> 2022-06-23 08:43:29 jdbc[3]:
>> /**/ResultSet rs1747 = stat1734.executeQuery("select a.id,
>> a.when_created, a.state, b.meta, a.informix_server_id, c.alias from
>> alerting_incidents a join alerting_criteria_violations b on a.id =
>> b.alerting_incident_id, informix_servers c where a.informix_server_id =
>> c.id and a.informix_server_id = 11 order by a.when_created desc ");
>> 2022-06-23 08:43:29 jdbc[3]: exception
>> org.h2.jdbc.JdbcSQLSyntaxErrorException: Table
>> "ALERTING_CRITERIA_VIOLATIONS" not found; SQL statement:
>> select a.id, a.when_created, a.state, b.meta, a.informix_server_id,
>> c.alias from alerting_incidents a join alerting_criteria_violations b on
>> a.id = b.alerting_incident_id, informix_servers c where
>> a.informix_server_id = c.id and a.informix_server_id = 11 order by
>> a.when_created desc [42102-210]
>> at
>> org.h2.message.DbException.getJdbcSQLException(DbException.java:521)
>> at
>> org.h2.message.DbException.getJdbcSQLException(DbException.java:496)
>> at org.h2.message.DbException.get(DbException.java:227)
>> at org.h2.message.DbException.get(DbException.java:203)
>> at
>> org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8410)
>> at
>> org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8381)
>> at org.h2.command.Parser.readTableOrView(Parser.java:8370)
>> at org.h2.command.Parser.readTablePrimary(Parser.java:1866)
>> at org.h2.command.Parser.readTableReference(Parser.java:2342)
>> at org.h2.command.Parser.readTableReference(Parser.java:2377)
>> at org.h2.command.Parser.parseSelectFromPart(Parser.java:2793)
>> at org.h2.command.Parser.parseSelect(Parser.java:2900)
>> at org.h2.command.Parser.parseQueryPrimary(Parser.java:2783)
>> at org.h2.command.Parser.parseQueryTerm(Parser.java:2650)
>> at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2629)
>> at
>> org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2622)
>> at org.h2.command.Parser.parseQueryExpression(Parser.java:2615)
>> at org.h2.command.Parser.parseQuery(Parser.java:2576)
>> at org.h2.command.Parser.parsePrepared(Parser.java:707)
>> at org.h2.command.Parser.parse(Parser.java:674)
>> at org.h2.command.Parser.parse(Parser.java:644)
>> at org.h2.command.Parser.prepareCommand(Parser.java:551)
>> at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:615)
>> at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:553)
>> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
>> at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:92)
>> at
>> com.informix.hq.server.rest.api.alert.AlertingIncidentsResource.getIncidents(AlertingIncidentsResource.java:108)
>> at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at
>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
>> at
>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
>> at
>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
>> at
>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
>> at
>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
>> at
>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
>> at
>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
>> at
>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
>> at
>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
>> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
>> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
>> at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
>> at
>> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
>> at
>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
>> at
>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
>> at
>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
>> at
>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
>> at
>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
>> at
>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
>> at
>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
>> at
>> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
>> at
>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550)
>> at
>> org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
>> at
>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
>> at
>> org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
>> at
>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
>> at
>> org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
>> at
>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
>> at
>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
>> at
>> org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)
>> at
>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
>> at org.eclipse.jetty.server.Server.handle(Server.java:516)
>> at
>> org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
>> at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
>> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
>> at
>> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
>> at
>> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
>> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
>> at
>> org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
>> at
>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
>> at
>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
>> at
>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
>> at
>> org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
>> at
>> org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
>> at
>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:882)
>> at
>> org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1036)
>> at java.lang.Thread.run(Thread.java:748)
>> 2022-06-23 08:43:29 jdbc[3]:
>> /**/stat1734.close();
>> 2022-06-23 08:43:29 jdbc[3]:
>> /**/conn2680.close();
>>
>>
>> As you can see there is no table now with the name
>> *USER_ALERT_MESSENGERS*
>> On Wednesday, 22 June 2022 at 22:36:33 UTC+5:30 Shubham kapoor wrote:
>>
>>> Hi all,
>>>
>>> Recently I have migrated my h2db from verison 1.4.192 to 2.1.210. Every
>>> thing works wells and application is started with h2db.mv.db version 2.
>>> After some time I noticed that h2 deletes some of the tables by its own. In
>>> total I had 14 tables but after some time only 9 remains and 5 got deteled.
>>> Below are the tables which got deleted in h2 verison 2
>>>
>>> create table if not exists alerting_criteria_violations(id identity,
>>> timestamp bigint not null, meta " + H2Schema.BINARY_COLUMN_64K,
>>> alerting_incident_id bigint not null, foreign key(alerting_incident_id)
>>> references alerting_incidents(id) on delete cascade);
>>>
>>> create table if not exists config(data " + H2Schema.BINARY_COLUMN_64K +
>>> ");
>>>
>>> create table if not exists user_alert_messengers(id bigint, user_id
>>> bigint, data " + H2Schema.BINARY_COLUMN_64K + ",foreign key (user_id)
>>> references users(id) on delete cascade);
>>>
>>> create table if not exists user_alert_services(id bigint, user_id
>>> bigint, data " + H2Schema.BINARY_COLUMN_64K + ", foreign key (user_id)
>>> references users(id) on delete cascade);
>>>
>>> create table if not exists user_permissions(user_id bigint, group_id
>>> bigint, server_id bigint, permissions smallint, foreign key (user_id)
>>> references users(id) on delete cascade, foreign key (group_id) references
>>> informix_server_groups(id) on delete cascade, foreign key (server_id)
>>> references informix_servers(id) on delete cascade);
>>>
>>> H2Schema.BINARY_COLUMN_64K = binary(65536)
>>>
>>>
>>> Then I started debug tracing mode and found some logs.
>>>
>>> Scenario: I opened my h2db.mv.db file with h2 console and ran a wrong
>>> query over there and was there on console for some time. After a few
>>> minutes, I disconnected from the console and started my application which
>>> use to connect with h2db for login information. but my application didn't
>>> started.
>>>
>>>
>>>
>>> I am attaching the debug logs with scenarios. Please help.
>>>
>>>
>>> Please note while migrating from h2 version 1 to 2 I have also executed
>>> some of the alters to create primary key on some tables.
>>>
>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/83e86fad-5359-43e5-95e7-c0a96b42fa4bn%40googlegroups.com.
