Confluence has been updated to version 6.15.9

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You have been testing the heck out of the Exalate, and now it is time to start from scratch.  But your Jira database has now all these  exalate related tables. 
This document details out how to drop all these tables


  • Don't do this in production
  • Warning
    titleObvious warning


    • Be  sure to take backup before proceeding

    ...

    Code Block
    languagesql
    linenumberstrue
    collapsetrue
    DELETE FROM jira.propertystring where id = (SELECT id FROM jira.propertyentry where property_key = 'AO_08F1AF_#');
    DELETE FROM jira.propertyentry where property_key = 'AO_08F1AF_#';


    Postgres Specific Queries

    Drop all Exalate tables

    Code Block
    languagesql
    titleDrop All Exalate Tables
    linenumberstrue
    collapsetrue
    DROP TABLE "AO_08F1AF_TRIGGER_CONFIG_DTO";
    DROP TABLE "AO_08F1AF_PROGRESS_TRACKER";
    DROP TABLE "AO_08F1AF_LIFECYCLE_DTO";
    DROP TABLE "AO_08F1AF_NODE";
    DROP TABLE "AO_08F1AF_ERROR";
    DROP TABLE "AO_08F1AF_ASSIGNED_LICENSE";
    DROP TABLE "AO_08F1AF_LICENSE";
    DROP TABLE "AO_08F1AF_TRIGGER";
    DROP TABLE "AO_08F1AF_TRACE";
    DROP TABLE "AO_08F1AF_TWIN_TRACE";
    DROP TABLE "AO_08F1AF_BLOB_EVENT";
    DROP TABLE "AO_08F1AF_BLOB_REQUEST";
    DROP TABLE "AO_08F1AF_BLOB_METADATA";
    DROP TABLE "AO_08F1AF_SYNC_REQUEST";
    DROP TABLE "AO_08F1AF_SYNC_EVENT";
    DROP TABLE "AO_08F1AF_CONNECT_CONTEXT";
    DROP TABLE "AO_08F1AF_REPLICA";
    DROP TABLE "AO_08F1AF_INSTANCE";
    DROP TABLE "AO_08F1AF_NODE_INFO";
    DROP TABLE "AO_08F1AF_RELATION";
    

    ...