pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16957: initdb.exe initialize a database cluster has stopped working
3+ messages / 3 participants
[nested] [flat]
* BUG #16957: initdb.exe initialize a database cluster has stopped working
@ 2021-04-09 20:51 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2021-04-09 20:51 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: sadaqatcustom@gmail.com
The following bug has been logged on the website:
Bug reference: 16957
Logged by: ahmed il
Email address: sadaqatcustom@gmail.com
PostgreSQL version: 13.2
Operating system: windows 2016 server
Description:
I am trying to install postgresql binary zip file to my windows machines
using a batch file , it gets install on some machines but shows
followig error in windows evet log in some of the machies. Pls help
Event Log Windows:
Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
0x5faa5f0f
Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
0x5e9140a1
Exception code: 0xc0000409
Fault offset: 0x000000000006c9e8
Faulting process id: 0x579c
Faulting application start time: 0x01d72d5bc0a912a0
Faulting application path: C:\pgsql\bin\initdb.exe
Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Faulting package full name:
Faulting package-relative application ID:
After this i tried the official installer of postgresql and it gave me same
this error in windows event log
Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
0x5faa5f0f
Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
0x5e9140a1
Exception code: 0xc0000409
Fault offset: 0x000000000006c9e8
Faulting process id: 0xde00
Faulting application start time: 0x01d72d717352a9d5
Faulting application path: C:\pgsql\bin\initdb.exe
Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Faulting package full name:
Faulting package-relative application ID:
pls help
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16957: initdb.exe initialize a database cluster has stopped working
@ 2021-04-11 04:18 Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Sandeep Thakkar @ 2021-04-11 04:18 UTC (permalink / raw)
To: sadaqatcustom@gmail.com; pgsql-bugs@lists.postgresql.org
Hi
That DLL seems associated with Visual C++. Can you try installing
https://aka.ms/vs/16/release/vc_redist.x64.exe and then check again if the
initdb is working fine?
On Sat, Apr 10, 2021 at 2:59 AM PG Bug reporting form <
noreply@postgresql.org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16957
> Logged by: ahmed il
> Email address: sadaqatcustom@gmail.com
> PostgreSQL version: 13.2
> Operating system: windows 2016 server
> Description:
>
> I am trying to install postgresql binary zip file to my windows machines
> using a batch file , it gets install on some machines but shows
> followig error in windows evet log in some of the machies. Pls help
>
> Event Log Windows:
> Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
> 0x5faa5f0f
> Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
> 0x5e9140a1
> Exception code: 0xc0000409
> Fault offset: 0x000000000006c9e8
> Faulting process id: 0x579c
> Faulting application start time: 0x01d72d5bc0a912a0
> Faulting application path: C:\pgsql\bin\initdb.exe
> Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
> Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Faulting package full name:
> Faulting package-relative application ID:
>
> After this i tried the official installer of postgresql and it gave me same
> this error in windows event log
>
> Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
> 0x5faa5f0f
> Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
> 0x5e9140a1
> Exception code: 0xc0000409
> Fault offset: 0x000000000006c9e8
> Faulting process id: 0xde00
> Faulting application start time: 0x01d72d717352a9d5
> Faulting application path: C:\pgsql\bin\initdb.exe
> Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
> Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Faulting package full name:
> Faulting package-relative application ID:
>
> pls help
>
>
--
Sandeep Thakkar
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16957: initdb.exe initialize a database cluster has stopped working
@ 2021-04-11 10:34 sadaqat <sadaqatcustom@gmail.com>
parent: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
0 siblings, 0 replies; 3+ messages in thread
From: sadaqat @ 2021-04-11 10:34 UTC (permalink / raw)
To: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; +Cc: pgsql-bugs@lists.postgresql.org
Hi Sandeep ,
Thanks for the response , the vc++ redistributables are already installed
in the system .
When I failed to install using the binary zip files then I downloaded the
gui installer of official postgresql from their website , which downloaded
all the required
visual c++ redistributables to the system , but that official gui installer
still failed giving the same error.
I am sharing with you the temp log file of official gui installer of
postgresql. May be it is of some help.
...
...
upacking...
unpacking..
Unpacking C:\Program Files\PostgreSQL\13\lib\postgres.lib
Unpacking C:\Program Files\PostgreSQL\13\lib\wxmsw31ud_core.lib
Unpacking C:\Program Files\PostgreSQL\13\installer\vcredist_x86.exe
Unpacking C:\Program Files\PostgreSQL\13\installer\vcredist_x64.exe
Setting variable whoami from C:\WINDOWS\System32\whoami
Script exit code: 0
Script output:
{userame}\{userame}
Script stderr:
Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761"
/inheritance:r
Script exit code: 0
Script output:
processed file:
C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761
Successfully processed 1 files; Failed processing 0 files
Script stderr:
Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761" /T
/Q /grant "{userame}\{userame}:(OI)(CI)F"
Script exit code: 0
Script output:
Successfully processed 1 files; Failed processing 0 files
Script stderr:
[08:23:33] Running the post-installation/upgrade actions:
[08:23:33] Write the base directory to the ini file...
[08:23:33] Write the version number to the ini file...
Initialising the database cluster (this may take a few minutes)...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****"
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_4e4790a761"
"C:\Program Files\PostgreSQL\13" "C:\Program Files\PostgreSQL\13\data" 5433
"DEFAULT" 0
Script exit code: 0
Script output:
WScript.Shell Initialized...
Scripting.FileSystemObject initialized...
Called CreateDirectory(C:\Program Files\PostgreSQL\13\data)...
Called CreateDirectory(C:\Program Files\PostgreSQL\13)...
Called ClearAcl (C:\Program Files\PostgreSQL\13\data)...
Executing batch file 'rad001AC.bat'...
C:\Program Files\PostgreSQL\13\data NT SERVICE\TrustedInstaller:(I)(F)
NT
SERVICE\TrustedInstaller:(I)(CI)(IO)(F)
NT AUTHORITY\SYSTEM:(I)(F)
NT AUTHORITY\SYSTEM:(I)(OI)(CI)(IO)(F)
BUILTIN\{userame}s:(I)(F)
BUILTIN\{userame}s:(I)(OI)(CI)(IO)(F)
BUILTIN\Users:(I)(RX)
BUILTIN\Users:(I)(OI)(CI)(IO)(GR,GE)
CREATOR OWNER:(I)(OI)(CI)(IO)(F)
APPLICATION PACKAGE AUTHORITY\ALL
APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL
APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
APPLICATION PACKAGE AUTHORITY\ALL
RESTRICTED APPLICATION PACKAGES:(I)(RX)
APPLICATION PACKAGE AUTHORITY\ALL
RESTRICTED APPLICATION PACKAGES:(I)(OI)(CI)(IO)(GR,GE)
Successfully processed 1 files; Failed processing 0 files
Removing inherited ACLs on (C:\Program Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
WScript.Network initialized...
strParentOfDataDirC:\Program Files\PostgreSQL\13
logged in user{userame}\{userame}
Called AclCheck(C:\Program Files\PostgreSQL\13\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the {userame}\{userame} account can read the
path C:\Program Files\PostgreSQL\13\data
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Ensuring we can write to the data directory (using icacls) to
{userame}\{userame}:
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to (NT AUTHORITY\NetworkService) on (C:\Program
Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to CREATOR OWNER on (C:\Program
Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to SYSTEM on (C:\Program Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting full access to {userame}s on (C:\Program Files\PostgreSQL\13\data)
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Executing batch file 'rad001AC.bat'...
Reading: objConfFile is nothing...
Writing: objConfFile is nothing...
Called AclCheck(C:\Program Files\PostgreSQL\13\data)
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Executing icacls to ensure the NT AUTHORITY\NetworkService account can read
the path C:\Program Files\PostgreSQL\13\data
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
Successfully processed 1 files; Failed processing 0 files
Called IsVistaOrNewer()...
'winmgmts' object initialized...
Version:10.
MajorVersion:10
Granting service account access to the data directory (using icacls) to NT
AUTHORITY\NetworkService:
Executing batch file 'rad001AC.bat'...
processed file: C:\Program Files\PostgreSQL\13\data
processed file: C:\Program Files\PostgreSQL\13\data\log
Successfully processed 2 files; Failed processing 0 files
initcluster.vbs ran to completion
Script stderr:
Configuring database server startup...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\startupcfg.vbs" 13 "NT
AUTHORITY\NetworkService" "****" "C:\Program Files\PostgreSQL\13"
"C:\Program Files\PostgreSQL\13\data" "postgresql-x64-13"
Script exit code: 0
Script output:
startupcfg.vbs ran to completion
Script stderr:
Creating menu shortcuts...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\createshortcuts_server.vbs" 13
"postgres" 5433 "PostgreSQL 13" "C:\Program Files\PostgreSQL\13"
"C:\Program Files\PostgreSQL\13\data" "postgresql-x64-13"
Script exit code: 0
Script output:
Start FixupFile(C:\Program Files\PostgreSQL\13\scripts\serverctl.vbs)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
Start FixupFile(C:\Program Files\PostgreSQL\13\scripts\runpsql.bat)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
createshortcuts_server.vbs ran to completion
Script stderr:
Starting the database server...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\startserver.vbs" postgresql-x64-13
Script exit code: 0
Script output:
startserver.vbs ran to completion
Script stderr:
[08:24:07] Installing the adminpack module in the postgres database...
Executing C:\Program Files\PostgreSQL\13\bin\psql.exe -c "CREATE EXTENSION
adminpack" -d postgres
Script exit code: 2
Script output:
Script stderr:
psql: error: could not connect to server: Connection refused
(0x0000274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5433?
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5433?
Failed to load SQL modules into the database cluster.
[08:28:26] Write the data directory to the ini file...
[08:28:26] Write the port number, service ID, locale and superuser to the
ini file...
[08:28:26] Write ServiceID(postgresql-x64-13) to registry/ini...
Problem running post-install step. Installation may not complete correctly
Error reading file C:/Program Files/PostgreSQL/13/data/postgresql.conf
Setting variable whoami from C:\WINDOWS\System32\whoami
Script exit code: 0
Script output:
{userame}\{userame}
Script stderr:
Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_2fbe7cd101"
/inheritance:r
Script exit code: 0
Script output:
processed file:
C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_2fbe7cd101
Successfully processed 1 files; Failed processing 0 files
Script stderr:
Executing C:\WINDOWS\System32\icacls
"C:\Users\{userame}\AppData\Local\Temp/postgresql_installer_2fbe7cd101" /T
/Q /grant "{userame}\{userame}:(OI)(CI)F"
Script exit code: 0
Script output:
Successfully processed 1 files; Failed processing 0 files
Script stderr:
Creating menu shortcuts...
Executing C:\WINDOWS\System32\cscript //NoLogo "C:\Program
Files\PostgreSQL\13\installer\server\createshortcuts_clt.vbs" "PostgreSQL
13" "C:\Program Files\PostgreSQL\13"
Script exit code: 0
Script output:
Start FixupFile(C:\Program Files\PostgreSQL\13\scripts\runpsql.bat)...
Opening file for reading...
Closing file (reading)...
Replacing placeholders...
Opening file for writing...
Closing file...
End FixupFile()...
createshortcuts_clt.vbs ran to completion
Script stderr:
[08:28:42] Write the server description to the ini file...
[08:28:42] Write the server branding to the ini file...
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
On Sun, Apr 11, 2021 at 9:18 AM Sandeep Thakkar <
sandeep.thakkar@enterprisedb.com> wrote:
> Hi
>
> That DLL seems associated with Visual C++. Can you try installing
> https://aka.ms/vs/16/release/vc_redist.x64.exe and then check again if
> the initdb is working fine?
>
>
> On Sat, Apr 10, 2021 at 2:59 AM PG Bug reporting form <
> noreply@postgresql.org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 16957
>> Logged by: ahmed il
>> Email address: sadaqatcustom@gmail.com
>> PostgreSQL version: 13.2
>> Operating system: windows 2016 server
>> Description:
>>
>> I am trying to install postgresql binary zip file to my windows machines
>> using a batch file , it gets install on some machines but shows
>> followig error in windows evet log in some of the machies. Pls help
>>
>> Event Log Windows:
>> Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
>> 0x5faa5f0f
>> Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
>> 0x5e9140a1
>> Exception code: 0xc0000409
>> Fault offset: 0x000000000006c9e8
>> Faulting process id: 0x579c
>> Faulting application start time: 0x01d72d5bc0a912a0
>> Faulting application path: C:\pgsql\bin\initdb.exe
>> Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
>> Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Faulting package full name:
>> Faulting package-relative application ID:
>>
>> After this i tried the official installer of postgresql and it gave me
>> same
>> this error in windows event log
>>
>> Faulting application name: initdb.exe, version: 13.0.1.20314, time stamp:
>> 0x5faa5f0f
>> Faulting module name: ucrtbase.dll, version: 10.0.14393.3659, time stamp:
>> 0x5e9140a1
>> Exception code: 0xc0000409
>> Fault offset: 0x000000000006c9e8
>> Faulting process id: 0xde00
>> Faulting application start time: 0x01d72d717352a9d5
>> Faulting application path: C:\pgsql\bin\initdb.exe
>> Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
>> Report Id: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Faulting package full name:
>> Faulting package-relative application ID:
>>
>> pls help
>>
>>
>
> --
> Sandeep Thakkar
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-04-11 10:34 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-04-09 20:51 BUG #16957: initdb.exe initialize a database cluster has stopped working PG Bug reporting form <noreply@postgresql.org>
2021-04-11 04:18 ` Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
2021-04-11 10:34 ` sadaqat <sadaqatcustom@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox