Content
View differences
Updated by Markus Kahl almost 8 years ago
**Preconditions**
- openproject-ce on dev branch
- 5.6.41 MySQL Community Server
**Steps to reproduce**
- \`bundle exec rake db:create db:migrate\`
**Error log**
$ bundle exec rake db:drop db:create db:migrate db:seed
Dropped database 'openproject_ce'
Created database 'openproject_ce'
== 10000000000000 ToV710AggregatedMigrations: migrating =======================
-- create_table("work_packages", {:id=>:integer, :bulk=>true})
-> 0.0432s
-- create_table("users", {:id=>:integer, :bulk=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE TABLE `users` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `login` varchar(256) DEFAULT '' NOT NULL, `firstname` varchar(30) DEFAULT '' NOT NULL, `lastname` varchar(30) DEFAULT '' NOT NULL, `mail` varchar(60) DEFAULT '' NOT NULL, `admin` tinyint(1) DEFAULT 0 NOT NULL, `status` int DEFAULT 1 NOT NULL, `last_login_on` datetime, `language` varchar(5) DEFAULT '', `auth_source_id` int, `created_on` datetime, `updated_on` datetime, `type` varchar(255), `identity_url` varchar(255), `mail_notification` varchar(255) DEFAULT '' NOT NULL, `first_login` tinyint(1) DEFAULT 1 NOT NULL, `force_password_change` tinyint(1) DEFAULT 0, `failed_login_count` int DEFAULT 0, `last_failed_login_on` datetime, INDEX `index_users_on_auth_source_id` (`auth_source_id`), INDEX `index_users_on_id_and_type` (`id`, `type`), INDEX `index_users_on_type` (`type`), INDEX `index_users_on_type_and_login` (`type`(255), `login`(255)), INDEX `index_users_on_type_and_status` (`type`, `status`)) ENGINE=InnoDB
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:47:in `create_table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/users.rb:36:in `table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:35:in `create'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:180:in `block in create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `each'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:135:in `run_aggregated_migrations'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:122:in `up'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE TABLE `users` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `login` varchar(256) DEFAULT '' NOT NULL, `firstname` varchar(30) DEFAULT '' NOT NULL, `lastname` varchar(30) DEFAULT '' NOT NULL, `mail` varchar(60) DEFAULT '' NOT NULL, `admin` tinyint(1) DEFAULT 0 NOT NULL, `status` int DEFAULT 1 NOT NULL, `last_login_on` datetime, `language` varchar(5) DEFAULT '', `auth_source_id` int, `created_on` datetime, `updated_on` datetime, `type` varchar(255), `identity_url` varchar(255), `mail_notification` varchar(255) DEFAULT '' NOT NULL, `first_login` tinyint(1) DEFAULT 1 NOT NULL, `force_password_change` tinyint(1) DEFAULT 0, `failed_login_count` int DEFAULT 0, `last_failed_login_on` datetime, INDEX `index_users_on_auth_source_id` (`auth_source_id`), INDEX `index_users_on_id_and_type` (`id`, `type`), INDEX `index_users_on_type` (`type`), INDEX `index_users_on_type_and_login` (`type`(255), `login`(255)), INDEX `index_users_on_type_and_status` (`type`, `status`)) ENGINE=InnoDB
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:47:in `create_table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/users.rb:36:in `table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:35:in `create'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:180:in `block in create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `each'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:135:in `run_aggregated_migrations'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:122:in `up'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
Caused by:
Mysql2::Error: Specified key was too long; max key length is 767 bytes
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:47:in `create_table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/users.rb:36:in `table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:35:in `create'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:180:in `block in create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `each'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:135:in `run_aggregated_migrations'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:122:in `up'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
- openproject-ce on dev branch
- 5.6.41 MySQL Community Server
**Steps to reproduce**
- \`bundle exec rake db:create db:migrate\`
**Error log**
$ bundle exec rake db:drop db:create db:migrate db:seed
Dropped database 'openproject_ce'
Created database 'openproject_ce'
== 10000000000000 ToV710AggregatedMigrations: migrating =======================
-- create_table("work_packages", {:id=>:integer, :bulk=>true})
-> 0.0432s
-- create_table("users", {:id=>:integer, :bulk=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE TABLE `users` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `login` varchar(256) DEFAULT '' NOT NULL, `firstname` varchar(30) DEFAULT '' NOT NULL, `lastname` varchar(30) DEFAULT '' NOT NULL, `mail` varchar(60) DEFAULT '' NOT NULL, `admin` tinyint(1) DEFAULT 0 NOT NULL, `status` int DEFAULT 1 NOT NULL, `last_login_on` datetime, `language` varchar(5) DEFAULT '', `auth_source_id` int, `created_on` datetime, `updated_on` datetime, `type` varchar(255), `identity_url` varchar(255), `mail_notification` varchar(255) DEFAULT '' NOT NULL, `first_login` tinyint(1) DEFAULT 1 NOT NULL, `force_password_change` tinyint(1) DEFAULT 0, `failed_login_count` int DEFAULT 0, `last_failed_login_on` datetime, INDEX `index_users_on_auth_source_id` (`auth_source_id`), INDEX `index_users_on_id_and_type` (`id`, `type`), INDEX `index_users_on_type` (`type`), INDEX `index_users_on_type_and_login` (`type`(255), `login`(255)), INDEX `index_users_on_type_and_status` (`type`, `status`)) ENGINE=InnoDB
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:47:in `create_table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/users.rb:36:in `table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:35:in `create'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:180:in `block in create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `each'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:135:in `run_aggregated_migrations'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:122:in `up'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE TABLE `users` (`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY, `login` varchar(256) DEFAULT '' NOT NULL, `firstname` varchar(30) DEFAULT '' NOT NULL, `lastname` varchar(30) DEFAULT '' NOT NULL, `mail` varchar(60) DEFAULT '' NOT NULL, `admin` tinyint(1) DEFAULT 0 NOT NULL, `status` int DEFAULT 1 NOT NULL, `last_login_on` datetime, `language` varchar(5) DEFAULT '', `auth_source_id` int, `created_on` datetime, `updated_on` datetime, `type` varchar(255), `identity_url` varchar(255), `mail_notification` varchar(255) DEFAULT '' NOT NULL, `first_login` tinyint(1) DEFAULT 1 NOT NULL, `force_password_change` tinyint(1) DEFAULT 0, `failed_login_count` int DEFAULT 0, `last_failed_login_on` datetime, INDEX `index_users_on_auth_source_id` (`auth_source_id`), INDEX `index_users_on_id_and_type` (`id`, `type`), INDEX `index_users_on_type` (`type`), INDEX `index_users_on_type_and_login` (`type`(255), `login`(255)), INDEX `index_users_on_type_and_status` (`type`, `status`)) ENGINE=InnoDB
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:47:in `create_table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/users.rb:36:in `table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:35:in `create'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:180:in `block in create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `each'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:135:in `run_aggregated_migrations'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:122:in `up'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
Caused by:
Mysql2::Error: Specified key was too long; max key length is 767 bytes
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:47:in `create_table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/users.rb:36:in `table'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/tables/base.rb:35:in `create'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:180:in `block in create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `each'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:179:in `create_tables'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:135:in `run_aggregated_migrations'
/home/mkahl/dev/openproject/openproject-ce/db/migrate/10000000000000_to_v710_aggregated_migrations.rb:122:in `up'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `load'
/home/mkahl/.rbenv/versions/2.5.1/bin/bundle:23:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)