Re: Get hot_standby_feedback messages

Hi,

We are unable to determine the transaction for xmin that is holding back
the slots.
--- I am not sure if this is a bug, but Is there any way we can find this
data and debug more?

Thanks,
Nikhil

On Sat, Jul 23, 2022 at 11:43 AM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
wrote:

> Hi,
>
> I got the data by extra logging but the issue is that it is always sending
> the same xmin. There are no long running transactions or inactive slots on
> the standby
>
> Since it is sending the same xmin, vacuum is not happening on primary.
> After we set hot_standby_feedback to 'off', the xmin becomes null and
> vacuum goes through. If we revert hot_standby_feedback to 'on' again, it
> will be stuck in the same xmin.
>
> We are unable to determine the transaction for xmin that is holding back
> the slots.
>
> Thanks,
> Nikhil
>
> On Sat, Jul 23, 2022 at 12:30 AM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
> wrote:
>
>> Hi,
>>
>> Is there a way we can get the actual messages(esp the xmin) that are sent
>> to the primary when hot_standby_feedback is enabled on standby.
>>
>> Thanks,
>> Nikhil
>>
>