Re: Terminating connection because of crash of another server process

From: Deepak Goel <deicool(at)gmail(dot)com>
To: Deo Felix <deofelix9(at)gmail(dot)com>
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Terminating connection because of crash of another server process
Date: 2023-09-29 08:41:05
Message-ID: CA+b7NVUYbDtLq1Y0RRTipRp3n8uV6zPZMK+mJC2or-pp1rdfWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The error says very little. You might want to put the 'Debug' on along with
"Detail".

Deepak
"The greatness of a nation can be judged by the way its animals are treated
- Mahatma Gandhi"

+91 73500 12833
deicool(at)gmail(dot)com

Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool

"Plant a Tree, Go Green"

Make In India : http://www.makeinindia.com/home

On Fri, Sep 29, 2023 at 1:54 PM Deo Felix <deofelix9(at)gmail(dot)com> wrote:

> Please find the screenshot of error from the log file [image:
> postgresqlerror.png]
>
>
>
>
> On Thu, 28 Sept 2023 at 14:29, Deepak Goel <deicool(at)gmail(dot)com> wrote:
>
>> Please print the "out of shared memory error" or you need to make a
>> provision for printing detailed error.
>>
>>
>> Deepak
>> "The greatness of a nation can be judged by the way its animals are
>> treated - Mahatma Gandhi"
>>
>> +91 73500 12833
>> deicool(at)gmail(dot)com
>>
>> Facebook: https://www.facebook.com/deicool
>> LinkedIn: www.linkedin.com/in/deicool
>>
>> "Plant a Tree, Go Green"
>>
>> Make In India : http://www.makeinindia.com/home
>>
>>
>> On Thu, Sep 28, 2023 at 4:55 PM Deo Felix <deofelix9(at)gmail(dot)com> wrote:
>>
>>> The problem occurred when refreshing materialized views, out of shared
>>> memory error occur
>>>
>>> On Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool(at)gmail(dot)com> wrote:
>>>
>>>> The error posted by you ( WARNING: terminating connection because of
>>>> crash of another server process) is at a very high level. Can you
>>>> drill down for a detailed error?
>>>>
>>>>
>>>> Deepak
>>>> "The greatness of a nation can be judged by the way its animals are
>>>> treated - Mahatma Gandhi"
>>>>
>>>> +91 73500 12833
>>>> deicool(at)gmail(dot)com
>>>>
>>>> Facebook: https://www.facebook.com/deicool
>>>> LinkedIn: www.linkedin.com/in/deicool
>>>>
>>>> "Plant a Tree, Go Green"
>>>>
>>>> Make In India : http://www.makeinindia.com/home
>>>>
>>>>
>>>> On Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9(at)gmail(dot)com> wrote:
>>>>
>>>>> Okay, basically I have installed this extension
>>>>> pgaudit, repmgr, pgagent And I will audit them as you have adviced
>>>>>
>>>>> On Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
>>>>> wrote:
>>>>>
>>>>>> > On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9(at)gmail(dot)com> wrote:
>>>>>> >
>>>>>> > Okay thank you, I have not installed the mentioned extensions
>>>>>>
>>>>>> That's not the point. The point is that buggy extensions are one
>>>>>> cause of this kind of instability, and you need to audit for *any*
>>>>>> 3rd-party extensions in *YOUR* installation.
>>>>>
>>>>>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-09-29 09:27:33 Re: Terminating connection because of crash of another server process
Previous Message Deo Felix 2023-09-29 08:21:24 Re: Terminating connection because of crash of another server process