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] <javascript:>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]<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/-/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.
