RE: BUG #17636: terminating connection because of crash of another server process
| От | Chaurasia Sujeet |
|---|---|
| Тема | RE: BUG #17636: terminating connection because of crash of another server process |
| Дата | |
| Msg-id | DB9PR07MB8654DF5F15F15FB70477322B84399@DB9PR07MB8654.eurprd07.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: BUG #17636: terminating connection because of crash of another server process (Julien Rouhaud <rjuju123@gmail.com>) |
| Ответы |
Re: BUG #17636: terminating connection because of crash of another server process
|
| Список | pgsql-bugs |
Hi,
We've upgraded postgres to postgres13, and no extension is configured in postgresql on the server, Yet it again crashed again, and there is no antivirus on the server.
Since the problem happens randomly and we are not able to recreate the problem ourselves. and the log shows no query or details as to what caused the crash. we just get a message that one PID of postgres.exe exited with code 0, which makes it difficult to even troubleshoot.
According to the article you shared, we set up the minidump for the random crash, but we didn't find the dump in the crashdumps directory.
We followed the highlighted part below from this article, as the crash dump handler is already included in the postgresql as per the article. so any crash dump should get generated in the crashdumps directory.
| If the crashes appear to be random and you don't know how to trigger them, it's hard to connect a debugger to the problem postgres.exe before it crashes. Setting your debugger as the JIT (just-in-time) or post-mortem debugger won't help you, because PostgreSQL generally runs as a service under a different user account that cannot interact with the desktop. You could always initdb a new cluster under your normal user account and use pg_ctl to start the postmaster with that cluster manually, so you can JIT debug under your own user account where Pg can interact with the desktop. This isn't suitable for production use, though, and you might not be able to reproduce the problem that way. In PostgreSQL 9.0 and above there is a crash dump hander included in PostgreSQL. To use it:
|
Please help us to know if there is any other step here to generate a crash dump as the issue is random and we are not aware of the cause that is making postgres.exe crash.
Thanks,
Sujeet
-----Original Message-----
From: Julien Rouhaud <rjuju123@gmail.com>
Sent: Monday, October 17, 2022 7:49 AM
To: Chaurasia Sujeet <Sujeet.Chaurasia@lisec.com>; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17636: terminating connection because of crash of another server process
[You don't often get email from mailto:rjuju123@gmail.com. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]
Hi,
On Wed, Oct 12, 2022 at 11:22:26AM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17636
> Logged by: Sujeet Swaminath
> Email address: mailto:sujeet.chaurasia@lisec.com
> PostgreSQL version: 12.11
> Operating system: Windows
> Description:
>
> We are facing this issue with POSTGRES 12.11, only on windows OS, with
> Linux OS, it works fine,
>
> if the executable that is using the database session crashes, then the
> entire database goes to recovery mode and restarts, in the Postgres
> log, we can find the below messages.
>
> "2022-10-06 17:44:09.210 CEST [8860] LOG: server process (PID 9980)
> exited with exit code 0
> 2022-10-06 17:44:09.210 CEST [8860] LOG: terminating any other active
> server processes
>
> 2022-10-06 17:44:09.211 CEST [9992] WARNING: terminating the
> connection because of the crash of another server process
>
> 2022-10-06 17:44:09.211 CEST [9992] DETAIL: The postmaster has
> commanded this server process to roll back the current transaction and
> exit because another server process exited abnormally and possibly
> corrupted shared memory.
>
> 2022-10-06 17:44:09.211 CEST [9992] HINT: In a moment you should be
> able to reconnect to the database and repeat your command. "
This unfortunately isn't enough information to understand what's going on.
First, is the problem still happening if you update to version 12.12?
Also, do you have any extension or modules configured? You haven't shown the logs corresponding to the original process problem, including the query it was executing in case of a normal backend.
Can you manually reproduce the problem, and/or get a stack trace of the problem? See
(and possibly
for more details on how to do.
В списке pgsql-bugs по дате отправления:
Следующее
От: Amit KapilaДата:
Сообщение: Re: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios