Thread: PANIC: hash table "LOCK" hash corrupted

PANIC: hash table "LOCK" hash corrupted

From
Gerhard Heift
Date:
Hello,

I'm playing with postgres in OpenVZ. When I migrate my machine with
the database from one host to another I get following errors:

2009-10-04 20:20:43 CEST PANIC:  hash table "LOCK hash" corrupted
2009-10-04 20:20:43 CEST STATEMENT:  begin
2009-10-04 20:20:43 CEST @ LOG:  server process (PID 14554) was
2009-10-04 20:20:43 CEST @ LOG:  terminating any other active server processes

What does this mean?

Thanks,
  Gerhard

Attachment

Re: PANIC: hash table "LOCK" hash corrupted

From
Tom Lane
Date:
Gerhard Heift <ml-postgresql-20081012-3518@gheift.de> writes:
> I'm playing with postgres in OpenVZ. When I migrate my machine with
> the database from one host to another I get following errors:

> 2009-10-04 20:20:43 CEST PANIC:  hash table "LOCK hash" corrupted
> 2009-10-04 20:20:43 CEST STATEMENT:  begin
> 2009-10-04 20:20:43 CEST @ LOG:  server process (PID 14554) was
> 2009-10-04 20:20:43 CEST @ LOG:  terminating any other active server processes

> What does this mean?

Apparently it means that OpenVZ doesn't work too well :-( --- it
hasn't migrated the contents of shared memory accurately.  This
could be a synchronization type of problem, eg contents of process
local memory and shared memory not copied at the same instant.
IIRC one of the main reasons for "hash table corrupted" panics is
failing to find a hash table entry that is expected to be there
according to some other state information.

            regards, tom lane