Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup
Дата
Msg-id CAM3SWZQ0BZXwWQJW5EQ6N=P8=M6kn1PTp9yi3WKhVxjpXP7KXg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup  (charles.harwood@zuerchertech.com)
Ответы Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup  ("Charles R. Harwood" <charles.harwood@zuerchertech.com>)
Список pgsql-bugs
On Fri, Jan 30, 2015 at 2:14 PM,  <charles.harwood@zuerchertech.com> wrote:
> Many postgres worker processes stopped responding.  They continued to be in
> state 'active' and not 'waiting' for hours.  Each query was on the table
> that an autovacuum process was also hung on processing and was the oldest
> active transaction on.


Was pg_upgrade run on this database at some point [1]?

I foresee more problems here...

[1] http://www.postgresql.org/message-id/20140825225029.2536.5315@wrigleys.postgresql.org
--
Peter Geoghegan

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

Предыдущее
От: satson.csc17@gmail.com
Дата:
Сообщение: BUG #12717: Slow Query
Следующее
От: hans@matfyz.cz
Дата:
Сообщение: BUG #12721: psql -a does not preserve empty lines between SELECTs