Right. Well, given the crc function is something I wrote, I better fix that!
I'm surprised it's not come up before, to be honest. -- Pat On 09/11/2010, at 9:46 AM, crazy_matt wrote: > They both throw the same error. I tried all NULLs and all empties. > > On Nov 8, 3:28 pm, Pat Allan <[email protected]> wrote: >> Hmm, what happens if you change all the empty strings to NULLs? It's a bug >> either way, for sure, but I just want to check as to which scenario we're >> having the problem with. >> >> -- >> Pat >> >> On 09/11/2010, at 4:23 AM, crazy_matt wrote: >> >>> I thought of that over the weekend and gave it a try. I converted all >>> NULL values in one of those columns to empty strings, added the column >>> back into my index and go that same error: "sql_range_query: ERROR: >>> index 0 out of valid range, 0..-1 CONTEXT: PL/pgSQL function "crc32" >>> line 10 at assignment" >> >>> However, when I filled them with an arbitrary, non-empty string value >>> the indexing succeeded. So the CRC is failing on NULL values but also >>> on empty strings in Postgres. >> >>> I suppose I can think of some default value for those rows, but I'd >>> love to have the CRC function not fail on NULL values. If I felt >>> qualified to tackle that I would give it a try, but I'm definitely a >>> noob when it comes to sphinx. >> >>> On Nov 5, 4:15 pm, Pat Allan <[email protected]> wrote: >>>> Hi Matt >> >>>> What are the values in the columns you want to facet? Is there anything >>>> particularly odd? I'm wondering if NULL values are failing in CRC >>>> conversion... if there are NULL values in audience_type, author_type or >>>> format, perhaps try changing them to blank strings? >> >>>> Cheers >> >>>> -- >>>> Pat >> >>>> On 06/11/2010, at 5:19 AM, crazy_matt wrote: >> >>>>> Interesting. I have no IDs with a value of 0. As I mentioned, when I >>>>> remove the three columns I was trying to facet on, the indexing >>>>> succeeded. It has something to do with the CRCs for the facted >>>>> columns. >> >>>>> On Nov 5, 12:13 pm, Luciano Sousa <[email protected]> wrote: >>>>>> if you have some id 0 in your table, the sphinx can not index it, so you >>>>>> will not have the sphinx functioning properly. I believe this is your >>>>>> problem. >>>>>> I had a similar problem and removed all the values id = 0 in my database. >> >>>>>> 2010/11/5 crazy_matt <[email protected]> >> >>>>>>> When I remove the faceted fields, the indexing job runs just fine. But >>>>>>> I kinda wanna get those working. >> >>>>>>> On Nov 5, 11:40 am, crazy_matt <[email protected]> wrote: >>>>>>>> Obviously. That is why I'm confused about this error. The TS-generated >>>>>>>> SQL looks like this: >> >>>>>>>> sql_query = SELECT "books"."id" * 2 + 0 AS "id" , "books"."title" AS >>>>>>>> "title", "books"."subtitle" AS "subtitle", "books"."keywords" AS >>>>>>>> "keywords", "books"."pub_year" AS "pub_year", "books"."id" AS >>>>>>>> "sphinx_internal_id", 1809255439 AS "class_crc", 0 AS >>>>>>>> "sphinx_deleted", COALESCE("books"."title", '') AS "title_sort", >>>>>>>> COALESCE("books"."audience_type", '') AS "audience_type", >>>>>>>> crc32("books"."audience_type") AS "audience_type_facet", >>>>>>>> COALESCE("books"."author_type", '') AS "author_type", >>>>>>>> crc32("books"."author_type") AS "author_type_facet", >>>>>>>> COALESCE("books"."format", '') AS "format", crc32("books"."format") AS >>>>>>>> "format_facet" FROM "books" WHERE ("books"."id" >= $start >>>>>>>> AND "books"."id" <= $end) GROUP BY "books"."id", "books"."title", >>>>>>>> "books"."subtitle", "books"."keywords", "books"."pub_year", >>>>>>>> "books"."id", "books"."title", "books"."audience_type", >>>>>>>> "books"."audience_type", "books"."author_type", "books"."author_type", >>>>>>>> "books"."format", "books"."format" >> >>>>>>>> On Nov 5, 11:17 am, Luciano Sousa <[email protected]> wrote: >> >>>>>>>>> tables are not indexed with id = 0 >> >>>>>>>>> 2010/11/5 crazy_matt <[email protected]> >> >>>>>>>>>> I keep getting the following error when I index: >> >>>>>>>>>> ERROR: index 'book_core': sql_range_query: ERROR: index 0 out of >>>>>>>>>> valid range, 0..-1 >>>>>>>>>> CONTEXT: PL/pgSQL function "crc32" line 10 at assignment >> >>>>>>>>>> The only information I could find about the index out of range error >>>>>>>>>> was for IDs that were enormous. I'm at a loss. Any ideas what may be >>>>>>>>>> causing this? >> >>>>>>>>>> Matt >> >>>>>>>>>> -- >>>>>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups >>>>>>>>>> "Thinking Sphinx" group. >>>>>>>>>> To post to this group, send email to >>>>>>> [email protected]. >>>>>>>>>> To unsubscribe from this group, send email to >>>>>>>>>> [email protected]<thinking-sphinx%[email protected]> >>>>>>> <thinking-sphinx%[email protected]<thinking-sphinx%[email protected]> >> >>>>>>>>>> . >>>>>>>>>> For more options, visit this group at >>>>>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en. >> >>>>>>>>> -- >>>>>>>>> att: Luciano Sousahttp://www.lucianosousa.net >>>>>>>>> <http://www.lucianosousa.net>http://twitter.com/lucianosousa >>>>>>>>> *Ruby on Rails Developer >>>>>>>>> *Linux User #456387 >>>>>>>>> *Contato: (21) 7639-5049 >> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups >>>>>>> "Thinking Sphinx" group. >>>>>>> To post to this group, send email to [email protected]. >>>>>>> To unsubscribe from this group, send email to >>>>>>> [email protected]<thinking-sphinx%[email protected]> >>>>>>> . >>>>>>> For more options, visit this group at >>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en. >> >>>>>> -- >>>>>> att: Luciano Sousahttp://www.lucianosousa.net >>>>>> <http://www.lucianosousa.net>http://twitter.com/lucianosousa >>>>>> *Ruby on Rails Developer >>>>>> *Linux User #456387 >>>>>> *Contato: (21) 7639-5049 >> >>>>> -- >>>>> You received this message because you are subscribed to the Google Groups >>>>> "Thinking Sphinx" group. >>>>> To post to this group, send email to [email protected]. >>>>> To unsubscribe from this group, send email to >>>>> [email protected]. >>>>> For more options, visit this group >>>>> athttp://groups.google.com/group/thinking-sphinx?hl=en. >> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Thinking Sphinx" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. >> >> > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
