Hey guys...I've gotten sphinx running on my app Cashboard, but it's
being weird in development mode on some accounts.
When I'm logged into a certain account in particular and search for
'invoice' it's giving me:
INTERNAL ERROR: incoming-schema mismatch (in=ordinal client_name:
32@192, my=ordinal client_name:32@0)
This happens when I try to access @results, which is being setup like
so:
@results = ThinkingSphinx.search(
params[:q],
:page => params[:page],
:with => {
:account_id => @account.id
},
# order by classes...
:order => 'model_order ASC, @relevance DESC',
:enable_star => 1
)
I've rebuilt my indexes but that doesn't have any effect.
I'm at a loss here...can anyone help me?
I do have a model called "Invoice", which has the following index
defined:
# THINKING SPHINX INDEX
define_index do
indexes :assigned_id, :sortable => true
indexes :notes
indexes client(:name), :as => :client_name
has :account_id, :due_date, :created_on, :has_been_paid
has '6', :as => :model_order, :type => :integer
set_property :delta => true
end
The thing is, if I search 'invoice' from another account it works just
fine. Anyone know what might be going on here?
REBUILD OUTPUT:
$ rake ts:rebuild
(in /Users/seth/Work/cashboard/site/trunk)
DEPRECATION WARNING: Rake tasks in vendor/plugins/ar_fixtures/tasks,
vendor/plugins/dhtml_calendar/tasks, vendor/plugins/fetcher/tasks,
vendor/plugins/harsh/tasks, and vendor/plugins/thinking-sphinx/tasks
are deprecated. Use lib/tasks instead. (called from /Users/seth/Work/
cashboard/site/trunk/vendor/rails/railties/lib/tasks/rails.rb:10)
Generating Configuration to /Users/seth/Work/cashboard/site/trunk/
config/development.sphinx.conf
Sphinx 1.10-beta (r2420)
Copyright (c) 2001-2010, Andrew Aksyonoff
Copyright (c) 2008-2010, Sphinx Technologies Inc (http://
sphinxsearch.com)
using config file '/Users/seth/Work/cashboard/site/trunk/config/
development.sphinx.conf'...
indexing index 'company_core'...
collected 45897 docs, 0.8 MB
sorted 0.6 Mhits, 100.0% done
total 45897 docs, 795629 bytes
total 1.661 sec, 478798 bytes/sec, 27620.16 docs/sec
indexing index 'company_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.072 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'company'...
indexing index 'estimate_core'...
collected 24150 docs, 30.6 MB
sorted 20.9 Mhits, 100.0% done
total 24150 docs, 30595697 bytes
total 14.540 sec, 2104173 bytes/sec, 1660.88 docs/sec
indexing index 'estimate_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.233 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'estimate'...
indexing index 'expense_core'...
collected 19815 docs, 0.7 MB
sorted 0.5 Mhits, 100.0% done
total 19815 docs, 713271 bytes
total 0.403 sec, 1766169 bytes/sec, 49065.00 docs/sec
indexing index 'expense_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.043 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'expense'...
indexing index 'invoice_core'...
collected 110827 docs, 4.7 MB
sorted 3.4 Mhits, 100.0% done
total 110827 docs, 4669671 bytes
total 10.365 sec, 450485 bytes/sec, 10691.53 docs/sec
indexing index 'invoice_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.104 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'invoice'...
indexing index 'invoice_schedule_core'...
collected 1755 docs, 0.0 MB
sorted 0.0 Mhits, 100.0% done
total 1755 docs, 11926 bytes
total 0.107 sec, 111422 bytes/sec, 16396.65 docs/sec
indexing index 'invoice_schedule_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.045 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'invoice_schedule'...
indexing index 'payment_core'...
collected 66265 docs, 2.1 MB
sorted 1.6 Mhits, 100.0% done
total 66265 docs, 2117191 bytes
total 2.419 sec, 875167 bytes/sec, 27391.46 docs/sec
indexing index 'payment_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.068 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'payment'...
indexing index 'person_core'...
collected 44230 docs, 2.2 MB
collected 45313 attr values
sorted 0.1 Mvalues, 100.0% done
sorted 1.7 Mhits, 100.0% done
total 44230 docs, 2159248 bytes
total 3.526 sec, 612246 bytes/sec, 12541.24 docs/sec
indexing index 'person_delta'...
collected 0 docs, 0.0 MB
collected 0 attr values
sorted 0.0 Mvalues, 100.0% done
total 0 docs, 0 bytes
total 0.065 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'person'...
indexing index 'project_core'...
collected 43838 docs, 1.5 MB
sorted 1.2 Mhits, 100.0% done
total 43838 docs, 1544174 bytes
total 2.024 sec, 762730 bytes/sec, 21653.38 docs/sec
indexing index 'project_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.049 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'project'...
indexing index 'time_entry_core'...
collected 988024 docs, 36.1 MB
sorted 25.2 Mhits, 100.0% done
total 988024 docs, 36117240 bytes
total 21.464 sec, 1682611 bytes/sec, 46029.56 docs/sec
indexing index 'time_entry_delta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.931 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'time_entry'...
total 133862 reads, 0.960 sec, 2.2 kb/call avg, 0.0 msec/call avg
total 664 writes, 4.429 sec, 885.5 kb/call avg, 6.6 msec/call avg
Started successfully (pid 14725).
--
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.
