Error Upgrade from version 2.37 to 2.38

Hi Community,
I get an error when I wanted to upgrade an instance from 2.37 to 2.38:

ERROR: could not create unique index “in_userinfo_openid”
Detail: Key (openid)=( ) is duplicated.

Note: I was able to upgrade my copy of the demo database with no issues.
If anyone has similar issue let me know how it was solved.

Attached is the full log file
log2.38upgradeError.docx (22.5 KB)

1 Like

Hi Jean
I asked for support from the developers as well as server administrators. All ‘caused by’ errors refer to the table “Migration V2_38_36__Drop_users_table.sql” any clue?

Thanks!

Hi,

here is a SQL query you could use to find the duplicates:

select * from users ou
where (select count(*) from users inr
where inr.openid = ou.openid) > 1

Once the duplicate values are identified, you would need to change or remove them before you can restart the upgrade.

Kind regards
Morten

2 Likes

Thanks after updating the duplicate openid i managed to upgrade to 2.38 successfully.