Upgrading Database fails

bchampion

When doing a maintenance mode upgrade of the database, I am getting this error in the logs

-- Update the version
UPDATE version
SET version = '1.18.0';
. Cause: org.postgresql.util.PSQLException: ERROR: cannot drop table old_identities because other objects depend on it
Detail: view verus_users depends on table old_identities
Hint: Use DROP ... CASCADE to drop the dependent objects too.

Any thoughts on why this would be occurring?

dan

What version are you upgrading from/to?

bchampion

@dan 1.17.5 - 1.18.4

dan

Hmmmm.

...
Detail: view verus_users depends on table old_identities
...

I'm not familiar with the verus_users view and am not sure why that would be in the FusionAuth database. As far as I can tell, that isn't a standard part of the FusionAuth data model.

Did someone at your organization perhaps create a view to get access to the FusionAuth data? If so, you'd need to remove that view manually to perform the upgrade, then recreate it later.

Hope that helps.