HI Evgenij and Team, Can someone help me on upgrading H2DB from 1.4.199 to 1.4.200?
We are forming the JDBC URL like this : *jdbc:h2:%base%data\nim-sm-customizations;AUTO_SERVER=TRUE * *And it is working fine with h2DB jar version 1.4.199 but with 1.4.200 (only 1 version difference) it was throwing an error saying below:* WARNING [main] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [ca-nim-sm_h2DB] appears to have started a thread named [H2 TCP Server (tcp://10.230.44.99:55171)] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread: java.net.DualStackPlainSocketImpl.accept0(Native Method) java.net.DualStackPlainSocketImpl.socketAccept(DualStackPlainSocketImpl.java:131) java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:409) java.net.PlainSocketImpl.accept(PlainSocketImpl.java:199) java.net.ServerSocket.implAccept(ServerSocket.java:560) java.net.ServerSocket.accept(ServerSocket.java:528) org.h2.server.TcpServer.listen(TcpServer.java:263) org.h2.tools.Server.run(Server.java:610) java.lang.Thread.run(Thread.java:748) *For this I have removed the AUTO_SERVER=TRUE from the JDBC URL mentioned above and the error is not occurring while deploying my web application on Tomcat, however I am getting the below error in the tomcat longs and also unable to access my application UI.* 17-May-2021 11:27:25.401 INFO [Thread-4] org.apache.catalina.core.ApplicationContext.log SessionListener: contextDestroyed() 17-May-2021 11:27:25.401 INFO [Thread-4] org.apache.catalina.core.ApplicationContext.log ContextListener: contextDestroyed() 17-May-2021 11:27:52.562 SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [com.ca.integration.normalization.common.NIMServletContextListener] java.lang.RuntimeException: NIM Application Persistence could not be initialized, application startup failed with error : General error: "java.lang.IllegalStateException: Unable to read the page at position 1924162229955 [1.4.200/6]" [50000-200] at com.ca.integration.normalization.common.NIMServletContextListener.initializePersistence(NIMServletContextListener.java:567) at com.ca.integration.normalization.common.NIMServletContextListener.initializeNIMWithDbDatastore(NIMServletContextListener.java:188) at com.ca.integration.normalization.common.NIMServletContextListener.contextInitialized(NIMServletContextListener.java:127) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:706) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1023) at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1903) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) *This is a bit urgent so could someone help me to resolve the issue?* Thanks, Balamurali On Tue, May 11, 2021 at 1:35 PM Balamurali Krishna Ippili < [email protected]> wrote: > Hi Evgenij, > > One more thing is that the following is my application's H2 DB URL: > > *jdbc:h2:%base%data\nim-sm-customizations;AUTO_SERVER=TRUE* > > *And with the h2 jar version 1.4.199 I couldn't see any issues even if the > URL contains AUTO_SERVER=TRUE but with 1.4.200 only it was giving an > error below:* > > WARNING [main] > org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The > web application [ca-nim-sm_h2DB] appears to have started a thread named [H2 > TCP Server (tcp://10.230.44.99:55171)] but has failed to stop it. This is > very likely to create a memory leak. Stack trace of thread: > java.net.DualStackPlainSocketImpl.accept0(Native Method) > > > *Can we find any documentation that shows the differences between the > versions 1.4.199 and 1.4.200 to understand what has been changed?* > > > Thanks, > Balamurali > > On Tue, May 11, 2021 at 1:28 PM Balamurali Krishna Ippili < > [email protected]> wrote: > >> Hi Evgenij, >> >> If the AUTO_SERVER=TRUE has been removed , can the external applications >> still be able to access the DB? >> >> >> >> Thanks, >> Balamurali >> >> On Wed, May 5, 2021 at 7:36 PM Evgenij Ryazanov <[email protected]> wrote: >> >>> Hello. >>> >>> Don't use AUTO_SERVER in web applications, their lifecycle is different >>> from standalone applications. Web applications should either use an >>> embedded database or connections to a separate H2 Server process. >>> >>> -- >>> 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/bf14bddc-d495-4a16-a956-c35bab1ecafan%40googlegroups.com >>> <https://groups.google.com/d/msgid/h2-database/bf14bddc-d495-4a16-a956-c35bab1ecafan%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it. -- 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/CAG6_yCDQc%2Bn3t6Nieh8B%2BkD7y0L-kbkBkUuO6q2mwhHy_TH7Qg%40mail.gmail.com.
smime.p7s
Description: S/MIME Cryptographic Signature
