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

[Tommasso Borgato (Jira)]

     [ https://issues.jboss.org/browse/WFLY-12703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tommasso Borgato closed WFLY-12703.
-----------------------------------
    Resolution: Done


> 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}



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