{"action":"created","issue":{"url":"https://api.github.com/repos/diaspora/diaspora/issues/5851","labels_url":"https://api.github.com/repos/diaspora/diaspora/issues/5851/labels{/name}","comments_url":"https://api.github.com/repos/diaspora/diaspora/issues/5851/comments","events_url":"https://api.github.com/repos/diaspora/diaspora/issues/5851/events","html_url":"https://github.com/diaspora/diaspora/issues/5851","id":66411647,"number":5851,"title":"Database ecoding is not utf8mb4","user":{"login":"nazar-pc","id":928965,"avatar_url":"https://avatars.githubusercontent.com/u/928965?v=3","gravatar_id":"","url":"https://api.github.com/users/nazar-pc","html_url":"https://github.com/nazar-pc","followers_url":"https://api.github.com/users/nazar-pc/followers","following_url":"https://api.github.com/users/nazar-pc/following{/other_user}","gists_url":"https://api.github.com/users/nazar-pc/gists{/gist_id}","starred_url":"https://api.github.com/users/nazar-pc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nazar-pc/subscriptions","organizations_url":"https://api.github.com/users/nazar-pc/orgs","repos_url":"https://api.github.com/users/nazar-pc/repos","events_url":"https://api.github.com/users/nazar-pc/events{/privacy}","received_events_url":"https://api.github.com/users/nazar-pc/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-04-05T07:01:20Z","updated_at":"2015-04-05T08:00:42Z","closed_at":null,"body":"Update from last stable to 0.5 RC\r\n```\r\ndiaspora@diaspora:~/diaspora$ RAILS_ENV=production rake db:migrate\r\nFaraday::Builder is now Faraday::RackBuilder.\r\nRack::SSL is enabled\r\n== 20150106050733 SetMysqlToUnicodeMb4: migrating =============================\r\n-- remove_index(\"aspect_visibilities\", {:name=>\"shareable_and_aspect_id\"})\r\n   -> 0.4451s\r\n-- add_index(\"aspect_visibilities\", [\"shareable_id\", \"shareable_type\", \"aspect_id\"], {:name=>\"shareable_and_aspect_id\", :length=>{\"shareable_type\"=>189}, :using=>:btree})\r\n   -> 0.0737s\r\n-- remove_index(\"aspect_visibilities\", {:name=>\"index_aspect_visibilities_on_shareable_id_and_shareable_type\"})\r\n   -> 0.0705s\r\n-- add_index(\"aspect_visibilities\", [\"shareable_id\", \"shareable_type\"], {:name=>\"index_aspect_visibilities_on_shareable_id_and_shareable_type\", :length=>{\"shareable_type\"=>190}, :using=>:btree})\r\n   -> 0.0749s\r\n-- remove_index(\"chat_contacts\", {:name=>\"index_chat_contacts_on_user_id_and_jid\"})\r\n   -> 0.0693s\r\n-- add_index(\"chat_contacts\", [\"user_id\", \"jid\"], {:name=>\"index_chat_contacts_on_user_id_and_jid\", :length=>{\"jid\"=>190}, :using=>:btree, :unique=>true})\r\n   -> 0.0741s\r\n-- remove_index(\"comments\", {:name=>\"index_comments_on_guid\"})\r\n   -> 0.0734s\r\n-- add_index(\"comments\", [\"guid\"], {:name=>\"index_comments_on_guid\", :length=>{\"guid\"=>191}, :using=>:btree, :unique=>true})\r\n   -> 0.0871s\r\n-- remove_index(\"likes\", {:name=>\"index_likes_on_guid\"})\r\n   -> 0.0989s\r\n-- add_index(\"likes\", [\"guid\"], {:name=>\"index_likes_on_guid\", :length=>{\"guid\"=>191}, :using=>:btree, :unique=>true})\r\n   -> 0.1094s\r\n-- remove_index(\"o_embed_caches\", {:name=>\"index_o_embed_caches_on_url\"})\r\n   -> 0.0736s\r\n-- add_index(\"o_embed_caches\", [\"url\"], {:name=>\"index_o_embed_caches_on_url\", :length=>{\"url\"=>191}, :using=>:btree})\r\n   -> 0.0727s\r\n-- remove_index(\"participations\", {:name=>\"index_participations_on_guid\"})\r\n   -> 0.0748s\r\n-- add_index(\"participations\", [\"guid\"], {:name=>\"index_participations_on_guid\", :length=>{\"guid\"=>191}, :using=>:btree})\r\n   -> 0.1267s\r\n-- remove_index(\"people\", {:name=>\"index_people_on_diaspora_handle\"})\r\n   -> 0.0727s\r\n-- add_index(\"people\", [\"diaspora_handle\"], {:name=>\"index_people_on_diaspora_handle\", :unique=>true, :length=>{\"diaspora_handle\"=>191}})\r\n   -> 0.0793s\r\n-- remove_index(\"people\", {:name=>\"index_people_on_guid\"})\r\n   -> 0.0692s\r\n-- add_index(\"people\", [\"guid\"], {:name=>\"index_people_on_guid\", :length=>{\"guid\"=>191}, :using=>:btree, :unique=>true})\r\n   -> 0.0812s\r\n-- remove_index(\"photos\", {:name=>\"index_photos_on_status_message_guid\"})\r\n   -> 0.0724s\r\n-- add_index(\"photos\", [\"status_message_guid\"], {:name=>\"index_photos_on_status_message_guid\", :length=>{\"status_message_guid\"=>191}, :using=>:btree})\r\n   -> 0.0736s\r\n-- remove_index(\"posts\", {:name=>\"index_posts_on_guid\"})\r\n   -> 0.1095s\r\n-- add_index(\"posts\", [\"guid\"], {:name=>\"index_posts_on_guid\", :length=>{\"guid\"=>191}, :using=>:btree, :unique=>true})\r\n   -> 0.1283s\r\n-- remove_index(\"posts\", {:name=>\"index_posts_on_status_message_guid_and_pending\"})\r\n   -> 0.0830s\r\n-- add_index(\"posts\", [\"status_message_guid\", \"pending\"], {:name=>\"index_posts_on_status_message_guid_and_pending\", :length=>{\"status_message_guid\"=>190}, :using=>:btree})\r\n   -> 0.0913s\r\n-- remove_index(\"posts\", {:name=>\"index_posts_on_status_message_guid\"})\r\n   -> 0.0762s\r\n-- add_index(\"posts\", [\"status_message_guid\"], {:name=>\"index_posts_on_status_message_guid\", :length=>{\"status_message_guid\"=>191}, :using=>:btree})\r\n   -> 0.0937s\r\n-- remove_index(\"posts\", {:name=>\"index_posts_on_author_id_and_root_guid\"})\r\n   -> 0.0786s\r\n-- add_index(\"posts\", [\"author_id\", \"root_guid\"], {:name=>\"index_posts_on_author_id_and_root_guid\", :length=>{\"root_guid\"=>190}, :using=>:btree, :unique=>true})\r\n   -> 0.1042s\r\n-- remove_index(\"posts\", {:name=>\"index_posts_on_root_guid\"})\r\n   -> 0.1016s\r\n-- add_index(\"posts\", [\"root_guid\"], {:name=>\"index_posts_on_root_guid\", :length=>{\"root_guid\"=>191}})\r\n   -> 0.1015s\r\n-- remove_index(\"posts\", {:name=>\"index_posts_on_tweet_id\"})\r\n   -> 0.1066s\r\n-- add_index(\"posts\", [\"tweet_id\"], {:name=>\"index_posts_on_tweet_id\", :length=>{\"tweet_id\"=>191}, :using=>:btree})\r\n   -> 0.1042s\r\n-- remove_index(\"rails_admin_histories\", {:name=>\"index_rails_admin_histories\"})\r\n   -> 0.0749s\r\n-- add_index(\"rails_admin_histories\", [\"item\", \"table\", \"month\", \"year\"], {:name=>\"index_rails_admin_histories\", :length=>{\"table\"=>188}, :using=>:btree})\r\n   -> 0.0791s\r\n-- remove_index(\"schema_migrations\", {:name=>\"unique_schema_migrations\"})\r\n   -> 0.0828s\r\n-- add_index(\"schema_migrations\", [\"version\"], {:name=>\"unique_schema_migrations\", :length=>{\"version\"=>191}, :using=>:btree})\r\n   -> 0.0755s\r\n-- remove_index(\"services\", {:name=>\"index_services_on_type_and_uid\"})\r\n   -> 0.0831s\r\n-- add_index(\"services\", [\"type\", \"uid\"], {:name=>\"index_services_on_type_and_uid\", :length=>{\"type\"=>64, \"uid\"=>127}, :using=>:btree})\r\n   -> 0.0778s\r\n-- remove_index(\"taggings\", {:name=>\"index_taggings_on_taggable_id_and_taggable_type_and_context\"})\r\n   -> 0.0867s\r\n-- add_index(\"taggings\", [\"taggable_id\", \"taggable_type\", \"context\"], {:name=>\"index_taggings_on_taggable_id_and_taggable_type_and_context\", :length=>{\"taggable_type\"=>95, \"context\"=>95}, :using=>:btree})\r\n   -> 0.1304s\r\n-- remove_index(\"tags\", {:name=>\"index_tags_on_name\"})\r\n   -> 0.0770s\r\n-- add_index(\"tags\", [\"name\"], {:name=>\"index_tags_on_name\", :length=>{\"name\"=>191}, :using=>:btree, :unique=>true})\r\n   -> 0.1279s\r\n-- remove_index(\"users\", {:name=>\"index_users_on_invitation_service_and_invitation_identifier\"})\r\n   -> 0.1159s\r\n-- add_index(\"users\", [\"invitation_service\", \"invitation_identifier\"], {:name=>\"index_users_on_invitation_service_and_invitation_identifier\", :length=>{\"invitation_service\"=>64, \"invitation_identifier\"=>127}, :using=>:btree, :unique=>true})\r\n   -> 0.0777s\r\n-- remove_index(\"users\", {:name=>\"index_users_on_username\"})\r\n   -> 0.0807s\r\n-- add_index(\"users\", [\"username\"], {:name=>\"index_users_on_username\", :length=>{\"username\"=>191}, :using=>:btree, :unique=>true})\r\n   -> 0.0804s\r\n-- remove_index(\"users\", {:name=>\"index_users_on_email\"})\r\n   -> 0.0733s\r\n-- add_index(\"users\", [\"email\"], {:name=>\"index_users_on_email\", :length=>{\"email\"=>191}, :using=>:btree})\r\n   -> 0.1111s\r\n-- remove_index(\"notifications\", {:name=>\"index_notifications_on_target_type_and_target_id\"})\r\n   -> 0.0747s\r\n-- add_index(\"notifications\", [\"target_type\", \"target_id\"], {:name=>\"index_notifications_on_target_type_and_target_id\", :length=>{\"target_type\"=>190}, :using=>:btree})\r\n   -> 0.0832s\r\nrake aborted!\r\nStandardError: An error has occurred, all later migrations canceled:\r\n\r\nDatabase encoding is not utf8mb4!/home/diaspora/diaspora/db/migrate/20150106050733_set_mysql_to_unicode_mb4.rb:17:in `check_config'\r\n/home/diaspora/diaspora/db/migrate/20150106050733_set_mysql_to_unicode_mb4.rb:23:in `change_encoding'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:417:in `method_missing'\r\n/home/diaspora/diaspora/db/migrate/20150106050733_set_mysql_to_unicode_mb4.rb:8:in `up'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:569:in `up'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:609:in `exec_migration'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:590:in `block (2 levels) in migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:589:in `block in migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:588:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:765:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:995:in `block in execute_migration_in_transaction'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:1043:in `ddl_transaction'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:994:in `execute_migration_in_transaction'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:956:in `block in migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:952:in `each'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:952:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:820:in `up'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:798:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/tasks/database_tasks.rb:137:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/bin/ruby_executable_hooks:15:in `eval'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/bin/ruby_executable_hooks:15:in `<main>'\r\nDatabase encoding is not utf8mb4!\r\n/home/diaspora/diaspora/db/migrate/20150106050733_set_mysql_to_unicode_mb4.rb:17:in `check_config'\r\n/home/diaspora/diaspora/db/migrate/20150106050733_set_mysql_to_unicode_mb4.rb:23:in `change_encoding'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:417:in `method_missing'\r\n/home/diaspora/diaspora/db/migrate/20150106050733_set_mysql_to_unicode_mb4.rb:8:in `up'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:569:in `up'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:609:in `exec_migration'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:590:in `block (2 levels) in migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:589:in `block in migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:588:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:765:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:995:in `block in execute_migration_in_transaction'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:1043:in `ddl_transaction'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:994:in `execute_migration_in_transaction'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:956:in `block in migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:952:in `each'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:952:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:820:in `up'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/migration.rb:798:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/tasks/database_tasks.rb:137:in `migrate'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/bin/ruby_executable_hooks:15:in `eval'\r\n/home/diaspora/.rvm/gems/ruby-2.1.5/bin/ruby_executable_hooks:15:in `<main>'\r\nTasks: TOP => db:migrate\r\n(See full trace by running task with --trace)\r\n```\r\n\r\n> diaspora@diaspora:~/diaspora$ mysql --version\r\nmysql  Ver 14.14 Distrib 5.5.41, for debian-linux-gnu (x86_64) using readline 6.2\r\n\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/10498946-database-ecoding-is-not-utf8mb4?utm_campaign=plugin&utm_content=tracker%2F522&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F522&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/diaspora/diaspora/issues/comments/89732661","html_url":"https://github.com/diaspora/diaspora/issues/5851#issuecomment-89732661","issue_url":"https://api.github.com/repos/diaspora/diaspora/issues/5851","id":89732661,"user":{"login":"nazar-pc","id":928965,"avatar_url":"https://avatars.githubusercontent.com/u/928965?v=3","gravatar_id":"","url":"https://api.github.com/users/nazar-pc","html_url":"https://github.com/nazar-pc","followers_url":"https://api.github.com/users/nazar-pc/followers","following_url":"https://api.github.com/users/nazar-pc/following{/other_user}","gists_url":"https://api.github.com/users/nazar-pc/gists{/gist_id}","starred_url":"https://api.github.com/users/nazar-pc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nazar-pc/subscriptions","organizations_url":"https://api.github.com/users/nazar-pc/orgs","repos_url":"https://api.github.com/users/nazar-pc/repos","events_url":"https://api.github.com/users/nazar-pc/events{/privacy}","received_events_url":"https://api.github.com/users/nazar-pc/received_events","type":"User","site_admin":false},"created_at":"2015-04-05T08:00:42Z","updated_at":"2015-04-05T08:00:42Z","body":"After commenting:\r\n```\r\n    raise \"Database encoding is not #{encoding}!\"   if connection_config[:encoding] != encoding\r\n    raise \"Database collation is not #{collation}!\" if connection_config[:collation] != collation\r\n```\r\nMigrations finished successfully"}}