Обсуждение: [HACKERS] xid table corrupted.

Hi.

    After a begin/end block, with ~ 168 fetch, select count(*) and update,
I had "xid table corrupted", or, after dump the database and recreate
id, I had "cannot remove lock from HTAB", and, then, when I ran "vacuum"
on this database, seems that there are still remaining locks on the
table, even after the "end transation".

    I think this was because the transaction log gets full. There's a way
to increase its size?


    Robson.

------------------------------

On Mon, 23 Jun 1997, Robson Paniago de Miranda wrote:

> Hi.
>
>     After a begin/end block, with ~ 168 fetch, select count(*) and update,
> I had "xid table corrupted", or, after dump the database and recreate
> id, I had "cannot remove lock from HTAB", and, then, when I ran "vacuum"
> on this database, seems that there are still remaining locks on the
> table, even after the "end transation".
>
>     I think this was because the transaction log gets full. There's a way
> to increase its size?

    what version of PostgreSQL are you running?

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org

------------------------------