Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4
Дата
Msg-id 20140604153355.GO5146@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Could not open file pg_multixact/offsets/ ERROR on 9.3.4  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund wrote:

> On 2014-06-04 16:59:10 +0200, Alexey Klyukin wrote:
> > I've recently discovered a peculiar problem on one of our big databases
> > (more than 1TB). The database has been upgraded from 9.2 to 9.3.4 (using
> > hardlinks to speedup the process)  on April 7th around 22:00 local time.
> > When doing  vacuum on any table, the system fails with the following error:
> > 
> > ERROR:  could not access status of transaction 2035987419
> > DETAIL:  Could not open file "pg_multixact/offsets/795A": No such file or
> > directory.

> Looks like you're hitting the issue described in
> http://archives.postgresql.org/message-id/20140530121631.GE25431%40alap3.anarazel.de

Will look into this.  Thanks.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Proposing pg_hibernate
Следующее
От: Keith Fiske
Дата:
Сообщение: Re: [BUGS] BUG #9652: inet types don't support min/max