Thread
-
BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
PG Bug reporting form <noreply@postgresql.org> — 2023-11-03T09:13:13Z
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.
-
Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Laurenz Albe <laurenz.albe@cybertec.at> — 2023-11-03T11:03:53Z
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
-
Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Koray Yavuz <korayyavuuz@gmail.com> — 2023-11-03T13:27:58Z
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-2506-preview-6513c5ec-c5a2-4aaf-97f5-44c13d29e0d4 > 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
-
Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Laurenz Albe <laurenz.albe@cybertec.at> — 2023-11-03T14:03:31Z
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
-
Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Manika Singhal <manika.singhal@enterprisedb.com> — 2023-11-03T14:12:28Z
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
-
Ynt: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Murat Topcu <murat-topcu@outlook.com> — 2024-01-06T15:43:09Z
I get the same error when I install update KB5033375. It gives the same error in the installation I use Installer, postgresql that I downloaded as a zip archive also gives the same error. The postgresql server installed with a working installation before the update gives this error in the windows logs FATAL: configuration file "C:/ProgramData/PostgresData/postgresql.conf" contains errors Postgresql, which I downloaded from the zip and tried to run, gives the following error in its logs: 2024-01-06 18:35:25.438 +03 [28168] LOG: invalid value for parameter "lc_monetary": "Turkish_Turkey.1254" 2024-01-06 18:35:25.439 +03 [28168] LOG: invalid value for parameter "lc_numeric": "Turkish_Turkey.1254" 2024-01-06 18:35:25.440 +03 [28168] LOG: invalid value for parameter "lc_time": "Turkish_Turkey.1254" 2024-01-06 18:35:25.440 +03 [28168] FATAL: configuration file "C:/ProgramData/somePath/anotherPath/postgresql/postgresql.conf" contains errors As a solution, I uninstall the update, but since it is a security update, it would be great if a better solution can be found. Windows için Posta<https://go.microsoft.com/fwlink/?LinkId=550986> ile gönderildi Kimden: Manika Singhal<mailto:manika.singhal@enterprisedb.com> Gönderilme: 6 Ocak 2024 Cumartesi 18:28 Kime: Laurenz Albe<mailto:laurenz.albe@cybertec.at> Bilgi: Koray Yavuz<mailto:korayyavuuz@gmail.com>; pgsql-bugs@lists.postgresql.org<mailto:pgsql-bugs@lists.postgresql.org> Konu: Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language 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
-
BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language
Koray Yavuz <korayyavuuz@gmail.com> — 2024-01-06T16:18:44Z
There is a solution works for this problem in Microsoft Community. I don't know if this is a permanent solution, but it works. Here is the link: https://answers.microsoft.com/tr-tr/windowserver/forum/all/kb5033371-nolu-update-paketi-hakkında/0d13be9e-2fa4-436d-b8c4-f3d4b925fac2 Murat Topcu <murat-topcu@outlook.com> şunları yazdı (6 Oca 2024 18:43): I get the same error when I install update KB5033375. It gives the same error in the installation I use Installer, postgresql that I downloaded as a zip archive also gives the same error. The postgresql server installed with a working installation before the update gives this error in the windows logs FATAL: configuration file "C:/ProgramData/PostgresData/postgresql.conf" contains errors Postgresql, which I downloaded from the zip and tried to run, gives the following error in its logs: 2024-01-06 18:35:25.438 +03 [28168] LOG: invalid value for parameter "lc_monetary": "Turkish_Turkey.1254" 2024-01-06 18:35:25.439 +03 [28168] LOG: invalid value for parameter "lc_numeric": "Turkish_Turkey.1254" 2024-01-06 18:35:25.440 +03 [28168] LOG: invalid value for parameter "lc_time": "Turkish_Turkey.1254" 2024-01-06 18:35:25.440 +03 [28168] FATAL: configuration file "C:/ProgramData/somePath/anotherPath/postgresql/postgresql.conf" contains errors As a solution, I uninstall the update, but since it is a security update, it would be great if a better solution can be found. Windows için Posta ile gönderildi Kimden: Manika Singhal Gönderilme: 6 Ocak 2024 Cumartesi 18:28 Kime: Laurenz Albe Bilgi: Koray Yavuz; pgsql-bugs@lists.postgresql.org Konu: Re: BUG #18181: KB5031455 Update crashes PostgreSQL Server for Turkish language 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> ş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