Re: Funny hang on PostgreSQL 10 during parallel index scan on slave - Mailing list pgsql-hackers

From Chris Travers
Subject Re: Funny hang on PostgreSQL 10 during parallel index scan on slave
Date
Msg-id CAN-RpxDXG8hiOGdwEzq1sKpghzBUCJwTSSsiT3Rhu3opfY+NbA@mail.gmail.com
Whole thread Raw
In response to Re: Funny hang on PostgreSQL 10 during parallel index scan on slave  (Chris Travers <chris.travers@adjust.com>)
Responses Re: Funny hang on PostgreSQL 10 during parallel index scan on slave
Re: Funny hang on PostgreSQL 10 during parallel index scan on slave
List pgsql-hackers
Will submit a patch here shortly.  Thanks!  Should we do for master and 10?  Or 9.6 too?

On Wed, Sep 5, 2018 at 6:40 PM Chris Travers <chris.travers@adjust.com> wrote:
Yep,  Maybe we should check for signals there.

On Wed, Sep 5, 2018 at 5:27 PM Thomas Munro <thomas.munro@enterprisedb.com> wrote:
On Wed, Sep 5, 2018 at 8:23 AM Chris Travers <chris.travers@adjust.com> wrote:
> 1.  The query is in a parallel index scan or similar
> 2.  A process is executing a parallel plan and allocating a significant chunk of memory (2MB for example) in dynamic shared memory.
> 3.  The startup process goes into a loop where it sends a sigusr1, sleeps 5m, and sends another sigusr1 etc.
> 4.  The sigusr1 aborts the system call, which is then retried.
> 5.  Because the system call takes more than 5ms, we end up in an endless loop

Do you mean this loop in dsm_impl_posix_resize() is getting
interrupted constantly and never completing?

                /* We may get interrupted, if so just retry. */
                do
                {
                        rc = posix_fallocate(fd, 0, size);
                } while (rc == EINTR);

--
Thomas Munro
http://www.enterprisedb.com


--
Best Regards,
Chris Travers
Head of Database

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com 
Saarbrücker Straße 37a, 10405 Berlin



--
Best Regards,
Chris Travers
Head of Database

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com 
Saarbrücker Straße 37a, 10405 Berlin

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module
Next
From: Thomas Munro
Date:
Subject: Re: Funny hang on PostgreSQL 10 during parallel index scan on slave