Ferret - mysql server has gone away


#1

I’ve problem with ferret (acts_as_ferret). search-engine and webserver
are on the same machine. I use acts_as_ferret :field => … to define
which columns are indexed. I recreate the index with
Search.rebuild_index (Search is my model).

To find some results, I use Search.find_with_ferret(“keyword”, {}, {}).
Sometimes, I merge conditions to this query in the last hash. I create
an index over 7’000 records.

For a while, the search is run correctly. Suddently, after perhaps 10
requests, I receive the error message below and the search doesn’t run
anymore. I don’t use any Drb-Server.

Has someone a solution for this problem??? Thanks for helping!

ActiveRecord::StatementInvalid: Mysql::Error: MySQL server has gone
away: SELECT * FROM searches WHERE (searches.id in
(‘266582’,‘261710’,‘261788’,‘266607’,‘262659’,‘258206’,‘261781’,‘258207’,‘261783’,‘262124’))
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:147:in
log' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/mysql_adapter.rb:299:inexecute’
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/mysql_adapter.rb:515:in
select' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:7:inselect_all_without_query_cache’
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in
select_all' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:582:infind_by_sql’
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:1341:in
find_every' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:536:infind’
from
/home/schwinge/ruby/gems/gems/acts_as_ferret-0.4.3/lib/class_methods.rb:384:in
retrieve_records' from /home/schwinge/ruby/gems/gems/acts_as_ferret-0.4.3/lib/class_methods.rb:360:ineach’
from
/home/schwinge/ruby/gems/gems/acts_as_ferret-0.4.3/lib/class_methods.rb:360:in
retrieve_records' from /home/schwinge/ruby/gems/gems/acts_as_ferret-0.4.3/lib/class_methods.rb:300:inar_find_by_contents’
from
/home/schwinge/ruby/gems/gems/acts_as_ferret-0.4.3/lib/class_methods.rb:288:in
find_records_lazy_or_not' from /home/schwinge/ruby/gems/gems/acts_as_ferret-0.4.3/lib/class_methods.rb:185:infind_with_ferret’
from (irb):19