When i start Flowable against the existing activiti, flowable detects that the schema needs to be upgraded. But for me it seems like the queries which are executed to find out which tables exists breaks the transaction and after that the creation of new tables fails.
[2023-01-17 16:50:25.071] INFO org.flowable.idm.engine.impl.db.IdmDbSchemaManager [thread:20,FelixStartLevel] upgrading flowable identity schema from 5.99.0.0 to 6.6.0.0
[2023-01-17 16:50:25.087] INFO org.flowable.idm.engine.impl.db.IdmDbSchemaManager [thread:20,FelixStartLevel] Upgrade needed: 59900 → 6000. Looking for schema update resource for component ‘identity’
[2023-01-17 16:50:25.120] INFO org.flowable.idm.engine.impl.db.IdmDbSchemaManager [thread:20,FelixStartLevel] performing upgrade on identity with resource org/flowable/idm/db/upgrade/flowable.postgres.upgradestep.59900.to.6000.identity.sql
[2023-01-17 16:50:25.124] SEVERE org.flowable.idm.engine.impl.db.IdmDbSchemaManager [thread:20,FelixStartLevel] problem during schema upgrade, statement create table ACT_ID_PROPERTY (
NAME_ varchar(64),
VALUE_ varchar(300),
REV_ integer,
primary key (NAME_)
)
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:286)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)