Unexpected behaviour since Windows 1903 Update

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Unexpected behaviour since Windows 1903 Update

Koorsen, Andre

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 

[hidden email]
www.cgm.com/za

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.