Hi,
On 2015-04-30 10:05:33 -0700, Joshua D. Drake wrote:
> postgres[21118]: [8-1] ERROR: unexpected data beyond EOF
> in block 9 of relation base/430666195/430666206
>
> FreeBSD 10
> ZFS
> iSCSI
> RAID 50 (don't start, I didn't spec it).
> fsync on, full_page_writes on
>
> The restart of Postgr
On 04/30/2015 12:09 PM, Alvaro Herrera wrote:
Joshua D. Drake wrote:
I take that back, it appears this table is heavily deleted from and also
uses the lo_manage() triggers.
Well, if it's heavily deleted, then it's probably also heavily vacuumed
and from time to time empty pages at the tail
Joshua D. Drake wrote:
>
> I take that back, it appears this table is heavily deleted from and also
> uses the lo_manage() triggers.
Well, if it's heavily deleted, then it's probably also heavily vacuumed
and from time to time empty pages at the tail are removed by vacuum. It
might also be the c
I take that back, it appears this table is heavily deleted from and also
uses the lo_manage() triggers.
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the w
On 04/30/2015 10:28 AM, Alvaro Herrera wrote:
Joshua D. Drake wrote:
Alright folks,
So I have this error:
postgres[21118]: [8-1] ERROR: unexpected data beyond EOF
in block 9 of relation base/430666195/430666206
Which produces this lovely hint:
postgres[21118]: [8-2] HINT: This has been
Joshua D. Drake wrote:
>
> Alright folks,
>
> So I have this error:
>
> postgres[21118]: [8-1] ERROR: unexpected data beyond EOF
> in block 9 of relation base/430666195/430666206
>
> Which produces this lovely hint:
>
> postgres[21118]: [8-2] HINT: This has been seen to occur with buggy
> ke
Alright folks,
So I have this error:
postgres[21118]: [8-1] ERROR: unexpected data beyond EOF
in block 9 of relation base/430666195/430666206
Which produces this lovely hint:
postgres[21118]: [8-2] HINT: This has been seen to occur with buggy
kernels; consider updating your system.
Howev
I've been working closely with Black Duck Software, and their customer,
to get to the bottom of $subject, and we have just declared success.
Here is a summary of the problem and solution for the archives.
The end-customer has a fairly beefy server, lots of RAM and CPUs, and is
running an I/O inten
