Обсуждение: Get hot_standby_feedback messages

Поиск
Список
Период
Сортировка

Get hot_standby_feedback messages

От
Nikhil Shetty
Дата:
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

Re: Get hot_standby_feedback messages

От
Nikhil Shetty
Дата:
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.dba04@gmail.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

Re: Get hot_standby_feedback messages

От
Nikhil Shetty
Дата:
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.dba04@gmail.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.dba04@gmail.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