Postgres/Troubleshooting

Problem Description: Gigaflow and Response services not starting due to inconsistent state for postgres service.

Symptoms: Windows service manager indicates that the postgres service is “stopped” but task manager shows one or more instances of postgres.exe is running. Gigaflow and Response services fail to start.

Root Cause: This problem can occur when the postgres service takes longer than expected to report a healthy status to the windows service manager. As a result, Windows service manager (incorrectly) assumes that the service has failed to start properly. If postgres has been configured as a dependency for Gigaflow services, neither will start unless Windows is reporting that Postgres has started properly. Delayed start-up is most commonly seen if database has not been shutdown gracefully and enters “recovery mode” upon subsequent start-up. However, delayed start may occur for other reasons.

Resolution: Check recent output in postgres data\logs folder to confirm postgres is running in a healthy state (i.e. that recovery mode has completed successfully). Using Task Manager, check that there are postgres.exe processes running in the Details tab. Manually stop the postgres service from an admin command prompt by using “pg_ctl.exe”, then restart the windows service for postgres. Finally, start “Gigaflow” services.

To manually stop postgres (without service manager), from an administrator command prompt (changing loactions as appropriate)

"c:\Program Files\PostgreSQL\11\bin\pg_ctl.exe" stop -D "c:\Program Files\PostgreSQL\11\data"

To manually start postgres (without service manager), from an administrator command prompt (changing loactions as appropriate)

"c:\Program Files\PostgreSQL\11\bin\pg_ctl.exe" start  -D "c:\Program Files\PostgreSQL\11\data"

You can find out where the exe and data folders are by looking at the properties of the Postgres service in the windows service manager (you can drag and double click on the path to copy/see the whole line)

• 

  Exe location

• 

  Data folder location

Problem Description:

Postgres installer fails with "An error occured executing the Microsoft VC++ runtime installer

Symptoms:

During installation of Gigaflow, when it tries to launch the postgres installer, you get the above Error. 

Root Cause: This can be caused by 2 issues,

1) A newer version of VC++ has been installed already as part of another tool or windows update
2) Required updates haven't yet been installed.

Resolution: Issue 1: Run the postgres installer from an administrator command prompt with the following additional aruments "--install_runtimes 0"

Issue 2: Visual Studio 2015 C++ Re-distributable requires Windows Server 2012 R2 with Update (KB2919335) installed.

Update KB2919335 will required update KB2919442 to already be installed.

KB2919442 is not available automatically via Windows Update to Windows Server 2012 R2.

The fix is: 1. Download and install KB2919442. 2. Download and install KB2919355 which includes KB2919335 3. Install GigaFlow with Visual Studio 2015 C++ Redistributable and PostgreSQL.

Here are the 2 KB that need to be installed before GigaFlow 1. Windows8.1-KB2919442-x64.msu ( must be installed before KB2919355) 2. Windows8.1-KB2919355-x64.msu