Обсуждение: issue with smlar exension and gist index creation (9.2Beta1)

Hi All,

I am playing around with 9.2Beta1 and the smlar extension that was presented
at pgcon. Looks like a lot of great work has gone into both - so thanks to
everyone for all the great work. 


I did run into an issue while creating a GIST index using the _text_sml_ops.

I am getting "ERROR: failed to re-find parent for block 25399". 


Create index statement :
Create index my_musbject_array_idx on message_20120605 USING
GIST(regexp_split_to_array(msubject, E'\\s+') _text_sml_ops);

(msubject is a varchar(255))
Encoding is UTF8


Table has data in it already. I know this isn't the preferred method of
creating this kind of index, but I don't see why it should fail with this
error. 


I am working to see if I can find a reproducible case that doesn't involve
19GB of table data,  but was told I might as well throw this out to the list
tonight. 

I understand that smlar is very new, not even a contrib yet, but was told I
might as well throw this out to this list. 


If anyone wants more details please let me know and I will try and get them
to you. 


..: Mark 

"mark" <dvlhntr@gmail.com> writes:
> I am playing around with 9.2Beta1 and the smlar extension that was presented
> at pgcon. Looks like a lot of great work has gone into both - so thanks to
> everyone for all the great work. 
> I did run into an issue while creating a GIST index using the _text_sml_ops.
> I am getting "ERROR: failed to re-find parent for block 25399". 

Try beta2 ... this sounds suspiciously like the bug Heikki fixed last week:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1996ed5e8bfaf1314e7817015668029c07d3b9b
        regards, tom lane

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, June 05, 2012 9:22 PM
> To: mark
> Cc: 'pgsql-hackers'
> Subject: Re: [HACKERS] issue with smlar exension and gist index
> creation (9.2Beta1)
> 
> "mark" <dvlhntr@gmail.com> writes:
> > I am playing around with 9.2Beta1 and the smlar extension that was
> > presented at pgcon. Looks like a lot of great work has gone into both
> > - so thanks to everyone for all the great work.
> > I did run into an issue while creating a GIST index using the
> _text_sml_ops.
> > I am getting "ERROR: failed to re-find parent for block 25399".
> 
> Try beta2 ... this sounds suspiciously like the bug Heikki fixed last
> week:
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1996
> ed5e8bfaf1314e7817015668029c07d3b9b
> 
>             regards, tom lane


Thanks, I will give that a shot and see if I still have the same issue. 

..: Mark