BUG #13595: pg_ctl.exe interferes with GPClient.exe

From: it(at)ramsoft(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13595: pg_ctl.exe interferes with GPClient.exe
Date: 2015-08-29 01:42:42
Message-ID: 20150829014242.2090.78049@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13595
Logged by: Nick Childs
Email address: it(at)ramsoft(dot)com
PostgreSQL version: 9.1.18
Operating system: Windows Server 2012 R2
Description:

We use PostgreSQL version 9.1.18 as part of a Pentaho deployment in our
software. We have a service called, "RamSoft Essence Solution Repository
Service," which runs the following command:

C:/Program Files/RamSoft/Essence/postgresql/bin/pg_ctl.exe runservice -N
"RamSoft Essence Solution Repository" -D "C:/Program
Files/RamSoft/Essence/postgresql/data"

About 6 months ago, we believe we were hit with the following bug in a
previous version of PostgreSQL, which caused major login/reboot delays due
to a hung gpclient process when Registry/Printer/Shortcut GPO's are applied
to the server running PostgreSQL:
http://www.postgresql.org/message-id/CAEB4t-NpXGiP5Bqvv3P+d+x=V4BqE+Awg+G7ennBn8icPXep_g@mail.gmail.com
- it would delay the ability to log in to the server or reboot for over 40
minutes, unless gpclient.exe was force killed or the service was disabled
before reboot.

Our Development team provided a procedure to upgrade PostgreSQL to 9.1.18,
which does appear to have successfully resolved the login/reboot delay
issues with our domain-joined machines running PostgreSQL for all GPO's
except a shortcut GPO that is applied in one of our datacenters. For some
reason, this specific shortcut policy still triggers the bug after 9.1.18
upgrade.

However, we have noticed an additional behavior/problem between pg_ctl.exe
and gpclient.exe in domain environments with Registry/Printer/Shortcut GPO's
applied:

- Reboot VM; no extended delays are experienced
- Log in to VM: no extended delays are experienced
- Open Administrative Command Prompt, and run: gpupdate /force - command
hangs indefinitely; never completes
- Stop Essence Solution Repository Service (pg_ctl.exe)
- Re-run gpupdate /force - completes very quickly, and successfully
- Start Essence Solution Repository Service
- Re-run gpupdate /force - completes very quickly, and successfully
- Perform reboot
- gpupdate /force hangs again, until we stop/start Essence Solution
Repository Service

Disabling Essence Solution Repository Service before the reboot allows
gpupdate /force to complete quickly and successfully immediately after
logging in. Starting the service after login allows gpupdate /force to
complete. Setting the service to delayed start does NOT allow gpupdate
/force to complete unless it is stopped/started before running the command.

So, it seems that there is still some sort of conflict between the initial
state of Essence Solution Repository Service (pg_ctl.exe) and gpclient.exe -
it needs to be stopped before gpupdate /force can run successfully, for some
reason.

- Is this a known issue on 9.1.18?
- Is this reproducible for you?
- We also need to know why version 9.1.18 fixed the delays for all GPO
settings except for Shortcut-related policies.
- Is there anything we can do to help you solve this problem?

Please let us know if you have any questions.

Browse pgsql-bugs by date

  From Date Subject
Next Message Noah Misch 2015-08-29 05:42:39 Re: [BUGS] Compile fails on AIX 6.1
Previous Message Tom Lane 2015-08-28 22:34:16 Re: [BUGS] Compile fails on AIX 6.1