"ERROR: must be owner of relation vpx_sn_vdevice_backing_rel_seq" error vCenter Server Appliance 6.x
search cancel

"ERROR: must be owner of relation vpx_sn_vdevice_backing_rel_seq" error vCenter Server Appliance 6.x


Article ID: 324972


Updated On:


VMware vCenter Server


  • The upgrade/migration fails with the error:
VMware VirtualCenter failed firstboot. Database in-place upgrade failed. Please see vcdb_inplace.err and vcdb_inplace.out for details.
Please search for these symptoms in the VMware Knowledge Base for any known issues and possible resolutions. If none can be found, collect a support bundle and open a support request.
  • In firstbootStatus.json, you see entry similar to:
"failedSteps": "vpxd_firstboot"
  • In vpxd_firstboot.py_####_stdout.log and vcdb_inplace.err you see entry similar to:

ERROR: must be owner of relation vpx_sn_vdevice_backing_rel_seq

  • vCenter Server Appliance - Firstboot logs are located in the /var/log/firstboot directory.
  • vCenter Server on Windows - Firstboot logs are located in the VMware-VCS-logs-<year><month><day><hour><minute><second>.zip/vcs_logs/uninstall directory or the VMware-VCS-logs-<year><month><day><hour><minute><second>/vcs_logs/uninstall/<vCenter Hostname><year><month><day><hour><minute><second>.zip/ProgramData/VMware/vCenterServer/logs/firstboot directory.


VMware vCenter Server 7.0.x
VMware vCenter Server Appliance 6.0.x
VMware vCenter Server Appliance 6.5.x
VMware vCenter Server Appliance 6.7.x


The issue occurs when the db schema is not owned by the vCenter database user (vc).


To resolve this issue, the db schema owner must be changed to the default vCenter Server Appliance database user (vc).
  1. Connect to the vCenter Server Appliance using an SSH session or into the Bash shell
  2. Using WinSCP, copy the attached fix_sequence_owners.sh to the /tmp/ directory. 
  3. Run this command: 
chmod +x /tmp/fix_sequence_owners.sh
  1. To apply the required database permissions changes, run this command:
sh /tmp/fix_sequence_owners.sh

Additional Information


fix_sequence_owner.sh get_app