From: Koray Yavuz <korayyavuuz@gmail.com>
To: Murat Topcu <murat-topcu@outlook.com>
Cc: Manika Singhal <manika.singhal@enterprisedb.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-bugs@lists.postgresql.org
Subject: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Date: Sat, 6 Jan 2024 19:18:44 +0300
Message-ID: <6751DF5E-6D6C-4447-ADBC-2332402F5D37@gmail.com> (raw)
In-Reply-To: <DB4PR02MB10031860049329F63254E952FF3652@DB4PR02MB10031.eurprd02.prod.outlook.com>
References: <DB4PR02MB10031860049329F63254E952FF3652@DB4PR02MB10031.eurprd02.prod.outlook.com>
--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--
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: korayyavuuz@gmail.com, murat-topcu@outlook.com, manika.singhal@enterprisedb.com, laurenz.albe@cybertec.at, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
In-Reply-To: <6751DF5E-6D6C-4447-ADBC-2332402F5D37@gmail.com>
* 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