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] 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]. > 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.
