On Wed, 24 Dec 2025 at 12:15, Shlok Kyal <shlok.kyal.oss@gmail.com> wrote:
>
There is a buildfarm failure in fairywren at [1].
The failure occurs when a sequence is dropped concurrently while
pg_get_sequence_data() is being executed as part of the copy_sequences
query. This can be reproduced by pausing execution inside
pg_get_sequence_data() and dropping the sequence in parallel. In such
a case, the function returns NULL values for last_value, which is not
currently expected by the subscriber side and results in a failure.
I am analyzing this scenario further to identify a proper solution. I
will share the detailed analysis and proposed fix in a subsequent
email.
[1] -
https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=fairywren&dt=2026-01-19%2002%3A32%3A40&stg=subscription-check
Regards,
Vignesh
