[jboss-jira] [JBoss JIRA] (WFLY-12703) Error populating DB schema with PostgreSQL as JDBC store

Error populating DB schema with PostgreSQL as JDBC store -------------------------------------------------------- Key: WFLY-12703 URL: https://issues.jboss.org/browse/WFLY-12703 Project: WildFly Issue Type: Bug Components: Clustering Affects Versions: 18.0.0.Final Reporter: Tommasso Borgato Assignee: Paul Ferraro Priority: Blocker The scenario is a 4 nodes WildFly cluster where Web Sessions are stored in an invalidation cache backed by PostgreSQL DB; this is the cli script used to configure all 4 nodes: {noformat} embed-server --server-config=standalone-ha.xml /subsystem=jgroups/channel=ee:write-attribute(name=stack,value=tcp) /subsystem=infinispan/cache-container=web/invalidation-cache=offload:add() /subsystem=infinispan/cache-container=web/invalidation-cache==offload/component=transaction:write-attribute(name=mode, value=BATCH) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/component=locking:write-attribute(name=isolation, value=REPEATABLE_READ) data-source add --name=testDS --jndi-name=java:jboss/datasources/testDS --driver-name=postgresql-connector.jar --connection-url=jdbc:postgresql://postgres-115.mwqe.upshift.rdu2.redhat.com:5432/dballo03 --enabled=true --jta=true --use-java-context=true --transaction-isolation=TRANSACTION_READ_COMMITTED --min-pool-size=1 --max-pool-size=5 --pool-prefill=true --user-name=dballo03 --password=dballo03 --prepared-statements-cache-size=32 --share-prepared-statements=true /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc:add(data-source=testDS,fetch-state=false,passivation=false,purge=false,shared=true,dialect=POSTGRES){allow-resource-service-restart=true} /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=prefix,value=s) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=id-column.name,value=id) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=id-column.type,value=VARCHAR(255)) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=data-column.name,value=datum) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=data-column.type,value=BYTEA) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=timestamp-column.name,value=version) /subsystem=infinispan/cache-container=web/invalidation-cache=offload/store=jdbc/table=string:write-attribute(name=timestamp-column.type,value=BIGINT) /subsystem=infinispan/cache-container=web:write-attribute(name=default-cache, value=offload) /subsystem=transactions:write-attribute(name=node-identifier,value=wildfly2) {noformat} Note that the Database schema was empty before running the tests; This is the sequence that produces the error: - Node 1 is started - App clusterbench is deployed on Node 1 - Database tables are created: - "public"."s_clusterbench_ee8_ear_clusterbench_ee8_web_granular_war" - "public"."s_clusterbench_ee8_ear_clusterbench_ee8_web_passivating_war" - "public"."s_clusterbench_ee8_ear_clusterbench_ee8_web_war" - Node 2 is started - App clusterbench is deployed on Node 2 ---> ERROR The error is: {noformat} ERROR o.j.e.c.i.i.u.WildFlyServiceInstrumentationProviderSunstone - could not deploy /home/hudson/static_build_env/clustering/clusterbench/clusterbench-ee8.ear via management client to service WildFly Service 2, result is not a success: { "outcome" : "failed", "failure-description" : {"WFLYCTL0080: Failed services" : { "org.wildfly.clustering.infinispan.cache.web.clusterbench-ee8.ear.clusterbench-ee8-web-granular.war" : "org.infinispan.commons.CacheException: Unable to invoke method public void org.infinispan.persistence.manager.PersistenceManagerImpl.start() on object of type PersistenceManagerImpl\n Caused by: org.infinispan.commons.CacheException: Unable to invoke method public void org.infinispan.persistence.manager.PersistenceManagerImpl.start() on object of type PersistenceManagerImpl\n Caused by: org.infinispan.commons.CacheException: Unable to start cache loaders\n Caused by: org.infinispan.persistence.spi.PersistenceException: ISPN000527: Maximum startup attempts exceeded for store org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore\n Caused by: org.infinispan.persistence.spi.PersistenceException: org.postgresql.util.PSQLException: ERROR: relation \"s_clusterbench_ee8_ear_clusterbench_ee8_web_granular_war_timest\" already exists\n Caused by: org.postgresql.util.PSQLException: ERROR: relation \"s_clusterbench_ee8_ear_clusterbench_ee8_web_granular_war_timest\" already exists", "org.wildfly.clustering.infinispan.cache.web.clusterbench-ee8.ear.clusterbench-ee8-web-passivating.war" : "org.infinispan.commons.CacheException: Unable to invoke method public void org.infinispan.persistence.manager.PersistenceManagerImpl.start() on object of type PersistenceManagerImpl\n Caused by: org.infinispan.commons.CacheException: Unable to invoke method public void org.infinispan.persistence.manager.PersistenceManagerImpl.start() on object of type PersistenceManagerImpl\n Caused by: org.infinispan.commons.CacheException: Unable to start cache loaders\n Caused by: org.infinispan.persistence.spi.PersistenceException: ISPN000527: Maximum startup attempts exceeded for store org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore\n Caused by: org.infinispan.persistence.spi.PersistenceException: org.postgresql.util.PSQLException: ERROR: relation \"s_clusterbench_ee8_ear_clusterbench_ee8_web_passivating_war_tim\" already exists\n Caused by: org.postgresql.util.PSQLException: ERROR: relation \"s_clusterbench_ee8_ear_clusterbench_ee8_web_passivating_war_tim\" already exists" }}, "rolled-back" : true } {noformat}