Skip site navigation (1) Skip section navigation (2)

Re: BUG #5238: frequent signal 11 segfaults

From: Nagy Daniel <nagy(dot)daniel(at)telekom(dot)hu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, "pgsql-bugs(at)postgresql(dot)org"<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5238: frequent signal 11 segfaults
Date: 2009-12-18 11:11:04
Message-ID: 4B2B6348.1050504@telekom.hu (view raw or flat)
Thread:
Lists: pgsql-bugs
I don't know if it's related, but we often have index problems
as well. When performing full vacuum, many indexes contain
one more row versions than the tables:

WARNING:  index "iwiw_start_top_napi_fast_idx" contains 10932 row
versions, but table contains 10931 row versions
WARNING:  index "iwiw_start_top_napi_fast_idx" contains 10932 row
versions, but table contains 10931 row versions
WARNING:  index "iwiw_jatekok_ertek_idx" contains 17 row versions, but
table contains 16 row versions
WARNING:  index "ujtema_nehezseg_idx" contains 696 row versions, but
table contains 695 row versions

etc...

Daniel



Tom Lane wrote:
> Nagy Daniel <nagy(dot)daniel(at)telekom(dot)hu> writes:
>> I have pg segfaults on two boxes, a DL160G6 and a DL380g5.
>> I've just checked their memory with memtest86+ v2.11
>> No errors were detected.
>> We also monitor the boxes via IPMI, and there are no signs
>> of HW failures.
> 
> Hm.  Well, now that 8.4.2 is out, the first thing you ought to do is
> update and see if this happens to be resolved by any of the recent
> fixes.  (I'm not too optimistic about that, because it doesn't look
> exactly like any of the known symptoms, but an update is certainly
> worth your time in any case.)
> 
> If you still see it after that, please try to extract a reproducible
> test case.
> 
> 			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2009-12-19 00:27:22
Subject: Re: BUG #5249: PGUSER has to be set in the console for PSQL to authenticate
Previous:From: Dave PageDate: 2009-12-18 10:20:22
Subject: Re: BUG #5248: Cannot find SSLEAY32.dll problem.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group