Transactional Quartz jobs with WARN messages in the log: Datasource '<default>': Closing open connection prior to commit

[szxp]

Describe the bug

I am trying to schedule Quartz jobs programmatically using @Transactional, similar to as suggested in https://quarkus.io/guides/quartz#scheduling-jobs-programmatically, but WARN messages can be seen in the log: Datasource '<default>': Closing open connection prior to commit:

Listening for transport dt_socket at address: 5005
2022-08-06 20:56:12,046 WARN  [io.qua.hib.orm.dep.HibernateOrmProcessor] (build-2) Hibernate ORM is disabled because no JPA entities were found
2022-08-06 20:56:12,428 INFO  [io.qua.arc.pro.BeanProcessor] (build-5) Found unrecommended usage of private members (use package-private instead) in application beans:
        - @Inject field com.example.MyScheduler#dataSource,
        - @Inject field com.example.MyScheduler#quartz,
        - @Inject field com.example.MyScheduler#transactionManager
        - and 2 more - please enable debug logging to see the full list

__  ____  __  _____   ___  __ ____  ______
 --/ __ \/ / / / _ | / _ \/ //_/ / / / __/
 -/ /_/ / /_/ / __ |/ , _/ ,< / /_/ /\ \
--\___\_\____/_/ |_/_/|_/_/|_|\____/___/
2022-08-06 20:56:13,218 INFO  [com.exa.MyScheduler] (QuarkusQuartzScheduler_Worker-1) Execute: scheduler1

2022-08-06 20:56:13,218 INFO  [io.quarkus] (Quarkus Main Thread) module1 1.0.0 on JVM (powered by Quarkus 2.7.6.Final) started in 1.961s.
2022-08-06 20:56:13,223 INFO  [io.quarkus] (Quarkus Main Thread) Profile dev activated. Live Coding activated.
2022-08-06 20:56:13,224 INFO  [io.quarkus] (Quarkus Main Thread) Installed features: [agroal, cdi, hibernate-orm, hibernate-orm-panache, hibernate-validator, jdbc-h2, narayana-jta, quartz, scheduler, smallrye-context-propagation, vertx]
2022-08-06 20:56:13,338 INFO  [com.exa.MyScheduler] (QuarkusQuartzScheduler_Worker-1) conn: wrapped[conn0: url=jdbc:h2:mem:MyDB user=DBUSER]
2022-08-06 20:56:13,340 INFO  [com.exa.MyScheduler] (QuarkusQuartzScheduler_Worker-1) txman status: 6
2022-08-06 20:56:13,370 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-2) Execute: job
2022-08-06 20:56:13,378 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-2) conn: wrapped[conn1: url=jdbc:h2:mem:MyDB user=DBUSER]<<enrolled
2022-08-06 20:56:13,379 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-2) txman status: 0
2022-08-06 20:56:13,379 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-2) txm status: 0
2022-08-06 20:56:13,380 WARN  [io.agr.pool] (QuarkusQuartzScheduler_Worker-2) Datasource '<default>': Closing open connection prior to commit
2022-08-06 20:56:16,343 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-3) Execute: job
2022-08-06 20:56:16,346 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-3) conn: wrapped[conn1: url=jdbc:h2:mem:MyDB user=DBUSER]<<enrolled
2022-08-06 20:56:16,349 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-3) txman status: 0
2022-08-06 20:56:16,351 INFO  [com.exa.MyScheduler$MyJob] (QuarkusQuartzScheduler_Worker-3) txm status: 0
2022-08-06 20:56:16,352 WARN  [io.agr.pool] (QuarkusQuartzScheduler_Worker-3) Datasource '<default>': Closing open connection prior to commit

Expected behavior

No WARN messages in the log.

Actual behavior

WARN messages can be seen in the log:

Datasource '<default>': Closing open connection prior to commit

How to Reproduce?

Sample project https://github.com/szxp/quartz-test/blob/main/module1/src/main/java/com/example/MyScheduler.java

Run this Maven command in the module1 directory from Windows Powershell: mvn clean compile quarkus:dev -"Dquarkus.quartz.start-mode=forced"

Output of uname -a or ver

Microsoft Windows [Version 10.0.22000.795]

Output of java -version

openjdk 17.0.2 2022-01-18 OpenJDK Runtime Environment GraalVM CE 22.0.0.2 (build 17.0.2+8-jvmci-22.0-b05) OpenJDK 64-Bit Server VM GraalVM CE 22.0.0.2 (build 17.0.2+8-jvmci-22.0-b05, mixed mode, sharing)

GraalVM version (if different from Java)

No response

Quarkus version or git rev

2.7.6.Final

Build tool (ie. output of mvnw --version or gradlew --version)

Apache Maven 3.8.6 (84538c9988a25aec085021c365c560670ad80f63) Maven home: c:\Users\szp05\local\apache-maven-3.8.6 Java version: 17.0.2, vendor: GraalVM Community, runtime: c:\Users\szp05\local\graalvm-ce-java17-22.0.0.2 Default locale: en_US, platform encoding: Cp1252 OS name: "windows 11", version: "10.0", arch: "amd64", family: "windows"

Additional information

No response

[quarkus-bot[bot]]

/cc @machi1990, @mkouba

[mkouba]

CC @gsmet

[mkouba]

@szxp Does it still occur in recent versions of Quarkus (3.2+)?