pefernan opened a new issue, #2115: URL: https://github.com/apache/incubator-kie-issues/issues/2115
Running the process-compact-architecture example in dev mode, H2 Database is refreshed from time to time with the following error: ``` 2025-09-03 15:22:13,863 WARN [org.hib.eng.jdb.spi.SqlExceptionHelper] (Jobs-2) SQL Error: 42104, SQLState: 42S04 2025-09-03 15:22:13,885 ERROR [org.hib.eng.jdb.spi.SqlExceptionHelper] (Jobs-2) Table "JOB_DETAILS" not found (this database is empty); SQL statement: select jde1_0.id,jde1_0.correlation_id,jde1_0.created,jde1_0.execution_counter,jde1_0.execution_timeout,jde1_0.execution_timeout_unit,jde1_0.fire_time,jde1_0.last_update,jde1_0.priority,jde1_0.recipient,jde1_0.retries,jde1_0.scheduled_id,jde1_0.status,jde1_0.trigger from job_details jde1_0 where jde1_0.status in (?,?) and jde1_0.fire_time<=? [42104-232] ``` These errors happen in 10-minute intervals (default job sync interval). Note this is specific to H2, which shuts down after being idle for some time. Possible workarounds: - Append DB_CLOSE_DELAY=-1 to the connection string: %dev.quarkus.datasource.jdbc.url=jdbc:h2:mem:default;NON_KEYWORDS=VALUE,KEY;DB_CLOSE_DELAY=-1 - Increase the idle removal interval of the datasource: %dev.quarkus.datasource.jdbc.idle-removal-interval=60M - Keep at least one connection in the datasource pool: %dev.quarkus.datasource.jdbc.min-size=1 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
