Re: Backend crash on non-exclusive backup cancel

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Anastasia Lubennikova <lubennikovaav(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, David Steele <david(at)pgmasters(dot)net>
Subject: Re: Backend crash on non-exclusive backup cancel
Date: 2017-03-16 01:52:57
Message-ID: CAB7nPqQ355viypxHKbD6Jt0FUktiV+B2LTSAwg1tO0qTga+VSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Thu, Mar 16, 2017 at 12:46 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Hi,
>
> On 2017-03-15 15:28:03 +0900, Michael Paquier wrote:
>> diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c
>> index 64335f909e..eaf8e32fe1 100644
>> --- a/src/backend/access/transam/xlog.c
>> +++ b/src/backend/access/transam/xlog.c
>> --- a/src/backend/access/transam/xlogfuncs.c
>> +++ b/src/backend/access/transam/xlogfuncs.c
>> diff --git a/src/include/access/xlog.h b/src/include/access/xlog.h
>> index 104ee7dd5e..d4abf94862 100644
>> --- a/src/include/access/xlog.h
>> +++ b/src/include/access/xlog.h
>> @@ -288,8 +288,26 @@ extern void assign_max_wal_size(int newval, void *extra);
>> extern void assign_checkpoint_completion_target(double newval, void *extra);
>
> This seems like something easy enough to exercise in a tap test, could
> we get one?

The first problem needs to have a cancel request sent when
pg_stop_backup() is running, the second needs to have a session held
to see an the inconsistent status of the session lock, which are two
concepts foreign to the TAP tests without being able to run the
queries asynchronously and keep the sessions alive.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message anderson.hsu 2017-03-16 05:18:53 aspnet postgresql connection setting
Previous Message Andrzej Pilacik 2017-03-15 18:11:09 Re: postgresql hanging/stuck

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2017-03-16 01:54:52 Re: logical replication access control patches
Previous Message David Rowley 2017-03-16 01:52:03 Re: Patch to improve performance of replay of AccessExclusiveLock