-
Type:
Bug Report
-
Resolution: Cannot Reproduce
-
Priority:
L3 - Default
-
None
-
Affects Version/s: spring-boot 3.2.1
-
Component/s: spring-boot
-
None
When trying to bootstrap a new DB using Camunda BPM Spring Boot Starter the following exception occurs:
Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled. at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:772) ~[postgresql-42.2.5.jar:42.2.5] at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:361) ~[HikariCP-3.2.0.jar:na] at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) ~[HikariCP-3.2.0.jar:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na] at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:236) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at com.sun.proxy.$Proxy100.commit(Unknown Source) ~[na:na] at org.camunda.bpm.spring.boot.starter.configuration.impl.custom.EnterLicenseKeyConfiguration.postProcessEngineBuild(EnterLicenseKeyConfiguration.java:76) ~[camunda-bpm-spring-boot-starter-3.2.1.jar:3.2.1] ... 154 common frames omitted
However, when reverting back to 3.2.0, this error is not present.
Also, when using version 3.21, after that exception if i restart the application, camunda seems to be running fine.
Using the following configuration:
Spring-Boot: (v2.1.3.RELEASE) Camunda BPM: (v7.10.3-ee) Camunda BPM Spring Boot Starter: (v3.2.1) openjdk version "11.0.1" 2018-10-16 OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.1+13) OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.1+13, mixed mode)
Note that apparently in older version of the postgresql driver (i'm using 42.2.5) this is not autocommit thing is not checked; hence maybe you not finding this in some automated tests. (see https://www.postgresql.org/message-id/1379496313.51692.YahooMailNeo%40web162904.mail.bf1.yahoo.com)