Deltas on production with passenger not working - Tried everything.

[mrmanishs]

Yesterday, for the first time, I tried getting delta working on
production with no luck.

I have passenger, and tried the two items on the thinking-sphinx site
<correct permissions and setting bin_path>, and still no luck. Also,
tried changing cache_classes=false for production and still no luck.
Anyone have any other suggestions?

It indexes fine with no errors if I do it from console.

Manish

[Pat Allan]

Are you seeing any output in production.log when you make a request
that should fire a delta index? What versions of Rails and TS are you
using?

--
Pat

[mrmanishs]

Hey Pat,

No output in the production.log.

Rails version 2.3.3.
Thinking Sphinx v1.2.11

Manish

[Pat Allan]

Hmm.

What is the action doing that's updating? Is it updating columns that
are used for fields, or attributes? Best approach is to change columns
used for fields, because that will always fire off the delta index (if
it's working, anyway).

Also, what delta approach are you using?

--
Pat

[mrmanishs]

Pat,

Just a simple save and the columns update are attributes.

I'm just using the plain assigning a delta column to the database and
then index on action. (I think that's what you're asking?)

Manish

[Pat Allan]

Hi Manish

Try updating a column that's used by a field instead - although going
by another thread, seems you're not the only person having this problem.

Have you tried running it in production mode on your dev machine?

--
Pat

[Tim]

Hi Pat,

I'm also having the same problem on my production machine. I'm using
the delta => true version with the following:

Rails 2.3.2
Thinking Sphinx v1.2.11
ruby 1.8.6 (2007-09-23 patchlevel 110)

On my development machine in production it works fine using the same
software except ruby 1.8.7. On this machine I notice the timestamps
for the delta files update when a record is updated, but on the
production machine the timestamps are not updated (except for the
creation of .spl files). The sphinx files are stored in <railsapp>/db/
sphinx/production on both machines and permissions seem to be OK.

[Pat Allan]

Hi Tim

What are you using as a server on your production machine? Nginx/
Passenger, Apache/Passenger, Mongrel? (This is purely to help further
debugging).

--
Pat

[Pat Allan]

Hi Tim

What are you using as a server on your production machine? Nginx/
Passenger, Apache/Passenger, Mongrel? (This is purely to help further
debugging).

--
Pat

On 30/09/2009, at 10:48 AM, Tim wrote:

>

[Tim]

Hi Pat,

It's Apache 2.0.52 and passenger 2.2.2.

Development machine in mongrel.

[Tim]

Sorry, it's passenger 2.0.2

[Tim]

FWIT, dropping into script/console on the production machine in
production ENV does trigger the delta update when changing a record.

[Tim]

Okey dokey. It's apache not being privy to the Sphinx installation:

/opt/ruby-1.8.6/lib/ruby/gems/1.8/gems/activesupport-2.3.2/lib/
active_support/callbacks.rb:180: command not found: indexer

Is there a config option to set the path to sphinx?


(Sorry to hijack the thread, this might be a different problem to what
Manish is experiencing)

[Pat Allan]

Yup, have a look at the last item on this page:
http://freelancing-god.github.com/ts/en/common_issues.html

No worries about hijacking the thread, Manish's problem was different
- Nginx doesn't show output in production.log, but in it's own error
log instead.

--
Pat

[Tim]

Beautiful. Was that there before? How embarrassment.

That works great but I have to restart apache for the change to take
effect.

Also, the error I posted before was in the apache error_log, not in
any of the rails logs. You might want to mention that on your site?

Cheers mate

[Pat Allan]

On 01/10/2009, at 11:09 AM, Tim wrote:

> Beautiful. Was that there before? How embarrassment.

Yeah, it's been there a little while ;)

> That works great but I have to restart apache for the change to take
> effect.
>
> Also, the error I posted before was in the apache error_log, not in
> any of the rails logs. You might want to mention that on your site?

Ah, that's definitely useful - thanks for the tip.

Cheers

--
Pat

[mrmanishs]

No worries... just to put closure on the thread, the issue I had was
that passenger was spawning processes as "nobody" and "nobody" did not
have access to the sphinx commands, which is a different user. The way
to fix that is set nginx.conf passenger config as following, under the
passenger_root and passenger_ruby settings:

passenger_root /usr/local/ruby-enterprise-1.8.6-20090610/lib/ruby/
gems/1.8/gems/passenger-2.2.4;
passenger_ruby /usr/local/ruby-enterprise-1.8.6-20090610/bin/ruby;
passenger_user_switching off;
passenger_default_user <your default user to spawn off rails
processes>;


Manish