Re: error context for vacuum to include block number

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: error context for vacuum to include block number
Date: 2020-03-28 01:16:32
Message-ID: 20200328011632.GY20103@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Mar 28, 2020 at 06:28:38AM +0530, Amit Kapila wrote:
> > Hm, but I caused a crash *without* adding CHECK_FOR_INTERRUPTS, just
> > kill+sleep. The kill() could come from running pg_cancel_backend(). And the
> > sleep() just encourages a context switch, which can happen at any time.
>
> pg_sleep internally uses CHECK_FOR_INTERRUPTS() due to which it would
> have accepted the signal sent via pg_cancel_backend(). Can you try
> your scenario by temporarily removing CHECK_FOR_INTERRUPTS from
> pg_sleep() or maybe better by using OS Sleep call?

Ah, that explains it. Right, I'm not able to induce a crash with usleep().

Do you want me to resend a patch without that change ? I feel like continuing
to trade patches is more likely to introduce new errors or lose someone else's
changes than to make much progress. The patch has been through enough
iterations and it's very easy to miss an issue if I try to eyeball it.

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2020-03-28 01:19:13 Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Previous Message Amit Kapila 2020-03-28 00:58:38 Re: error context for vacuum to include block number