Unexpected behaviour since Windows 1903 Update

From: "Koorsen, Andre" <andre(dot)koorsen(at)cgm(dot)com>
To: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Cc: "Frylinck, Andre" <andre(dot)frylinck(at)cgm(dot)com>, "Paynter, Cole" <Cole(dot)Paynter(at)cgm(dot)com>
Subject: Unexpected behaviour since Windows 1903 Update
Date: 2019-09-18 11:39:39
Message-ID: B8A21D4745560A469A081863F39FE81D4699CFD0@SMBXKO4.cgm.ag
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good day PG team,

We have noticed some of our clients' backups not being created since the 1903 Windows update.
We are struggling to find the cause of the problem and decided to rely on you for guidance.

We have a scheduled task running a backup.exe which is essentially a java ProcessBuilder gathering all the databases and dumping it with pg_dump.
After the update no backups seem to be created and the logs just seem to stop at the the psql --version command.

Log from broken machine after Windows Update:
PGCommand.cleanup: Removing temporary files from crashed runs...
PGCommand.FileFinder: C:\WINDOWS\TEMP
Regex: C:\\WINDOWS\\TEMP\\\\za\.co\.reactor\.postgres\.PGCommand\..*\.tmp
PGCommand.cleanup: Done.
Executing:
PGUSER=sa
PGPASSWORD=*****
C:\Program Files (x86)\PostgreSQL\8.3\bin\psql -h SAPPCPT28 -p 5432 -A -t -c "select version()" postgres
PGCommand.FileFinder: C:\Program Files (x86)\PostgreSQL\8.3\bin
Regex: .*\\pg_dump.exe$
found: C:\Program Files (x86)\PostgreSQL\8.3\bin\pg_dump.exe
Executing:
PGUSER=sa
PGPASSWORD=*****
C:\Program Files (x86)\PostgreSQL\8.3\bin\psql -h SAPPCPT28 -p 5432 -A -t -c "select version()" postgres

Logs from working machine before Windows Update:
PGCommand.cleanup: Removing temporary files from crashed runs...
PGCommand.FileFinder: C:\Windows\TEMP
Regex: C:\\Windows\\TEMP\\\\za\.co\.reactor\.postgres\.PGCommand\..*\.tmp
PGCommand.cleanup: Done.
Executing:
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\psql -h localhost -p 5432 -A -t -c "select version()" postgres
Executing:
PGHOST=localhost
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe --version
Executing:
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\psql -h localhost -p 5432 -A -t -c "select version()" postgres
Executing:
PGHOST=localhost
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\psql.exe --version
Executing:
PGHOST=localhost
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\psql.exe -A -t -c "select array(select datname from pg_database where datname !~ 'template|^postgres$')" postgres
PGCommand.getPgDBs: Found ops_services,mededi,test,90,00 for owner null
Executing:
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe --blobs --encoding=UTF-8 --clean --create --format=custom --compress=9 -h localhost -f C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp ops_services ..
Copying: C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp to bak\ops_services.20190918.0.backup.zip
Rotating: bak\ops_services.%d.%u.backup.zip
PGCommand.FileFinder: bak
Regex: bak\\ops_services\.[0-9]{8}\.[0-9]*\.backup\.zip
found: bak\ops_services.20190912.0.backup.zip
found: bak\ops_services.20190913.0.backup.zip
found: bak\ops_services.20190913.1.backup.zip
found: bak\ops_services.20190914.0.backup.zip
found: bak\ops_services.20190915.0.backup.zip
found: bak\ops_services.20190916.0.backup.zip
found: bak\ops_services.20190917.0.backup.zip
found: bak\ops_services.20190918.0.backup.zip
Deleted file: bak\ops_services.20190912.0.backup.zip
PGCommand.pg_dump ops_services - OK.

Executing:
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe --blobs --encoding=UTF-8 --clean --create --format=custom --compress=9 -h localhost -f C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp mededi
Copying: C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp to bak\mededi.20190918.0.backup.zip
Rotating: bak\mededi.%d.%u.backup.zip
PGCommand.FileFinder: bak
Regex: bak\\mededi\.[0-9]{8}\.[0-9]*\.backup\.zip
found: bak\mededi.20190912.0.backup.zip
found: bak\mededi.20190913.0.backup.zip
found: bak\mededi.20190913.1.backup.zip
found: bak\mededi.20190914.0.backup.zip
found: bak\mededi.20190915.0.backup.zip
found: bak\mededi.20190916.0.backup.zip
found: bak\mededi.20190917.0.backup.zip
found: bak\mededi.20190918.0.backup.zip
Deleted file: bak\mededi.20190912.0.backup.zip
PGCommand.pg_dump mededi - OK.

