Re: ERROR: could not access status of transaction

Поиск
Список
Период
Сортировка
От raghu ram
Тема Re: ERROR: could not access status of transaction
Дата
Msg-id AANLkTims48njGKkvkXHiTG6=19hQ31VFmFRPPLg+5w03@mail.gmail.com
обсуждение исходный текст
Ответ на ERROR: could not access status of transaction  (Stevie <stevieg@web.de>)
Ответы Re: ERROR: could not access status of transaction  (Stevie <stevieg@web.de>)
Re: ERROR: could not access status of transaction  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-admin
Дерево обсуждения


On Thu, Mar 24, 2011 at 6:09 PM, Stevie <stevieg@web.de> wrote:
Hello pgsql-admins,

we have a problem with our Postgresql 9.0.3 backup database (Ubuntu 10.4).
The backup and restore is done as described here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html
If you want to know the exact steps of backup and restore,please ask.

We restore the database on the backup host and it's starting. I've append the mainlog.

If we dump or reindex the database we get "could not access status of transaction NNNNNN" errors.
PG tries to access old clog files: "pg_clog/00CD". But in the pg_clog directory the files start at "00E6" and end at "0198".
I've append the pg_controldata output. This clog files doesn't exist on the original database neither.

I could create empty clog files, but it seems that our database is in an inconsistent state?
Any suggestions are welcome.


There is a commit log corruption in your database. You need to make the files with right size (256K of zeroes).A suitable "dd" from /dev/zero will accomplish this on modernUnixen (ie, anything that has /dev/zero). Filling of those files with zeroes nothing but  " all those old transactions are aborted".



The safest way to resolve the issue by using the below command:-


dd if=/dev/zero of=Transaction_missing_file_of pg_clog bs=256K count=1 (To make the uncommitted record as they haven't been committed).


--Raghu Ram



 
Regards
Steffen


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


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

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: Re: What does error "psql: Kerberos 5 authentication not supported" means?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What does error "psql: Kerberos 5 authentication not supported" means?