Re: No such file or directory in pg_replslot - Mailing list pgsql-hackers

From Jeremy Finzel
Subject Re: No such file or directory in pg_replslot
Date
Msg-id CAMa1XUiz+DckOA9H1zhX9-cL_qQR4cpuJjYekmm27rWm2U63xg@mail.gmail.com
Whole thread Raw
In response to Re: No such file or directory in pg_replslot  (Andres Freund <andres@anarazel.de>)
Responses Re: No such file or directory in pg_replslot
Re: No such file or directory in pg_replslot
List pgsql-hackers
That doesn't indicate an error.  You need to provide more details what made you consider things wedged...

Andres

Thank you very much for the reply.  We typically see no visible replication delay over 5 minutes ever.  Today we saw a delay of over 3 hours, and no obvious increase in workload either on the provider or the subscriber.  I also did not see the LSN advancing whatsoever in terms of applying changes.

I first checked for long-running transactions on the master but there was nothing too unusual except an ANALYZE which I promptly killed, but with no improvement to the situation.

I found the messages above using strace after canceling the subscription and finding that the process was taking extremely long to cancel.  There are 2.1 million files in pg_replslot which I don't think is normal?  Any ideas as to where I should be looking or what could cause this?

Thanks,
Jeremy


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: No such file or directory in pg_replslot
Next
From: Pavel Stehule
Date:
Subject: proposal: new polymorphic types - commontype and commontypearray