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

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

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

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16808
Logged by:          Michael Wilder
Email address:      [hidden email]
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"

Reply | Threaded
Open this post in threaded view
|

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

Mihir Pandya
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 <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16808
Logged by:          Michael Wilder
Email address:      [hidden email]
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"

Reply | Threaded
Open this post in threaded view
|

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

michael wilder
It worked. Thank you very much.

Mike Wilder
Cimcor, Inc.


On Fri, Jan 8, 2021 at 11:13 PM Mihir Pandya <[hidden email]> 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 <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16808
Logged by:          Michael Wilder
Email address:      [hidden email]
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: [hidden email]
Web: https://www.cimcor.com
      

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.