Re: pg11.1: dsa_area could not attach to segment - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: pg11.1: dsa_area could not attach to segment
Date
Msg-id 20190212050058.GF31721@telsasoft.com
Whole thread Raw
In response to Re: pg11.1: dsa_area could not attach to segment  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: pg11.1: dsa_area could not attach to segment
Re: pg11.1: dsa_area could not attach to segment
List pgsql-hackers
On Mon, Feb 11, 2019 at 08:43:14PM -0600, Justin Pryzby wrote:
> I have a suspicion that this doesn't happen if
> parallel_leader_participation=off.

I think this is tentatively confirmed..I ran 20 loops for over 90 minutes with
no crash when parallel_leader_participation=off.

On enabling parallel_leader_participation, crash within 10min.

Sergei, could you confirm ?

Thomas:

2019-02-11 23:56:20.611 EST [12699] PANIC:  dsa_area could not attach to segment index:6 handle:1376636277
[pryzbyj@telsasoft-db postgresql]$ ls /dev/shm/ |grep PostgreSQL.1376636277 || echo Not present.
Not present.

Thanks,
Justin


pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Problems with plan estimates in postgres_fdw
Next
From: Thomas Munro
Date:
Subject: Re: pg11.1: dsa_area could not attach to segment