BUG #16808: Postgres Windows installer fails with unknown error and terminates

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: wilder(dot)michael(at)cimcor(dot)com
Subject: BUG #16808: Postgres Windows installer fails with unknown error and terminates
Date: 2021-01-06 03:25:26
Message-ID: 16808-4aee39460fb3cd25@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: 16808
Logged by: Michael Wilder
Email address: wilder(dot)michael(at)cimcor(dot)com
PostgreSQL version: 11.10
Operating system: Windows 8.1
Description:

upgrading windows Postgres from 11.2 to 11.10

fails to install

unknown error reported and Install Builder terminates

I ran installer executable as adminstrator

Install Builder script is incorrectly adding lower case "i" before the "C:\"
drive in path causing command to fail.
Errorneous command: Executing iC:\WINDOWS\System32\icacls "C:\Program
Files\PostgreSQL\11\data" /T /Q /grant "NT
AUTHORITY\NetworkService:(OI)(CI)F"
I removed the leading "i" and ran command in the command prompt with no
problem.

See attached log below. Error is at the bottom of log

Installer executable (from EDB): postgresql-11.10-1-windows-x64.exe

Windows system: Windows 8.1 Pro, 64 bit
updates current as of Dec 9 2020

Install log:

Log started 01/05/2021 at 20:41:26
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Setting variable whoami from C:\WINDOWS\System32\whoami
Script exit code: 0

Script output:
cimcor\wilder.michael

Script stderr:

Executing C:\WINDOWS\System32\icacls
"C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be"
/inheritance:r
Script exit code: 0

Script output:
processed file:
C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be
Successfully processed 1 files; Failed processing 0 files

Script stderr:

Executing C:\WINDOWS\System32\icacls
"C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be"
/T /Q /grant "cimcor\wilder.michael:(OI)(CI)F"
Script exit code: 0

Script output:
Successfully processed 1 files; Failed processing 0 files

Script stderr:

Executing C:\WINDOWS\System32\cscript //NoLogo
"C:\Users\wilder.michael\AppData\Local\Temp\postgresql_installer_ec3c8740be\prerun_checks.vbs"
Script exit code: 0

Script output:
The scripting host appears to be functional.

Script stderr:

[20:41:32] Using branding: PostgreSQL 11
Executing
C:\Users\wilder.michael\AppData\Local\Temp/postgresql_installer_ec3c8740be/temp_check_comspec.bat

Script exit code: 0

Script output:
"test ok"

Script stderr:

Could not find registry key
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-x64-11
DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
[20:41:33] Existing base directory: C:\Program Files\PostgreSQL\11
[20:41:33] Existing data directory: C:\Program Files\PostgreSQL\11\data
[20:41:33] Using branding: PostgreSQL 11
[20:41:33] Using Super User: postgres and Service Account: NT
AUTHORITY\NetworkService
[20:41:33] Using Service Name: postgresql-x64-11
Executing
C:\Users\wilder.michael\AppData\Local\Temp\postgresql_installer_ec3c8740be\pg_controldata.exe
"C:\Program Files\PostgreSQL\11\data"
Script exit code: 0

Script output:
pg_control version number: 1100
Catalog version number: 201809051
Database system identifier: 6833885629359526376
Database cluster state: shut down
pg_control last modified: 1/5/2021 8:03:44 PM
Latest checkpoint location: 0/2D8F750
Latest checkpoint's REDO location: 0/2D8F750
Latest checkpoint's REDO WAL file: 000000010000000000000002
Latest checkpoint's TimeLineID: 1
Latest checkpoint's PrevTimeLineID: 1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID: 0:1400
Latest checkpoint's NextOID: 24601
Latest checkpoint's NextMultiXactId: 1
Latest checkpoint's NextMultiOffset: 0
Latest checkpoint's oldestXID: 562
Latest checkpoint's oldestXID's DB: 1
Latest checkpoint's oldestActiveXID: 0
Latest checkpoint's oldestMultiXid: 1
Latest checkpoint's oldestMulti's DB: 1
Latest checkpoint's oldestCommitTsXid:0
Latest checkpoint's newestCommitTsXid:0
Time of latest checkpoint: 1/5/2021 8:03:44 PM
Fake LSN counter for unlogged rels: 0/1
Minimum recovery ending location: 0/0
Min recovery ending loc's timeline: 0
Backup start location: 0/0
Backup end location: 0/0
End-of-backup record required: no
wal_level setting: replica
wal_log_hints setting: off
max_connections setting: 100
max_worker_processes setting: 8
max_prepared_xacts setting: 0
max_locks_per_xact setting: 64
track_commit_timestamp setting: off
Maximum data alignment: 8
Database block size: 8192
Blocks per segment of large relation: 131072
WAL block size: 8192
Bytes per WAL segment: 16777216
Maximum length of identifiers: 64
Maximum columns in an index: 32
Maximum size of a TOAST chunk: 1996
Size of a large-object chunk: 2048
Date/time type storage: 64-bit integers
Float4 argument passing: by value
Float8 argument passing: by value
Data page checksum version: 0
Mock authentication nonce:
24c99494b0510fdd51313a6c8ff5344f7ac120c1f7413e99a8452cac1dbd8cc9

Script stderr:

[20:41:35] Existing cluster catalog version: 201809051, installer catalog
version: 201809051
[20:41:35] Existing cluster Date/time settings: 64-bit integers, installer
Date/time settings: 64-bit integers
[20:41:35] Existing cluster pg_control version number: 1100, installer
pg_control version number: 1100
[20:41:35] Switching to upgrade mode with cluster: C:\Program
Files\PostgreSQL\11\data
[20:42:49] Reading port number from C:\Program
Files\PostgreSQL\11\data/postgresql.conf
Preparing to Install
[20:44:53] Removing OpenSSL 1.0.2 files from installdir if exist
Preparing to Install
[20:44:54] Fixing the ACLs on data directory
Executing C:\WINDOWS\System32\icacls "C:\Program Files\PostgreSQL\11\data"
/inheritance:r
Script exit code: 0

Script output:
processed file: C:\Program Files\PostgreSQL\11\data
Successfully processed 1 files; Failed processing 0 files

Script stderr:

Executing C:\WINDOWS\System32\icacls "C:\Program Files\PostgreSQL\11\data"
/T /Q /grant "wilder.michael:(OI)(CI)F"
Script exit code: 0

Script output:
Successfully processed 1784 files; Failed processing 0 files

Script stderr:

Executing iC:\WINDOWS\System32\icacls "C:\Program Files\PostgreSQL\11\data"
/T /Q /grant "NT AUTHORITY\NetworkService:(OI)(CI)F"
Script exit code:

Script output:

Script stderr:

Unknown error while running iC:\WINDOWS\System32\icacls "C:\Program
Files\PostgreSQL\11\data" /T /Q /grant "NT
AUTHORITY\NetworkService:(OI)(CI)F"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-01-06 15:42:09 BUG #16809: Package postgresql96-9.6.20-2PGDG.rhel7.x86_64 is not signed
Previous Message Etsuro Fujita 2021-01-06 03:15:38 Re: BUG #16807: Assert failed in postgres_fdw/estimate_path_cost_size with an empty foreign table