Pat, I've been really happy using thinking_sphinx for about a year now, so I appreciate your work on it. I'm having exactly the same error as JB; right down to the fact that we're both running against PostgreSQL databases. I tried switching to Sphinx 0.9.9-id64-release (r2117), and it doesn't seem to have helped. Do you have any other ideas about how I might address this? Thanks, Terry
On Feb 12, 7:53 pm, Pat Allan <[email protected]> wrote: > Hi JB > > The problem is that with the * 4, the results are bigger than 32 bits... so > you'll need to compile Sphinx with the --enable-id64 flag, to allow 64 bit > document ids. > > Give that a spin, see if it helps. > > Cheers > > -- > Pat > > On 13/02/2010, at 4:35 AM, johnnybutler7 wrote: > > > Hi, > > > I have 4 models to index, 3 of them work fine but 1 keeps hanging when > > building the indexes. Ive trawled the forums and read solutions for > > similar issues but these don't seem to work for me. > > > The problem table which hangs the indexing is called Category and has > > the appropriate id key field etc so should in essence work so i am a > > bit stumped on that one. > > > I have read about the issue with the large id's and this does apply to > > my tables. All 4 tables id's are pretty big for example 1900639709 is > > an id field for one of the models called product. This table seems to > > index ok but the category model who's id starts at 1600578709 just > > hangs. > > In the config file i see the id * 4 which is probably causing the > > issue. > > > Basically what can i do to fix this. Below is the output > > > distributed index 'host_application' can not be directly indexed; > > skipping. > > indexing index 'manufacturer_core'... > > ERROR: index 'manufacturer_core': sql_range_query: ERROR: integer out > > of range > > (DSN=pgsql://postgres:*...@localhost:2810/av3_live). > > total 0 docs, 0 bytes > > total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec > > distributed index 'manufacturer' can not be directly indexed; > > skipping. > > indexing index 'product_core'... > > ERROR: index 'product_core': sql_range_query: ERROR: integer out of > > range > > (DSN=pgsql://postgres:*...@localhost:2810/av3_live). > > total 0 docs, 0 bytes > > total 0.014 sec, 0.00 bytes/sec, 0.00 docs/sec > > distributed index 'product' can not be directly indexed; skipping. > > Loaded suite /opt/local/bin/rake > > Started > > > thanks > > > JB > > > -- > > 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.
