Re: hung backends stuck in spinlock heavy endless loop - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: hung backends stuck in spinlock heavy endless loop
Date
Msg-id CAHyXU0zuamrY4uJ68LZfy1+Lc1FJ3stofDkGfGX+Q43vruxjjQ@mail.gmail.com
Whole thread Raw
In response to Re: hung backends stuck in spinlock heavy endless loop  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: hung backends stuck in spinlock heavy endless loop
List pgsql-hackers
On Thu, Jan 15, 2015 at 1:32 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> Since it's possible the database is a loss, do you see any value in
> bootstrappinng it again with checksums turned on?  One point of note
> is that this is a brand spanking new SSD, maybe we nee to rule out
> hardware based corruption?

hm!  I bootstrapped a new database with checksums on, and lo,

[cds2 18347 2015-01-15 15:58:29.955 CST 1779]WARNING:  page
verification failed, calculated checksum 28520 but expected 28541
[cds2 18347 2015-01-15 15:58:29.955 CST 1779]CONTEXT:  SQL statement
"COPY lease_delete FROM
'/tmp/C1188732_onesiteproperty.lease_delete.csv' CSV HEADER"

merlin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: segmentation fault in execTuples.c#ExecStoreVirtualTuple
Next
From: Peter Geoghegan
Date:
Subject: Re: infinite loop in _bt_getstackbuf