Hi Pat,
Sorry to disturb you again but I have another problem using Thinking Sphinx
with delta
I set up my index with delta => true : : ThinkingSphinx::Index.define(:image,
:with => :active_record, :delta => true) do
I have a rails app which read ftp folders and update the mysql database to feed
images with delta to true.
I have a cron which launch sphinx indexer rotate delta every 10'
but now every time an image is saved with active-record (Model.save) from the
ftp app, rotate delta is launched and the next image will be got only when
rotate is finished (about 3'), any idea why ?
What I could do is using delayed_delta, it works, but I prefer not using
delayed_job
TS 3.0.4
rails 3.2.13
Sphinx 2.0.8
Thanks, regards
Patrick
Le 16 juil. 2013 à 20:12, Pat Allan a écrit :
> It is winter here - some warmer weather would be nice :)
>
> Great to know it's working now!
>
> On 16/07/2013, at 10:35 PM, Patrick Lamotte wrote:
>
>> ok it works, so I'll remove the per_page and :page every time I use facets,
>> it is logical actually
>> Many thanks, and nice summer (it's winter in australia isn't it ?
>> Patrick
>>
>> Le 16 juil. 2013 à 14:18, Pat Allan a écrit :
>>
>>> Ah, sorry, remove :page as well:
>>>
>>> facets = Image.facets(keywords, cearch.except(:page, :per_page))
>>>
>>> On 16/07/2013, at 10:13 PM, Patrick Lamotte wrote:
>>>
>>>> yes you're right, but I tried with except and recreating cearch without
>>>> the per_page option and i've got the same error with offset and
>>>> max_matches equal to the config file
>>>> ThinkingSphinx::SphinxError (query 0 error: offset out of bounds
>>>> (offset=10000, max_matches=10000); query 1 error: offset out of bounds
>>>> (offset=10000, max_matches=10000)):
>>>>
>>>> Le 16 juil. 2013 à 13:29, Pat Allan a écrit :
>>>>
>>>>> There's not much point passing :per_page into the facet call - it's going
>>>>> to grab all the results in one hit anyway (hence why it's picking up on
>>>>> the max_matches value).
>>>>>
>>>>> So, instead of "facets = Image.facets(keywords, cearch)", try "facets =
>>>>> Image.facets(keywords, cearch.except(:per_page))".
>>>>>
>>>>> On 16/07/2013, at 8:37 PM, Patrick Lamotte wrote:
>>>>>
>>>>>> cearch[:per_page] = val_def_ppage #user default
>>>>>> cearch[:per_page] = @current_params["per_page"].to_i if
>>>>>> @current_params["per_page"] #unless it was changed in the search
>>>>>> cearch[:page] = params["page"].to_i if params["page"]
>>>>>>
>>>>>> keywords = @current_params["key_words"] ?
>>>>>> Pixways::SearchesHelper.filter_keywords(@current_params["key_words"]) :
>>>>>> ''
>>>>>> cearch[:match_mode] = :extended
>>>>>> @medias = Image.search(keywords, cearch)
>>>>>>
>>>>>> @medias.context[:panes] << ThinkingSphinx::Panes::ExcerptsPane
>>>>>> @nb_images = {}
>>>>>> facets = Image.facets(keywords, cearch)
>>>>>> @nb_images = facets[:provider_id]
>>>>>>
>>>>>> the error is in the last line @nb_images = facets[:provider_id]
>>>>>>
>>>>>> indices => image_index.rb
>>>>>> ThinkingSphinx::Index.define(:image, :with => :active_record, :delta =>
>>>>>> ThinkingSphinx::Deltas::DelayedDelta) do
>>>>>> indexes :title, :subject ...
>>>>>> # attributes
>>>>>> has :ratio, :reception_date ...
>>>>>> has :provider_id, :facet => true
>>>>>>
>>>>>>
>>>>>>
>>>>>> Le 16 juil. 2013 à 12:27, Pat Allan a écrit :
>>>>>>
>>>>>>> Can you share with us the full facet search call?
>>>>>>>
>>>>>>> On 16/07/2013, at 7:02 PM, Patrick Lamotte wrote:
>>>>>>>
>>>>>>>> Hi Pat,
>>>>>>>>
>>>>>>>> Yes it happens only when one tries to show page 2, so there is a :page
>>>>>>>> option in the search.
>>>>>>>> max_matches is set up in the config file, but not in the search, I
>>>>>>>> tried to pass max_matches in the search, it's ok for the first page
>>>>>>>> but same error offset out of bounds with max_matches number set up in
>>>>>>>> the search, instead of per_page option.
>>>>>>>> It works fine with TS 3.0.3 and it's only when facets are requested,
>>>>>>>> text searches work fine.
>>>>>>>> Thanks, regards
>>>>>>>>
>>>>>>>> Patrick
>>>>>>>>
>>>>>>>> Le 16 juil. 2013 à 01:42, Pat Allan a écrit :
>>>>>>>>
>>>>>>>>> Hi Patrick
>>>>>>>>>
>>>>>>>>> Are you passing in a :page or :offset option to your search? It looks
>>>>>>>>> like it's trying to request the second page of results, but there's
>>>>>>>>> only one, due to max_matches being set to the largest possible page
>>>>>>>>> size.
>>>>>>>>>
>>>>>>>>> So, if you are using :page or :offset, remove that option, see if
>>>>>>>>> that helps.
>>>>>>>>>
>>>>>>>>> Cheers
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Pat
>>>>>>>>>
>>>>>>>>> On 16/07/2013, at 12:39 AM, Patrick Lamotte wrote:
>>>>>>>>>
>>>>>>>>>> Hi Pat,
>>>>>>>>>>
>>>>>>>>>> I updated to 3.0.4, but I still got an error with facets
>>>>>>>>>> ThinkingSphinx::SphinxError (query 0 error: offset out of bounds
>>>>>>>>>> (offset=20, max_matches=20); query 1 error: offset out of bounds
>>>>>>>>>> (offset=20, max_matches=20)):
>>>>>>>>>>
>>>>>>>>>> 20 is results per page(if I choose 40 then error will offset=40,
>>>>>>>>>> max_matches=40)
>>>>>>>>>> if I set max_matches and limit in the search, to 1000 for instance,
>>>>>>>>>> then same error with offset=1000, max_matches=1000
>>>>>>>>>>
>>>>>>>>>> No problem with text searches, any idea ?
>>>>>>>>>>
>>>>>>>>>> Thanks, regards
>>>>>>>>>>
>>>>>>>>>> Patrick
>>>>>>>>>>
>>>>>>>>>> Le 14 juin 2013 à 04:58, Pat Allan a écrit :
>>>>>>>>>>
>>>>>>>>>>> Just pushed a fix, it'll be part of 3.0.4 when that gets released :)
>>>>>>>>>>>
>>>>>>>>>>> On 14/06/2013, at 12:58 AM, Patrick Lamotte wrote:
>>>>>>>>>>>
>>>>>>>>>>>> ok, don't worry
>>>>>>>>>>>> Thanks for answering so quickly everytime
>>>>>>>>>>>> Best
>>>>>>>>>>>> Patrick
>>>>>>>>>>>>
>>>>>>>>>>>> Le 13 juin 2013 à 16:56, Pat Allan a écrit :
>>>>>>>>>>>>
>>>>>>>>>>>>> Just looked at the v1/v2 source, I was setting max_matches/limit
>>>>>>>>>>>>> then, but I'm not with the v3 branch - I'll need to fix that! In
>>>>>>>>>>>>> the meantime, using those options will deal with the problem.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Sorry for the hassle.
>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>> Pat
>>>>>>>>>>>>>
>>>>>>>>>>>>> On 14/06/2013, at 12:53 AM, Patrick Lamotte wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Hi Pat,
>>>>>>>>>>>>>> Thanks, it worked that way, but is it the good way to do it now
>>>>>>>>>>>>>> ? it worked before with v2 ?
>>>>>>>>>>>>>> Thanks again,best regards
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Patrick
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Le 13 juin 2013 à 16:33, Pat Allan a écrit :
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Hi Patrick
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Can you try setting max_matches and limit in your search call
>>>>>>>>>>>>>>> to 1000?
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Image.facets(
>>>>>>>>>>>>>>> :with => {:provider_id => provs_list},
>>>>>>>>>>>>>>> :max_matches => 1000,
>>>>>>>>>>>>>>> :limit => 1000
>>>>>>>>>>>>>>> )
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>> Pat
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> On 13/06/2013, at 7:21 PM, pix_plm wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>>>> I am having problems with facets after updating to TS V3, for
>>>>>>>>>>>>>>>> some reason facets don't return all parameters and I don't
>>>>>>>>>>>>>>>> understand what are the criterias ?
>>>>>>>>>>>>>>>> I use facets to get number of images per provider
>>>>>>>>>>>>>>>> (provider_id), calling Image.facets :with { :provider_id =>
>>>>>>>>>>>>>>>> provs_list }
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> facets.inspect => ****
>>>>>>>>>>>>>>>> #<ThinkingSphinx::FacetSearch:0x00000006bc1ff0
>>>>>>>>>>>>>>>> @options={:with=>{:provider_id=>[99, 92, 150, 28, 116, 170,
>>>>>>>>>>>>>>>> 45, 25, 74, 21, 3, 55, 12, 71, 93, 27, 79, 98, 52, 152, 65,
>>>>>>>>>>>>>>>> 151, 38, 155, 115, 161, 53, 124, 106, 4, 133, 68, 156, 121,
>>>>>>>>>>>>>>>> 134, 39, 117, 86, 26, 48, 67, 13, 167, 33, 162, 34, 22, 85,
>>>>>>>>>>>>>>>> 15, 90, 47, 69, 18, 168, 163, 147, 153, 166, 59, 63, 131, 75,
>>>>>>>>>>>>>>>> 154, 105, 41, 64, 119, 139, 84, 118, 94, 107, 96, 31, 113,
>>>>>>>>>>>>>>>> 165, 40, 149, 35, 158, 8, 70, 112, 76, 97, 17, 109, 145, 137,
>>>>>>>>>>>>>>>> 110, 11, 58, 7, 43, 16, 51, 1, 50, 10, 83, 36, 102, 169, 159,
>>>>>>>>>>>>>>>> 111, 123, 19, 91, 66, 101, 160], :content_error=>0},
>>>>>>>>>>>>>>>> :classes=>[Image(id: integer, ...)]}, @query=nil, @hash={}>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> results :
>>>>>>>>>>>>>>>> facets[:provider_id] => {4=>167153, 7=>185846, 10=>26215,
>>>>>>>>>>>>>>>> 13=>88504, 17=>617844, 16=>53911, 18=>105185, 19=>12223,
>>>>>>>>>>>>>>>> 21=>361506, 15=>59375, 26=>261693, 25=>27155, 27=>156428,
>>>>>>>>>>>>>>>> 33=>553155, 31=>129199, 34=>719638, 22=>151379, 35=>3216,
>>>>>>>>>>>>>>>> 36=>126032, 38=>19279}
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> I don't understand why I don't get all providers results ?
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> I am running rails 3.2.13, ts 3.0.3, sphinx 2.0.7
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> indices for Image Model
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> ThinkingSphinx::Index.define(:image, :with => :active_record,
>>>>>>>>>>>>>>>> :delta => ThinkingSphinx::Deltas::DelayedDelta) do
>>>>>>>>>>>>>>>> indexes :title, :subject, ...
>>>>>>>>>>>>>>>> # attributes
>>>>>>>>>>>>>>>> has :ratio, :reception_date ...
>>>>>>>>>>>>>>>> has :provider_id, :facet => true
>>>>>>>>>>>>>>>> end
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Any idea ?
>>>>>>>>>>>>>>>> Thanks
>>>>>>>>>>>>>>>> Patrick
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>> You received this message because you are subscribed to the
>>>>>>>>>>>>>>>> Google Groups "Thinking Sphinx" group.
>>>>>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from
>>>>>>>>>>>>>>>> it, send an email to
>>>>>>>>>>>>>>>> [email protected].
>>>>>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>>>>>> [email protected].
>>>>>>>>>>>>>>>> Visit this group at
>>>>>>>>>>>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en.
>>>>>>>>>>>>>>>> For more options, visit
>>>>>>>>>>>>>>>> https://groups.google.com/groups/opt_out.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>> You received this message because you are subscribed to a topic
>>>>>>>>>>>>>>> in the Google Groups "Thinking Sphinx" group.
>>>>>>>>>>>>>>> To unsubscribe from this topic, visit
>>>>>>>>>>>>>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe?hl=en.
>>>>>>>>>>>>>>> To unsubscribe from this group and all its topics, send an
>>>>>>>>>>>>>>> email to [email protected].
>>>>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>>>>> [email protected].
>>>>>>>>>>>>>>> Visit this group at
>>>>>>>>>>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en.
>>>>>>>>>>>>>>> For more options, visit
>>>>>>>>>>>>>>> https://groups.google.com/groups/opt_out.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> You received this message because you are subscribed to the
>>>>>>>>>>>>>> Google Groups "Thinking Sphinx" group.
>>>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from
>>>>>>>>>>>>>> it, send an email to
>>>>>>>>>>>>>> [email protected].
>>>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>>>> [email protected].
>>>>>>>>>>>>>> Visit this group at
>>>>>>>>>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en.
>>>>>>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>> You received this message because you are subscribed to a topic
>>>>>>>>>>>>> in the Google Groups "Thinking Sphinx" group.
>>>>>>>>>>>>> To unsubscribe from this topic, visit
>>>>>>>>>>>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe?hl=en.
>>>>>>>>>>>>> To unsubscribe from this group and all its topics, send an email
>>>>>>>>>>>>> to [email protected].
>>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>>> [email protected].
>>>>>>>>>>>>> Visit this group at
>>>>>>>>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en.
>>>>>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>>>>>> Groups "Thinking Sphinx" group.
>>>>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>>>>> send an email to [email protected].
>>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>>> [email protected].
>>>>>>>>>>>> Visit this group at
>>>>>>>>>>>> http://groups.google.com/group/thinking-sphinx?hl=en.
>>>>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> You received this message because you are subscribed to a topic in
>>>>>>>>>>> the Google Groups "Thinking Sphinx" group.
>>>>>>>>>>> To unsubscribe from this topic, visit
>>>>>>>>>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe.
>>>>>>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>>>>>>> [email protected].
>>>>>>>>>>> To post to this group, send email to
>>>>>>>>>>> [email protected].
>>>>>>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>>>> Groups "Thinking Sphinx" group.
>>>>>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>>>>>> send an email to [email protected].
>>>>>>>>>> To post to this group, send email to
>>>>>>>>>> [email protected].
>>>>>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> You received this message because you are subscribed to a topic in
>>>>>>>>> the Google Groups "Thinking Sphinx" group.
>>>>>>>>> To unsubscribe from this topic, visit
>>>>>>>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe.
>>>>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>>>>> [email protected].
>>>>>>>>> To post to this group, send email to [email protected].
>>>>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> You received this message because you are subscribed to the Google
>>>>>>>> Groups "Thinking Sphinx" group.
>>>>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>>>>> an email to [email protected].
>>>>>>>> To post to this group, send email to [email protected].
>>>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> You received this message because you are subscribed to a topic in the
>>>>>>> Google Groups "Thinking Sphinx" group.
>>>>>>> To unsubscribe from this topic, visit
>>>>>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe.
>>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>>> [email protected].
>>>>>>> To post to this group, send email to [email protected].
>>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "Thinking Sphinx" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>>> an email to [email protected].
>>>>>> To post to this group, send email to [email protected].
>>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to a topic in the
>>>>> Google Groups "Thinking Sphinx" group.
>>>>> To unsubscribe from this topic, visit
>>>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe.
>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>> [email protected].
>>>>> To post to this group, send email to [email protected].
>>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>>
>>>>>
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google Groups
>>>> "Thinking Sphinx" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send an
>>>> email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>>
>>>
>>>
>>> --
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "Thinking Sphinx" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Thinking Sphinx" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://groups.google.com/group/thinking-sphinx.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>
>
>
> --
> You received this message because you are subscribed to a topic in the Google
> Groups "Thinking Sphinx" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/thinking-sphinx/yiF1CHH9XAA/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/thinking-sphinx.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/groups/opt_out.
