OK. Now we are nearly there... the index generation worked without errors.
But searching is still not working...
In a Rails console I did:
pry(main)> Image.search "sphinx"
[]
pry(main)> ThinkingSphinx.search 'sphinx'
[]
But when I connect with mysql directly to Sphinx I get three results:
mysql> select * from image_core where match('sphinx');
+------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+------------+------------+-----------------------+
| id | weight | sphinx_internal_id | sphinx_deleted | aspect_ratio |
chromaticity | origin | image_type | licencetype | client_id | user_id |
created_at | updated_at | sphinx_internal_class |
+------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+------------+------------+-----------------------+
| 3390 | 1692 | 1695 | 0 | 2410462618 |
3828862733 | 3 | 151 | 0 | 24 | 114367 |
1354014113 | 1358164002 | Image |
| 3392 | 1692 | 1696 | 0 | 67325096 |
3828862733 | 3 | 146 | 0 | 24 | 114367 |
1354014121 | 1358164220 | Image |
| 3394 | 1692 | 1697 | 0 | 67325096 |
3828862733 | 3 | 140 | 0 | 24 | 114367 |
1354014126 | 1358164297 | Image |
+------+--------+--------------------+----------------+--------------+--------------+--------+------------+-------------+-----------+---------+------------+------------+-----------------------+
3 rows in set (0.01 sec)
I get the expected results...
I do not have any entries in Rails development.log concerning sphinx...
In development.searchd.query.log I have one entry:
Tue Jan 15 14:53:18.559 2013] 0.004 sec [ext2/0/ext 3 (0,20)] [image_core]
sphinx
What do you think?
Govinda
Am Dienstag, 15. Januar 2013 14:23:04 UTC+1 schrieb Pat Allan:
>
> It's actually complaining that it can't connect to Sphinx - you need to
> run ts:start after ts:configure, and *then* ts:generate, as Thinking Sphinx
> talks to the daemon to load up the data.
>
> And sorry, I wasn't clear with that comment about the logs. I meant the
> Rails logs.
>
> Cheers
>
> --
> Pat
>
> On 16/01/2013, at 12:20 AM, [email protected] <javascript:>wrote:
>
> > What do you mean by logs... the rails logs, sphinx logs or mysql logs...
> ?
> >
> > After adjusting my index definition according to your recent replies ...
> I did a
> >
> > rake ts:configure
> >
> > which went fine
> >
> > and then a
> >
> > rake ts:generate --trace
> [8s]
> > ** Invoke ts:generate (first_time)
> > ** Invoke environment (first_time)
> > ** Execute environment
> > ** Execute ts:generate
> > Generating index files for image_core
> > rake aborted!
> > Can't connect to MySQL server on '127.0.0.1' (61)
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/mysql2-0.3.11/lib/mysql2/client.rb:44:in
>
> `connect'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/mysql2-0.3.11/lib/mysql2/client.rb:44:in
>
> `initialize'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:35:in
>
> `new'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:35:in
>
> `initialize'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:14:in
>
> `new'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:14:in
>
> `new'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/connection.rb:26:in
>
> `block in pool'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/innertube-1.0.2/lib/innertube.rb:120:in
>
> `call'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/innertube-1.0.2/lib/innertube.rb:120:in
>
> `block in take'
> > <internal:prelude>:10:in `synchronize'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/innertube-1.0.2/lib/innertube.rb:116:in
>
> `take'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/real_time/transcriber.rb:16:in
>
> `copy'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:21:in
>
> `block (2 levels) in generate'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:21:in
>
> `block (2 levels) in find_each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:21:in
>
> `each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:21:in
>
> `block in find_each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:72:in
>
> `find_in_batches'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/relation/batches.rb:20:in
>
> `find_each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/global/gems/activerecord-3.2.9/lib/active_record/querying.rb:8:in
>
> `find_each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:20:in
>
> `block in generate'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:13:in
>
> `each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/rake_interface.rb:13:in
>
> `generate'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bundler/gems/thinking-sphinx-0098973687d0/lib/thinking_sphinx/tasks.rb:14:in
>
> `block (2 levels) in <top (required)>'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:228:in
>
> `call'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:228:in
>
> `block in execute'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:223:in
>
> `each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:223:in
>
> `execute'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:166:in
>
> `block in invoke_with_call_chain'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/lib/ruby/1.9.1/monitor.rb:211:in
>
> `mon_synchronize'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:159:in
>
> `invoke_with_call_chain'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/task.rb:152:in
>
> `invoke'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:143:in
>
> `invoke_task'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:101:in
>
> `block (2 levels) in top_level'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:101:in
>
> `each'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:101:in
>
> `block in top_level'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:110:in
>
> `run_with_threads'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:95:in
>
> `top_level'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:73:in
>
> `block in run'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:160:in
>
> `standard_exception_handling'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/lib/rake/application.rb:70:in
>
> `run'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/gems/rake-10.0.3/bin/rake:33:in
>
> `<top (required)>'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bin/rake:23:in
>
> `load'
> >
> /Users/govindafichtner/.rbenv/versions/1.9.3-p194-perf/gemsets/imageserver/bin/rake:23:in
>
> `<main>'
> > Tasks: TOP => ts:generate
> >
> >
> > This is a little weird because I can connect to the database with rails
> and also with the mysql command line just fine...
> >
> > Govinda
> >
> >
> >
> > Am Dienstag, 15. Januar 2013 00:40:52 UTC+1 schrieb Pat Allan:
> > This one's a little more surprising… you should see the full SphinxQL
> command in your logs when Image.search is called - can you confirm what
> that is, and whether you see results using it directly via mysql?
> > --
> > Pat
> >
> > On 15/01/2013, at 12:15 AM, [email protected] wrote:
> >
> > > OK. And the next problem I have when I generate a realtime index with
> only the attributes that I got working until now is
> > > that searching seems not work at all for me:
> > >
> > > [13] pry(main)> Image.search('sphinx')
> > > []
> > >
> > > But when I am connecting directly to sphinx via mysql:
> > >
> > > mysql> select * from image_core where match('sphinx');
> > >
> +------+--------+--------------------+----------------+--------+-----------------------+
> > > | id | weight | sphinx_internal_id | sphinx_deleted | origin |
> sphinx_internal_class |
> > >
> +------+--------+--------------------+----------------+--------+-----------------------+
> > > | 3390 | 1692 | 1695 | 0 | 3 | Image
> |
> > > | 3392 | 1692 | 1696 | 0 | 3 | Image
> |
> > > | 3394 | 1692 | 1697 | 0 | 3 | Image
> |
> > >
> +------+--------+--------------------+----------------+--------+-----------------------+
> > > 3 rows in set (0.00 sec)
> > >
> > > I am a little lost what I might be doing wrong...
> > >
> > > Govinda
> > >
> > >
> > >
> > > Am Montag, 14. Januar 2013 12:15:52 UTC+1 schrieb
> [email protected]:
> > > Hello guys,
> > >
> > > after the announcement here
> https://github.com/pat/thinking-sphinx/issues/186 that there is some
> support for realtime indexes I gave it shot and tried to port my existing
> (and working) thinking_sphinx v2 indexes and tried to port them to the new
> v3 syntax...
> > >
> > > ThinkingSphinx::Index.define :image, :with => :real_time do
> > > # indexes assoc(:file)
> > > indexes file_width
> > > indexes file_height
> > > indexes file_colorspace
> > > indexes file_content_type, :as => :file_type
> > > indexes file_resolution
> > > indexes file_depth
> > > indexes description
> > > indexes category
> > > indexes tags
> > > indexes campaigns
> > > indexes image_type.name, :as => :image_type_name
> > > # has "CRC32(file_chromaticity)", :as => :chromaticity, :type =>
> :integer
> > > # has "CRC32(file_aspect_ratio)", :as => :aspect_ratio, :type =>
> :integer
> > > has image_origin_id, :as => :origin
> > > # has image_licencetype_id, :as => :licencetype
> > > # has image_type_id, :as => :image_type
> > > # has client_id
> > > # has user_id
> > > # has created_at
> > > # has updated_at
> > > # has status
> > > end
> > >
> > > When I do a "rake ts:generate" I get the following error:
> > >
> > > rake aborted!
> > > Unknown attribute type ''
> > >
> > > Does anybody know how I have to change my indexes to get them to play
> nicely with sphinx3?
> > > I am using the edge branch with Rails 3.2.9, Ruby 1.9.3 and sphinx
> 2.0.6.
> > >
> > > Cheers, Govinda
> > >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups "Thinking Sphinx" group.
> > > To view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/EK7lcZXrOMIJ.
> > > 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 view this discussion on the web visit
> https://groups.google.com/d/msg/thinking-sphinx/-/7-gJ17EdG-gJ.
> > To post to this group, send email to
> > [email protected]<javascript:>
> .
> > To unsubscribe from this group, send email to
> [email protected] <javascript:>.
> > 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 view this discussion on the web visit
https://groups.google.com/d/msg/thinking-sphinx/-/h_lZ9cIn7J8J.
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.
