Error while searching with range

[Nugroho Herucahyono]

Hi all,

I got "bignum too big to convert into `unsigned long'" error while
trying to filter my search with range

0..(any value greater than 4_000_000_000)

Is there any way to get around it??

[Pat Allan]

Hi Nugroho

What's the data type of the attribute you're filtering on - float, or integer?

If it's a float, make sure you're passing in floats to the range, instead of integers. If it's an integer, then let me know what the stacktrace is, although there might be an upper limit of 2^32.

--
Pat

> --
>
> You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
>
>

[Nugroho Herucahyono]

Hi Pat,

Thanks for the extremely quick response :)

it's integer

this is the trace

/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/message.rb:26:in
`pack'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/message.rb:26:in
`append_int'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/message.rb:44:in
`append_ints'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/message.rb:44:in
`each'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/message.rb:44:in
`append_ints'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/filter.rb:43:in
`append_integer_range'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client/filter.rb:28:in
`query_message'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client.rb:613:in
`query_message'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client.rb:613:in `each'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client.rb:613:in
`query_message'
/usr/lib/ruby/gems/1.8/gems/riddle-1.0.8/lib/riddle/client.rb:309:in `query'
/usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.14/lib/thinking_sphinx/search.rb:258:in
`populate'
/usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.14/lib/thinking_sphinx/search.rb:257:in
`populate'
/usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.14/lib/thinking_sphinx/search.rb:380:in
`call'
/usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.14/lib/thinking_sphinx/search.rb:380:in
`retry_on_stale_index'
/usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.14/lib/thinking_sphinx/search.rb:254:in
`populate'
/usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.14/lib/thinking_sphinx/search.rb:173:in
`total_pages'

[Pat Allan]

You caught me at a good time, and the problem isn't too complex.

It looks like you're using Sphinx 0.9.8 - if you want to use 64bit integers, you'll need to use Sphinx 0.9.9 instead - try that, and Thinking Sphinx/Riddle should automatically play nicely with filters using integers greater than 2^32.

If I'm wrong, let me know and we can investigate further :)

--
Pat

[Nugroho Herucahyono]

I've tried Sphinx 0.9.9 and ts-99 before, but the delayed_job indexer
weren't work.

Was there any bug fixed on delayed_job recently?

[Pat Allan]

The latest TS gem handles both 0.9.8 and 0.9.9 - the old thinking-sphinx-099 gem is now most definitely deprecated.

As for delayed deltas, you'll want to install ts-delayed-delta, as I've extracted it from the core TS code. It should all work fine, but make sure you look through the installation guide to make sure it's all set up smoothly.
http://freelancing-god.github.com/ts/en/deltas.html (the last section)

--
Pat

[Nugroho Herucahyono]

Ugh... my bad...

looks like I missed the train :(

Thanks a lot for your GREAT works!!!