Re: Shared buffer hash table corrupted - Mailing list pgsql-general

From Tom Lane
Subject Re: Shared buffer hash table corrupted
Date
Msg-id 28090.1582392880@sss.pgh.pa.us
Whole thread Raw
In response to Re: Shared buffer hash table corrupted  (Mark Fletcher <markf@corp.groups.io>)
Responses Re: Shared buffer hash table corrupted  (Mark Fletcher <markf@corp.groups.io>)
List pgsql-general
Mark Fletcher <markf@corp.groups.io> writes:
> Thanks for the response. I did restart the postmaster yesterday. Earlier
> this morning, a query that normally completes fine started to error out
> with 'invalid memory alloc request size 18446744073709551613'. Needless to
> say our database isn't quite that size. This query was against a table in a
> different database than the one that had the corruption warning yesterday.
> Restarting the postmaster again fixed the problem. For good measure I
> restarted the machine as well.

Um.  At that point I'd agree with your concern about developing hardware
problems.  Both of these symptoms could be easily explained by dropped
bits in PG's shared memory area.  Do you happen to know if the server
has ECC RAM?

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Replication: slave server has 3x size of production server?
Next
From: Mark Fletcher
Date:
Subject: Re: Shared buffer hash table corrupted