During the upgrade from 6.1.0 to 6.2.0 with PostgreSQL in HA environment, the database might run into locking contention and consequently errors for "duplicate key" of node ids, as this error is on every node_id:
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "node_meta_infos_pk"
Detail: Key (node_id)=(26023197) already exists.
Rolling restart might resolve the issue, but that is not always helping.
See stacktrace attached.
Note the above duplicate node_id error appears on every id and not only on a single node id only.