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

From: Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
To: Nick Anderson <nicholas(dot)anderson(at)zurichna(dot)com>
Cc: GOLLET Nicolas <ng(at)ng(dot)pe>, 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: Re: Re: BUG #15769: The database cluster intialisation failed.
Date: 2019-05-24 06:22:15
Message-ID: CANFyU97croi4W+sXdpziB_5Ws_z1knMAermiV2fgH1paRctaOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(dot)anderson(at)zurichna(dot)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(dot)anderson(at)zurichna(dot)com
>
>
>
>
>
> zurichna.com <https://www.zurichna.com/>
>
>
>
> [image: cid:image002(dot)jpg(at)01D2293B(dot)21F32D80]
> <https://www.linkedin.com/company/zurich-north-america> [image:
> cid:image003(dot)jpg(at)01D2293B(dot)21F32D80] <https://twitter.com/ZurichNAnews> [image:
> cid:image004(dot)jpg(at)01D2293B(dot)21F32D80]
> <https://www.youtube.com/user/ZurichNorthAmerica>
>
>
>
>
>
> *From:* Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>
> *Sent:* Friday, May 17, 2019 7:55 PM
> *To:* Nick Anderson <nicholas(dot)anderson(at)zurichna(dot)com>
> *Cc:* GOLLET Nicolas <ng(at)ng(dot)pe>; Tomas Vondra <
> tomas(dot)vondra(at)2ndquadrant(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)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(dot)anderson(at)zurichna(dot)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(dot)anderson(at)zurichna(dot)com
>
>
>
>
>
> zurichna.com <https://www.zurichna.com/>
>
>
>
> [image: cid:image002(dot)jpg(at)01D2293B(dot)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(dot)jpg(at)01D2293B(dot)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(dot)jpg(at)01D2293B(dot)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(at)ng(dot)pe>
> *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
> *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(dot)anderson(at)zurichna(dot)com
>
>
>
>
>
> zurichna.com <https://www.zurichna.com/>
>
>
>
> [image: cid:image002(dot)jpg(at)01D2293B(dot)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(dot)jpg(at)01D2293B(dot)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(dot)jpg(at)01D2293B(dot)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(at)ng(dot)pe>
> *Sent:* Tuesday, April 23, 2019 10:50 AM
> *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
> *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(dot)anderson(at)zurichna(dot)com <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,
>
>
>
> [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(dot)anderson(at)zurichna(dot)com
>
>
>
>
>
> zurichna.com <https://www.zurichna.com/>
>
>
>
>
> <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=>
>
> <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=>
>
> <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(dot)thakkar(at)enterprisedb(dot)com>
>
> *Sent:* Friday, April 19, 2019 7:46 AM
>
> *To:* Nick Anderson <nicholas(dot)anderson(at)zurichna(dot)com>
>
> *Cc:* Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>;
> 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 <
> 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: nicholas(dot)anderson(at)zurichna(dot)com
>
>
>
>
>
>
>
> zurichna.com
>
>
>
>
>
>
>
>
>
> -----Original Message-----
>
> From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
>
> Sent: Wednesday, April 17, 2019 10:57 AM
>
> To: Nick Anderson <nicholas(dot)anderson(at)zurichna(dot)com>;
> 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: 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.
>
>
>
>
>
>
>
>
> ******************* 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2019-05-24 06:27:35 Re: BUG #15816: PostgreSQL 12 Beta 1, pgAdmin 4
Previous Message PG Bug reporting form 2019-05-24 03:18:25 BUG #15818: postgis ST_AsMVT function report [9913] ERROR: Missing libprotobuf-c