Re: Return pg_control from pg_backup_stop().

From: Marcel Hofstetter <hofstetter(at)jomasoft(dot)ch>
To: David Steele <david(at)pgbackrest(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, solai v <solai(dot)cdac(at)gmail(dot)com>
Subject: Re: Return pg_control from pg_backup_stop().
Date: 2026-10-29 08:27:29
Message-ID: 186fd9a0-1d5e-4e77-9139-f4339a956d16@jomasoft.ch
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Am 28.10.2026 um 09:56 schrieb David Steele:
> On 10/28/26 07:38, Michael Paquier wrote:
>> On Wed, Oct 28, 2026 at 09:00:44AM +0900, Michael Paquier wrote:
>>> Hearing nothing, I have added that into my own pipeline and applies
>>> the fix down to v15.  v14 has been left out, the branch going EOL soon
>>> with a problem that is extremely going to happen in practice does not
>>> give me a warm feeling.  For v15 and v16, I have backpatched
>>> d2c1e18de9d1 first.  The fix has been applied as of 4a92c8c29bd0.
>>
>> Based on a sudden report from billbug, under Solaris 11, this gets
>> fun:
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?
>> nm=billbug&dt=2026-10-28%2004%3A00%3A01
>>
>> And we have a crash in a BASE_BACKUP command:
>> 2026-10-28 05:23:30.548 CET [1429:4] LOG:  client backend (PID 1498)
>> was terminated by signal 11: Segmentation Fault
>> 2026-10-28 05:23:30.548 CET [1429:5] DETAIL:  Failed process was
>> running: BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,
>> CHECKPOINT 'fast',  WAIT 0,  TABLESPACE_MAP,  MANIFEST 'yes',  TARGET
>> 'client')
>>
>> This runs under valgrind with -DRELCACHE_FORCE_RELEASE, and of course
>> I am not able to reproduce it with combinations of these three.
>
> Are you sure valgrind is running? I'm not too familiar with build farm
> configuration but it set 'use_valgrind' => undef, which seems to imply
> it is off even if -DUSE_VALGRIND is also set.
>
>>
>> The closest thing that I can see in recent history would be
>> 040932c31146.  One possible explanation is PG_CONTROL_FILE_SIZE added
>> to the stack of perform_base_backup()?  I'm still puzzled without more
>> information from valgrind, but if that's right we could try a
>> palloc0() instead.
>
> This was my first thought, but I can't see why 8KiB on the stack would
> be an issue. To me this looks a lot like a latent issue being exposed
> because we've pushed things around on the stack a bit.
>
>> My blind suggestion of fix would be the attached, that I cannot really
>> test.  Thoughts or comments?
>
> The patch looks good to me but I'm concerned it would just be masking
> the real issue even if it works.
>
> I'd be curious to see if the back branches run green when they run. It
> would also be helpful to get a stack trace.
>
> I've CC'd billbug's owner. The HEAD run with the 2026-10-28 04:00 UTC
> snapshot crashed a client backend (PID 1498) running BASE_BACKUP with
> SIGSEGV during src/bin/pg_basebackup/t/010_pg_basebackup.pl, but no
> backtrace made it into the logs. Could you check whether a core file was
> written and get a backtrace from it? If no core was written then the
> coreadm settings may be redirecting or suppressing it. Any additional
> info you can provide would be greatly appreciated.

sorry. core was disabled. enabled now for the future.
interesting: my second solaris11/sparc animal is fine.
https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=margay&br=master

Best regards,
Marcel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-10-29 08:51:20 Re: Proposal: Conflict log history table for Logical Replication
Previous Message shveta malik 2026-10-29 08:26:44 Re: Avoid resetting subscription two_phase state to pending when already enabled