RE: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases

Поиск
Список
Период
Сортировка
От Hayato Kuroda (Fujitsu)
Тема RE: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases
Дата
Msg-id TYAPR01MB5866DD8D8DED33F45688E1D5F5769@TYAPR01MB5866.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
Dear Sawada-san,

Thank you for giving the patch! I confirmed that the problem you raised could be
occurred on the HEAD, and the test you added could reproduce that. When the stats
entry has been removed but pg_stat_get_subscription_stats() is called, the returned
values are set as 0x0.
Additionally, I have checked other pgstat_drop_* functions, and I could not find
any similar problems.

A comment:

```
+       /*
+        * Tell the cumulative stats system that the subscription is getting
+        * dropped.
+        */
+       pgstat_drop_subscription(subid);
```

Isn't it better to write down something you said as comment? Or is it quite trivial?

> There is a chance the
> transaction dropping the subscription fails due to network error etc
> but we don't need to worry about it as reporting the subscription drop
> is transactional.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: WAL Insertion Lock Improvements
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: WAL Insertion Lock Improvements