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

[Tommasso Borgato (Jira)]

Tommasso Borgato created WFLY-12703:
---------------------------------------

             Summary: 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


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}




--
This message was sent by Atlassian Jira
(v7.13.8#713008)