Re: Adding a range check on the sequence index from the publisher.

From: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Subject: Re: Adding a range check on the sequence index from the publisher.
Date: 2026-09-22 04:59:52
Message-ID: A111188F-321D-4D4C-88F3-F1FA46AFCEA8@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Sep 22, 2026, at 03:51, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> Hi all,
> (CCing Amit as the committer of this feature)
>
> This was originally reported to pgsql-security by Anthropic OSS
> program but the security team considered it as a non-vuln bug since
> it's a v19-beta code, and I'm reporting here on behalf of them as it's
> permitted now.
>
> The reported problem is in sequencesync.c; the sequence
> synchronization worker uses an integer that came back from the
> publisher as a list subscript without checking it, and then writes
> through the resulting pointer.
>
> While it's not a problem in normal cases where the publisher is a
> normal PostgreSQL, it could lead to out-of-bounds writes when the
> publisher is a malicious server looking like a publisher.
>
> Other fields that we get through get_and_validate_seq_info() could
> also get the wrong value but they just show the wrong values rather
> than OOB writes. So I think we need a safeguard only for seqidx.
>
> I've attached the patch to fix it. Feedback is very welcome.
>
> Regards,
>
> --
> Masahiko Sawada
> Amazon Web Services: https://aws.amazon.com
> <v1-0001-Add-a-range-check-on-the-sequence-index-from-the-.patch>

If the concern here is a malicious publisher, does it also make sense to replace Assert(!isnull) with a runtime check and fail if seqidx is NULL?

Also there is a typo in the commit message:
```
which bounds-checks only under assertinos, so it was possible that an
```

assertinos -> assertions

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message John Naylor 2026-09-22 04:53:31 Re: Move system identifier generation to a common helper