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/83e86fad-5359-43e5-95e7-c0a96b42fa4bn%40googlegroups.com.
