Re: BUG #16285: bt_metap fails with value is out of range for type integer

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: BUG #16285: bt_metap fails with value is out of range for type integer
Дата
Msg-id CAGnEboiBdXk350rvn_dhjoU8AXtQ3kmD1YN9nK-0V97_7YdfRQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16285: bt_metap fails with value is out of range for type integer  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: BUG #16285: bt_metap fails with value is out of range for type integer  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-bugs
Дерево обсуждения
вт, 3 мар. 2020 г. в 01:03, Peter Geoghegan <pg@bowt.ie>:
I think it's more likely that the problem here is the relatively new
column returned by bt_metap(), oldest_xact. That has only been around
since Postgres v11.

This made me look at the stats, as this is a test copy of the DB upgraded to 12.2 recently. Per pg_stat_user_tables,
table had never been vacuumed since upgrade, only analyzed.
I've run vacuum manually and this made the issue go away.

It is beyond my skills to try to find the real place for this issue now. I think we might be hitting some uninitialized value somewhere, perhaps?..

--
Victor Yegorov

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #16285: bt_metap fails with value is out of range for type integer
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #16285: bt_metap fails with value is out of range for typeinteger