Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin

From: Sanjay Khatri <sanjaykhatri218(at)gmail(dot)com>
To: Tomas Vondra <tomas(at)vondra(dot)me>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin
Date: 2024-11-21 14:25:27
Message-ID: CANLv43+3=8vnGRMNQ8zXZU+nS02ORzQKz_oJiCb_pkGRhifNhQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)vondra(dot)me> wrote:
>
>>
>>
>> On 11/21/24 15:03, Daniel Gustafsson wrote:
>> >> On Thu, 21 Nov 2024, 17:46 Daniel Gustafsson, <daniel(at)yesql(dot)se> wrote:
>> >>> On 21 Nov 2024, at 04:22, Sanjay Khatri <sanjaykhatri218(at)gmail(dot)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(at)gmail(dot)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
>>
>>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-11-21 14:42:19 Re: Document NULL
Previous Message Sanjay Khatri 2024-11-21 14:24:18 Re: Windows 2016 server crashed after changes in Postgres 15.8 pgAdmin