pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
6+ messages / 4 participants
[nested] [flat]
* BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
@ 2023-11-03 09:13 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: PG Bug reporting form @ 2023-11-03 09:13 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: korayyavuuz@gmail.com
The following bug has been logged on the website:
Bug reference: 18181
Logged by: Koray Yavuz
Email address: korayyavuuz@gmail.com
PostgreSQL version: 16.0
Operating system: Windows 11
Description:
I just got a new computer, installed clean Windows 11 and all updates.
Before installing the KB5031455 update, I installed PostgreSQL v16. During
the installation, I selected "Turkish, Turkey" as the language and it was
successful, the service started working. However, after installing the
KB5031455 Update, I could not start the PostgreSQL server service. There was
the following error in Event Viewer:
"FATAL: configuration file "C:/Program
Files/PostgreSQL/16/data/postgresql.conf" contains errors"
I wanted to completely uninstall and reinstall. However, I noticed that in
the language selection section during the installation, it said "Turkish,
Türkiye" instead of "Turkish, Turkey". I got the error: The installation
could not be completed, the cluster could not be created. When I wanted to
do manual initdb, I got the error "Turkish_Türkiye.1254" cannot be found.
After uninstalling the KB5031455 update, when I wanted to install it again
(This time language section is "Turkish, Turkey by the way), it was
successful. I think I encountered such a problem because the "Turkey"
expression on Windows changed to "Türkiye" with this update.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
@ 2023-11-03 11:03 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 6+ messages in thread
From: Laurenz Albe @ 2023-11-03 11:03 UTC (permalink / raw)
To: korayyavuuz@gmail.com; pgsql-bugs@lists.postgresql.org
On Fri, 2023-11-03 at 09:13 +0000, PG Bug reporting form wrote:
> I just got a new computer, installed clean Windows 11 and all updates.
> Before installing the KB5031455 update, I installed PostgreSQL v16. During
> the installation, I selected "Turkish, Turkey" as the language and it was
> successful, the service started working. However, after installing the
> KB5031455 Update, I could not start the PostgreSQL server service. There was
> the following error in Event Viewer:
>
> "FATAL: configuration file "C:/Program
> Files/PostgreSQL/16/data/postgresql.conf" contains errors"
This is not a bug. You added something illegal to "postgresql.conf",
and the server refuses to start without a valid configuration.
Edit the file and fix the problem.
The error message should give you details about what was wrong.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
@ 2023-11-03 13:27 Koray Yavuz <korayyavuuz@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 6+ messages in thread
From: Koray Yavuz @ 2023-11-03 13:27 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-bugs@lists.postgresql.org
No, i did not add anything to postgresql.conf file. Like i said before, there is a problem with that Windows update.
I installed the update again to double check. When the update is installed, PostgreSQL stops and cannot be started. I saw another error message on the event viewer that Turkish_Türkiye.1254 (it should be Turkish_Turkey.1254 but name has been changed) could not be found. As soon as I uninstall the update, the server becomes running again.
In release notes you can see that:
"This update changes the English name of the former Republic of Turkey. The new, official name is the Republic of Türkiye."
https://support.microsoft.com/en-us/topic/october-31-2023-kb5031455-os-builds-22621-2506-and-22631-2...
> Laurenz Albe <laurenz.albe@cybertec.at> şunları yazdı (3 Kas 2023 14:03):
>
> On Fri, 2023-11-03 at 09:13 +0000, PG Bug reporting form wrote:
>> I just got a new computer, installed clean Windows 11 and all updates.
>> Before installing the KB5031455 update, I installed PostgreSQL v16. During
>> the installation, I selected "Turkish, Turkey" as the language and it was
>> successful, the service started working. However, after installing the
>> KB5031455 Update, I could not start the PostgreSQL server service. There was
>> the following error in Event Viewer:
>>
>> "FATAL: configuration file "C:/Program
>> Files/PostgreSQL/16/data/postgresql.conf" contains errors"
>
> This is not a bug. You added something illegal to "postgresql.conf",
> and the server refuses to start without a valid configuration.
> Edit the file and fix the problem.
> The error message should give you details about what was wrong.
>
> Yours,
> Laurenz Albe
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
@ 2023-11-03 14:03 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 1 reply; 6+ messages in thread
From: Laurenz Albe @ 2023-11-03 14:03 UTC (permalink / raw)
To: Koray Yavuz <korayyavuuz@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
On Fri, 2023-11-03 at 14:29 +0300, Koray Yavuz wrote:
> > Laurenz Albe <laurenz.albe@cybertec.at> şunları yazdı (3 Kas 2023 14:03):
> > On Fri, 2023-11-03 at 09:13 +0000, PG Bug reporting form wrote:
> > > I just got a new computer, installed clean Windows 11 and all updates.
> > > Before installing the KB5031455 update, I installed PostgreSQL v16. During
> > > the installation, I selected "Turkish, Turkey" as the language and it was
> > > successful, the service started working. However, after installing the
> > > KB5031455 Update, I could not start the PostgreSQL server service. There was
> > > the following error in Event Viewer:
> > >
> > > "FATAL: configuration file "C:/Program
> > > Files/PostgreSQL/16/data/postgresql.conf" contains errors"
> >
> > This is not a bug. You added something illegal to "postgresql.conf",
> > and the server refuses to start without a valid configuration.
> > Edit the file and fix the problem.
> > The error message should give you details about what was wrong.
>
> No, i did not add anything to postgresql.conf file. Like i said before,
> there is a problem with that Windows update.
Hm. The Windows installer is not maintained by PostgreSQL, but by
EnterpriseDB. Perhaps one of them is on the list and can comment, but
it is not a PostgreSQL bug that the project can fix.
> I installed the update again to double check. When the update is installed,
> PostgreSQL stops and cannot be started. I saw another error message on the
> event viewer that Turkish_Türkiye.1254 (it should be Turkish_Turkey.1254)
> could not be found. As soon as I uninstall the update, the server becomes
> running again.
Well, perhaps the installer added something problematic to "postgresql.conf"?
You didn't quote the literal error message, but I'd search for "Türkiye".
Perhaps the "ü" was in a wrong encoding.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
@ 2023-11-03 14:12 Manika Singhal <manika.singhal@enterprisedb.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 6+ messages in thread
From: Manika Singhal @ 2023-11-03 14:12 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Koray Yavuz <korayyavuuz@gmail.com>; pgsql-bugs@lists.postgresql.org
Hi Koray,
Thanks for reaching out!
Some other users have also reported this issue after the mentioned windows update.
We are trying to reproduce the issue on our side and will provide an update soon.
------------------------------
Thanks & Regards
Manika Singhal
EnterprisDB Pune
> On 03-Nov-2023, at 7:33 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> On Fri, 2023-11-03 at 14:29 +0300, Koray Yavuz wrote:
>>> Laurenz Albe <laurenz.albe@cybertec.at <mailto:laurenz.albe@cybertec.at>> şunları yazdı (3 Kas 2023 14:03):
>>> On Fri, 2023-11-03 at 09:13 +0000, PG Bug reporting form wrote:
>>>> I just got a new computer, installed clean Windows 11 and all updates.
>>>> Before installing the KB5031455 update, I installed PostgreSQL v16. During
>>>> the installation, I selected "Turkish, Turkey" as the language and it was
>>>> successful, the service started working. However, after installing the
>>>> KB5031455 Update, I could not start the PostgreSQL server service. There was
>>>> the following error in Event Viewer:
>>>>
>>>> "FATAL: configuration file "C:/Program
>>>> Files/PostgreSQL/16/data/postgresql.conf" contains errors"
>>>
>>> This is not a bug. You added something illegal to "postgresql.conf",
>>> and the server refuses to start without a valid configuration.
>>> Edit the file and fix the problem.
>>> The error message should give you details about what was wrong.
>>
>> No, i did not add anything to postgresql.conf file. Like i said before,
>> there is a problem with that Windows update.
>
> Hm. The Windows installer is not maintained by PostgreSQL, but by
> EnterpriseDB. Perhaps one of them is on the list and can comment, but
> it is not a PostgreSQL bug that the project can fix.
>
>> I installed the update again to double check. When the update is installed,
>> PostgreSQL stops and cannot be started. I saw another error message on the
>> event viewer that Turkish_Türkiye.1254 (it should be Turkish_Turkey.1254)
>> could not be found. As soon as I uninstall the update, the server becomes
>> running again.
>
> Well, perhaps the installer added something problematic to "postgresql.conf"?
> You didn't quote the literal error message, but I'd search for "Türkiye".
> Perhaps the "ü" was in a wrong encoding.
>
> Yours,
> Laurenz Albe
^ permalink raw reply [nested|flat] 6+ messages in thread
* BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
@ 2024-01-06 16:18 Koray Yavuz <korayyavuuz@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Koray Yavuz @ 2024-01-06 16:18 UTC (permalink / raw)
To: Murat Topcu <murat-topcu@outlook.com>; +Cc: Manika Singhal <manika.singhal@enterprisedb.com>; Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-bugs@lists.postgresql.org
--Apple-Mail-0CF870AF-448A-4E84-A2E7-E39F1D6AC036
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">There is a solution works for this problem i=
n Microsoft Community. I don't know if this is a permanent solution, but it w=
orks. <div><br></div><div>Here is the link: <a href=3D"https://ans=
wers.microsoft.com/tr-tr/windowserver/forum/all/kb5033371-nolu-update-paketi=
-hakk%C4%B1nda/0d13be9e-2fa4-436d-b8c4-f3d4b925fac2" style=3D"font-family: H=
elvetica; font-size: 12px;">https://answers.microsoft.com/tr-tr/windowserver=
/forum/all/kb5033371-nolu-update-paketi-hakk=C4=B1nda/0d13be9e-2fa4-436d-b8c=
4-f3d4b925fac2</a></div><div><div dir=3D"ltr"><br><blockquote type=3D"cite">=
Murat Topcu <murat-topcu@outlook.com> =C5=9Funlar=C4=B1 yazd=C4=B1 (6 O=
ca 2024 18:43):<br><br></blockquote></div><blockquote type=3D"cite"><div dir=
=3D"ltr">=EF=BB=BF
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-3=
">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style>@font-face { font-family: Helvetica; }
@font-face { font-family: "Cambria Math"; }
@font-face { font-family: Calibri; }
p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0cm; font-size: 11pt; fon=
t-family: Calibri, sans-serif; }
a:link, span.MsoHyperlink { color: blue; text-decoration: underline; }
.MsoChpDefault { }
@page WordSection1 { size: 612pt 792pt; margin: 70.85pt; }
div.WordSection1 { page: WordSection1; }</style>
<div class=3D"WordSection1">
<p class=3D"MsoNormal">I get the same error when I install update KB5033375.=
</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">It gives the same error in the installation I use Ins=
taller, postgresql that I downloaded as a zip archive also gives the same er=
ror.</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">The postgresql server installed with a working instal=
lation before the update gives this error in the windows logs</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">FATAL: configuration file "C:/ProgramData/PostgresDat=
a/postgresql.conf" contains errors</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Postgresql, which I downloaded from the zip and tried=
to run, gives the following error in its logs:</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">2024-01-06 18:35:25.438 +03 [28168] LOG: invalid valu=
e for parameter "lc_monetary": "Turkish_Turkey.1254"</p>
<p class=3D"MsoNormal">2024-01-06 18:35:25.439 +03 [28168] LOG: invalid valu=
e for parameter "lc_numeric": "Turkish_Turkey.1254"</p>
<p class=3D"MsoNormal">2024-01-06 18:35:25.440 +03 [28168] LOG: invalid valu=
e for parameter "lc_time": "Turkish_Turkey.1254"</p>
<p class=3D"MsoNormal">2024-01-06 18:35:25.440 +03 [28168] FATAL: configurat=
ion file "C:/ProgramData/somePath/anotherPath/postgresql/postgresql.conf" co=
ntains errors</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">As a solution, I uninstall the update, but since it i=
s a security update, it would be great if a better solution can be found.</p=
>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Windows i=C3=A7in <a href=3D"https://go.microsoft.com=
/fwlink/?LinkId=3D550986">
Posta</a> ile g=C3=B6nderildi</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<div style=3D"mso-element:para-border-div;border:none;border-top:solid #E1E1=
E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class=3D"MsoNormal" style=3D"border:none;padding:0cm"><b>Kimden: </b><a h=
ref=3D"mailto:manika.singhal@enterprisedb.com">Manika Singhal</a><br>
<b>G=C3=B6nderilme: </b>6 Ocak 2024 Cumartesi 18:28<br>
<b>Kime: </b><a href=3D"mailto:laurenz.albe@cybertec.at">Laurenz Albe</a><br=
>
<b>Bilgi: </b><a href=3D"mailto:korayyavuuz@gmail.com">Koray Yavuz</a>; <a h=
ref=3D"mailto:pgsql-bugs@lists.postgresql.org">
pgsql-bugs@lists.postgresql.org</a><br>
<b>Konu: </b>Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for T=
urkish language</p>
</div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Hi Koray,<o:p></o:p></p>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal">Thanks for reaching out!<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">Some other users have also reported this issue after t=
he mentioned windows update.<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal">We are trying to reproduce the issue on our side and w=
ill provide an update soon.<o:p></o:p></p>
</div>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"color:black">-------------------------=
-----<o:p></o:p></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"color:black">Thanks & Regards<br>
Manika Singhal<br>
EnterprisDB Pune<o:p></o:p></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"color:black"><o:p> </o:p></span><=
/p>
</div>
</div>
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><o:p> </o:p></p>
</div>
<div>
<p class=3D"MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style=3D"margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class=3D"MsoNormal">On 03-Nov-2023, at 7:33 PM, Laurenz Albe <laurenz.=
albe@cybertec.at> wrote:<o:p></o:p></p>
</div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif">On Fri, 2023-11-03 at 14:29 +0300, Koray Yavuz wrote=
:<br style=3D"caret-color: rgb(0, 0, 0);font-variant-caps: normal;text-align=
:start;-webkit-text-stroke-width: 0px;word-spacing:0px">
<br>
</span><o:p></o:p></p>
<blockquote style=3D"margin-top:5.0pt;margin-bottom:5.0pt">
<blockquote style=3D"margin-top:5.0pt;margin-bottom:5.0pt">
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif">Laurenz Albe <<a href=3D"mailto:laurenz.albe@cybe=
rtec.at">laurenz.albe@cybertec.at</a>> =C5=9Funlar=C4=B1 yazd=C4=B1 (3 Ka=
s 2023 14:03):<br>
On Fri, 2023-11-03 at 09:13 +0000, PG Bug reporting form wrote:<br>
<br>
<o:p></o:p></span></p>
<blockquote style=3D"margin-top:5.0pt;margin-bottom:5.0pt">
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif">I just got a new computer, installed clean Windows 1=
1 and all updates.<br>
Before installing the KB5031455 update, I installed PostgreSQL v16. During<b=
r>
the installation, I selected "Turkish, Turkey" as the language and it was<br=
>
successful, the service started working. However, after installing the<br>
KB5031455 Update, I could not start the PostgreSQL server service. There was=
<br>
the following error in Event Viewer:<br>
<br>
"FATAL: configuration file "C:/Program<br>
Files/PostgreSQL/16/data/postgresql.conf" contains errors"<o:p></o:p></span>=
</p>
</blockquote>
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif"><br>
This is not a bug. You added something illegal to "postgresql.conf",<b=
r>
and the server refuses to start without a valid configuration.<br>
Edit the file and fix the problem.<br>
The error message should give you details about what was wrong.<o:p></o:p></=
span></p>
</blockquote>
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif"><br>
No, i did not add anything to postgresql.conf file. Like i said before,<br>
there is a problem with that Windows update.<o:p></o:p></span></p>
</blockquote>
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif"><br>
Hm. The Windows installer is not maintained by PostgreSQL, but by<br>
EnterpriseDB. Perhaps one of them is on the list and can comment, but<=
br>
it is not a PostgreSQL bug that the project can fix.<br>
<br style=3D"caret-color: rgb(0, 0, 0);font-variant-caps: normal;text-align:=
start;-webkit-text-stroke-width: 0px;word-spacing:0px">
<br>
</span><o:p></o:p></p>
<blockquote style=3D"margin-top:5.0pt;margin-bottom:5.0pt">
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif">I installed the update again to double check. When t=
he update is installed,<br>
PostgreSQL stops and cannot be started. I saw another error message on the<b=
r>
event viewer that Turkish_T=C3=BCrkiye.1254 (it should be Turkish_Turkey.125=
4)<br>
could not be found. As soon as I uninstall the update, the server becomes<br=
>
running again.<o:p></o:p></span></p>
</blockquote>
<p class=3D"MsoNormal"><span style=3D"font-size:9.0pt;font-family:"Helv=
etica",sans-serif"><br>
Well, perhaps the installer added something problematic to "postgresql.conf"=
?<br>
You didn't quote the literal error message, but I'd search for "T=C3=BCrkiye=
".<br>
Perhaps the "=C3=BC" was in a wrong encoding.<br>
<br>
Yours,<br>
Laurenz Albe</span><o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
</div></blockquote></div></body></html>=
--Apple-Mail-0CF870AF-448A-4E84-A2E7-E39F1D6AC036--
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-01-06 16:18 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-03 09:13 BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language PG Bug reporting form <noreply@postgresql.org>
2023-11-03 11:03 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-11-03 13:27 ` Koray Yavuz <korayyavuuz@gmail.com>
2023-11-03 14:03 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-11-03 14:12 ` Manika Singhal <manika.singhal@enterprisedb.com>
2024-01-06 16:18 BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language Koray Yavuz <korayyavuuz@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox