Digitale Infrastruktur

Steps¶

What steps did you followed?

1. Opened http://projects.piratenpartei.ch/knowledgebase/categories/5
2. Entered "ca" in the Search Box
3. Pressed Enter

Observation¶

What has happened?

• An error message appeared (see below).

ActiveRecord::StatementInvalid in SearchController#index

Mysql::Error: Incorrect key file for table '/tmp/#sql_5236_0.MYI'; try to repair it: SELECT `wiki_pages`.`id` AS t0_r0, `wiki_pages`.`wiki_id` AS t0_r1, `wiki_pages`.`title` AS t0_r2, `wiki_pages`.`created_on` AS t0_r3, `wiki_pages`.`protected` AS t0_r4, `wiki_pages`.`parent_id` AS t0_r5, `wikis`.`id` AS t1_r0, `wikis`.`project_id` AS t1_r1, `wikis`.`start_page` AS t1_r2, `wikis`.`status` AS t1_r3, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11, `projects`.`dmsf_description` AS t2_r12, `wiki_contents`.`id` AS t3_r0, `wiki_contents`.`page_id` AS t3_r1, `wiki_contents`.`author_id` AS t3_r2, `wiki_contents`.`text` AS t3_r3, `wiki_contents`.`comments` AS t3_r4, `wiki_contents`.`updated_on` AS t3_r5, `wiki_contents`.`version` AS t3_r6 FROM `wiki_pages`  LEFT OUTER JOIN `wikis` ON `wikis`.id = `wiki_pages`.wiki_id  LEFT OUTER JOIN `projects` ON `projects`.id = `wikis`.project_id  LEFT OUTER JOIN `wiki_contents` ON wiki_contents.page_id = wiki_pages.id WHERE ((((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (projects.id IN (34) OR projects.is_public = 1 OR projects.id IN (25) OR projects.id IN (41,93,57,47)))) AND (((LOWER(title) LIKE '%ca%') OR (LOWER(wiki_contents.text) LIKE '%ca%'))))  ORDER BY wiki_pages.created_on DESC LIMIT 11
RAILS_ROOT: /srv/www/redmine

Application Trace | Framework Trace | Full Trace
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/mysql_adapter.rb:639:in `select'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/associations.rb:1622:in `select_all_rows'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/associations.rb:1401:in `find_with_associations'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/associations.rb:1399:in `catch'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/associations.rb:1399:in `find_with_associations'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/base.rb:1580:in `find_every'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/base.rb:619:in `find'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/base.rb:2182:in `with_scope'
/var/lib/gems/1.8/gems/activerecord-2.3.11/lib/active_record/base.rb:2182:in `with_scope'
/srv/www/redmine/app/controllers/search_controller.rb:77:in `index'
/srv/www/redmine/app/controllers/search_controller.rb:76:in `each'
/srv/www/redmine/app/controllers/search_controller.rb:76:in `index'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/base.rb:1333:in `send'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/base.rb:1333:in `perform_action_without_filters'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/filters.rb:617:in `call_filters'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/var/lib/gems/1.8/gems/activesupport-2.3.11/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/var/lib/gems/1.8/gems/activesupport-2.3.11/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/flash.rb:151:in `perform_action'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/base.rb:532:in `send'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/base.rb:532:in `process_without_filters'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/filters.rb:606:in `process'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/base.rb:391:in `process'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/base.rb:386:in `call'
/var/lib/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/routing/route_set.rb:438:in `call'
Request

Parameters:

{"q"=>"ca"}
Show session dump

Response

Headers:

{"Content-Type"=>"",
 "Cache-Control"=>"no-cache"}