Recent windows update kb5019959 block part of psql execution from bat file when called by installer

Question

Recent windows update kb5019959 block part of psql execution from bat file when called by installer

Sriman Narayanan S 1

As part of the installer, we are creating postgresql database using psql by calling from a batch file. After recent windows update [ kb5019959 ] the database creation part fails. tried with both windows 10 & 11. still the installation is getting fails. verified by uninstalling kb it works fine

content of bat file :

set AppDir=%~dp0

if %AppDir:~-1%==\ set AppBinPath=%AppDir:~0,-1%

@Rem85 set Parent path

for %%? in ("%~dp0..") do set TOPDIR=%%~f?

set CALog="%temp%\InstallConfig.log"

@Echo ================================================= >> %CALog%

@Echo Database Configuration >> %CALog%

@Echo ================================================= >> %CALog%

@Echo . >> %CALog%

@Echo Current Directory = %TOPDIR% >> %CALog%

@Echo . >> %CALog%

set PSQLInitDBAppPath="%TOPDIR%\pgsql\bin\initdb.exe"

set PSQLCTLAppPath="%TOPDIR%\pgsql\bin\pg_ctl.exe"

set PSQLAppPath="%TOPDIR%\pgsql\bin\psql.exe"

@Echo Creating database...

@Echo Creating database... >> %CALog%

icacls "%TOPDIR%\var" /grant *S-1-5-32-545:(OI)(CI)(F)

%PSQLInitDBAppPath% -D "%TOPDIR%\var\db" -E 'UTF-8' -U daemon

@Echo Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Updating database configuration...

@Echo Updating database configuration... >> %CALog%

rename "%TOPDIR%\var\db*.conf" *.bak

@Echo Backup configuration: Result = %ERRORLEVEL% >> %CALog%

replace "%TOPDIR%\tmp\psql*.conf" "%TOPDIR%\var\db" /a

@Echo Copy New files: Result = %ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Rem85 RMDIR /s /q "%TOPDIR%\tmp\psql"

@Rem85 moving to postgresql bin directory

@Echo Starting database...

@Echo Starting database... >> %CALog%

rem TIMEOUT /T 10

mkdir "%TOPDIR%\var\basedb"

icacls "%TOPDIR%\var\basedb" /grant *S-1-5-32-545:(OI)(CI)(F)

@Echo Permission: Result = %ERRORLEVEL% >> %CALog%

%PSQLCTLAppPath% -s -w start -D "%TOPDIR%\var\db"

@Echo PSQL_CTL: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Creating base tablespace...

@Echo Creating base tablespace... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -c "CREATE TABLESPACE basedb OWNER daemon LOCATION '%TOPDIR%/var/basedb/'" postgres

@Echo BaseDB: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Creating base database...

@Echo Creating base database... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -c "CREATE DATABASE base TABLESPACE basedb" postgres

@Echo Database: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Creating database link...

@Echo Creating database link... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -c "CREATE EXTENSION dblink" base

@Echo Link: Result= %ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Creating base tables...

@Echo Creating base tables... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -d base -f "%TOPDIR%\etc\db\setup.sql"

@Echo Tables: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Initializing base tables...

@Echo Initializing base tables... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -d base -f "%TOPDIR%\etc\db\init_windows.sql"

@Echo Init: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

if exist "%TOPDIR%\tmp\scripts\default\license.sql" (

@Echo Initializing license tables...

@Echo Initializing license tables... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -d base -f "%TOPDIR%\tmp\scripts\default\license.sql"

@Echo License: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

)

if exist "%temp%\reseller.sql" (

@Echo Adding reseller information...

@Echo Adding reseller information... >> %CALog%

%PSQLAppPath% -q -h 127.0.0.1 -p 55100 -U daemon -d base -f "%temp%\reseller.sql"

@Echo Reseller: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

)

@Echo Stop database...

@Echo Stop database... >> %CALog%

%PSQLCTLAppPath% -s -D "%TOPDIR%\var\db" -w stop -m f

@Echo Stop: Result=%ERRORLEVEL% >> %CALog%

@Echo . >> %CALog%

@Echo Database configuration completed.

@Echo Database configuration completed. >> %CALog%

@Echo ================================================= >> %CALog%

Postgresql LOG:

[2022-11-19 00:38:45.947 IST] LOG: database system was shut down at 2022-11-19 00:38:45 IST

[2022-11-19 00:38:45.947 IST] DEBUG: mapped win32 error code 2 to 2

[2022-11-19 00:38:45.947 IST] DEBUG: checkpoint record is at 0/16A7670

