Thread: 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