Yeah, the delta indexing output looks fine - also, it's define_indexes, not
define_index, to ensure indices are loaded.
As for the fuzzy searching on production, can you confirm that the enable_star
and min_infix_len settings are set in the generated Sphinx configuration file?
And :star should be true, not 1, though I'd be surprised if that changed
anything (1 is still true-ish).
--
Pat
On 10/01/2012, at 2:22 PM, maximulus wrote:
> I am using script/console production and then
>
> Item.define_index && Item.index_delta; 'lentils'
>
> I get this:
>
> using config file
> '/home/webuser/rails_apps/project/current/config/
> production.sphinx.conf'...
> indexing index 'item_delta'...
> collected 0 docs, 0.0 MB
> collected 0 attr values
> sorted 0.0 Mvalues, nan% done
> total 0 docs, 0 bytes
> total 0.006 sec, 0 bytes/sec, 0.00 docs/sec
> total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
> total 4 writes, 0.000 sec, 0.1 kb/call avg, 0.0 msec/call avg
> rotating indices: succesfully sent SIGHUP to searchd (pid=3462).
> => "lentils"
>
> I have to be honest, I think that is what I should get but I am not
> certain.
>
> However, when I do the test for fuzzy, I DO get all the
> results I should on the test with
> Item.search('pistachio', :star => 1) from console.
>
> Here is my query from the controller
>
> @items = Item.search params[:search], :conditions=>
> {:active=>1, :star=>1,
> :field_weights => {:itemname => 20, :description => 10}
> }, :page=>params[:page], :per_page=>10
>
> Do you see anything here? Is the 'star' not reading as 1 perhaps?
>
> Thanks for all your help. I am running out of ideas.
>
> Ari
>
>
> On Jan 9, 7:24 pm, "Pat Allan" <[email protected]> wrote:
>> Hmm, nothing out of the ordinary there. How are you testing fuzzy searching?
>> And deltas?
>>
>> --
>> Pat
>>
>> On 10/01/2012, at 12:41 AM, maximulus wrote:
>>
>>
>>
>>
>>
>>
>>
>>> Sure thanks Pat.
>>
>>> Just to update, I did a full reinstall of sphinx and thinking sphinx,
>>> as I had originally installed sphinx with the yum package manager,
>>> which installed sphinx from root and then I manually changed the
>>> ownership. I reinstalled from source (using wget) through the web
>>> user, which is why searched is now in /usr/local/bin' as oppose to usr/
>>> bin in the original question.
>>
>>> Was shocked to find I still have the same problem.
>>
>>> Here is what is in the sphinx.yml file
>>> production:
>>> port: 3312
>>> bin_path: '/usr/local/bin'
>>> address: 127.0.0.1
>>> mem_limit: 512M
>>> max_children: 300
>>> max_matches: 100000
>>> seamless_rotate: 1
>>> preopen_indexes: 1
>>> enable_star: true
>>> morphology: stem_en
>>> min_infix_len: 3
>>> query_log_file: "/home/webuser/rails_apps/project/current/log/
>>> searchd.query.log"
>>> searchd_log_file: "/home/webuser/rails_apps/project/current/log/
>>> searchd.log"
>>> pid_file: "/home/webuser/rails_apps/project/shared/pids"
>>> searchd_file_path: "/home/webuser/rails_apps/project/current/db/
>>> sphinx"
>>
>>> On Jan 9, 6:24 am, "Pat Allan" <[email protected]> wrote:
>>>> Can you share the contents of your config/sphinx.yml file?
>>
>>>> --
>>>> Pat
>>
>>>> On 08/01/2012, at 11:37 AM, maximulus wrote:
>>
>>>>> Hello,
>>
>>>>> I am using Rails 2.3.12
>>
>>>>> All settings are the same for development and production server except
>>>>> the os: Leopard/Centos and WEBBrick/Nginx-Passenger
>>
>>>>> I am using thinking-sphinx-0.9.9 gem version 1.3.2
>>
>>>>> I am using sphinx 0.9.9 R2117
>>
>>>>> Permissions to web user have been granted to all thinking sphinx files
>>>>> and searchd.
>>>>> I Rake with RAILS_ENV=production in production mode, that is the only
>>>>> difference I can find.
>>>>> Path is set to where searchd is, in usr/bin.
>>>>> I can see no errors in the production.log, or the nginx error log.
>>
>>>>> I am in fact using the same database, so when I make a change to say,
>>>>> an item name, it works in development but not production. Also fuzzy
>>>>> search works only in development. Rake ts:index works fine in both.
>>
>>>>> Are there any other tests I can run, or have I overlooked anything?
>>
>>>>> Thank you in advance,
>>>>> Max
>>
>>>>> --
>>>>> 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
>>> 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.
>
--
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.
