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"
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 |