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

Hi Tom,
I have a python script which simulates our production environment and so fa=
r I have been able to replicate the failure on demand.  What is the best wa=
y to make this available?

Also, I can make this sandbox environment available for remote access if th=
at would help.

Thanks!
Spencer


> On Aug 29, 2016, at 10:32 AM, Spencer Thomason <spencer@whiteskycommunica=
tions.com> wrote:
>=20
> Hi Tom,
> I'm working on labbing this up and hopefully I can replicate it outside o=
f our production environment.
>=20
> We have a text column that contains fair amount of text (e.g. generated f=
rom a fax of maybe 10-25 pages) and then a tsvector column of that text wit=
h a gin index.  To improve performance, we delete text on the old records n=
ightly.
>=20
> This appears to be related to number of records updated and the size of t=
he update to the tsvector column.  Hopefully I can provide more details and=
 a test case soon.
>=20
> Thanks,
> Spencer
>=20
>=20
>=20
>> 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 i=
tems)
>>> 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
>=20