Bug ID 968945: Postgres service fails to restart with orphaned processes

Last Modified: Nov 22, 2021

Bug Tracker

Affected Product:  See more info
BIG-IQ Platform(all modules)

Known Affected Versions:
7.1.0, 7.1.0.1, 7.1.0.2, 7.1.0.3, 7.1.6, 7.1.6.1, 7.1.7, 7.1.7.1, 7.1.7.2, 7.1.8, 7.1.8.1, 7.1.8.2, 7.1.8.3, 7.1.8.4, 7.1.8.5, 7.1.9, 7.1.9.7, 7.1.9.8, 7.1.9.9

Opened: Dec 02, 2020
Severity: 3-Major

Symptoms

The postgres service gets stuck trying to restart due to child processes from a previous instance not terminating.

Impact

The postgres service will not start for some time, often up to an hour. During this period other critical services also cannot start or cannot operate correctly.

Conditions

This is most often seen on first boot into an upgraded BIG-IQ 7000 system. Other rare cases might also exist.

Workaround

Find the remaining child processes with this command: # pgrep -a -u postgres Kill these processes with the "kill" command. Typically the only processes that need to be killed are listed with "autovacuum" in the process title, so start with those.

Fix Information

None

Behavior Change