Error in H2 DB while doing load test. and seems like H2 DB shut down while inserting Wiretaps
2022-05-04 10:09:56,413 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper [DefaultMessageListenerContainer-1] The database has been closed; SQL statement:
insert into IkasanWiretap (Id, ModuleName, FlowName, ComponentName, EventId, PayloadContent, CreatedDateTime, Expiry, Harvested, HarvestedDateTime) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90098-200]
2022-05-04 10:09:56,413 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper [DefaultMessageListenerContainer-1] The database has been closed; SQL statement:
insert into IkasanWiretap (Id, ModuleName, FlowName, ComponentName, EventId, PayloadContent, CreatedDateTime, Expiry, Harvested, HarvestedDateTime) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90098-200]
Producer,flowComponent=org.ikasan.component.endpoint.jms.spring.producer.ArjunaJmsTemplateProducer@37f627d0,transitions=null]], exception is[org.springframework.dao.DataAccessResourceFailureException: could not execute statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute statement]
org.springframework.dao.DataAccessResourceFailureException: could not execute statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute statement
at org.spri
ng bean with name 'configurationServiceDao' defined in class path resource [configuration-service-conf.xml]: Cannot resolve reference to bean 'configurationServiceSessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.DatabaseException: java.sql.SQLException: Cannot create PoolableConnectionFactory (General error: "java.lang.IllegalStateException: Chunk 58937 not found [1.4.200/9]" [50000-200])
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.resolveMethodArguments(AutowiredAnnotationBeanPostProcessor.java:767)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:719)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431)
at org.springf
Following the DB recovery guide, we did try and recover and worked OK but the Ikasan wiretaps table were empty after recovery