AAE - Alfresco-process-query-service - Pod restarted with error after dropping tables

Description

Customer reported that he reproduced this issue using Alfresco activiti services runing on M12 version with Postgresql database.

Step to reproduce:

  1. Prior to drop the tables on the querysvc db, scaled down the POD 

  2. Then manual drop table and constraints

     

  3. Then scaleup the POD.

Issue Symptoms

When he tried to spin up the alfresco app services which is alfresco-process-query-services it creates the tables on the public schema but then the customer deleted the tables and constraints on the tables and restarted the container. In the pod restart, it is checking the liquibase alter scripts not the create scripts. this is getting failed since it is trying to alter the objects whichever not exist.

Error exception on pod restart:

Expectation:
It should run createScript instead of alterScript since customer deleted the objects manually in the backend.

Question:
The customer wants to know after manual database table drop/deletion, was there any arguments to pass additionaly to recreate the objects instead of altering them?

Environment

AAE 7.1 M12, Postgresql

Testcase ID

None

Activity

Show:
Elias Ricken de Medeiros
April 1, 2021, 1:39 PM

, I was able to reproduce the issue after dropping the tables audit_event and databasechangelog_audit. Indeed, the clean-up of the database is not completed after dropping tables, the customer should also drop sequences. The error disappeared after I dropped the sequence audit_sequence. This should solve the issue for the customer as well:

drop sequence audit_sequence;

Elias Ricken de Medeiros
March 26, 2021, 6:18 PM
Edited

Is the customer dropping both databasechangelog_audit anddatabasechangelog_query? In order to try to reproduce it, we need exactly all the commands he has run against the database.

Assignee

Unassigned

Reporter

Seng Ei Liaw

Labels

None

Escalated By

None

Security Issue

None

ACT Numbers

00375235

Premier Customer

None

Code Branch

None

Build Location

None

Regression Since

None

Work Funnel End

None

Patch Attached

None

Dependent Version/s

None

Cloud or Enterprise

None

Prioritization Score

None

Delivery Team

None

Bug Priority

Category 2

Components

Affects versions