Loading...
Loading...
vCenter Server Appliance 6.7 upgrade fails during Update Manager firstboot while creating VUM Database with error:"Failed to create VUM database"You will see similar entries in /var/log/firstboot/updatemgr-firstboot.py_####_stdout.log 2019-04-17T22:08:04.346Z Exception caught in checkException: Failed to create Database schema2019-04-17 22:08:04,347 UpdateMgr received BaseInstallException '{ "detail": [ { "localized": "Failed to create VUM database", "translatable": "Failed to create VUM database", "id": "install.updatemgr.error.db_create" }, { "localized": "Failed to setup VUM database", "translatable": "Failed to setup VUM database", "id": "install.updatemgr.error.db_setup" } ], "resolution": { "localized": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a support request.", "translatable": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a support request.", "id": "install.updatemgr.resolution.common" }, "problemId": "install.updatemgr.firstboot", "componentKey": "Update Manager"}' during action 'firstboot'.Traceback (most recent call last): File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 106, in proxy return func(self, *args, **kwargs) File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 577, in _createDataBaseSchema raise LoggedException("Failed to create Database schema")LoggedException: Failed to create Database schemaDuring handling of the above exception, another exception occurred:Traceback (most recent call last): File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 710, in Main updateMgrFB.firstbootAction() File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 668, in firstbootAction self._setupDataBase(msg) File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 106, in proxy return func(self, *args, **kwargs) File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 530, in _setupDataBase self._createDataBaseSchema(msg) File "/usr/lib/vmware-updatemgr/firstboot/updatemgr-firstboot.py", line 117, in proxy problemId="install.updatemgr.firstboot")cis.baseCISException.BaseInstallException: { "detail": [ { "localized": "Failed to create VUM database", "translatable": "Failed to create VUM database", "id": "install.updatemgr.error.db_create" }, { "localized": "Failed to setup VUM database", "translatable": "Failed to setup VUM database", "id": "install.updatemgr.error.db_setup" } ], "resolution": { "localized": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a support request.", "translatable": "Search for these symptoms in the VMware knowledge base for any known issues and possible workarounds. If none can be found, collect a support bundle and open a support request.", "id": "install.updatemgr.resolution.common" }, "problemId": "install.updatemgr.firstboot", "componentKey": "Update Manager"}Updatemgr-Firstboot.py:2019-04-18 21:25:58.647 UTC 5cb8eb66.56dc 0 VCDB postgres ERROR: role "vumuser" already exists2019-04-18 21:25:58.647 UTC 5cb8eb66.56dc 0 VCDB postgres STATEMENT: CREATE USER vumuser WITH PASSWORD 'yIqMtKL7=3r01$gG';2019-04-18 21:25:59.107 UTC 5cb8eb67.5700 0 VCDB vumuser FATAL: password authentication failed for user "vumuser"2019-04-18 21:25:59.107 UTC 5cb8eb67.5700 0 VCDB vumuser DETAIL: Password does not match for user "vumuser"
This issue occurs when the role "vumuser" already exists and its trying to create the user vumuser .
Take a backup of the VUM database.Take a snapshot of the VCSA appliance.Run the below commands to connect to DB and drop the users, /opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDBDrop owned by vumuser;Drop user vumuser; Re-run the VCSA upgrade process again.
Click on a version to see all relevant bugs
VMware Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.