[2022-11-19 00:38:45.947 IST] DEBUG: redo record is at 0/16A7670; shutdown TRUE

[2022-11-19 00:38:45.947 IST] DEBUG: next transaction ID: 0/672; next OID: 11913

[2022-11-19 00:38:45.947 IST] DEBUG: next MultiXactId: 1; next MultiXactOffset: 0

[2022-11-19 00:38:45.947 IST] DEBUG: oldest unfrozen transaction ID: 662, in database 1

[2022-11-19 00:38:45.947 IST] DEBUG: transaction ID wrap limit is 2147484309, limited by database with OID 1

[2022-11-19 00:38:45.954 IST] DEBUG: shmem_exit(0): 4 callbacks to make

[2022-11-19 00:38:45.954 IST] DEBUG: proc_exit(0): 2 callbacks to make

[2022-11-19 00:38:45.954 IST] DEBUG: exit(0)

[2022-11-19 00:38:45.954 IST] DEBUG: shmem_exit(-1): 0 callbacks to make

[2022-11-19 00:38:45.954 IST] DEBUG: proc_exit(-1): 0 callbacks to make

[2022-11-19 00:38:45.969 IST] DEBUG: reaping dead processes

[2022-11-19 00:38:45.980 IST] LOG: database system is ready to accept connections

[2022-11-19 00:38:46.001 IST] LOG: autovacuum launcher started

[2022-11-19 00:38:46.001 IST] DEBUG: InitPostgres

[2022-11-19 00:38:46.001 IST] DEBUG: my backend ID is 1

[2022-11-19 00:38:46.001 IST] DEBUG: mapped win32 error code 2 to 2

[2022-11-19 00:38:46.001 IST] DEBUG: StartTransaction

[2022-11-19 00:38:46.001 IST] DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:

[2022-11-19 00:38:46.001 IST] DEBUG: CommitTransaction

[2022-11-19 00:38:46.001 IST] DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:

[2022-11-19 00:38:46.001 IST] DEBUG: mapped win32 error code 2 to 2

[2022-11-19 00:38:46.880 IST] DEBUG: forked new backend, pid=4272 socket=7556

[2022-11-19 00:38:46.896 IST] DEBUG: postgres child[4272]: starting with (

[2022-11-19 00:38:46.896 IST] DEBUG: postgres

[2022-11-19 00:38:46.896 IST] DEBUG: )

[2022-11-19 00:38:46.896 IST] DEBUG: InitPostgres

[2022-11-19 00:38:46.896 IST] DEBUG: my backend ID is 2

[2022-11-19 00:38:46.896 IST] DEBUG: mapped win32 error code 2 to 2

[2022-11-19 00:38:46.896 IST] DEBUG: StartTransaction

[2022-11-19 00:38:46.896 IST] DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:

[2022-11-19 00:38:46.896 IST] FATAL: role "SYSTEM" does not exist

[2022-11-19 00:38:46.896 IST] DEBUG: shmem_exit(1): 7 callbacks to make

[2022-11-19 00:38:46.896 IST] DEBUG: proc_exit(1): 3 callbacks to make

[2022-11-19 00:38:46.896 IST] DEBUG: exit(1)

[2022-11-19 00:38:46.896 IST] DEBUG: shmem_exit(-1): 0 callbacks to make

[2022-11-19 00:38:46.896 IST] DEBUG: proc_exit(-1): 0 callbacks to make

[2022-11-19 00:38:46.896 IST] DEBUG: reaping dead processes

[2022-11-19 00:38:46.896 IST] DEBUG: server process (PID 4272) exited with exit code 1

[2022-11-19 00:38:46.974 IST] DEBUG: forked new backend, pid=19428 socket=7556

[2022-11-19 00:38:46.990 IST] DEBUG: postgres child[19428]: starting with (

[2022-11-19 00:38:46.990 IST] DEBUG: postgres

[2022-11-19 00:38:46.990 IST] DEBUG: )

[2022-11-19 00:38:46.990 IST] DEBUG: InitPostgres

[2022-11-19 00:38:46.990 IST] DEBUG: my backend ID is 2

[2022-11-19 00:38:46.990 IST] DEBUG: mapped win32 error code 2 to 2

[2022-11-19 00:38:46.990 IST] DEBUG: StartTransaction

[2022-11-19 00:38:46.990 IST] DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:

[2022-11-19 00:38:46.990 IST] DEBUG: mapped win32 error code 2 to 2

[2022-11-19 00:38:47.006 IST] DEBUG: CommitTransaction

[2022-11-19 00:38:47.006 IST] DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:

[2022-11-19 00:38:47.006 IST] DEBUG: StartTransactionCommand