HI, I´m updating my environment from 7.3 to 7.5, and the same fail in the post-scripts with the error:
"Update failed (code 0-2)"
Checking some log I found this:
NOTICE: Found extension citext and it exists in pg_catalog
There are errors while upgrading the webapps database. Check /var/log/vcac/vcac-config.log for more information.
+ res=2
+ echo 'Script /etc/bootstrap/postupdate.d/20-vcac failed, error status 2'
+ exit 2
and this:
Upgrade:
Command execution failed with unexpected error: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/catalog-service-BUG2067627.xml::1::BUG2067627:
Reason: liquibase.exception.DatabaseException:
Error executing SQL ALTER TABLE public.cat_tenant ALTER COLUMN id TYPE CITEXT: ERROR: could not create unique index "cat_tenant_pkey"
Detail: Key (id)=(LabAca) is duplicated..
Check de DB:
id | lastsync | name
---------------+-----------------------------+------------
LabAca | 2017-05-29 05:54:24.057 | LabAca
labaca | 2018-11-15 10:24:39.504 | LabAca
test | 2017-04-28 17:09:25.642 | test
Finally i found it, the error is clear (duplicated id in postgress DB table), but I can´t delete the first register because foreign restrictions.
Any idea of how I can fix this?
Regards for any ideas.
Hi. I am running a 7.3 to 7.5 upgrade and had the same error. Dup[licate tenant key. Was wondering how you fixed this?
Also any chance you could post the SQL cmd to list the duplicate entry as I can't get the table to list (my syntax is wrong) .
Thanks.
Have found the reasons for this error.