AAE - Alfresco-process-query-service - Pod restarted with error after dropping tables
Customer reported that he reproduced this issue using Alfresco activiti services runing on M12 version with Postgresql database.
Step to reproduce:
Prior to drop the tables on the querysvc db, scaled down the POD
Then manual drop table and constraints
Then scaleup the POD.
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:
It should run createScript instead of alterScript since customer deleted the objects manually in the backend.
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?
AAE 7.1 M12, Postgresql
, 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;
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.