Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin - Mailing list pgsql-hackers

From Sanjay Khatri
Subject Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin
Date
Msg-id CANLv43+3=8vnGRMNQ8zXZU+nS02ORzQKz_oJiCb_pkGRhifNhQ@mail.gmail.com
Whole thread Raw
In response to Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin  (Sanjay Khatri <sanjaykhatri218@gmail.com>)
List pgsql-hackers

But my concern is it occured only after deleting the pgAdmin.bak file.

On Thu, 21 Nov 2024, 19:54 Sanjay Khatri, <sanjaykhatri218@gmail.com> wrote:

Yeah maybe, we contacted a Hardware Engineer, he told to clean the RAM, etc. If still does not works, then some issue with the motherboard.

On Thu, 21 Nov 2024, 19:49 Tomas Vondra, <tomas@vondra.me> wrote:


On 11/21/24 15:03, Daniel Gustafsson wrote:
>> On Thu, 21 Nov 2024, 17:46 Daniel Gustafsson, <daniel@yesql.se> wrote:
>>> On 21 Nov 2024, at 04:22, Sanjay Khatri <sanjaykhatri218@gmail.com> wrote:
>>>
>>> We tried it on another server with similar configurations.
>>> Just installed the Postgres 15 and its PgAdmin.
>>> Kept the server ONN for the whole day, the server was okay.
>>> But then we tried the pgAdmin workaround by deleting the pgAdmin.bak file in  'AppData/Roaming/pgAdmin' and restarted the PgAdmin.
>>> Soon within an hour the server crashed. Its happening when PgAdmin workaround is performed.
>>> Do Let me know if someone else faced the same issue?
>>
>> Just to make sure we're talking about the same thing.  Did Windows crash and
>> required a restart when you removed a file from pgAdmin, or did the server get
>> bricked and refused to boot at all with systems diagnostics issues?
>>
>> On 21 Nov 2024, at 14:50, Sanjay Khatri <sanjaykhatri218@gmail.com> wrote:
>>
>> Yes we are talking about same thing.
>> But this time a different server with Similar configuration.
>> On deleting the pgAdmin.bak file after which I restarted pgAdmin. But after an hour or two, the machine crashed and refuses to boot.
>
> If removing a file from pgAdmin can brick your server (regardless of it being
> standard operating procedure or not), then I think it's something which the
> pgAdmin developers should be made aware of.
>

Color me skeptical. Weird unexpected things happen, but I simply don't
see how removing a .bak file from a regular application, could break the
BIOS and cause machine check exceptions there. These things are at least
two or three steps apart (BIOS <-> OS <-> application).

It's far more likely this is just a traditional hardware issue. If you
search for "dell machine check error" you'll find plenty of similar
reports. I only checked a couple, but it's invariably some due to some
hardware issue.


regards

--
Tomas Vondra

pgsql-hackers by date:

Previous
From: Sanjay Khatri
Date:
Subject: Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin
Next
From: "David G. Johnston"
Date:
Subject: Re: Document NULL