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

From Jim Nasby
Subject Re: Cluster seems broken after pg_basebackup
Date
Msg-id 54D9223E.4040405@BlueTreble.com
Whole thread Raw
In response to Re: Cluster seems broken after pg_basebackup  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Cluster seems broken after pg_basebackup  (Guillaume Drolet <droletguillaume@gmail.com>)
Re: Cluster seems broken after pg_basebackup  (Guillaume Drolet <droletguillaume@gmail.com>)
List pgsql-general
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.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com


pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Question on session_replication_role
Next
From: Brent Wood
Date:
Subject: Re: Partioning with overlapping and non overlapping constraints