| From: | Thadeus Anand <thadeus(at)rmkv(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, vignesh C <vignesh21(at)gmail(dot)com> |
| Subject: | Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine |
| Date: | 2025-08-26 12:21:03 |
| Message-ID: | CANUywME1iAHRRpfRH_ZWYFRQ-dZsk-i7NxYRS0wehYJNGC4XLQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
Here is the result of "select * from pg_replication_slots"
slot_name plugin slot_type datoid database temporary active active_pid xmin
catalog_xmin restart_lsn confirmed_flush_lsn wal_status safe_wal_size
two_phase inactive_since conflicting invalidation_reason failover synced
rmkv_crm_sub_twn pgoutput logical 5 postgres FALSE TRUE 240,409 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_main_sub_twn pgoutput logical 5 postgres FALSE TRUE 240,410 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
standby_slot [NULL] physical [NULL] [NULL] FALSE TRUE 240,458 [NULL] [NULL]
2EA/834D54B8 [NULL] reserved 21,486,545,736 FALSE [NULL] [NULL] [NULL] FALSE
FALSE
rmkv_crm_sub_cbe pgoutput logical 5 postgres FALSE TRUE 240,404 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_main_sub_cbe pgoutput logical 5 postgres FALSE TRUE 240,406 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_crm_sub_tvl pgoutput logical 5 postgres FALSE TRUE 240,408 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_main_sub_tvl pgoutput logical 5 postgres FALSE TRUE 240,411 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_crm_sub_blr pgoutput logical 5 postgres FALSE TRUE 240,405 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_main_sub_blr pgoutput logical 5 postgres FALSE TRUE 240,407 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_crm_sub_vch pgoutput logical 5 postgres FALSE TRUE 240,403 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_main_sub_vch pgoutput logical 5 postgres FALSE TRUE 240,401 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_crm_sub_vdp pgoutput logical 5 postgres FALSE TRUE 240,400 [NULL]
10861325 2E9/296801D0 2EA/834D54B8 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
rmkv_main_sub_vdp pgoutput logical 5 postgres FALSE TRUE 419,107 [NULL]
10861325 2E9/296801D0 2EA/1E788780 reserved 15,681,629,000 FALSE [NULL]
FALSE [NULL] FALSE FALSE
Thadeus Anand.
On Tue, Aug 26, 2025 at 5:44 PM Thadeus Anand <thadeus(at)rmkv(dot)com> wrote:
> Hi,
>
> Since this afternoon, the replication slot folders have started to grow in
> size again. I have attached a couple of screenshots showing the size and
> some contents of a folder. Hope you find them useful.
>
> I checked the database log at the publisher, and could find nothing
> suspicious around that time when the spill files started appearing.
>
> Thadeus Anand.
>
>
> On Tue, Aug 26, 2025 at 4:05 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> wrote:
>
>> On Tue, Aug 26, 2025 at 1:45 PM Thadeus Anand <thadeus(at)rmkv(dot)com> wrote:
>> >
>> > We created the publications and subscriptions again last night after
>> restarting the publisher and all the subscribers.
>> >
>> > So far, everything seems to be working fine, and the replication slot
>> folders remain at 4 KB each.
>> >
>> > I did not change anything, and didn't do anything differently this
>> time. In any case, I will monitor this closely and let you know if any
>> malfunction.occurs.
>> >
>>
>> Thanks for the update.
>>
>> --
>> With Regards,
>> Amit Kapila.
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2025-08-26 14:01:08 | BUG #19032: In restore_command %f parameter does not support WAL partial files. |
| Previous Message | Thadeus Anand | 2025-08-26 12:14:03 | Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine |