pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Sergei Kornilov <sk@zsrv.org>
Cc: pgsql-hackers@lists.postgresql.org <pgsql-hackers@lists.postgresql.org>
Subject: Re: pg11.1: dsa_area could not attach to segment
Date: Mon, 11 Feb 2019 23:00:58 -0600
Message-ID: <20190212050058.GF31721@telsasoft.com> (raw)
In-Reply-To: <20190212024314.GC31721@telsasoft.com>
References: <CAEepm=3rCe5L6ABWi74ZcJ_zz+n8nF3AyJZpMN=bhg+U0=W46Q@mail.gmail.com>
	<20190206070819.GA29720@telsasoft.com>
	<CAEepm=3Aq=R=3f8xtH1ipBeMFvrCXk6yobWN7B__ftfkWhxrAw@mail.gmail.com>
	<20190206071940.GB29720@telsasoft.com>
	<CAEepm=18oK3LCKnPbMQeYumFVM=ZPA_v_RmsVBaP1eeF6LOB7Q@mail.gmail.com>
	<20190207014719.GJ29720@telsasoft.com>
	<20190211040132.GV31721@telsasoft.com>
	<67790871549896669@iva5-d3020dc3459d.qloud-c.yandex.net>
	<CAEepm=2=BFXs_+8X-eEyNBpG0OddaWe190KQaOX2TE5aS8UL-A@mail.gmail.com>
	<20190212024314.GC31721@telsasoft.com>

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




view thread (32+ messages)  latest in thread

Message-ID: <20190212050058.GF31721@telsasoft.com>
Permalink:  ../20190212050058.GF31721@telsasoft.com/
Also on:    postgresql.org/message-id/20190212050058.GF31721@telsasoft.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: pryzby@telsasoft.com, thomas.munro@enterprisedb.com, sk@zsrv.org, pgsql-hackers@lists.postgresql.org
  Subject: Re: pg11.1: dsa_area could not attach to segment
  In-Reply-To: <20190212050058.GF31721@telsasoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox