RE: Re: Re: BUG #15769: The database cluster intialisation failed.

From: GOLLET Nicolas <ng(at)ng(dot)pe>
To: "Nick Anderson" <nicholas(dot)anderson(at)zurichna(dot)com>
Cc: "Sandeep Thakkar" <sandeep(dot)thakkar(at)enterprisedb(dot)com>, "Tomas Vondra" <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: Re: Re: BUG #15769: The database cluster intialisation failed.
Date: 2019-04-23 15:50:18
Message-ID: 16a4ae4033f.eb90629957737.4473958611546140462@ng.pe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(dot)anderson(at)zurichna(dot)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(dot)anderson(at)zurichna(dot)com

 

 

   https://www.zurichna.com/

 

   https://www.linkedin.com/company/zurich-north-america  https://twitter.com/ZurichNAnews  https://www.youtube.com/user/ZurichNorthAmerica      

 

 

From: Sandeep Thakkar <mailto:sandeep(dot)thakkar(at)enterprisedb(dot)com>

Sent: Friday, April 19, 2019 7:46 AM

To: Nick Anderson <mailto:nicholas(dot)anderson(at)zurichna(dot)com>

Cc: Tomas Vondra <mailto:tomas(dot)vondra(at)2ndquadrant(dot)com>; mailto:pgsql-bugs(at)lists(dot)postgresql(dot)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(dot)anderson(at)zurichna(dot)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(dot)anderson(at)zurichna(dot)com

   http://zurichna.com

-----Original Message-----

From: Tomas Vondra <mailto:tomas(dot)vondra(at)2ndquadrant(dot)com>

Sent: Wednesday, April 17, 2019 10:57 AM

To: Nick Anderson <mailto:nicholas(dot)anderson(at)zurichna(dot)com>; mailto:pgsql-bugs(at)lists(dot)postgresql(dot)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(dot)anderson(at)zurichna(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-04-23 16:42:06 BUG #15776: Pgpool
Previous Message Tom Lane 2019-04-23 14:55:28 Re: Possible to store invalid SCRAM-SHA-256 Passwords