ERROR: canceling autovacuum task


Question :-  What this error "canceling autovacuum task" denotes in Director logs ?

Answer:-  While  importing the database from one Director to other. you may see some errors in TRUSTY environment


2024-11-12 03:42:56 UTC [12884-1] ERROR:  canceling autovacuum task   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
2024-11-12 03:42:56 UTC [12884-2] CONTEXT:  automatic analyze of table "vnms.public.alarm_change"
2024-11-12 03:42:56 UTC [12723-4] postgres@vnms LOG:  process 12723 acquired AccessExclusiveLock on relation 26464 of database 26038 after 1000.523 ms
2024-11-12 03:42:56 UTC [12723-5] postgres@vnms STATEMENT:  ALTER TABLE ONLY public.alarm_change
            ADD CONSTRAINT alarm_change_pkey PRIMARY KEY (id);


vacuum will basically cleanup unused or deleted entries in postgres. 


 Since it's cancelled it shouldn't cause any issue.


If you upgrade to 22.1.4, we manually run vacuum to free up some disk space.


"cancelling autovaccum task" during the DB import is deemed to be innocuous/irrelevant, it's not an issue.