Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-19925

ORA-00955 when doing failover with Oracle database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 7.4.0.CD20-CR1
    • Clustering
    • None
    • Regression
    • +
    • Workaround Exists
    • Hide

      Override the default table prefix (i.e. ispn_entry) to generate shorter identifiers - or disable segmentation for the JDBC store.

      Show
      Override the default table prefix (i.e. ispn_entry) to generate shorter identifiers - or disable segmentation for the JDBC store.

      It seems like the index is being inserted twice. This was not observed for CD19. Database is Oracle 19c RAC.

      java.lang.IllegalStateException: 
      could not deploy /tmp/tests-clustering/cbnc.ear via management client to service WildFly Service 1: {
          "outcome" : "failed",
          "failure-description" : {"WFLYCTL0080: Failed services" : {
              "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.b.war\"" : "org.infinispan.commons.CacheException: Unable to start cache loaders\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: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object\n\n    Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object\n\n    Caused by: Error : 955, Position : 13, Sql = CREATE INDEX \"segment_index_ispn_entry_cbnc_\" ON \"ispn_entry_cbnc_ear_b_war\" (segment), OriginalSql = CREATE INDEX \"segment_index_ispn_entry_cbnc_\" ON \"ispn_entry_cbnc_ear_b_war\" (segment), Error Msg = ORA-00955: name is already used by an existing object\n",
              "org.wildfly.clustering.infinispan.cache.web.\"cbnc.ear.c.war\"" : "org.infinispan.commons.CacheException: Unable to start cache loaders\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: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object\n\n    Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object\n\n    Caused by: Error : 955, Position : 13, Sql = CREATE INDEX \"segment_index_ispn_entry_cbnc_\" ON \"ispn_entry_cbnc_ear_c_war\" (segment), OriginalSql = CREATE INDEX \"segment_index_ispn_entry_cbnc_\" ON \"ispn_entry_cbnc_ear_c_war\" (segment), Error Msg = ORA-00955: name is already used by an existing object\n"
          }},
          "rolled-back" : true
      }
      

              pferraro@redhat.com Paul Ferraro
              jkasik@redhat.com Jan Kašík
              Tommaso Borgato
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: