Confluence has been updated to version 6.15.9

JIRA SERVER

This article describes how you can remove the database for a specific connection in Jira Server.

Do not use this in production, make sure you have a back up of your DB.


Delete all DB tables

PostgreSQL

TRUNCATE TABLE "AO_08F1AF_TRACE" CASCADE;
TRUNCATE TABLE "AO_08F1AF_TWIN_TRACE"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_ERROR"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_BLOB_EVENT"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_BLOB_REQUEST"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_SYNC_EVENT"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_SYNC_REQUEST"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_BLOB_METADATA"  CASCADE;
TRUNCATE TABLE "AO_08F1AF_REPLICA"  CASCADE;

MySQL

SET FOREIGN_KEY_CHECKS = 0;
 
 
TRUNCATE TABLE AO_08F1AF_TRACE;
TRUNCATE TABLE AO_08F1AF_TWIN_TRACE;
TRUNCATE TABLE AO_08F1AF_ERROR;
TRUNCATE TABLE AO_08F1AF_BLOB_EVENT;
TRUNCATE TABLE AO_08F1AF_BLOB_REQUEST;
TRUNCATE TABLE AO_08F1AF_SYNC_EVENT;
TRUNCATE TABLE AO_08F1AF_SYNC_REQUEST;
TRUNCATE TABLE AO_08F1AF_BLOB_METADATA;
TRUNCATE TABLE AO_08F1AF_REPLICA;

Clean-up by connection

This scripts find all the synced issues for a specific connection and then deletes all DB tables related to sync data for these issues.