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

It worked. Thank you very much.

Mike Wilder
Cimcor, Inc.

On Fri, Jan 8, 2021 at 11:13 PM Mihir Pandya <mihir(dot)pandya(at)enterprisedb(dot)com>
wrote:

> Hi Michael,
>
> Thanks for reporting this bug. The fix is part of the updated installer
> postgresql-11.10-2-windows-x64.exe.
> Please download it.
>
> Regards,
> Mihir Pandya
>
> On Wed, Jan 6, 2021 at 6:57 PM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> 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"
>>
>>

--
Thank you,

michael wilder
Systems Engineer
Cimcor, Inc.
Office: 219-736-4400 x6085​
Mobile: 219-689-3704
Email: wilder(dot)michael(at)cimcor(dot)com
Web: https://www.cimcor.com
<https://twitter.com/cimtrak> <https://www.facebook.com/Cimtrak/>
<https://www.linkedin.com/company/cimcor-inc-/>

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise be protected by law. Any access,
use, disclosure or distribution of this email message by anyone other than
the intended recipient(s) is unauthorized and prohibited. If you are not an
intended recipient (or an agent acting on an intended recipient’s behalf),
please contact the sender by reply e-mail and immediately destroy all
copies of the original message.