pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Thomas Munro <thomas.munro@gmail.com>
To: Haifang Wang (Centific Technologies Inc) <v-haiwang@microsoft.com>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Cc: Rahul Pandey <pandeyrah@microsoft.com>
Cc: Vishwa Deepak <Vishwa.Deepak@microsoft.com>
Cc: Shawn Steele <Shawn.Steele@microsoft.com>
Cc: Amy Wishnousky <amyw@microsoft.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Cc: Shweta Gulati <gulatishweta@microsoft.com>
Cc: Ashish Nawal <nawalashish@microsoft.com>
Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
Date: Thu, 29 Aug 2024 11:16:53 -0400
Message-ID: <9b3a9dce-c909-4da4-a3d8-daae0135714d@dunslane.net> (raw)
In-Reply-To: <CA+hUKG+yLnVjc7qw1ac32GCzRUenXrK=3=nCvwP-LJBL8wVTEg@mail.gmail.com>
References: <PH8PR21MB390263C479B81A1B7330E744E5182@PH8PR21MB3902.namprd21.prod.outlook.com>
	<PH8PR21MB39022FCDB4806CD57694F50AE5FF2@PH8PR21MB3902.namprd21.prod.outlook.com>
	<CA+hUKGK-G=DB5MttZzzZf7mzTMxRVSACNg-WGK59Tk1Q9vY3cA@mail.gmail.com>
	<CA+hUKGJO7Ma=30ayjwAhFPQ41Hej_mSsCUb3Kr22i-cr3qxM0w@mail.gmail.com>
	<CA+hUKGJTOgnTzu4VD6Am0X6g67atkQHFVk+C-w5wkGrGiao-=Q@mail.gmail.com>
	<0ba29a3c-9c1c-44c4-84a0-3405f8464075@dunslane.net>
	<CA+hUKGJasTBQ1THqDeeVdeRSFao3+T1LGnwJfqmT4sR-WmTebQ@mail.gmail.com>
	<dd630b4a-e136-42d4-814e-954f9c03f90a@dunslane.net>
	<CANFyU963Cf1RK0AZ99muoKWCZKGB0+RTMVeZ5J57upksR1qgnQ@mail.gmail.com>
	<CA+hUKGKa7R23AqDFnLymLuLU0E7fjCnd0=SBe50VXonYLG0EiA@mail.gmail.com>
	<CANFyU94EO+_9Qj5CDK=Ei6pxXyZu9FMOw8rJ1zr-VqkY3fq+0g@mail.gmail.com>
	<CA+hUKGJtx=o0Td4JjJ9-P+HMuKZpf6cnmu=_dx9hr2THC08wsQ@mail.gmail.com>
	<PH8PR21MB3902C154DA07EC6206E9372BE58B2@PH8PR21MB3902.namprd21.prod.outlook.com>
	<CA+hUKG+yLnVjc7qw1ac32GCzRUenXrK=3=nCvwP-LJBL8wVTEg@mail.gmail.com>


On 2024-08-28 We 6:16 AM, Thomas Munro wrote:
> On Tue, Aug 27, 2024 at 9:29 AM Haifang Wang (Centific Technologies
> Inc) <v-haiwang@microsoft.com> wrote:
>> Just would like to follow up with you about this bug. How is it going with the investigation?
> Well, we figured out that Windows is aborting inside setlocale().  The
> C standard says "The pointer to string returned by the setlocale
> function is such that a subsequent call with that string value and its
> associated category will restore that part of the program’s locale."
> Window does not conform, and crashes itself.
>
> One practical change we could make would be to reject non-ASCII locale
> names in initdb, as in the attached, and back-patch to 16.  Then the
> EDB installer (a separate project that is calling initdb and providing
> the non-ASCII string containing "ü") would at least get a graceful
> failure instead of a crash.  It hardly makes a difference to the user,
> but I've finally understood that these crashes in the Windows runtime
> library might be generating a stream of crash reports to Microsoft,
> which might be bringing you here?
>
> For example:
>
> $ initdb -D asdf --locale="liberté"
> The files belonging to this database system will be owned by user "tmunro".
> This user must also own the server process.
>
> initdb: error: locale name "liberté" contains non-ASCII characters


+1 for doing this.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com






view thread (73+ messages)  latest in thread

Message-ID: <9b3a9dce-c909-4da4-a3d8-daae0135714d@dunslane.net>
Permalink:  ../9b3a9dce-c909-4da4-a3d8-daae0135714d@dunslane.net/
Also on:    postgresql.org/message-id/9b3a9dce-c909-4da4-a3d8-daae0135714d@dunslane.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: andrew@dunslane.net, thomas.munro@gmail.com, v-haiwang@microsoft.com, sandeep.thakkar@enterprisedb.com, pandeyrah@microsoft.com, Vishwa.Deepak@microsoft.com, Shawn.Steele@microsoft.com, amyw@microsoft.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org, gulatishweta@microsoft.com, nawalashish@microsoft.com
  Subject: Re: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607
  In-Reply-To: <9b3a9dce-c909-4da4-a3d8-daae0135714d@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox