Re: Cluster seems broken after pg_basebackup - Mailing list pgsql-general

From Guillaume Drolet
Subject Re: Cluster seems broken after pg_basebackup
Date
Msg-id CAOkiyv6g95xcSxdKy7RppeDUVp1OwOTi4Fk_bRb=VwguPMYjbg@mail.gmail.com
Whole thread Raw
In response to Re: Cluster seems broken after pg_basebackup  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general


2015-02-09 16:10 GMT-05:00 Jim Nasby <Jim.Nasby@bluetreble.com>:
On 2/9/15 11:51 AM, Guillaume Lelarge wrote:
According to this page
<https://msdn.microsoft.com/en-ca/library/cc704588.aspx>, exception
0xC0000005 means STATUS_ACCESS_VIOLATION - The instruction at 0x%08lx
referenced memory at 0x%08lx. The memory could not be %s. This is not of
much help to me.

In my experience that means that your data is corrupted.

I hope these additional bits of information can help someone figuring
out a solution to get my cluster up and running again.

PS. I was thinking of reinstalling PGSQL over my current install but
keeping my PGDATA. I've done it in the past for fixing problems with
starting the service and it worked. What do you think?

You could try it, but as Guillaume Drolet mentioned I don't see this helping.

Since this is happening on your original database, I suspect that's what's been corrupted. In my experience, this means you either have faulty hardware, or there's a misconfiguration that means fsync isn't doing what it's supposed to do.

For those interested, I reinstalled the PGSQL binaries over, keeping my PGDATA and tablespace. It stopped the crashes mentioned in the previous posts, at least for now. We'll see if the crashes come back.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PL/PgSQL and pg_temp pseudo-schema
Next
From: Igor Neyman
Date:
Subject: Re: stored procedure variable names