Confluence has been updated to version 6.15.9

JIRA SERVER/DATACENTER

Introduction


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


Obvious warning


  • Be  sure to take backup before proceeding


Approach 


The following steps need to be followed


  1. Uninstall Exalate
  2. Drop all Exalate Tables
  3. Drop the records related to Exalate Upgrade tasks
  4. Restart Jira
  5. Install Exalate



Step 2 and 3 require SQL commands





MYSQL Specific Queries


Drop all Exalate tables

Drop All Exalate Tables
DROP TABLE jira.AO_08F1AF_TRIGGER_CONFIG_DTO;
DROP TABLE jira.AO_08F1AF_PROGRESS_TRACKER;
DROP TABLE jira.AO_08F1AF_LIFECYCLE_DTO;
DROP TABLE jira.AO_08F1AF_NODE;
DROP TABLE jira.AO_08F1AF_ERROR;
DROP TABLE jira.AO_08F1AF_ASSIGNED_LICENSE;
DROP TABLE jira.AO_08F1AF_LICENSE;
DROP TABLE jira.AO_08F1AF_TRIGGER;
DROP TABLE jira.AO_08F1AF_TRACE;
DROP TABLE jira.AO_08F1AF_TWIN_TRACE;
DROP TABLE jira.AO_08F1AF_BLOB_EVENT;
DROP TABLE jira.AO_08F1AF_BLOB_REQUEST;
DROP TABLE jira.AO_08F1AF_BLOB_METADATA;
DROP TABLE jira.AO_08F1AF_SYNC_REQUEST;
DROP TABLE jira.AO_08F1AF_SYNC_EVENT;
DROP TABLE jira.AO_08F1AF_CONNECT_CONTEXT;
DROP TABLE jira.AO_08F1AF_REPLICA;
DROP TABLE jira.AO_08F1AF_INSTANCE;
DROP TABLE jira.AO_08F1AF_NODE_INFO;
DROP TABLE jira.AO_08F1AF_RELATION;

Drop the records related to Exalate Upgrade tasks

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

Drop All Exalate Tables
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";

Drop the records related to Exalate Upgrade tasks

DELETE FROM propertystring where id = (SELECT id FROM propertyentry where property_key = 'AO_08F1AF_#');
DELETE FROM propertyentry where property_key = 'AO_08F1AF_#';