Re: could not access status of transaction 4244329

ruben20@superguai.com wrote:
> Hi:
>
> I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting
> this error after executing a query:
>
>   Warning: pg_exec() query failed: ERROR: could not access status of
> transaction 4244329 in /home/wisconsin/www/_proc/bbdd/_c_bbdd.php on
> line 160
>   ERROR ACCESO BASE DE DATOSERROR: could not access status of
> transaction 4244329
>

[SNIP]

>
> I tried reindexing:
>
>   DROP INDEX movimientos_c_c_i01;
>   CREATE INDEX movimientos_c_c_i01 ON movimientos_c_c (cod_empresa,
> cod_per_emp, cod_movimiento, fecha_movimiento);
>
>   ERROR:  could not access status of transaction 4244329
>   DETAIL:  could not open file "/usr/local/pgsql/data/pg_clog/0004": No
> existe el fichero o el directorio
>

create a empty file:

# touch /usr/local/pgsql/data/pg_clog/0004

at this point postgres will complain about the fact that an offset is missing,

at this point fill with 0 your file ( blocks of 8K ) till reach that offset reclaimed.



Regards
Gaetano Mendola