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

            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:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.