search

clear-code / redmine_full_text_search

Full text search for Redmine
MIT License
61 stars 24 forks source link

undefined method `[]' for nil:NilClass /opt/redmine/plugins/full_text_search/db/migrate/20190603061606_create_fts_targets.rb:12:in `change' #78

Closed minzak closed 4 years ago

minzak commented 4 years ago

I have latest redmine 4.1 and: Version: '10.3.18-MariaDB-0+deb10u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10 

ruby 2.6.5p114 (2019-10-01 revision 67812) [x86_64-linux]
gem 3.0.3
Rails 5.2.4.1

Can't migrate, got error:

bundle exec rake redmine:plugins:migrate RAILS_ENV=production --trace
** Invoke redmine:plugins:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute redmine:plugins:migrate
== 20190603061606 CreateFtsTargets: migrating =================================
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

undefined method `[]' for nil:NilClass
/opt/redmine/plugins/full_text_search/db/migrate/20190603061606_create_fts_targets.rb:12:in `change'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:814:in `exec_migration'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:797:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:796:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:977:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `migrate'
/opt/redmine/lib/redmine/plugin.rb:510:in `up'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1011:in `migrate'
/opt/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/opt/redmine/lib/redmine/plugin.rb:483:in `migrate'
/opt/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/opt/redmine/lib/redmine/plugin.rb:496:in `each'
/opt/redmine/lib/redmine/plugin.rb:496:in `migrate'
/opt/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:199:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:188:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:160:in `invoke_task'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:125:in `run_with_threads'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:110:in `top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:83:in `block in run'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:80:in `run'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
/usr/local/bin/rake:23:in `load'
/usr/local/bin/rake:23:in `<top (required)>'
/usr/local/lib/ruby/2.6.0/bundler/cli/exec.rb:74:in `load'
/usr/local/lib/ruby/2.6.0/bundler/cli/exec.rb:74:in `kernel_load'
/usr/local/lib/ruby/2.6.0/bundler/cli/exec.rb:28:in `run'
/usr/local/lib/ruby/2.6.0/bundler/cli.rb:463:in `exec'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/usr/local/lib/ruby/2.6.0/bundler/cli.rb:27:in `dispatch'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/usr/local/lib/ruby/2.6.0/bundler/cli.rb:18:in `start'
/usr/local/lib/ruby/gems/2.6.0/gems/bundler-1.17.2/exe/bundle:30:in `block in <top (required)>'
/usr/local/lib/ruby/2.6.0/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/usr/local/lib/ruby/gems/2.6.0/gems/bundler-1.17.2/exe/bundle:22:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'

Caused by:
NoMethodError: undefined method `[]' for nil:NilClass
/opt/redmine/plugins/full_text_search/db/migrate/20190603061606_create_fts_targets.rb:12:in `change'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:814:in `exec_migration'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:797:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:796:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:977:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `migrate'
/opt/redmine/lib/redmine/plugin.rb:510:in `up'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1011:in `migrate'
/opt/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/opt/redmine/lib/redmine/plugin.rb:483:in `migrate'
/opt/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/opt/redmine/lib/redmine/plugin.rb:496:in `each'
/opt/redmine/lib/redmine/plugin.rb:496:in `migrate'
/opt/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:199:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:188:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:160:in `invoke_task'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:125:in `run_with_threads'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:110:in `top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:83:in `block in run'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:80:in `run'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
/usr/local/bin/rake:23:in `load'
/usr/local/bin/rake:23:in `<top (required)>'
/usr/local/lib/ruby/2.6.0/bundler/cli/exec.rb:74:in `load'
/usr/local/lib/ruby/2.6.0/bundler/cli/exec.rb:74:in `kernel_load'
/usr/local/lib/ruby/2.6.0/bundler/cli/exec.rb:28:in `run'
/usr/local/lib/ruby/2.6.0/bundler/cli.rb:463:in `exec'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
/usr/local/lib/ruby/2.6.0/bundler/cli.rb:27:in `dispatch'
/usr/local/lib/ruby/2.6.0/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
/usr/local/lib/ruby/2.6.0/bundler/cli.rb:18:in `start'
/usr/local/lib/ruby/gems/2.6.0/gems/bundler-1.17.2/exe/bundle:30:in `block in <top (required)>'
/usr/local/lib/ruby/2.6.0/bundler/friendly_errors.rb:124:in `with_friendly_errors'
/usr/local/lib/ruby/gems/2.6.0/gems/bundler-1.17.2/exe/bundle:22:in `<top (required)>'
/usr/local/bin/bundle:23:in `load'
/usr/local/bin/bundle:23:in `<main>'
Tasks: TOP => redmine:plugins:migrate
kou commented 4 years ago

Could you show the output of the following command:

RAILS_ENV=production bin/rails runner 'pp ActiveRecord::Base.connection.select_rows("SHOW VARIABLES LIKE \"mroonga_version\"")'
minzak commented 4 years ago 
mariadb-server-10.3-mroonga is already the newest version (9.10-1).
groonga-tokenizer-mecab is already the newest version (9.1.0-1).

Was installed on this man - http://mroonga.org/docs/install/debian.html

RAILS_ENV=production bin/rails runner 'pp ActiveRecord::Base.connection.select_rows("SHOW VARIABLES LIKE \"mroonga_version\"")'
Traceback (most recent call last):
        53: from bin/rails:4:in `<main>'
        52: from bin/rails:4:in `require'
        51: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands.rb:18:in `<top (required)>'
        50: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command.rb:46:in `invoke'
        49: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command/base.rb:69:in `perform'
        48: from /usr/local/lib/ruby/gems/2.6.0/gems/thor-1.0.1/lib/thor.rb:392:in `dispatch'
        47: from /usr/local/lib/ruby/gems/2.6.0/gems/thor-1.0.1/lib/thor/invocation.rb:127:in `invoke_command'
        46: from /usr/local/lib/ruby/gems/2.6.0/gems/thor-1.0.1/lib/thor/command.rb:27:in `run'
        45: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/runner/runner_command.rb:29:in `perform'
        44: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command/actions.rb:15:in `require_application_and_environment!'
        43: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command/actions.rb:28:in `require_environment!'
        42: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/application.rb:337:in `require_environment!'
        41: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/application.rb:337:in `require'
        40: from /var/www/redmine/config/environment.rb:16:in `<top (required)>'
        39: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/application.rb:361:in `initialize!'
        38: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/initializable.rb:60:in `run_initializers'
        37: from /usr/local/lib/ruby/2.6.0/tsort.rb:205:in `tsort_each'
        36: from /usr/local/lib/ruby/2.6.0/tsort.rb:226:in `tsort_each'
        35: from /usr/local/lib/ruby/2.6.0/tsort.rb:347:in `each_strongly_connected_component'
        34: from /usr/local/lib/ruby/2.6.0/tsort.rb:347:in `call'
        33: from /usr/local/lib/ruby/2.6.0/tsort.rb:347:in `each'
        32: from /usr/local/lib/ruby/2.6.0/tsort.rb:349:in `block in each_strongly_connected_component'
        31: from /usr/local/lib/ruby/2.6.0/tsort.rb:431:in `each_strongly_connected_component_from'
        30: from /usr/local/lib/ruby/2.6.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
        29: from /usr/local/lib/ruby/2.6.0/tsort.rb:228:in `block in tsort_each'
        28: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/initializable.rb:61:in `block in run_initializers'
        27: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/initializable.rb:32:in `run'
        26: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/initializable.rb:32:in `instance_exec'
        25: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/application/finisher.rb:69:in `block in <module:Finisher>'
        24: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/application/finisher.rb:69:in `each'
        23: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/engine.rb:356:in `eager_load!'
        22: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/engine.rb:475:in `eager_load!'
        21: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/engine.rb:475:in `each'
        20: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/engine.rb:477:in `block in eager_load!'
        19: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/engine.rb:477:in `each'
        18: from /usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/engine.rb:478:in `block (2 levels) in eager_load!'
        17: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:246:in `require_dependency'
        16: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:334:in `depend_on'
        15: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:356:in `require_or_load'
        14: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:37:in `load_interlock'
        13: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:13:in `loading'
        12: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/concurrency/share_lock.rb:151:in `exclusive'
        11: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:14:in `block in loading'
        10: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:37:in `block in load_interlock'
         9: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:378:in `block in require_or_load'
         8: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:291:in `require'
         7: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:257:in `load_dependency'
         6: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:291:in `block in require'
         5: from /usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies.rb:291:in `require'
         4: from /var/www/redmine/plugins/full_text_search/app/models/full_text_search/target.rb:1:in `<top (required)>'
         3: from /var/www/redmine/plugins/full_text_search/app/models/full_text_search/target.rb:2:in `<module:FullTextSearch>'
         2: from /var/www/redmine/plugins/full_text_search/app/models/full_text_search/target.rb:13:in `<class:Target>'
         1: from /var/www/redmine/plugins/full_text_search/lib/full_text_search/mroonga.rb:54:in `mroonga_vector_load_is_supported?'
/var/www/redmine/plugins/full_text_search/lib/full_text_search/mroonga.rb:48:in `groonga_version': undefined method `[]' for nil:NilClass (NoMethodError)

But i remember in past with oldest version and redmine 3.4 all was worked. Also i have this plugins:

mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 80
Server version: 10.3.18-MariaDB-0+deb10u1 Debian 10

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT plugin_name, plugin_version, plugin_maturity
    -> FROM information_schema.plugins
    -> ORDER BY plugin_name;
+-------------------------------+----------------+-----------------+
| plugin_name                   | plugin_version | plugin_maturity |
+-------------------------------+----------------+-----------------+
| Aria                          | 1.5            | Stable          |
| binlog                        | 1.0            | Stable          |
| CLIENT_STATISTICS             | 2.0            | Stable          |
| CSV                           | 1.0            | Stable          |
| FEEDBACK                      | 1.1            | Stable          |
| INDEX_STATISTICS              | 2.0            | Stable          |
| InnoDB                        | 10.3           | Stable          |
| INNODB_BUFFER_PAGE            | 10.3           | Stable          |
| INNODB_BUFFER_PAGE_LRU        | 10.3           | Stable          |
| INNODB_BUFFER_POOL_STATS      | 10.3           | Stable          |
| INNODB_CMP                    | 10.3           | Stable          |
| INNODB_CMPMEM                 | 10.3           | Stable          |
| INNODB_CMPMEM_RESET           | 10.3           | Stable          |
| INNODB_CMP_PER_INDEX          | 10.3           | Stable          |
| INNODB_CMP_PER_INDEX_RESET    | 10.3           | Stable          |
| INNODB_CMP_RESET              | 10.3           | Stable          |
| INNODB_FT_BEING_DELETED       | 10.3           | Stable          |
| INNODB_FT_CONFIG              | 10.3           | Stable          |
| INNODB_FT_DEFAULT_STOPWORD    | 10.3           | Stable          |
| INNODB_FT_DELETED             | 10.3           | Stable          |
| INNODB_FT_INDEX_CACHE         | 10.3           | Stable          |
| INNODB_FT_INDEX_TABLE         | 10.3           | Stable          |
| INNODB_LOCKS                  | 10.3           | Stable          |
| INNODB_LOCK_WAITS             | 10.3           | Stable          |
| INNODB_METRICS                | 10.3           | Stable          |
| INNODB_MUTEXES                | 10.3           | Stable          |
| INNODB_SYS_COLUMNS            | 10.3           | Stable          |
| INNODB_SYS_DATAFILES          | 10.3           | Stable          |
| INNODB_SYS_FIELDS             | 10.3           | Stable          |
| INNODB_SYS_FOREIGN            | 10.3           | Stable          |
| INNODB_SYS_FOREIGN_COLS       | 10.3           | Stable          |
| INNODB_SYS_INDEXES            | 10.3           | Stable          |
| INNODB_SYS_SEMAPHORE_WAITS    | 10.3           | Stable          |
| INNODB_SYS_TABLES             | 10.3           | Stable          |
| INNODB_SYS_TABLESPACES        | 10.3           | Stable          |
| INNODB_SYS_TABLESTATS         | 10.3           | Stable          |
| INNODB_SYS_VIRTUAL            | 10.3           | Stable          |
| INNODB_TABLESPACES_ENCRYPTION | 10.3           | Stable          |
| INNODB_TABLESPACES_SCRUBBING  | 10.3           | Stable          |
| INNODB_TRX                    | 10.3           | Stable          |
| MEMORY                        | 1.0            | Stable          |
| MRG_MyISAM                    | 1.0            | Stable          |
| MyISAM                        | 1.0            | Stable          |
| mysql_native_password         | 1.0            | Stable          |
| mysql_old_password            | 1.0            | Stable          |
| partition                     | 1.0            | Stable          |
| PERFORMANCE_SCHEMA            | 0.1            | Stable          |
| SEQUENCE                      | 1.0            | Stable          |
| SQL_SEQUENCE                  | 1.0            | Stable          |
| TABLE_STATISTICS              | 2.0            | Stable          |
| unix_socket                   | 1.0            | Stable          |
| USER_STATISTICS               | 2.0            | Stable          |
| user_variables                | 1.0            | Stable          |
| wsrep                         | 1.0            | Stable          |
+-------------------------------+----------------+-----------------+
54 rows in set (0.001 sec)

also i see logs:

/var/lib/mysql/groonga.log 
3575/3575              100%
2020-01-02 15:23:56.794229|n|94d46700|mroonga 7.07 started.
2020-01-02 15:23:56.794258|n|94d46700|log level is 'NOTICE'
2020-01-02 15:24:08.575630|n|941a0700|mroonga 7.07 deinit
2020-01-02 15:24:08.576942|n|941a0700|grn_fin (0)
2020-01-02 15:24:09.070742|n|37f95d00|mroonga 7.07 started.
2020-01-02 15:24:09.070779|n|37f95d00|log level is 'NOTICE'
2020-01-02 15:24:17.519158|n|0c0a9700|spec:2:update:Object:32(type):8
2020-01-02 15:24:17.519531|n|0c0a9700|spec:3:update:Bool:32(type):1
2020-01-02 15:24:17.519563|n|0c0a9700|spec:4:update:Int8:32(type):1
2020-01-02 15:24:17.519577|n|0c0a9700|spec:5:update:UInt8:32(type):1
2020-01-02 15:24:17.519589|n|0c0a9700|spec:6:update:Int16:32(type):2
2020-01-02 15:24:17.519602|n|0c0a9700|spec:7:update:UInt16:32(type):2
2020-01-02 15:24:17.519614|n|0c0a9700|spec:8:update:Int32:32(type):4
2020-01-02 15:24:17.519625|n|0c0a9700|spec:9:update:UInt32:32(type):4
2020-01-02 15:24:17.519636|n|0c0a9700|spec:10:update:Int64:32(type):8
2020-01-02 15:24:17.519647|n|0c0a9700|spec:11:update:UInt64:32(type):8
2020-01-02 15:24:17.519658|n|0c0a9700|spec:12:update:Float:32(type):8
2020-01-02 15:24:17.519670|n|0c0a9700|spec:13:update:Time:32(type):8
2020-01-02 15:24:17.519681|n|0c0a9700|spec:14:update:ShortText:32(type):4096
2020-01-02 15:24:17.519693|n|0c0a9700|spec:15:update:Text:32(type):65536
2020-01-02 15:24:17.519705|n|0c0a9700|spec:16:update:LongText:32(type):2147483648
2020-01-02 15:24:17.519717|n|0c0a9700|spec:17:update:TokyoGeoPoint:32(type):8
2020-01-02 15:24:17.519728|n|0c0a9700|spec:18:update:WGS84GeoPoint:32(type):8
2020-01-02 15:24:17.534793|n|0c0a9700|DDL:256:table_create mroonga_operations
2020-01-02 15:24:17.535804|n|0c0a9700|spec:256:update:mroonga_operations:51(table:no_key):0
2020-01-02 15:24:17.535888|n|0c0a9700|DDL:257:column_create mroonga_operations type
2020-01-02 15:24:17.539446|n|0c0a9700|spec:257:update:mroonga_operations.type:65(column:var_size):14(ShortText)
2020-01-02 15:24:17.540233|n|0c0a9700|DDL:258:column_create mroonga_operations table
2020-01-02 15:24:17.544771|n|0c0a9700|spec:258:update:mroonga_operations.table:65(column:var_size):14(ShortText)
2020-01-02 15:24:17.544838|n|0c0a9700|DDL:259:column_create mroonga_operations record
2020-01-02 15:24:17.546785|n|0c0a9700|spec:259:update:mroonga_operations.record:64(column:fix_size):9(UInt32)
2020-01-02 15:24:17.548049|n|0c0a9700|DDL:265:table_create fts_tags
2020-01-02 15:24:17.550556|n|0c0a9700|spec:265:update:fts_tags:49(table:pat_key):0
2020-01-02 15:24:17.550624|n|0c0a9700|DDL:266:column_create fts_tags id
2020-01-02 15:24:17.552014|n|0c0a9700|spec:266:update:fts_tags.id:64(column:fix_size):10(Int64)
2020-01-02 15:24:17.552075|n|0c0a9700|DDL:267:column_create fts_tags type_id
2020-01-02 15:24:17.553659|n|0c0a9700|spec:267:update:fts_tags.type_id:64(column:fix_size):8(Int32)
2020-01-02 15:24:17.553707|n|0c0a9700|DDL:268:column_create fts_tags name
2020-01-02 15:24:17.558007|n|0c0a9700|spec:268:update:fts_tags.name:65(column:var_size):14(ShortText)
2020-01-02 15:24:17.558063|n|0c0a9700|DDL:269:table_create fts_tags#index_fts_tags_on_type_id_and_name
2020-01-02 15:24:17.559478|n|0c0a9700|spec:269:update:fts_tags#index_fts_tags_on_type_id_and_name:49(table:pat_key):0
2020-01-02 15:24:17.559509|n|0c0a9700|DDL:270:column_create fts_tags#index_fts_tags_on_type_id_and_name index
2020-01-02 15:24:17.566152|n|0c0a9700|spec:270:update:fts_tags#index_fts_tags_on_type_id_and_name.index:72(column:index):265(fts_tags)
2020-01-02 15:25:04.015089|n|0c0a9700|mroonga 7.07 deinit
2020-01-02 15:25:04.018890|n|0c0a9700|grn_fin (0)
kou commented 4 years ago

Mroonga isn't available on MariaDB.

Could you run the following?

sudo -H mysql --defaults-file=/etc/mysql/debian.cnf < /usr/share/mroonga/install.sql
minzak commented 4 years ago

At last i see plugins:

MariaDB [(none)]> SELECT plugin_name, plugin_version, plugin_maturity FROM information_schema.plugins ORDER BY plugin_name;
+-------------------------------+----------------+-----------------+
| plugin_name                   | plugin_version | plugin_maturity |
+-------------------------------+----------------+-----------------+
| Aria                          | 1.5            | Stable          |
| binlog                        | 1.0            | Stable          |
| CLIENT_STATISTICS             | 2.0            | Stable          |
| CSV                           | 1.0            | Stable          |
| FEEDBACK                      | 1.1            | Stable          |
| INDEX_STATISTICS              | 2.0            | Stable          |
| InnoDB                        | 10.3           | Stable          |
| INNODB_BUFFER_PAGE            | 10.3           | Stable          |
| INNODB_BUFFER_PAGE_LRU        | 10.3           | Stable          |
| INNODB_BUFFER_POOL_STATS      | 10.3           | Stable          |
| INNODB_CMP                    | 10.3           | Stable          |
| INNODB_CMPMEM                 | 10.3           | Stable          |
| INNODB_CMPMEM_RESET           | 10.3           | Stable          |
| INNODB_CMP_PER_INDEX          | 10.3           | Stable          |
| INNODB_CMP_PER_INDEX_RESET    | 10.3           | Stable          |
| INNODB_CMP_RESET              | 10.3           | Stable          |
| INNODB_FT_BEING_DELETED       | 10.3           | Stable          |
| INNODB_FT_CONFIG              | 10.3           | Stable          |
| INNODB_FT_DEFAULT_STOPWORD    | 10.3           | Stable          |
| INNODB_FT_DELETED             | 10.3           | Stable          |
| INNODB_FT_INDEX_CACHE         | 10.3           | Stable          |
| INNODB_FT_INDEX_TABLE         | 10.3           | Stable          |
| INNODB_LOCKS                  | 10.3           | Stable          |
| INNODB_LOCK_WAITS             | 10.3           | Stable          |
| INNODB_METRICS                | 10.3           | Stable          |
| INNODB_MUTEXES                | 10.3           | Stable          |
| INNODB_SYS_COLUMNS            | 10.3           | Stable          |
| INNODB_SYS_DATAFILES          | 10.3           | Stable          |
| INNODB_SYS_FIELDS             | 10.3           | Stable          |
| INNODB_SYS_FOREIGN            | 10.3           | Stable          |
| INNODB_SYS_FOREIGN_COLS       | 10.3           | Stable          |
| INNODB_SYS_INDEXES            | 10.3           | Stable          |
| INNODB_SYS_SEMAPHORE_WAITS    | 10.3           | Stable          |
| INNODB_SYS_TABLES             | 10.3           | Stable          |
| INNODB_SYS_TABLESPACES        | 10.3           | Stable          |
| INNODB_SYS_TABLESTATS         | 10.3           | Stable          |
| INNODB_SYS_VIRTUAL            | 10.3           | Stable          |
| INNODB_TABLESPACES_ENCRYPTION | 10.3           | Stable          |
| INNODB_TABLESPACES_SCRUBBING  | 10.3           | Stable          |
| INNODB_TRX                    | 10.3           | Stable          |
| MEMORY                        | 1.0            | Stable          |
| MRG_MyISAM                    | 1.0            | Stable          |
| Mroonga                       | 9.10           | Stable          |
| MyISAM                        | 1.0            | Stable          |
| mysql_native_password         | 1.0            | Stable          |
| mysql_old_password            | 1.0            | Stable          |
| partition                     | 1.0            | Stable          |
| PERFORMANCE_SCHEMA            | 0.1            | Stable          |
| SEQUENCE                      | 1.0            | Stable          |
| SQL_SEQUENCE                  | 1.0            | Stable          |
| TABLE_STATISTICS              | 2.0            | Stable          |
| unix_socket                   | 1.0            | Stable          |
| USER_STATISTICS               | 2.0            | Stable          |
| user_variables                | 1.0            | Stable          |
| wsrep                         | 1.0            | Stable          |
+-------------------------------+----------------+-----------------+
55 rows in set (0.004 sec)
RAILS_ENV=production bin/rails runner 'pp ActiveRecord::Base.connection.select_rows("SHOW VARIABLES LIKE \"mroonga_version\"")'
[["mroonga_version", "9.10"]]

But migrate still not work:

# RAILS_ENV=production bin/rails redmine:plugins:migrate
== 20190603061606 CreateFtsTargets: migrating =================================
-- create_table(:fts_targets, {:options=>"ENGINE=Mroonga DEFAULT CHARSET=utf8mb4"})
   -> 0.2218s
== 20190603061606 CreateFtsTargets: migrated (0.2231s) ========================

== 20190728022920 MroongaAddSourceTypeIdIndexToFtsTargets: migrating ==========
-- add_index(:fts_targets, :source_type_id)
   -> 0.0219s
== 20190728022920 MroongaAddSourceTypeIdIndexToFtsTargets: migrated (0.0220s) =

== 20190807085000 CreateFtsQueryExpansions: migrating =========================
-- create_table(:fts_query_expansions, {:options=>"ENGINE=Mroonga"})
   -> 0.0523s
== 20190807085000 CreateFtsQueryExpansions: migrated (0.0524s) ================

== 20190925074645 AddNameIndexToFtsTags: migrating ============================
-- add_index(:fts_tags, :name, {:type=>"fulltext", :comment=>"NORMALIZER 'NormalizerNFKC121'"})
rails aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Table 'biz_redminedb.fts_tags' doesn't exist: CREATE fulltext INDEX `index_fts_tags_on_name`  ON `fts_tags` (`name`)  COMMENT 'NORMALIZER \'NormalizerNFKC121\''
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190925074645_add_name_index_to_fts_tags.rb:6:in `change'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `each'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'biz_redminedb.fts_tags' doesn't exist: CREATE fulltext INDEX `index_fts_tags_on_name`  ON `fts_tags` (`name`)  COMMENT 'NORMALIZER \'NormalizerNFKC121\''
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190925074645_add_name_index_to_fts_tags.rb:6:in `change'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `each'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'

Caused by:
Mysql2::Error: Table 'biz_redminedb.fts_tags' doesn't exist
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190925074645_add_name_index_to_fts_tags.rb:6:in `change'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `each'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
Tasks: TOP => redmine:plugins:migrate
(See full trace by running task with --trace)

And with trace:

RAILS_ENV=production bin/rails redmine:plugins:migrate --trace
** Invoke redmine:plugins:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute redmine:plugins:migrate
== 20190925074645 AddNameIndexToFtsTags: migrating ============================
-- add_index(:fts_tags, :name, {:type=>"fulltext", :comment=>"NORMALIZER 'NormalizerNFKC121'"})
rails aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Table 'biz_redminedb.fts_tags' doesn't exist: CREATE fulltext INDEX `index_fts_tags_on_name`  ON `fts_tags` (`name`)  COMMENT 'NORMALIZER \'NormalizerNFKC121\''
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:871:in `block in method_missing'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:840:in `block in say_with_time'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:840:in `say_with_time'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:860:in `method_missing'
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190925074645_add_name_index_to_fts_tags.rb:6:in `change'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:814:in `exec_migration'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:797:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:796:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:977:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1011:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `each'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:199:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:188:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:160:in `invoke_task'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:125:in `run_with_threads'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:110:in `top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command.rb:48:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands.rb:18:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'biz_redminedb.fts_tags' doesn't exist: CREATE fulltext INDEX `index_fts_tags_on_name`  ON `fts_tags` (`name`)  COMMENT 'NORMALIZER \'NormalizerNFKC121\''
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:871:in `block in method_missing'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:840:in `block in say_with_time'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:840:in `say_with_time'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:860:in `method_missing'
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190925074645_add_name_index_to_fts_tags.rb:6:in `change'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:814:in `exec_migration'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:797:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:796:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:977:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1011:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `each'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:199:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:188:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:160:in `invoke_task'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:125:in `run_with_threads'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:110:in `top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command.rb:48:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands.rb:18:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'

Caused by:
Mysql2::Error: Table 'biz_redminedb.fts_tags' doesn't exist
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `_query'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:131:in `block in query'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `handle_interrupt'
/usr/local/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/client.rb:130:in `query'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
/usr/local/lib/ruby/gems/2.6.0/gems/activesupport-5.2.4.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:382:in `add_index'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:871:in `block in method_missing'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:840:in `block in say_with_time'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:840:in `say_with_time'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:860:in `method_missing'
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190925074645_add_name_index_to_fts_tags.rb:6:in `change'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:814:in `exec_migration'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
/usr/local/lib/ruby/2.6.0/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:797:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:796:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:977:in `migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1345:in `ddl_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1262:in `migrate_without_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `block in migrate'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1363:in `with_advisory_lock'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1210:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/usr/local/lib/ruby/gems/2.6.0/gems/activerecord-5.2.4.1/lib/active_record/migration.rb:1011:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:497:in `block in migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `each'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:496:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `block in execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:281:in `execute'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:199:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/task.rb:188:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:160:in `invoke_task'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `each'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:116:in `block in top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:125:in `run_with_threads'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:110:in `top_level'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:23:in `block in perform'
/usr/local/lib/ruby/gems/2.6.0/gems/rake-13.0.1/lib/rake/application.rb:186:in `standard_exception_handling'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands/rake/rake_command.rb:20:in `perform'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/command.rb:48:in `invoke'
/usr/local/lib/ruby/gems/2.6.0/gems/railties-5.2.4.1/lib/rails/commands.rb:18:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
Tasks: TOP => redmine:plugins:migrate
kou commented 4 years ago

Could you recreate schema?

RAILS_ENV=production bin/rails redmine:plugins:migrate NAME=full_text_search VERSION=0
RAILS_ENV=production bin/rails redmine:plugins:migrate NAME=full_text_search
minzak commented 4 years ago

Yes, but no lucky:

root@Server226:/var/www/bizlevel/redmine# RAILS_ENV=production bin/rails redmine:plugins:migrate NAME=full_text_search VERSION=0
== 20190807085000 CreateFtsQueryExpansions: reverting =========================
-- drop_table(:fts_query_expansions, {:options=>"ENGINE=Mroonga"})
   -> 0.0156s
== 20190807085000 CreateFtsQueryExpansions: reverted (0.0202s) ================

== 20190728022920 MroongaAddSourceTypeIdIndexToFtsTargets: reverting ==========
-- remove_index(:fts_targets, {:column=>:source_type_id})
   -> 0.0078s
== 20190728022920 MroongaAddSourceTypeIdIndexToFtsTargets: reverted (0.0093s) =

== 20190603061606 CreateFtsTargets: reverting =================================
-- drop_table(:fts_targets, {:options=>"ENGINE=Mroonga DEFAULT CHARSET=utf8mb4"})
   -> 0.0300s
== 20190603061606 CreateFtsTargets: reverted (0.0324s) ========================

== 20190603061445 CreateFtsTags: reverting ====================================
== 20190603061445 CreateFtsTags: reverted (0.0012s) ===========================

== 20190603061110 CreateFtsTagTypes: reverting ================================
-- drop_table(:fts_tag_types)
   -> 0.0116s
== 20190603061110 CreateFtsTagTypes: reverted (0.0128s) =======================

== 20190603060948 CreateFtsTypes: reverting ===================================
-- drop_table(:fts_types)
   -> 0.0083s
== 20190603060948 CreateFtsTypes: reverted (0.0095s) ==========================

== 20190603054615 DropSearcherRecords: reverting ==============================
-- create_table(:searcher_records)
   -> 0.7011s
== 20190603054615 DropSearcherRecords: reverted (0.7014s) =====================

== 20190226093843 AddMissingIndexesToSearcherRecords: reverting ===============
== 20190226093843 AddMissingIndexesToSearcherRecords: reverted (0.0000s) ======

== 20190226093842 ExtendContentSize: reverting ================================
== 20190226093842 ExtendContentSize: reverted (0.0000s) =======================

== 20170810052427 AddIndexToIssueContents: reverting ==========================
== 20170810052427 AddIndexToIssueContents: reverted (0.0000s) =================

== 20170810045914 CreateIssueContents: reverting ==============================
-- drop_table(:issue_contents, {:options=>"ENGINE=Mroonga DEFAULT CHARSET=utf8mb4", :id=>:integer})
   -> 0.0188s
== 20170810045914 CreateIssueContents: reverted (0.0198s) =====================

== 20170630075028 AddIndexToSearcherRecords: reverting ========================
== 20170630075028 AddIndexToSearcherRecords: reverted (0.0000s) ===============

== 20170630075027 LoadCommentsFromChangesets: reverting =======================
== 20170630075027 LoadCommentsFromChangesets: reverted (0.0000s) ==============

== 20170630063757 CopyRecordsToSearcherRecords: reverting =====================
== 20170630063757 CopyRecordsToSearcherRecords: reverted (0.0001s) ============

== 20170630063657 CreateSearcherRecords: reverting ============================
-- drop_table(:searcher_records, {:options=>"ENGINE=Mroonga", :id=>:integer})
   -> 0.1617s
== 20170630063657 CreateSearcherRecords: reverted (0.1634s) ===================

== 20170630063557 EnablePgroonga: reverting ===================================
== 20170630063557 EnablePgroonga: reverted (0.0001s) ==========================

And finally:

root@Server226:/var/www/bizlevel/redmine# RAILS_ENV=production bin/rails redmine:plugins:migrate NAME=full_text_search
== 20170630063557 EnablePgroonga: migrating ===================================
== 20170630063557 EnablePgroonga: migrated (0.0000s) ==========================

== 20170630063657 CreateSearcherRecords: migrating ============================
-- create_table(:searcher_records, {:options=>"ENGINE=Mroonga", :id=>:integer})
   -> 0.4715s
== 20170630063657 CreateSearcherRecords: migrated (0.4718s) ===================

== 20170630063757 CopyRecordsToSearcherRecords: migrating =====================
== 20170630063757 CopyRecordsToSearcherRecords: migrated (0.0000s) ============

== 20170630075027 LoadCommentsFromChangesets: migrating =======================
== 20170630075027 LoadCommentsFromChangesets: migrated (0.0001s) ==============

== 20170630075028 AddIndexToSearcherRecords: migrating ========================
== 20170630075028 AddIndexToSearcherRecords: migrated (0.0001s) ===============

== 20170810045914 CreateIssueContents: migrating ==============================
-- create_table(:issue_contents, {:options=>"ENGINE=Mroonga DEFAULT CHARSET=utf8mb4", :id=>:integer})
   -> 0.0384s
== 20170810045914 CreateIssueContents: migrated (0.0388s) =====================

== 20170810052427 AddIndexToIssueContents: migrating ==========================
== 20170810052427 AddIndexToIssueContents: migrated (0.0000s) =================

== 20190226093842 ExtendContentSize: migrating ================================
== 20190226093842 ExtendContentSize: migrated (0.0000s) =======================

== 20190226093843 AddMissingIndexesToSearcherRecords: migrating ===============
== 20190226093843 AddMissingIndexesToSearcherRecords: migrated (0.0000s) ======

== 20190603054615 DropSearcherRecords: migrating ==============================
-- drop_table(:searcher_records)
   -> 0.0434s
== 20190603054615 DropSearcherRecords: migrated (0.0436s) =====================

== 20190603060948 CreateFtsTypes: migrating ===================================
-- create_table(:fts_types)
   -> 0.0165s
== 20190603060948 CreateFtsTypes: migrated (0.0166s) ==========================

== 20190603061110 CreateFtsTagTypes: migrating ================================
-- create_table(:fts_tag_types)
   -> 0.0185s
== 20190603061110 CreateFtsTagTypes: migrated (0.0196s) =======================

== 20190603061445 CreateFtsTags: migrating ====================================
-- create_table(:fts_tags, {:options=>"ENGINE=Mroonga"})
rails aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: [object][register] already used name was assigned: <fts_tags>: CREATE TABLE `fts_tags` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `type_id` int NOT NULL, `name` varchar(255) NOT NULL, UNIQUE INDEX `index_fts_tags_on_type_id_and_name`  (`type_id`, `name`)) ENGINE=Mroonga
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190603061445_create_fts_tags.rb:10:in `change'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:494:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: [object][register] already used name was assigned: <fts_tags>: CREATE TABLE `fts_tags` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `type_id` int NOT NULL, `name` varchar(255) NOT NULL, UNIQUE INDEX `index_fts_tags_on_type_id_and_name`  (`type_id`, `name`)) ENGINE=Mroonga
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190603061445_create_fts_tags.rb:10:in `change'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:494:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'

Caused by:
Mysql2::Error: [object][register] already used name was assigned: <fts_tags>
/var/www/bizlevel/redmine/plugins/redmine_full_text_search/db/migrate/20190603061445_create_fts_tags.rb:10:in `change'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:510:in `up'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:542:in `migrate_plugin'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:483:in `migrate'
/var/www/bizlevel/redmine/lib/redmine/plugin.rb:494:in `migrate'
/var/www/bizlevel/redmine/lib/tasks/redmine.rake:135:in `block (3 levels) in <top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
Tasks: TOP => redmine:plugins:migrate
(See full trace by running task with --trace)
kou commented 4 years ago

It seems that your Mroonga database is broken. Could you do the recover process? https://github.com/clear-code/redmine_full_text_search#how-to-recover-broken-database

minzak commented 4 years ago

YES. At last it is worked! Thanks.