Re: BUG #14295: Hot standby crash during tsvector rebuild

Hi Tom,
I'm working on labbing this up and hopefully I can replicate it outside of =
our production environment.

We have a text column that contains fair amount of text (e.g. generated fro=
m a fax of maybe 10-25 pages) and then a tsvector column of that text with =
a gin index.  To improve performance, we delete text on the old records nig=
htly.

This appears to be related to number of records updated and the size of the=
 update to the tsvector column.  Hopefully I can provide more details and a=
 test case soon.

Thanks,
Spencer



> On Aug 26, 2016, at 4:05 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> spencer@whiteskycommunications.com writes:
>> Logs from one of the replicas is below:
>> 2016-08-26 06:01:50 UTC FATAL:  unexpected GIN leaf action: 0
>> 2016-08-26 06:01:50 UTC CONTEXT:  xlog redo Insert item, node:
>> 1663/16387/33108 blkno: 6622 isdata: T isleaf: T 3 segments: 2 (add 0 it=
ems)
>> 0 unknown action 0 ???
>=20
> Hmm, we have seen a couple of reports of that recently but have not been
> able to track it down.  Can you provide more details about what you're
> doing that triggers it?  Maybe even a self-contained test case?  It
> doesn't have to be one that fails every time, as long as it'll fail
> occasionally.
>=20
>             regards, tom lane