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-10-02 05:54:59
Message-ID: CALW=F4O8u4riWnn93UmtfDwMBz=EYWdXPvhOWPWdxqEwOQ5tPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It is in production that is why the debug is off

On Fri, 29 Sept 2023 at 11:41, Deepak Goel <deicool(at)gmail(dot)com> wrote:

> 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

Browse pgsql-admin by date

  From Date Subject
Next Message Deo Felix 2023-10-02 06:00:58 Re: Terminating connection because of crash of another server process
Previous Message Ron 2023-09-30 21:17:34 Re: Backup solution over unreliable network