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