Uploaded image for project: 'WildFly'
  1. WildFly
  2. WFLY-19972

[CLUSTERING] ORA-01555 when using ORACLE to offload session data

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • None
    • 35.0.0.Beta1
    • Clustering
    • None
    • ---
    • ---

      We have a 4 nodes cluster connected to an Oracle database (Oracle Database 23ai Free Release 23.0.0.0.0) using JDBC Driver https://download.oracle.com/otn-pub/otn_software/jdbc/236/ojdbc17.jar (see https://www.oracle.com/cis/database/technologies/appdev/jdbc-downloads.html);

      Fail-over is triggered by shutting down and then restarting, each one of the 4 cluster nodes in a sequence (e.g. node 1 is shut down, we wait ~1min and then re-start it, then we do the same with node 2);

      Right after the first node is stopped we observe the following error on the other nodes:

      2024-11-19 15:00:41,029 ERROR [org.infinispan.PERSISTENCE] (blocking-thread-wildfly3-p15-t6) ISPN008009: I/O error while unmarshalling from stream: java.io.IOException: ORA-01555: snapshot too old: rollback segment number  with name "" too small
      

      Complete server logs in server-log.zip

              pferraro@redhat.com Paul Ferraro
              tborgato@redhat.com Tommaso Borgato
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: