AWX Clean Up job cannot delete _unpartitioned tables

Get Help
,
1

We update AWX

  • from version 6 (…) to 24.6.1 by use of fitbeard awx without kubernetes
  • We use an external postgres 16 database.
  • After restoring the dump to the new version a AWX migration took place, and
  • everythings works fine, except for
  • the “Cleanup Job”. It says it deletes (thousands) of entries, but then fails on deleting the 5 unpartioned* tables.
  • When emptying these tables, a DROP tables fails, but a DROP CASCADE tables succeeds.
  • But then jobs will not show any output anymore while or after running.
    We get messages like:

cannot drop table _unpartitioned_main_adhoccommandevent because other objects depend on it
DETAIL: default value for column id of table main_adhoccommandevent depends on sequence main_adhoccommandevent_id_seq

and

django.db.utils.IntegrityError: update or delete on table “main_inventoryupdate” violates foreign key constraint “main_inventoryupdate_inventory_update_id_8974f1f7_fk_main_inve” on table “_unpartitioned_main_inventoryupdateevent”
DETAIL: Key (unifiedjob_ptr_id)=(523855) is still referenced from table “_unpartitioned_main_inventoryupdateevent”.

I understand the _unpartioned tables are introduced in v19 and are no longer of use anymore?
Dropping these tables changes the dump from 400Mb to a mere 40Mb, but leaves us with a partial functional AWX.

Is there a way to clean up wisely these _unpartioned tables?

Cheers, Huub