Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again

From: Beat Hoedl <beat(dot)hoedl(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: beat(dot)hoedl(at)gmail(dot)com
Subject: Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again
Date: 2021-07-22 09:52:55
Message-ID: 8db8ae8f-52b5-a716-1800-9a84bca6354e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi

Have a bunch of processes connected to Postgres (10.0) on windows server
2016. The software was running without problems for at least a year.

Each process is doing different actions.

Every about 5-10 days a postgres.exe running for one of the application
processes crashes, tears down everything. Database recorves and then it
works again as normal.

The wierd thing is it's not always the same application process which
starts the whole sequence.

One success situation is as follows

2021-07-12 07:33:52.701 CEST [5744] LOG:  duration: 0.020 ms statement:
COMMIT
2021-07-12 07:33:52.707 CEST [5744] LOG:  duration: 0.023 ms statement:
DISCARD ALL
2021-07-12 07:33:52.707 CEST [5744] LOG:  duration: 0.005 ms statement:
BEGIN
2021-07-12 07:33:52.707 CEST [5744] LOG:  duration: 0.011 ms statement:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
.....

The same potgres.exe crashes afterwards

2021-07-12 07:33:55.321 CEST [5744] LOG:  duration: 0.032 ms statement:
COMMIT
2021-07-12 07:34:32.660 CEST [3972] LOG:  server process (PID 5744) was
terminated by exception 0xFFFFFFFF

The COMMIT was the last successfull action in the database.  I verified
the existence of the data in the database.
The new job at 07:34 caused the crash immediately.

Since I dont see DISCARD ALL/BEGIN/SET TRANSACTION my interpretation is 
this:
The possible (if any) corrupted shared memory is caused by an other
postgres.exe process.
Therfore checked all actions before these crashes. But also her it's
always a different one.

BTW: There is no virus scanner on the postgres folder and it's a
productive system, I cant just update.

So the problem leaves me puzzled.
Would be great if somebody has some ideas how to continue investigation.

Thanks

Beat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2021-07-22 10:07:35 Re: Fwd: Postgres.exe crashes and tears down all apps, recovers and is running again
Previous Message Vijaykumar Jain 2021-07-22 09:04:35 Re: Obsolete or dead serverconnections after reboot