search

likehopper / redmine_sla

Manage SLAs in Redmine!
GNU General Public License v2.0
10 stars 3 forks source link

ysql2::Error: BLOB/TEXT column 'name' used in key specification without a key length #3

Closed dynovativetech closed 1 year ago

dynovativetech commented 1 year ago

Hi, i am trying to install but getting the following error, kindly support

[dynotechsupport@secure redmine]$ RAILS_ENV=production bundle exec rake redmine:plugins:migrate NAME=redmine_sla == 202111112021001 CreateSlas: migrating ====================================== -- create_table(:slas, {}) rake aborted! StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: BLOB/TEXT column 'name' used in key specification without a key length /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in _query' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:inblock in query' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in handle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:inquery' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:206:in block (2 levels) in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/dependencies/interlock.rb:48:inblock in permit_concurrent_loads' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/dependencies/interlock.rb:47:inpermit_concurrent_loads' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:205:in block in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:696:inblock (2 levels) in log' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:inhandle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:inhandle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:695:inblock in log' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/notifications/instrumenter.rb:24:in instrument' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:687:inlog' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:204:in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/mysql/database_statements.rb:52:inexecute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:322:in create_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/mysql/schema_statements.rb:81:increate_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:929:in block in method_missing' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:897:inblock in say_with_time' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:897:in say_with_time' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:918:inmethod_missing' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration/compatibility.rb:35:in create_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration/compatibility.rb:100:increate_table' /home/dynotechsupport/redmine/plugins/redmine_sla/db/migrate/202111112021001_create_slas.rb:4:in change' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:867:inexec_migration' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:851:in block (2 levels) in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:850:inblock in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in with_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:849:inmigrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1037:in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1329:inblock in execute_migration_in_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1382:in ddl_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1328:inexecute_migration_in_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1302:in each' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1302:inmigrate_without_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1251:in block in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1401:inblock in with_advisory_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1416:in block in with_advisory_lock_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:inwith_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1416:in with_advisory_lock_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1397:inwith_advisory_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1251:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:468:inup' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1061:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:500:inmigrate_plugin' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:441:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:452:inmigrate' /home/dynotechsupport/redmine/lib/tasks/redmine.rake:151:in block (3 levels) in <top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/rake-13.0.6/exe/rake:27:in<top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:58:in load' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:58:inkernel_load' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:23:in run' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:492:inexec' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/command.rb:27:in run' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:ininvoke_command' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor.rb:392:in dispatch' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:34:indispatch' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/base.rb:485:in start' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:28:instart' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/exe/bundle:37:in block in <top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/friendly_errors.rb:117:inwith_friendly_errors' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/exe/bundle:29:in <top (required)>' /opt/cpanel/ea-ruby27/root/usr/bin/bundle:23:inload' /opt/cpanel/ea-ruby27/root/usr/bin/bundle:23:in `

'

Caused by: ActiveRecord::StatementInvalid: Mysql2::Error: BLOB/TEXT column 'name' used in key specification without a key length /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in _query' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:inblock in query' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in handle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:inquery' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:206:in block (2 levels) in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/dependencies/interlock.rb:48:inblock in permit_concurrent_loads' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/dependencies/interlock.rb:47:inpermit_concurrent_loads' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:205:in block in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:696:inblock (2 levels) in log' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:inhandle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:inhandle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:695:inblock in log' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/notifications/instrumenter.rb:24:in instrument' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:687:inlog' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:204:in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/mysql/database_statements.rb:52:inexecute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:322:in create_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/mysql/schema_statements.rb:81:increate_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:929:in block in method_missing' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:897:inblock in say_with_time' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:897:in say_with_time' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:918:inmethod_missing' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration/compatibility.rb:35:in create_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration/compatibility.rb:100:increate_table' /home/dynotechsupport/redmine/plugins/redmine_sla/db/migrate/202111112021001_create_slas.rb:4:in change' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:867:inexec_migration' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:851:in block (2 levels) in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:850:inblock in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in with_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:849:inmigrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1037:in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1329:inblock in execute_migration_in_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1382:in ddl_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1328:inexecute_migration_in_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1302:in each' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1302:inmigrate_without_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1251:in block in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1401:inblock in with_advisory_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1416:in block in with_advisory_lock_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:inwith_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1416:in with_advisory_lock_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1397:inwith_advisory_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1251:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:468:inup' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1061:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:500:inmigrate_plugin' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:441:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:452:inmigrate' /home/dynotechsupport/redmine/lib/tasks/redmine.rake:151:in block (3 levels) in <top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/rake-13.0.6/exe/rake:27:in<top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:58:in load' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:58:inkernel_load' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:23:in run' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:492:inexec' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/command.rb:27:in run' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:ininvoke_command' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor.rb:392:in dispatch' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:34:indispatch' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/base.rb:485:in start' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:28:instart' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/exe/bundle:37:in block in <top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/friendly_errors.rb:117:inwith_friendly_errors' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/exe/bundle:29:in <top (required)>' /opt/cpanel/ea-ruby27/root/usr/bin/bundle:23:inload' /opt/cpanel/ea-ruby27/root/usr/bin/bundle:23:in `

