Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-7498

VCS: cluster node loses identity when connection to database is broken/restarted

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.5
    • Component/s: Core VCS
    • Tags:
    • Upgrade notes:
      Hide

      for reconnect to database feature the following two lines needs to be uncomment in $NUXEO_HOME/oracle/deploy/nuxeo-ds.xml

      <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name-->

      ( not enabled by default due possible performance issue )

      Show
      for reconnect to database feature the following two lines needs to be uncomment in $NUXEO_HOME/oracle/deploy/nuxeo-ds.xml <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name--> ( not enabled by default due possible performance issue )

      Description

      When the connection to the database is broken, there is a mechanism in JDBCConnection to attempt to reconnect automatically.
      However if this happens for the cluster connection (first connection), the connection will have a new SID (Oracle) / pg_backend_pid (PostgreSQL) which won't be added to the CLUSTER_NODES table.
      The effect is that after reconnection the cluster node will not see any invalidation from other nodes as they will be sent to a nonexistent node.

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-7528 proper connection handling after database is down

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-8779 Cluster node must keep node identity after reconnect

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: