Plugin "redmine_xapian". Error: Can't open Xapian database
Added by Yury Muravev over 7 years ago
Good afternoon. Install the plugin according to the instructions. Searching get an error:
Can't open Xapian database - #<IOError: DatabaseOpeningError: Couldn't stat '/var/tmp/omindex/russian'> Can't open Xapian database - #<IOError: DatabaseOpeningError: Couldn't stat '/var/tmp/omindex/repodb'>
Files exist
root@debian:/var/tmp# ls -la | grep omindex drwxr-xr-x 5 nobody nogroup 4096 ноя 12 15:59 omindex root@debian:/var/tmp/omindex# ls -la drwxrwxr-x 5 nobody nogroup 4096 ноя 12 14:04 . drwxrwxrwt 5 root root 4096 ноя 12 15:43 .. drwxrwxr-x 2 nobody nogroup 4096 ноя 12 11:00 english drwxrwxr-x 2 nobody nogroup 4096 ноя 12 14:04 repodb drwxrwxr-x 2 nobody nogroup 4096 ноя 12 14:36 russian
In redmine plugins:
"Enable xapian engine to allow searches on attachments and repositories" - chosen "Directory containing Xapian databases" = /var/tmp/omindex "Set the stemming language..." = russian
About Redmine:
root@debian:/var/www/redmine/bin# ./about sh: 1: darcs: not found sh: 1: hg: not found sh: 1: cvs: not found sh: 1: bzr: not found Environment: Redmine version 3.2.4.stable.15949 Ruby version 2.2.5-p319 (2016-04-26) [x86_64-linux] Rails version 4.2.7.1 Environment production Database adapter Mysql2 SCM: Subversion 1.8.10 Git 2.1.4 Filesystem Redmine plugins: a_common_libs 2.1.10 redmine_ldap_sync 2.0.8.devel.gf831737c23-dirty redmine_xapian 1.6.6
Started GET "/search?utf8=%E2%9C%93&q=7474" for 192.168.0.32 at 2016-11-12 16:30:57 +0300
Processing by SearchController#index as HTML
Parameters: {"utf8"=>"✓", "q"=>"7474"}
^[[1m^[[36mSQL (1.9ms)^[[0m ^[[1mUPDATE `tokens` SET `tokens`.`updated_on` = '2016-11-12 16:30:57' WHERE `tokens`.`user_id` = 1 AND `tokens`.`value` = '305d6afe32e04f14f4360de8c41eb5be8044602d' $
^[[1m^[[35m (0.1ms)^[[0m SELECT MAX(`settings`.`updated_on`) FROM `settings`
^[[1m^[[36mUser Load (0.2ms)^[[0m ^[[1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND `users`.`id` = 1 LIMIT 1^[[0m
Current user: admin (id=1)
^[[1m^[[35mSetting Load (0.1ms)^[[0m SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'plugin_redmine_xapian' ORDER BY `settings`.`id` DESC LIMIT 1
^[[1m^[[36mIssue Load (0.2ms)^[[0m ^[[1mSELECT `issues`.* FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (projects.status <> 9 AND projects.id IN (SELECT e$
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (projects.status <> 9 AND proje$
^[[1m^[[36mCustomField Load (0.1ms)^[[0m ^[[1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'IssueCustomField' AND `custom_fields`.`searchable` = 1^[[0m
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `journals` ON `journals`.`$
^[[1m^[[36m (0.2ms)^[[0m ^[[1mSELECT DISTINCT `news`.`created_on`, `news`.`id` FROM `news` INNER JOIN `projects` ON `projects`.`id` = `news`.`project_id` WHERE (projects.status <> 9 AND projects$
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `documents`.`created_on`, `documents`.`id` FROM `documents` INNER JOIN `projects` ON `projects`.`id` = `documents`.`project_id` WHERE (projects.status <>$
^[[1m^[[36mCustomField Load (0.1ms)^[[0m ^[[1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'DocumentCustomField' AND `custom_fields`.`searchable` = 1^[[0m
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `changesets`.`committed_on`, `changesets`.`id` FROM `changesets` INNER JOIN `repositories` ON `repositories`.`id` = `changesets`.`repository_id` INNER JO$
^[[1m^[[36m (0.1ms)^[[0m ^[[1mSELECT DISTINCT `wiki_pages`.`created_on`, `wiki_pages`.`id` FROM `wiki_pages` INNER JOIN `wiki_contents` ON `wiki_contents`.`page_id` = `wiki_pages`.`id` INNER JOI$
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `messages`.`created_on`, `messages`.`id` FROM `messages` INNER JOIN `boards` ON `boards`.`id` = `messages`.`board_id` INNER JOIN `projects` ON `projects`$
^[[1m^[[36m (0.1ms)^[[0m ^[[1mSELECT DISTINCT `projects`.`created_on`, `projects`.`id` FROM `projects` WHERE (projects.status <> 9) AND (((name LIKE '%7474%') OR (identifier LIKE '%7474%') OR (d$
^[[1m^[[35mCustomField Load (0.1ms)^[[0m SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'ProjectCustomField' AND `custom_fields`.`searchable` = 1
Attachment::search
^[[1m^[[36m (0.1ms)^[[0m ^[[1mSELECT DISTINCT `attachments`.`created_on`, `attachments`.`id` FROM `attachments` JOIN issues ON attachments.container_id = issues.id JOIN projects ON issues.projec$
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `attachments`.`created_on`, `attachments`.`id` FROM `attachments` JOIN messages ON attachments.container_id = messages.id JOIN boards ON boards.id = mess$
^[[1m^[[36m (0.1ms)^[[0m ^[[1mSELECT DISTINCT `attachments`.`created_on`, `attachments`.`id` FROM `attachments` JOIN wiki_pages ON attachments.container_id = wiki_pages.id JOIN wikis ON wikis.id$
^[[1m^[[35m (0.1ms)^[[0m SELECT DISTINCT `attachments`.`created_on`, `attachments`.`id` FROM `attachments` JOIN projects ON projects.id = container_id WHERE (container_type = 'Project' AND proje$
Call xapian search service for Attachment
XapianSearch::search
XapianSearch::xapian_search
Global settings dump {"enable"=>"true", "index_database"=>"/var/tmp/omindex", "stemming_lang"=>"russian", "stem_langs"=>["danish", "dutch", "english", "finnish", "french", "german", "german2", "hun$
stemming_lang: russian
stemming_strategy: STEM_NONE
databasepath: /var/tmp/omindex/russian
Can't open Xapian database - #<IOError: DatabaseOpeningError: Couldn't stat '/var/tmp/omindex/russian'>
Call xapian search service for Attachment completed
Repository::search
Call xapian search service for "Repofile"
XapianSearch::search
XapianSearch::xapian_search
Global settings dump {"enable"=>"true", "index_database"=>"/var/tmp/omindex", "stemming_lang"=>"russian", "stem_langs"=>["danish", "dutch", "english", "finnish", "french", "german", "german2", "hun$
stemming_lang: russian
stemming_strategy: STEM_NONE
databasepath: /var/tmp/omindex/repodb
Can't open Xapian database - #<IOError: DatabaseOpeningError: Couldn't stat '/var/tmp/omindex/repodb'>
Call xapian search service for "Repofile" completed
^[[1m^[[36mSetting Load (0.3ms)^[[0m ^[[1mSELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'search_results_per_page' ORDER BY `settings`.`id` DESC LIMIT 1^[[0m
^[[1m^[[35mMember Exists (0.2ms)^[[0m SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 1 AND (projects.status<>9) LIM$
Rendered plugins/redmine_xapian/app/views/search/index.html.erb within layouts/base (10.6ms)
^[[1m^[[36mUserPreference Load (0.2ms)^[[0m ^[[1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 1 LIMIT 1^[[0m
Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_html_head.html.erb (1.2ms)
^[[1m^[[35mProject Load (0.2ms)^[[0m SELECT `projects`.`id`, `projects`.`name`, `projects`.`identifier`, `projects`.`lft`, `projects`.`rgt` FROM `projects` INNER JOIN `members` ON `projects`.`id$
Completed 200 OK in 110ms (Views: 28.5ms | ActiveRecord: 9.4ms)
Where did I go wrong? What should be corrected?
PS:
Linux debian 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u2 (2016-10-19) x86_64 GNU/Linux
nginx & Redmine were installed according to the instruction https://www.howtoforge.com/tutorial/how-to-install-redmine-with-nginx-on-ubuntu/