'

Caused by: Mysql2::Error: BLOB/TEXT column 'name' used in key specification without a key length /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in _query' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:inblock in query' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in handle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:inquery' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:206:in block (2 levels) in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/dependencies/interlock.rb:48:inblock in permit_concurrent_loads' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/share_lock.rb:187:in yield_shares' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/dependencies/interlock.rb:47:inpermit_concurrent_loads' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:205:in block in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:696:inblock (2 levels) in log' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in block (2 levels) in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:inhandle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in block in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:inhandle_interrupt' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in synchronize' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:695:inblock in log' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activesupport-6.1.7.2/lib/active_support/notifications/instrumenter.rb:24:in instrument' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_adapter.rb:687:inlog' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:204:in execute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/mysql/database_statements.rb:52:inexecute' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/schema_statements.rb:322:in create_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/mysql/schema_statements.rb:81:increate_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:929:in block in method_missing' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:897:inblock in say_with_time' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:897:in say_with_time' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:918:inmethod_missing' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration/compatibility.rb:35:in create_table' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration/compatibility.rb:100:increate_table' /home/dynotechsupport/redmine/plugins/redmine_sla/db/migrate/202111112021001_create_slas.rb:4:in change' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:867:inexec_migration' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:851:in block (2 levels) in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:850:inblock in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:in with_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:849:inmigrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1037:in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1329:inblock in execute_migration_in_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1382:in ddl_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1328:inexecute_migration_in_transaction' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1302:in each' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1302:inmigrate_without_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1251:in block in migrate' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1401:inblock in with_advisory_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1416:in block in with_advisory_lock_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:462:inwith_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1416:in with_advisory_lock_connection' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1397:inwith_advisory_lock' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1251:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:468:inup' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/activerecord-6.1.7.2/lib/active_record/migration.rb:1061:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:500:inmigrate_plugin' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:441:in migrate' /home/dynotechsupport/redmine/lib/redmine/plugin.rb:452:inmigrate' /home/dynotechsupport/redmine/lib/tasks/redmine.rake:151:in block (3 levels) in <top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/rake-13.0.6/exe/rake:27:in<top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:58:in load' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:58:inkernel_load' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli/exec.rb:23:in run' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:492:inexec' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/command.rb:27:in run' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:ininvoke_command' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor.rb:392:in dispatch' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:34:indispatch' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/vendor/thor/lib/thor/base.rb:485:in start' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/cli.rb:28:instart' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/exe/bundle:37:in block in <top (required)>' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/lib/bundler/friendly_errors.rb:117:inwith_friendly_errors' /home/dynotechsupport/.gem/ruby/ruby-2.7.8/gems/bundler-2.4.15/exe/bundle:29:in <top (required)>' /opt/cpanel/ea-ruby27/root/usr/bin/bundle:23:inload' /opt/cpanel/ea-ruby27/root/usr/bin/bundle:23:in `

' Tasks: TOP => redmine:plugins:migrate (See full trace by running task with --trace)

likehopper commented 1 year ago

For this start, for performance reasons, the plugin only works on a PostgreSQL database using its strengths ( cf. https://github.com/likehopper/redmine_sla/blob/main/README.md#prerequisites ). Indeed, the calculation of the SLAs is based on the use of the generate_series function of PostgreSQL ( cf. https://github.com/likehopper/redmine_sla/blob/main/doc/COMPUTE.md ). Yet, a contributor tries to adapt the plugin to MySQL... I'll let you know !