Thanks , I am actually trying to migrate my code from H2 1.3.176 to H2 2.1.214 so I wanted to make sure that is there a way to include MV_Store = FALSE But now its clear.
On Tuesday, July 12, 2022 at 7:55:22 AM UTC+5:30 [email protected] wrote: > 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 [email protected] 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 [email protected] >> 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/edf691b5-4c36-44b0-80b5-50c77b1ff979n%40googlegroups.com.
