openaustralia / infrastructure

Automated setup and configuration for most of OpenAustralia Foundation's servers
8 stars 2 forks source link

Unable to deploy planningalerts.org.au.test following instructions in README #136

Open jamezpolley opened 5 years ago

jamezpolley commented 5 years ago

Reproduction

vagrant up mysql.test
vagrant up planningalerts.org.au.test

Switch to a checkout of https://github.com/openaustralia/planningalerts. Use rbenv install to install ruby 2.3.1; then bundle install to set up the ruby environment. Then:

bundle exec cap -S stage=development deploy:setup deploy:cold foreman:start

Expected outcome

Planningalerts is deployed on the test host.

Observed outcome

** transaction: commit
  * 2019-07-30 15:55:00 executing `deploy:load_schema'
  * executing "cd /srv/www/production/releases/20190730055204 && bundle exec rake RAILS_ENV=production  db:schema:load"
    servers: ["planningalerts.org.au.test"]
    [planningalerts.org.au.test] executing command
*** [err :: planningalerts.org.au.test] rake aborted!
*** [err :: planningalerts.org.au.test] ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE TABLE `active_admin_comments` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `resource_id` varchar(255) NOT NULL, `resource_type` varchar(255) NOT NULL, `author_id` int, `author_type` varchar(255), `body` text, `created_at` datetime, `updated_at` datetime, `namespace` varchar(255),  INDEX `index_active_admin_comments_on_author_type_and_author_id`  (`author_type`, `author_id`),  INDEX `index_active_admin_comments_on_namespace`  (`namespace`),  INDEX `index_admin_notes_on_resource_type_and_resource_id`  (`resource_type`, `resource_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730055204/db/schema.rb:15:in `block in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `instance_eval'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:46:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730055204/db/schema.rb:13:in `<main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `block in load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:257:in `load_dependency'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:245:in `load_schema'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:266:in `block in load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:265:in `load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:258:in `block (3 levels) in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `kernel_load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:28:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:465:in `exec'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:27:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:18:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:30:in `block in <top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:22:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `<main>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `eval'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `<main>'
*** [err :: planningalerts.org.au.test] Caused by:
*** [err :: planningalerts.org.au.test] Mysql2::Error: Specified key was too long; max key length is 767 bytes
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730055204/db/schema.rb:15:in `block in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `instance_eval'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:46:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730055204/db/schema.rb:13:in `<main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `block in load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:257:in `load_dependency'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:245:in `load_schema'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:266:in `block in load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:265:in `load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:258:in `block (3 levels) in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `kernel_load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:28:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:465:in `exec'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:27:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:18:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:30:in `block in <top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:22:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `<main>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `eval'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `<main>'
*** [err :: planningalerts.org.au.test] Tasks: TOP => db:schema:load
*** [err :: planningalerts.org.au.test] (See full trace by running task with --trace)
 ** [out :: planningalerts.org.au.test] -- create_table("active_admin_comments", {:id=>:integer, :options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci", :force=>:cascade})
    command finished in 3775ms
failed: "sh -c 'cd /srv/www/production/releases/20190730055204 && bundle exec rake RAILS_ENV=production  db:schema:load'" on planningalerts.org.au.test
1d [james@blister:/srv/oaf/planningalerts] [default] master+ 3m3s 1 ± 
mlandauer commented 5 years ago

I would guess that this is caused by this commit in PlanningAlerts https://github.com/openaustralia/planningalerts/commit/b06536ad0e55830cea3e878b1a0adac023fcc248. In production innodb_large_prefix was set but perhaps this was not done in the mysql configuration for the vagrant setup?

jamezpolley commented 5 years ago

Yep, that's the same rabbit hole I went down.

innodb_large_prefix is not set for the vagrant mysql.

I've created https://github.com/openaustralia/infrastructure/pull/137 which turns it on, but that doesn't fix this.

 ** transaction: commit
  * 2019-07-30 16:25:16 executing `deploy:load_schema'
  * executing "cd /srv/www/production/releases/20190730062448 && bundle exec rake RAILS_ENV=production  db:schema:load"
    servers: ["planningalerts.org.au.test"]
    [planningalerts.org.au.test] executing command
*** [err :: planningalerts.org.au.test] rake aborted!
*** [err :: planningalerts.org.au.test] ActiveRecord::StatementInvalid: Mysql2::Error: Index column size too large. The maximum column size is 767 bytes.: CREATE TABLE `active_admin_comments` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `resource_id` varchar(255) NOT NULL, `resource_type` varchar(255) NOT NULL, `author_id` int, `author_type` varchar(255), `body` text, `created_at` datetime, `updated_at` datetime, `namespace` varchar(255),  INDEX `index_active_admin_comments_on_author_type_and_author_id`  (`author_type`, `author_id`),  INDEX `index_active_admin_comments_on_namespace`  (`namespace`),  INDEX `index_admin_notes_on_resource_type_and_resource_id`  (`resource_type`, `resource_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730062448/db/schema.rb:15:in `block in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `instance_eval'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:46:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730062448/db/schema.rb:13:in `<main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `block in load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:257:in `load_dependency'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:245:in `load_schema'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:266:in `block in load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:265:in `load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:258:in `block (3 levels) in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `kernel_load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:28:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:465:in `exec'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:27:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:18:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:30:in `block in <top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:22:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `<main>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `eval'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `<main>'
*** [err :: planningalerts.org.au.test] 
*** [err :: planningalerts.org.au.test] Caused by:
*** [err :: planningalerts.org.au.test] Mysql2::Error: Index column size too large. The maximum column size is 767 bytes.
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `_query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in `block in query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `handle_interrupt'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in `query'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in `block (2 levels) in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in `block in execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:579:in `block (2 levels) in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:578:in `block in log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:569:in `log'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/mysql/database_statements.rb:28:in `execute'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:871:in `block in method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `block in say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:840:in `say_with_time'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/migration.rb:860:in `method_missing'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730062448/db/schema.rb:15:in `block in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `instance_eval'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:50:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/schema.rb:46:in `define'
*** [err :: planningalerts.org.au.test] /srv/www/production/releases/20190730062448/db/schema.rb:13:in `<main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/bootsnap-1.3.2/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:50:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `block in load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:257:in `load_dependency'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activesupport-5.2.2.1/lib/active_support/dependencies.rb:285:in `load'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:245:in `load_schema'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:266:in `block in load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:316:in `block in each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:313:in `each_current_configuration'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/tasks/database_tasks.rb:265:in `load_schema_current'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/activerecord-5.2.2.1/lib/active_record/railties/databases.rake:258:in `block (3 levels) in <main>'
*** [err :: planningalerts.org.au.test] /srv/www/production/shared/bundle/ruby/2.3.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:74:in `kernel_load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli/exec.rb:28:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:465:in `exec'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/command.rb:27:in `run'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/invocation.rb:126:in `invoke_command'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor.rb:387:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:27:in `dispatch'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/vendor/thor/lib/thor/base.rb:466:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/cli.rb:18:in `start'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:30:in `block in <top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/lib/bundler/friendly_errors.rb:124:in `with_friendly_errors'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/gems/bundler-2.0.2/exe/bundle:22:in `<top (required)>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `load'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1@global/bin/bundle:23:in `<main>'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `eval'
*** [err :: planningalerts.org.au.test] /usr/local/rvm/gems/ruby-2.3.1/bin/ruby_executable_hooks:15:in `<main>'
*** [err :: planningalerts.org.au.test] Tasks: TOP => db:schema:load
*** [err :: planningalerts.org.au.test] (See full trace by running task with --trace)
 ** [out :: planningalerts.org.au.test] -- create_table("active_admin_comments", {:id=>:integer, :options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci", :force=>:cascade})
    command finished in 7763ms
failed: "sh -c 'cd /srv/www/production/releases/20190730062448 && bundle exec rake RAILS_ENV=production  db:schema:load'" on planningalerts.org.au.test