Hello Pat,
Thank you for the reply. That did indeed help. Delta indexing does
work now!
I agree with you on the environment. It will be something I will fix
in the future.
A new problem that popped up: my cache doesn't seem to expire any
more. On both development and test.
Specific (probably uncached) search queries do return the right
results so delta indexing is working, but my main (cached) index
returns stale results.
I probably have to look into this a little more, but if anything pops
to mind I'm happy to hear about it.
About the sphinx_select. Unfortunately that still doesn't work. This
is the app trace:
ThinkingSphinx::SphinxError
index assessment_core,assessment_delta: no such filter attribute
'relevant'
/opt/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.4.4/lib/
thinking_sphinx/search.rb:398:in `populate'
/opt/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.4.4/lib/
thinking_sphinx/search.rb:540:in `call'
/opt/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.4.4/lib/
thinking_sphinx/search.rb:540:in `retry_on_stale_index'
/opt/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.4.4/lib/
thinking_sphinx/search.rb:385:in `populate'
/opt/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.4.4/lib/
thinking_sphinx/search.rb:167:in `method_missing'
/my_app_path/lib/previous_assessments.rb:55:in
`show_student_previous_assessments'
And this is what I did:
with_relevant = "*, IF((school_year=#{@school_year} AND
assessment_semester=#{@semester}) OR is_collective_assessment=1, 1, 0)
AS relevant"
@assessments = Assessment.search @search,
:sphinx_select => with_relevant, :with => {'relevant' => 1},
:without => {:assessment_id => @id}, :page => params[:page],
:per_page => 20, :star => true, :match_mode => :boolean, :order =>
@order,
:sort_mode => @sort_order
As said before, this works on development but not on test...
Any clues?
Melissa
On Jun 4, 10:18 am, Pat Allan <[email protected]> wrote:
> Hi Melissa
>
> I think the first problem is that you're using the test environment for
> normal requests - when deltas and updates are disabled by default in the test
> environment (perhaps I'll change that at some point).
>
> To get around this, add the following to the bottom of config/environment.rb
> (outside the main block):
>
> ThinkingSphinx.deltas_enabled = true
> ThinkingSphinx.updates_enabled = true
>
> Generally though, I'd recommend using a different environment (just because
> of expectations of other libraries and Rails itself) for a test server -
> staging, perhaps?
>
> I'm not sure what's causing the second problem - but can you try the above
> change and then see if that fixes both issues? Also, can you provide a stack
> trace if the problem remains?
>
> Cheers
>
> --
> Pat
>
> On 03/06/2011, at 8:59 PM, melissa wrote:
>
>
>
>
>
>
>
> > Hi all,
>
> > I have (delayed) delta indexing running correctly on my development
> > server. Now that I've deployed my app to my test server it seems that
> > delayed delta indexing is running but not actually responding to any
> > changes. I haven't been able to find errors in log files.
>
> > I thought maybe path settings were a problem and tried to add the
> > following to my sphinx.yml, but I don't see them in the generated conf
> > file. Is this necessary?
> > test:
> > pid_file: /Users/username/app_path/tmp/searchd.pid
> > searchd_file_path: /Users/username/app_path/db/sphinx
>
> > Another, probably unrelated, problem is that :sphinx_select in
> > combination with :with is working on my development server but creates
> > an error on the test server. I have to turn delta indexing off to
> > actually see the error. What I'm doing something like this:
> >http://freelancing-god.github.com/ts/en/common_issues.html#or_attributes
> > with_relevant = "*, IF((school_year=#{@school_year} AND
> > assessment_semester=#{@semester}) OR is_collective_assessment=1, 1, 0)
> > AS relevant"
> > @assessments = Assessment.search @search, :sphinx_select =>
> > with_relevant, :with => {'relevant' => 1}, :without => {:assessment_id
> > => @id}, :page => params[:page], :per_page => 20, :star =>
> > true, :match_mode => :boolean, :order => @order, :sort_mode =>
> > @sort_order
>
> > The error I'm getting is a 'no such filter attribute'. It doesn't
> > recognise the name 'relevant' as something usable in the :with part of
> > the query. Anyone understand what is going on here?
>
> > I'm at a dead end with these issues. I've wanted to change from ferret
> > to sphinx because the ferret index gets corrupted several times a day
> > and causes me a lot of headache. I really need to get this to work.
>
> > My version of Sphinx 0.9.9 r2117 is the same on both servers, as are
> > the gem versions:
> > daemon_controller (0.2.6)
> > daemons (1.1.0, 1.0.10)
> > delayed_job (2.0.7)
> > riddle (1.3.3, 1.3.2, 1.2.2)
> > thinking_sphinx (1.4.4)
> > ts-delayed-delta (1.1.1)
>
> > The only difference as far as I can see:
> > My test server is a G5 PowerPC computer with OSX 10.5.8.
> > My development server is an intel machine.
>
> > Is it at all possible that my problems are hardware related? If so,
> > then I can put pressure on my employer to update the server hardware.
> > But more than anything I'm just hoping for any solutions or debugging
> > pointers...
>
> > Melissa
>
> > --
> > 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.