Executing:
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe --blobs --encoding=UTF-8 --clean --create --format=custom --compress=9 -h localhost -f C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp test
Copying: C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp to bak\test.20190918.0.backup.zip
Rotating: bak\test.%d.%u.backup.zip
PGCommand.FileFinder: bak
Regex: bak\\test\.[0-9]{8}\.[0-9]*\.backup\.zip
found: bak\test.20190912.0.backup.zip
found: bak\test.20190913.0.backup.zip
found: bak\test.20190913.1.backup.zip
found: bak\test.20190914.0.backup.zip
found: bak\test.20190915.0.backup.zip
found: bak\test.20190916.0.backup.zip
found: bak\test.20190917.0.backup.zip
found: bak\test.20190918.0.backup.zip
Deleted file: bak\test.20190912.0.backup.zip
PGCommand.pg_dump test - OK.

Executing:
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe --blobs --encoding=UTF-8 --clean --create --format=custom --compress=9 -h localhost -f C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp 90 .....
Copying: C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp to bak\90.20190918.0.backup.zip
Rotating: bak\90.%d.%u.backup.zip
PGCommand.FileFinder: bak
Regex: bak\\90\.[0-9]{8}\.[0-9]*\.backup\.zip
found: bak\90.20190912.0.backup.zip
found: bak\90.20190913.0.backup.zip
found: bak\90.20190913.1.backup.zip
found: bak\90.20190914.0.backup.zip
found: bak\90.20190915.0.backup.zip
found: bak\90.20190916.0.backup.zip
found: bak\90.20190917.0.backup.zip
found: bak\90.20190918.0.backup.zip
Deleted file: bak\90.20190912.0.backup.zip
PGCommand.pg_dump 90 - OK.

Executing:
PGPORT=5432
PGUSER=sa
PGPASSWORD=*****
C:\Program Files\PostgreSQL\9.4\bin\pg_dump.exe --blobs --encoding=UTF-8 --clean --create --format=custom --compress=9 -h localhost -f C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp 00 ............................
Copying: C:\Windows\TEMP\za.co.reactor.postgres.PGCommand.7998280513031952264.tmp to bak\00.20190918.0.backup.zip
Rotating: bak\00.%d.%u.backup.zip
PGCommand.FileFinder: bak
Regex: bak\\00\.[0-9]{8}\.[0-9]*\.backup\.zip
found: bak\00.20190912.0.backup.zip
found: bak\00.20190913.0.backup.zip
found: bak\00.20190913.1.backup.zip
found: bak\00.20190914.0.backup.zip
found: bak\00.20190915.0.backup.zip
found: bak\00.20190916.0.backup.zip
found: bak\00.20190917.0.backup.zip
found: bak\00.20190918.0.backup.zip
Deleted file: bak\00.20190912.0.backup.zip
PGCommand.pg_dump 00 - OK.

Thanks in advance.

Kind Regards / Vriendelike Groete / Beste Grüße / Cordiali Saluti

André Koorsen

Intermediate Java Developer.

[Description: Description: Description: Beschreibung: Beschreibung: Beschreibung: Beschreibung: Beschreibung: Beschreibung: cid:9D3999A1-695A-444B-B7E7-5DAEA298BAE8]

CompuGroup Medical South Africa (Pty) Ltd
Aurecon West
1 Century City Drive
Waterford Precinct
Century City
Cape Town
South Africa, 7441
andre(dot)koorsen(at)cgm(dot)com<mailto:andre(dot)koorsen(at)cgm(dot)com>
www.cgm.com/za<http://www.cgm.com/>

Board of directors: Thorsten P. Kollet, Dr Gerhard J. Schütz, Mervyn J. Cookson
CompuGroup Medical SA (Pty) Ltd.
Company Reg. No. 2005/023029/07
VAT No. 432 022 6063
Synchronizing Healthcare
Before printing, think about the environment.
DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.

Browse pgsql-sql by date

  From Date Subject
Next Message john snow 2019-09-19 03:47:44 any alternative to pg-safeupdate for windows 10?
Previous Message Iuri Sampaio 2019-09-12 23:17:06 Re: Looking for technical references on how to set up PostGIS/PostgreSQL for serving MapInfo Desktop application users