Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?

On 04.05.2011 22:27, Tomasz Chmielewski wrote:

>>> Then another pg_clog file disappeared.
>
> OK, I have:
>
> bookstor=# SELECT * FROM core_wot_seq;
>    sequence_name   | last_value | increment_by |      max_value      | min_value | cache_value | log_cnt | is_cycled
|is_called 
>
------------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
>   core_wot_seq     |       2593 |            1 | 9223372036854775807 |         1 |           1 |       8 | f
|t 
> (1 row)
>
> bookstor=# SELECT 1 FROM core_wot_seq;
>   ?column?
> ----------
>          1
> (1 row)
>
> bookstor=# SELECT 1 FROM core_wot_seq FOR UPDATE;
> ERROR:  could not access status of transaction 1573786613
> DETAIL:  Could not open file "pg_clog/05DC": No such file or directory.
>
> How do I best recover from this? Stop postgres, create an empty, 256k pg_clog/05DC file, start postgres?
>
> Export table, drop table, import table? Anything else?

Nobody has a clue? :|


--
Tomasz Chmielewski
http://wpkg.org