"ERROR: could not open shared memory segment "/PostgreSQL.3434571624": No such file or directory" error during Cloud Director upgrade

Products

• VMware Cloud Director

Issue/Introduction

Symptoms:

• Cloud Director Appliance upgrade fails during the Database Schema section.
• ERROR: could not open shared memory segment "/PostgreSQL.nnnnnnnnn": No such file or directory

 

Environment

VMware Cloud Director 10.x
VMware Cloud Director 10.5

Cause

This issue occurs due to the way in which the postgres user account is created.
During creation it is not created as a system user and as such, can have their IPC resource cleaned which may lead to postgres crashing with errors such as the above.

Resolution

This is a known issue impacting Cloud Director versions 10.4.0 - 10.4.2 and 10.5.0.
This issue is resolved in versions 10.4.3 and 10.5.1 found at Broadcom Downloads.

Workaround:

If you are unable to upgrade to 10.4.3 or 10.5.1, you can follow the workaround below:

1. On each appliance perform steps a-e: 
   1. Edit /etc/systemd/logind.conf
   2. Uncomment #RemoveIPC=yes
   3. Change RemoveIPC=yes to RemoveIPC=no
   4. Save /etc/systemd/logind.conf
   5. Restart the appliance.
2. Execute the upgrade