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

Improve Oracle + Nuxeo cluster node removal behavior

    XMLWordPrintable

    Details

    • Tags:
    • Impact type:
      Content model Change
    • Upgrade notes:
      Hide

      The format of the tables CLUSTER_NODES and CLUSTER_INVALS has changed and they **MUST** be dropped while the server is stopped.

      DROP TABLE "CLUSTER_NODES";
      DROP TABLE "CLUSTER_INVALS";

      If you don't want to let Nuxeo recreate them (when using noDDL), the new DDL to execute by hand is:

      CREATE TABLE "CLUSTER_NODES" ("NODEID" VARCHAR(25), "CREATED" TIMESTAMP);
      CREATE TABLE "CLUSTER_INVALS" ("NODEID" VARCHAR(25), "ID" VARCHAR2(36), "FRAGMENTS" VARCHAR2(4000), "KIND" NUMBER(3,0));
      CREATE INDEX "CLUSTER_INVALS_NODEID_IDX" ON "CLUSTER_INVALS" ("NODEID");

      Show
      The format of the tables CLUSTER_NODES and CLUSTER_INVALS has changed and they ** MUST ** be dropped while the server is stopped. DROP TABLE "CLUSTER_NODES"; DROP TABLE "CLUSTER_INVALS"; If you don't want to let Nuxeo recreate them (when using noDDL), the new DDL to execute by hand is: CREATE TABLE "CLUSTER_NODES" ("NODEID" VARCHAR(25), "CREATED" TIMESTAMP); CREATE TABLE "CLUSTER_INVALS" ("NODEID" VARCHAR(25), "ID" VARCHAR2(36), "FRAGMENTS" VARCHAR2(4000), "KIND" NUMBER(3,0)); CREATE INDEX "CLUSTER_INVALS_NODEID_IDX" ON "CLUSTER_INVALS" ("NODEID");

      Description

      When using Oracle and Nuxeo in cluster, on cluster node removal the cleanup that is done is sometimes incorrect due to session recycling on the Oracle side.

      The way we identify node ids should be based on not only SID but also SERIAL#.

        Attachments

          Issue Links

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-10884 Nuxeo cluster NX_NODEID may fail on Oracle with RAC active/active

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

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: