BUG #15769: The database cluster intialisation failed.
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:
When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an error
displays that says "Problem running post-install step. Installation may not
complete correctly. The database cluster initialization failed."
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an error
displays that says "Problem running post-install step. Installation may not
complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what
exactly failed and why. Try digging in the windows system log, for
example. I believe there should be a log file from the installer in
%TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
I found the bitrock-installer.log file (see attached), but it's not much help to me. It shows that it errored running a cscript and exited with an error code. Any help you can provide would be much appreciated.
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com
zurichna.com
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
Attachments:
-----Original Message-----
From: Nick Anderson [mailto:nicholas.anderson@zurichna.com]
Sent: Wednesday, April 17, 2019 2:53 PM
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: RE: Re: BUG #15769: The database cluster intialisation failed.
I found the bitrock-installer.log file (see attached), but it's not much help to me. It shows that it errored running a cscript and exited with an error code. Any help you can provide would be much appreciated.
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com
zurichna.com
_________________________________________________________________________________________________
There is this (close to the bottom of the log file):
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
Can you try executing from the dos-prompt the following command:
"C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F
and see what happens?
Regards,
Igor Neyman
-----Original Message-----
From: Igor Neyman [mailto:ineyman@perceptron.com]
Sent: Wednesday, April 17, 2019 4:55 PM
To: Nick Anderson <nicholas.anderson@zurichna.com>; Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: RE: Re: BUG #15769: The database cluster intialisation failed.
-----Original Message-----
From: Nick Anderson [mailto:nicholas.anderson@zurichna.com]
Sent: Wednesday, April 17, 2019 2:53 PM
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: RE: Re: BUG #15769: The database cluster intialisation failed.
I found the bitrock-installer.log file (see attached), but it's not much help to me. It shows that it errored running a cscript and exited with an error code. Any help you can provide would be much appreciated.
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com
zurichna.com
_________________________________________________________________________________________________
There is this (close to the bottom of the log file):
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
Can you try executing from the dos-prompt the following command:
"C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F
and see what happens?
Regards,
Igor Neyman
_______________________________________________________________________________________
Well, actually it looks like that command is missing mandatory (for bootstrapping mode) argument: DBNAME.
Regards,
Igor Neyman
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com
zurichna.com
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the
installation directory. Could you try launching the installer on the
command prompt with "--enable_acledit 1" option and check if this fixes the
issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <
nicholas.anderson@zurichna.com> wrote:
In case you did not receive the attachment on my reply I pasted code below
for the error section from the end of the bitrock_installer.log file.
Please advise.The database cluster will be initialized with locale "English_United
States.1252".
The default text search configuration will be set to "english".Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command
""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdbScript stderr:
Program ended with an error exit codeError running cscript //NoLogo
"C:\PostgreSQL/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL"
"C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit codeThanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196Office: 847-605-6959
Email: nicholas.anderson@zurichna.comzurichna.com
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>;
pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation
failed.On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database clusterinitialization failed."
There's not much we can do without additional info - we don't know what
exactly failed and why. Try digging in the windows system log, for example.
I believe there should be a log file from the installer in %TEMP% so maybe
there's more info in it.regards
--
Tomas Vondra
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.
--
Sandeep Thakkar
I tried running the installer from an admin command prompt with "--enable_acledit 1" but I still get the “database cluster intialisation failed” error. See details below from the new bitrock-installer.log file.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6" "C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit code
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://www.linkedin.com/company/zurich-north-america> [cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [cid:image004.jpg@01D2293B.21F32D80] <https://www.youtube.com/user/ZurichNorthAmerica>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Sent: Friday, April 19, 2019 7:46 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the installation directory. Could you try launching the installer on the command prompt with "--enable_acledit 1" option and check if this fixes the issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<http://zurichna.com>
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
Hello,
Your server is a virtual machine? If yes, which hypervisor is used.... maybe xen server 6.5?
Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector Extensions" support is partial. This partial support is not detected by the Visual Studio Runtime, causing the application to crash when using these instructions. Here during installation, it is the "postgres.exe" process that crashes...
For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed, to perform this control, we can run this small program available on my GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases)
Maybe you have a problem here similar to the one I mentioned here http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/ (in French)
Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 Nick Anderson <nicholas.anderson@zurichna.com> écrit ----
I tried running the installer from an admin command prompt with "--enable_acledit 1" but I still get the “database cluster intialisation failed” error. See details below from the new bitrock-installer.log file.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6" "C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: mailto:nicholas.anderson@zurichna.com
From: Sandeep Thakkar <mailto:sandeep.thakkar@enterprisedb.com>
Sent: Friday, April 19, 2019 7:46 AM
To: Nick Anderson <mailto:nicholas.anderson@zurichna.com>
Cc: Tomas Vondra <mailto:tomas.vondra@2ndquadrant.com>; mailto:pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the installation directory. Could you try launching the installer on the command prompt with "--enable_acledit 1" option and check if this fixes the issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <mailto:nicholas.anderson@zurichna.com> wrote:
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: mailto:nicholas.anderson@zurichna.com
-----Original Message-----
From: Tomas Vondra <mailto:tomas.vondra@2ndquadrant.com>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <mailto:nicholas.anderson@zurichna.com>; mailto:pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: mailto:nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:
When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender
immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes
of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender
immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of
information security and assessment of internal compliance with company policy.
Hi Nicolas,
What is the small program from GitHub supposed to do? When I run it as an administrator on the VM it flashes a command prompt window then nothing happens.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://www.linkedin.com/company/zurich-north-america> [cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [cid:image004.jpg@01D2293B.21F32D80] <https://www.youtube.com/user/ZurichNorthAmerica>
From: GOLLET Nicolas <ng@ng.pe>
Sent: Tuesday, April 23, 2019 10:50 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hello,
Your server is a virtual machine? If yes, which hypervisor is used.... maybe xen server 6.5?
Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector Extensions" support is partial. This partial support is not detected by the Visual Studio Runtime, causing the application to crash when using these instructions. Here during installation, it is the "postgres.exe" process that crashes...
For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed, to perform this control, we can run this small program available on my GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ng-2Dpe_Check-5FAVX-5FVS2013-5FBUG_releases&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=B-iUY7gd96MlcbCyd6E_TyA_zj_GjzDPCpoZKZfcMyE&e=>)
Maybe you have a problem here similar to the one I mentioned here http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/<https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.ng.pe_postgresql-2D9-2D4-2Det-2D9-2D5-2Dsous-2Dwindows_&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=0TxCAo-SA9aFQ156CdqBrlf7WfTvZECX7gsLy7vnVJU&e=> (in French)
Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> écrit ----
I tried running the installer from an admin command prompt with "--enable_acledit 1" but I still get the “database cluster intialisation failed” error. See details below from the new bitrock-installer.log file.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6" "C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit code
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D4FF3A.01E04CD0] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=_je2yrDw6ysQDmv5q8c7mkfRMlcNO_f8k1ITKNpPq-s&e=> [cid:image003.jpg@01D4FF3A.01E04CD0] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=76Zh5vKGc2rS4AnZrScxs7OVXJk1gYGv17Nt0U0KwMo&e=> [cid:image004.jpg@01D4FF3A.01E04CD0] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=jsu5QUNC-fnMR9Hx_anLCXu_KpA8NT5ppE19CWeSXEw&e=>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Friday, April 19, 2019 7:46 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the installation directory. Could you try launching the installer on the command prompt with "--enable_acledit 1" option and check if this fixes the issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<http://zurichna.com>
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
Hi,
I’m still waiting for a reply. We continue to get the database cluster initialization failed error. Please advise.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://www.linkedin.com/company/zurich-north-america> [cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [cid:image004.jpg@01D2293B.21F32D80] <https://www.youtube.com/user/ZurichNorthAmerica>
From: Nick Anderson
Sent: Tuesday, April 30, 2019 9:50 AM
To: GOLLET Nicolas <ng@ng.pe>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: RE: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hi Nicolas,
What is the small program from GitHub supposed to do? When I run it as an administrator on the VM it flashes a command prompt window then nothing happens.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://www.linkedin.com/company/zurich-north-america> [cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [cid:image004.jpg@01D2293B.21F32D80] <https://www.youtube.com/user/ZurichNorthAmerica>
From: GOLLET Nicolas <ng@ng.pe<mailto:ng@ng.pe>>
Sent: Tuesday, April 23, 2019 10:50 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>; Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hello,
Your server is a virtual machine? If yes, which hypervisor is used.... maybe xen server 6.5?
Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector Extensions" support is partial. This partial support is not detected by the Visual Studio Runtime, causing the application to crash when using these instructions. Here during installation, it is the "postgres.exe" process that crashes...
For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed, to perform this control, we can run this small program available on my GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ng-2Dpe_Check-5FAVX-5FVS2013-5FBUG_releases&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=B-iUY7gd96MlcbCyd6E_TyA_zj_GjzDPCpoZKZfcMyE&e=>)
Maybe you have a problem here similar to the one I mentioned here http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/<https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.ng.pe_postgresql-2D9-2D4-2Det-2D9-2D5-2Dsous-2Dwindows_&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=0TxCAo-SA9aFQ156CdqBrlf7WfTvZECX7gsLy7vnVJU&e=> (in French)
Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> écrit ----
I tried running the installer from an admin command prompt with "--enable_acledit 1" but I still get the “database cluster intialisation failed” error. See details below from the new bitrock-installer.log file.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6" "C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit code
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D504BF.599ACEC0] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=_je2yrDw6ysQDmv5q8c7mkfRMlcNO_f8k1ITKNpPq-s&e=> [cid:image003.jpg@01D504BF.599ACEC0] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=76Zh5vKGc2rS4AnZrScxs7OVXJk1gYGv17Nt0U0KwMo&e=> [cid:image004.jpg@01D504BF.599ACEC0] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=jsu5QUNC-fnMR9Hx_anLCXu_KpA8NT5ppE19CWeSXEw&e=>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Friday, April 19, 2019 7:46 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the installation directory. Could you try launching the installer on the command prompt with "--enable_acledit 1" option and check if this fixes the issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<http://zurichna.com>
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
Hi,
There is an update available to the Windows installer. There has been a fix
around that. Could you try the latest available installer and let us know?
Also, share the bitrock installer log if it fails again.
On Tue, May 7, 2019 at 8:56 PM Nick Anderson <nicholas.anderson@zurichna.com>
wrote:
Hi,
I’m still waiting for a reply. We continue to get the database cluster
initialization failed error. Please advise.Thanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
[image: cid:image002.jpg@01D2293B.21F32D80]
<https://www.linkedin.com/company/zurich-north-america> [image:
cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [image:
cid:image004.jpg@01D2293B.21F32D80]
<https://www.youtube.com/user/ZurichNorthAmerica>*From:* Nick Anderson
*Sent:* Tuesday, April 30, 2019 9:50 AM
*To:* GOLLET Nicolas <ng@ng.pe>
*Cc:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; Tomas Vondra <
tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
*Subject:* RE: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster
intialisation failed.Hi Nicolas,
What is the small program from GitHub supposed to do? When I run it as an
administrator on the VM it flashes a command prompt window then nothing
happens.Thanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
[image: cid:image002.jpg@01D2293B.21F32D80]
<https://www.linkedin.com/company/zurich-north-america> [image:
cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [image:
cid:image004.jpg@01D2293B.21F32D80]
<https://www.youtube.com/user/ZurichNorthAmerica>*From:* GOLLET Nicolas <ng@ng.pe>
*Sent:* Tuesday, April 23, 2019 10:50 AM
*To:* Nick Anderson <nicholas.anderson@zurichna.com>
*Cc:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; Tomas Vondra <
tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
*Subject:* [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster
intialisation failed.Hello,
Your server is a virtual machine? If yes, which hypervisor is used....
maybe xen server 6.5?Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag
without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector
Extensions" support is partial. This partial support is not detected by the
Visual Studio Runtime, causing the application to crash when using these
instructions. Here during installation, it is the "postgres.exe" process
that crashes...For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed,
to perform this control, we can run this small program available on my
GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases
<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ng-2Dpe_Check-5FAVX-5FVS2013-5FBUG_releases&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=B-iUY7gd96MlcbCyd6E_TyA_zj_GjzDPCpoZKZfcMyE&e=>
)Maybe you have a problem here similar to the one I mentioned here
http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.ng.pe_postgresql-2D9-2D4-2Det-2D9-2D5-2Dsous-2Dwindows_&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=0TxCAo-SA9aFQ156CdqBrlf7WfTvZECX7gsLy7vnVJU&e=>
(in French)Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 *Nick Anderson
<nicholas.anderson@zurichna.com <nicholas.anderson@zurichna.com>>* écrit
----I tried running the installer from an admin command prompt with
"--enable_acledit 1" but I still get the “database cluster intialisation
failed” error. See details below from the new bitrock-installer.log file.The database cluster will be initialized with locale "English_United
States.1252".The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command
""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No errorinitdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo
"C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6"
"C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit
codeThanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Sent:* Friday, April 19, 2019 7:46 AM
*To:* Nick Anderson <nicholas.anderson@zurichna.com>
*Cc:* Tomas Vondra <tomas.vondra@2ndquadrant.com>;
pgsql-bugs@lists.postgresql.org*Subject:* [EXTERNAL] Re: Re: BUG #15769: The database cluster
intialisation failed.Hi,
I'm not sure but the error may be because of insufficient ACLs on the
installation directory. Could you try launching the installer on the
command prompt with "--enable_acledit 1" option and check if this fixes the
issue?On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <
nicholas.anderson@zurichna.com> wrote:In case you did not receive the attachment on my reply I pasted code below
for the error section from the end of the bitrock_installer.log file.
Please advise.The database cluster will be initialized with locale "English_United
States.1252".The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command
""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No errorinitdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo
"C:\PostgreSQL/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL"
"C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit codeThanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com
zurichna.com
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>;
pgsql-bugs@lists.postgresql.orgSubject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation
failed.On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:
When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster
initialization failed."
There's not much we can do without additional info - we don't know what
exactly failed and why. Try digging in the windows system log, for example.
I believe there should be a log file from the installer in %TEMP% so maybe
there's more info in it.regards
--
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.
--
Sandeep Thakkar
Hi Sandeep,
I tried installing PostgreSQL 11.3, but I get the same error. Attached is the bitrock installer log. Please advise.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://www.linkedin.com/company/zurich-north-america> [cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [cid:image004.jpg@01D2293B.21F32D80] <https://www.youtube.com/user/ZurichNorthAmerica>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Sent: Friday, May 17, 2019 7:55 PM
To: Nick Anderson <nicholas.anderson@zurichna.com>
Cc: GOLLET Nicolas <ng@ng.pe>; Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
There is an update available to the Windows installer. There has been a fix around that. Could you try the latest available installer and let us know? Also, share the bitrock installer log if it fails again.
On Tue, May 7, 2019 at 8:56 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
Hi,
I’m still waiting for a reply. We continue to get the database cluster initialization failed error. Please advise.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=F5tH8bRn6shga_7MvVcur0GjzUKs1VL7RnGmQQ9nBEo&e=> [cid:image003.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=7ayhqYIvLeDrqSDNJ8eaNrvZ8VfWU8ZKgqWP-fAxKNc&e=> [cid:image004.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=wL_IFhUJN5XLvGS5x5vpdigm4A2BTSzy9kNB5V3HrIo&e=>
From: Nick Anderson
Sent: Tuesday, April 30, 2019 9:50 AM
To: GOLLET Nicolas <ng@ng.pe<mailto:ng@ng.pe>>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>; Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: RE: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hi Nicolas,
What is the small program from GitHub supposed to do? When I run it as an administrator on the VM it flashes a command prompt window then nothing happens.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=F5tH8bRn6shga_7MvVcur0GjzUKs1VL7RnGmQQ9nBEo&e=> [cid:image003.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=7ayhqYIvLeDrqSDNJ8eaNrvZ8VfWU8ZKgqWP-fAxKNc&e=> [cid:image004.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=wL_IFhUJN5XLvGS5x5vpdigm4A2BTSzy9kNB5V3HrIo&e=>
From: GOLLET Nicolas <ng@ng.pe<mailto:ng@ng.pe>>
Sent: Tuesday, April 23, 2019 10:50 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>; Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hello,
Your server is a virtual machine? If yes, which hypervisor is used.... maybe xen server 6.5?
Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector Extensions" support is partial. This partial support is not detected by the Visual Studio Runtime, causing the application to crash when using these instructions. Here during installation, it is the "postgres.exe" process that crashes...
For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed, to perform this control, we can run this small program available on my GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ng-2Dpe_Check-5FAVX-5FVS2013-5FBUG_releases&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=B-iUY7gd96MlcbCyd6E_TyA_zj_GjzDPCpoZKZfcMyE&e=>)
Maybe you have a problem here similar to the one I mentioned here http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/<https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.ng.pe_postgresql-2D9-2D4-2Det-2D9-2D5-2Dsous-2Dwindows_&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=0TxCAo-SA9aFQ156CdqBrlf7WfTvZECX7gsLy7vnVJU&e=> (in French)
Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> écrit ----
I tried running the installer from an admin command prompt with "--enable_acledit 1" but I still get the “database cluster intialisation failed” error. See details below from the new bitrock-installer.log file.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6" "C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit code
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D50FE3.63C6E670] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=_je2yrDw6ysQDmv5q8c7mkfRMlcNO_f8k1ITKNpPq-s&e=> [cid:image003.jpg@01D50FE3.63C6E670] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=76Zh5vKGc2rS4AnZrScxs7OVXJk1gYGv17Nt0U0KwMo&e=> [cid:image004.jpg@01D50FE3.63C6E670] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=jsu5QUNC-fnMR9Hx_anLCXu_KpA8NT5ppE19CWeSXEw&e=>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Friday, April 19, 2019 7:46 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the installation directory. Could you try launching the installer on the command prompt with "--enable_acledit 1" option and check if this fixes the issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<http://zurichna.com>
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
I'm not sure why the initdb fails on your system. Could you manually try
running "C:\PostgreSQL\bin\initdb.exe -D %TEMP%\data" and check if it
successful?
On Wed, May 22, 2019 at 1:12 AM Nick Anderson <
nicholas.anderson@zurichna.com> wrote:
Hi Sandeep,
I tried installing PostgreSQL 11.3, but I get the same error. Attached is
the bitrock installer log. Please advise.Thanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
[image: cid:image002.jpg@01D2293B.21F32D80]
<https://www.linkedin.com/company/zurich-north-america> [image:
cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [image:
cid:image004.jpg@01D2293B.21F32D80]
<https://www.youtube.com/user/ZurichNorthAmerica>*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Sent:* Friday, May 17, 2019 7:55 PM
*To:* Nick Anderson <nicholas.anderson@zurichna.com>
*Cc:* GOLLET Nicolas <ng@ng.pe>; Tomas Vondra <
tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
*Subject:* [EXTERNAL] Re: RE: Re: Re: BUG #15769: The database cluster
intialisation failed.Hi,
There is an update available to the Windows installer. There has been a
fix around that. Could you try the latest available installer and let us
know? Also, share the bitrock installer log if it fails again.On Tue, May 7, 2019 at 8:56 PM Nick Anderson <
nicholas.anderson@zurichna.com> wrote:Hi,
I’m still waiting for a reply. We continue to get the database cluster
initialization failed error. Please advise.Thanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
[image: cid:image002.jpg@01D2293B.21F32D80]
<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=F5tH8bRn6shga_7MvVcur0GjzUKs1VL7RnGmQQ9nBEo&e=>
[image: cid:image003.jpg@01D2293B.21F32D80]
<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=7ayhqYIvLeDrqSDNJ8eaNrvZ8VfWU8ZKgqWP-fAxKNc&e=>
[image: cid:image004.jpg@01D2293B.21F32D80]
<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=wL_IFhUJN5XLvGS5x5vpdigm4A2BTSzy9kNB5V3HrIo&e=>*From:* Nick Anderson
*Sent:* Tuesday, April 30, 2019 9:50 AM
*To:* GOLLET Nicolas <ng@ng.pe>
*Cc:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; Tomas Vondra <
tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
*Subject:* RE: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster
intialisation failed.Hi Nicolas,
What is the small program from GitHub supposed to do? When I run it as an
administrator on the VM it flashes a command prompt window then nothing
happens.Thanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
[image: cid:image002.jpg@01D2293B.21F32D80]
<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=F5tH8bRn6shga_7MvVcur0GjzUKs1VL7RnGmQQ9nBEo&e=>
[image: cid:image003.jpg@01D2293B.21F32D80]
<https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=7ayhqYIvLeDrqSDNJ8eaNrvZ8VfWU8ZKgqWP-fAxKNc&e=>
[image: cid:image004.jpg@01D2293B.21F32D80]
<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=wL_IFhUJN5XLvGS5x5vpdigm4A2BTSzy9kNB5V3HrIo&e=>*From:* GOLLET Nicolas <ng@ng.pe>
*Sent:* Tuesday, April 23, 2019 10:50 AM
*To:* Nick Anderson <nicholas.anderson@zurichna.com>
*Cc:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>; Tomas Vondra <
tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
*Subject:* [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster
intialisation failed.Hello,
Your server is a virtual machine? If yes, which hypervisor is used....
maybe xen server 6.5?Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag
without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector
Extensions" support is partial. This partial support is not detected by the
Visual Studio Runtime, causing the application to crash when using these
instructions. Here during installation, it is the "postgres.exe" process
that crashes...For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed,
to perform this control, we can run this small program available on my
GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases
<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ng-2Dpe_Check-5FAVX-5FVS2013-5FBUG_releases&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=B-iUY7gd96MlcbCyd6E_TyA_zj_GjzDPCpoZKZfcMyE&e=>
)Maybe you have a problem here similar to the one I mentioned here
http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/
<https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.ng.pe_postgresql-2D9-2D4-2Det-2D9-2D5-2Dsous-2Dwindows_&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=0TxCAo-SA9aFQ156CdqBrlf7WfTvZECX7gsLy7vnVJU&e=>
(in French)Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 *Nick Anderson
<nicholas.anderson@zurichna.com <nicholas.anderson@zurichna.com>>* écrit
----I tried running the installer from an admin command prompt with
"--enable_acledit 1" but I still get the “database cluster intialisation
failed” error. See details below from the new bitrock-installer.log file.The database cluster will be initialized with locale "English_United
States.1252".The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command
""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No errorinitdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo
"C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6"
"C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit
codeThanks,
[image: Zurich_Signature_logo]
*Nick Anderson*
*IT Infrastructure Specialist II*
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
*Office:* 847-605-6959
*Email:* nicholas.anderson@zurichna.com
zurichna.com <https://www.zurichna.com/>
*From:* Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
*Sent:* Friday, April 19, 2019 7:46 AM
*To:* Nick Anderson <nicholas.anderson@zurichna.com>
*Cc:* Tomas Vondra <tomas.vondra@2ndquadrant.com>;
pgsql-bugs@lists.postgresql.org*Subject:* [EXTERNAL] Re: Re: BUG #15769: The database cluster
intialisation failed.Hi,
I'm not sure but the error may be because of insufficient ACLs on the
installation directory. Could you try launching the installer on the
command prompt with "--enable_acledit 1" option and check if this fixes the
issue?On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <
nicholas.anderson@zurichna.com> wrote:In case you did not receive the attachment on my reply I pasted code below
for the error section from the end of the bitrock_installer.log file.
Please advise.The database cluster will be initialized with locale "English_United
States.1252".The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command
""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No errorinitdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo
"C:\PostgreSQL/installer/server/initcluster.vbs" "NT
AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL"
"C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit codeThanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com
zurichna.com
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>;
pgsql-bugs@lists.postgresql.orgSubject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation
failed.On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:
When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster
initialization failed."
There's not much we can do without additional info - we don't know what
exactly failed and why. Try digging in the windows system log, for example.
I believe there should be a log file from the installer in %TEMP% so maybe
there's more info in it.regards
--
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated
recipient(s) only and may contain privileged, proprietary, or otherwise
confidential information. If this message has reached you in error, kindly
destroy it without review and notify the sender immediately. Any other use
of such misdirected e-mail by you is prohibited. Where allowed by local
law, electronic communications with Zurich and its affiliates, including
e-mail and instant messaging (including content), may be scanned for the
purposes of information security and assessment of internal compliance with
company policy.
--
Sandeep Thakkar
When I try running "C:\PostgreSQL\bin\initdb.exe -D %TEMP%\data" I get an error that says “initdb – initialize a new database cluster has stopped working” and then asks me to close the program.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://www.linkedin.com/company/zurich-north-america> [cid:image003.jpg@01D2293B.21F32D80] <https://twitter.com/ZurichNAnews> [cid:image004.jpg@01D2293B.21F32D80] <https://www.youtube.com/user/ZurichNorthAmerica>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Sent: Friday, May 24, 2019 1:22 AM
To: Nick Anderson <nicholas.anderson@zurichna.com>
Cc: GOLLET Nicolas <ng@ng.pe>; Tomas Vondra <tomas.vondra@2ndquadrant.com>; pgsql-bugs@lists.postgresql.org
Subject: [EXTERNAL] Re: Re: RE: Re: Re: BUG #15769: The database cluster intialisation failed.
I'm not sure why the initdb fails on your system. Could you manually try running "C:\PostgreSQL\bin\initdb.exe -D %TEMP%\data" and check if it successful?
On Wed, May 22, 2019 at 1:12 AM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
Hi Sandeep,
I tried installing PostgreSQL 11.3, but I get the same error. Attached is the bitrock installer log. Please advise.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=bxJuZJS2ajIwiEcc-W-opMw_HKnWABVGG0_8e18dd4k&s=XXjyLjbBO_wf1lv-SWwjq-LeYBZ9az6SLi7cSGbm5-w&e=> [cid:image003.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=bxJuZJS2ajIwiEcc-W-opMw_HKnWABVGG0_8e18dd4k&s=NzXYuULHUHnv_iHIAVyyzdscRr8P25OTvWUbR0JvLPQ&e=> [cid:image004.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=bxJuZJS2ajIwiEcc-W-opMw_HKnWABVGG0_8e18dd4k&s=eBFuSjWzhnNgd8oJdbEEpls1sGSQX59iyhzUdz28_Tc&e=>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Friday, May 17, 2019 7:55 PM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: GOLLET Nicolas <ng@ng.pe<mailto:ng@ng.pe>>; Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
There is an update available to the Windows installer. There has been a fix around that. Could you try the latest available installer and let us know? Also, share the bitrock installer log if it fails again.
On Tue, May 7, 2019 at 8:56 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
Hi,
I’m still waiting for a reply. We continue to get the database cluster initialization failed error. Please advise.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=F5tH8bRn6shga_7MvVcur0GjzUKs1VL7RnGmQQ9nBEo&e=> [cid:image003.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=7ayhqYIvLeDrqSDNJ8eaNrvZ8VfWU8ZKgqWP-fAxKNc&e=> [cid:image004.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=wL_IFhUJN5XLvGS5x5vpdigm4A2BTSzy9kNB5V3HrIo&e=>
From: Nick Anderson
Sent: Tuesday, April 30, 2019 9:50 AM
To: GOLLET Nicolas <ng@ng.pe<mailto:ng@ng.pe>>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>; Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: RE: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hi Nicolas,
What is the small program from GitHub supposed to do? When I run it as an administrator on the VM it flashes a command prompt window then nothing happens.
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=F5tH8bRn6shga_7MvVcur0GjzUKs1VL7RnGmQQ9nBEo&e=> [cid:image003.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=7ayhqYIvLeDrqSDNJ8eaNrvZ8VfWU8ZKgqWP-fAxKNc&e=> [cid:image004.jpg@01D2293B.21F32D80] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=567Nxl53crIc8DdNXrTpgvdB-RZOvIALUcgDr0QMTH8&s=wL_IFhUJN5XLvGS5x5vpdigm4A2BTSzy9kNB5V3HrIo&e=>
From: GOLLET Nicolas <ng@ng.pe<mailto:ng@ng.pe>>
Sent: Tuesday, April 23, 2019 10:50 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>; Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Hello,
Your server is a virtual machine? If yes, which hypervisor is used.... maybe xen server 6.5?
Your problem reminds me a problem with poorly exposed CPU instructions....
For example, under Citrix XenServer 6.5, the CPU exposes the AVX2 flag without exposing the XSAVE and OSXSAVE flags, so that the "Advanced Vector Extensions" support is partial. This partial support is not detected by the Visual Studio Runtime, causing the application to crash when using these instructions. Here during installation, it is the "postgres.exe" process that crashes...
For Xen 6.5, service pack 1 fixes this problem....
It is easy to detect on the system that all flags are correctly exposed, to perform this control, we can run this small program available on my GitHub: (https://github.com/ng-pe/Check_AVX_VS2013_BUG/releases<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_ng-2Dpe_Check-5FAVX-5FVS2013-5FBUG_releases&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=B-iUY7gd96MlcbCyd6E_TyA_zj_GjzDPCpoZKZfcMyE&e=>)
Maybe you have a problem here similar to the one I mentioned here http://blog.ng.pe/postgresql-9-4-et-9-5-sous-windows/<https://urldefense.proofpoint.com/v2/url?u=http-3A__blog.ng.pe_postgresql-2D9-2D4-2Det-2D9-2D5-2Dsous-2Dwindows_&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=0TxCAo-SA9aFQ156CdqBrlf7WfTvZECX7gsLy7vnVJU&e=> (in French)
Sincerely,
Nicolas GOLLET,
---- Le ven., 19 avr. 2019 18:48:29 +0200 Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> écrit ----
I tried running the installer from an admin command prompt with "--enable_acledit 1" but I still get the “database cluster intialisation failed” error. See details below from the new bitrock-installer.log file.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQL9.6data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL9.6/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQL9.6data"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL9.6/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL9.6" "C:\PostgreSQL9.6data" 5432 "DEFAULT" 1: Program ended with an error exit code
Thanks,
[Zurich_Signature_logo]
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<https://www.zurichna.com/>
[cid:image002.jpg@01D5152E.C4412420] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_zurich-2Dnorth-2Damerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=_je2yrDw6ysQDmv5q8c7mkfRMlcNO_f8k1ITKNpPq-s&e=> [cid:image003.jpg@01D5152E.C4412420] <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_ZurichNAnews&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=76Zh5vKGc2rS4AnZrScxs7OVXJk1gYGv17Nt0U0KwMo&e=> [cid:image004.jpg@01D5152E.C4412420] <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_user_ZurichNorthAmerica&d=DwMFaQ&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=EQ-4v07yzyQkRffGPhbRfqrKYEKy21UYzeZM7HCb8gc&s=jsu5QUNC-fnMR9Hx_anLCXu_KpA8NT5ppE19CWeSXEw&e=>
From: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com<mailto:sandeep.thakkar@enterprisedb.com>>
Sent: Friday, April 19, 2019 7:46 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: Re: BUG #15769: The database cluster intialisation failed.
Hi,
I'm not sure but the error may be because of insufficient ACLs on the installation directory. Could you try launching the installer on the command prompt with "--enable_acledit 1" option and check if this fixes the issue?
On Thu, Apr 18, 2019 at 7:38 PM Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>> wrote:
In case you did not receive the attachment on my reply I pasted code below for the error section from the end of the bitrock_installer.log file. Please advise.
The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory C:/PostgreSQLdata ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
running bootstrap script ... initdb: could not execute command ""C:/PostgreSQL/bin/postgres.exe" --boot -x1 -F ": No error
initdb: removing contents of data directory "C:/PostgreSQLdata"
Called Die(Failed to initialise the database cluster with initdb)...
Failed to initialise the database cluster with initdb
Script stderr:
Program ended with an error exit code
Error running cscript //NoLogo "C:\PostgreSQL/installer/server/initcluster.vbs" "NT AUTHORITY\NetworkService" "postgres" "****" "C:\PostgreSQL" "C:\PostgreSQLdata" 5432 "DEFAULT" 0: Program ended with an error exit code
Thanks,
Nick Anderson
IT Infrastructure Specialist II
Zurich North America
1299 Zurich Way
Schaumburg, Illinois 60196
Office: 847-605-6959
Email: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
zurichna.com<http://zurichna.com>
-----Original Message-----
From: Tomas Vondra <tomas.vondra@2ndquadrant.com<mailto:tomas.vondra@2ndquadrant.com>>
Sent: Wednesday, April 17, 2019 10:57 AM
To: Nick Anderson <nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org>
Subject: [EXTERNAL] Re: BUG #15769: The database cluster intialisation failed.
On Wed, Apr 17, 2019 at 02:32:19PM +0000, PG Bug reporting form wrote:
The following bug has been logged on the website:
Bug reference: 15769
Logged by: Nick Anderson
Email address: nicholas.anderson@zurichna.com<mailto:nicholas.anderson@zurichna.com>
PostgreSQL version: 9.6.5
Operating system: Windows Server 2012 R2
Description:When trying to install PostgreSQL 9.6.5 on Windows Server 2012 R2 an
error displays that says "Problem running post-install step.
Installation may not complete correctly. The database cluster initialization failed."
There's not much we can do without additional info - we don't know what exactly failed and why. Try digging in the windows system log, for example. I believe there should be a log file from the installer in %TEMP% so maybe there's more info in it.
regards
--
Tomas Vondra https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com&d=DwIBAg&c=qP4sLPjPGMqyT1dV5J9o7Q&r=ER5XnAMUZ-Iy_JIvLpufx_6ifbU18udjQSV1rgm0vb4&m=gsIx9gvwpIaWzByHegFJHIjY5WRamIm_GNMj_2qDq60&s=3niEq0VI2C5chcg_cAdjmEl_uZLXMeqCFQC15e79R7g&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.
--
Sandeep Thakkar
******************* PLEASE NOTE *******************
This message, along with any attachments, is for the designated recipient(s) only and may contain privileged, proprietary, or otherwise confidential information. If this message has reached you in error, kindly destroy it without review and notify the sender immediately. Any other use of such misdirected e-mail by you is prohibited. Where allowed by local law, electronic communications with Zurich and its affiliates, including e-mail and instant messaging (including content), may be scanned for the purposes of information security and assessment of internal compliance with company policy.