Re: Terminating connection because of crash of another server process

From: Deo Felix <deofelix9(at)gmail(dot)com>
To: Deepak Goel <deicool(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:21:24
Message-ID: CALW=F4MU2YL5mJTTwk7cfBAW7tUNrb+WvRKSvwHZCR=vu8kOyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 Deepak Goel 2023-09-29 08:41:05 Re: Terminating connection because of crash of another server process
Previous Message Deepak Goel 2023-09-28 11:29:04 Re: Terminating connection because of crash of another server process