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 how to drop all these tables.
WARNING: Be sure to make a backup before proceeding.
Approach
The following steps need to be followed:
- Uninstall Exalate
- Drop all Exalate Tables
- Drop the records related to Exalate Upgrade tasks
- Restart Jira
- Install Exalate
Steps 2 and 3 require SQL commands
MYSQL Specific Queries
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 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_#';