How Can I Start from Scratch with Exalate?

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.

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

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_#';

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";

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