On 1 Feb 2012, at 16:04, Tom Lane wrote:
> postgres@dunquino.com writes:
>> This is intermittent and hard to reproduce but crashes consistently in t=
he
>> same place. That place is backend/access/common/heaptuple.c line 1104:
>> ...
>> This system is using streaming replication, and the problem always occur=
rs
>> on the secondary.
>=20
> Have you read the thread about bug #6200? I'm suspicious that this is
> the same or similar problem, with a slightly different visible symptom
> because of pickier hardware. I'm afraid we don't know what's going on
> yet there either, but the idea that t_hoff is wrong gives us a new line
> of thought.
>=20
> regards, tom lane
I didn't find 6200 when looking for mentions of this problem. So thanks for=
that.
I have read the thread now and I guess it could be the same kind of thing. =
I have tried creating a cut-down version of what is happening for real, but=
that didn't cause the problem.
I do have a bunch of core files, but I'm not (yet!) familiar with pg code s=
o I am unable to usefully analyse it.
One idea I saw mentioned in #6200 is of using another HS. I didn't think of=
that before. I may try creating another (or more) of them to see if I can =
reproduce it more quickly.
Regards,
orval