)]}'
{"id":"openstack%2Fdevstack~4221","triplet_id":"openstack%2Fdevstack~master~Ifdbdd1649b7688c5e7fdad421b49437f9df4664e","project":"openstack/devstack","branch":"master","topic":"bug/933208","hashtags":[],"change_id":"Ifdbdd1649b7688c5e7fdad421b49437f9df4664e","subject":"Converts all tables and connections (except Nova) to UTF8.","status":"ABANDONED","created":"2012-02-16 01:40:43.000000000","updated":"2012-03-29 22:35:24.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"31caafecc9b6d49ce6ba4f0c5f3e839510602a51","_number":4221,"virtual_id_number":4221,"owner":{"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"},"actions":{},"labels":{"Verified":{"all":[{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},{"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"date":"2012-02-21 19:54:20.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},{"value":0,"date":"2012-02-23 17:02:12.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"all":[{"date":"2012-02-21 19:54:20.000000000","_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},{"value":0,"date":"2012-02-16 01:41:20.000000000","permitted_voting_range":{"min":-1,"max":0},"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},{"value":0,"permitted_voting_range":{"min":0,"max":2},"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},{"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2012-02-21 19:54:20.000000000","updated_by":{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},"reviewer":{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},"state":"REVIEWER"},{"updated":"2012-02-23 17:02:12.000000000","updated_by":{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},"reviewer":{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},"state":"REVIEWER"}],"messages":[{"id":"ab2a6c5946d7c4dacb0d470fb96a276fcc27b844","author":{"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"},"date":"2012-02-16 01:41:20.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"45bfdb3663e91fc2962ab5e41c2a3035ba0de196","author":{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},"date":"2012-02-21 19:54:20.000000000","message":"Patch Set 2:\n\nWould something like this be cleaner?  http://notes.timeghost.net/2008/10/utf-8-and-mycnf.html","accounts_in_message":[],"_revision_number":2},{"id":"d1b7c79372f0017805b7a73826d7587203ed5a2b","author":{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},"date":"2012-02-21 20:00:34.000000000","message":"Patch Set 2:\n\nMeaning, make the default utf-8, explicitly special-case nova, and explain the bug.","accounts_in_message":[],"_revision_number":2},{"id":"2e4c2e40b01209186d7ab8292d7d74a2d69e1a7e","author":{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},"date":"2012-02-23 17:02:12.000000000","message":"Patch Set 2:\n\nNova has been utf8ified recently. So we should update the mysql connection string as well:\n\n    add_nova_flag \"--sql_connection\u003d$BASE_SQL_CONN/nova?charset\u003dutf8\"\n\nI have tested this and was able to create servers with unicode characters in its name, but it required the above change.","accounts_in_message":[],"_revision_number":2},{"id":"11cbd04890f777a86536437494343ef77db67a41","author":{"_account_id":9,"name":"LaunchpadSync","username":"launchpadsync"},"date":"2012-03-09 06:03:02.000000000","message":"Patch Set 2: Abandoned\n\ncode review expired after 2 weeks of no activity","accounts_in_message":[],"_revision_number":2},{"id":"f3489597957fc240caf48eb8ba1ae16a255df57e","author":{"_account_id":9,"name":"LaunchpadSync","username":"launchpadsync"},"date":"2012-03-09 06:03:02.000000000","message":"Patch Set 2:\n\ncode review expired after 2 weeks of no activity","accounts_in_message":[],"_revision_number":2},{"id":"a64b04c4c9751f2cbb77bd06e9bfbb4035e02400","author":{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},"date":"2012-03-09 16:10:18.000000000","message":"Patch Set 2:\n\nI think this is an easy win... can we get this in?","accounts_in_message":[],"_revision_number":2},{"id":"3a78c3b59515a3792a672793c9a5b68fc31a61da","author":{"_account_id":1155,"name":"sleepsonthefloor","username":"sleepsonthefloor"},"date":"2012-03-29 16:33:35.000000000","message":"Patch Set 2:\n\nThis just needs to be tweaked per naveed\u0027s comment","accounts_in_message":[],"_revision_number":2},{"id":"1f712c8d598747d5b5fa67cf448fb82d62a4749d","author":{"_account_id":970,"name":"Dean Troyer","email":"dtroyer@gmail.com","username":"dtroyer"},"date":"2012-03-29 22:35:24.000000000","message":"Patch Set 2:\n\nI re-proposed this in https://review.openstack.org/5977 with the addition noted by Naveed Massjouni above.","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"3da2f8cab14154e22df3dde2b74c2f8ade4719fa","revisions":{"b5b8df9f404614490160d9793d1a5bd63a923510":{"kind":"REWORK","_number":1,"created":"2012-02-16 01:40:43.000000000","uploader":{"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"},"ref":"refs/changes/21/4221/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/21/4221/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/21/4221/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/21/4221/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/21/4221/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/21/4221/1"}}},"commit":{"parents":[{"commit":"131774e004d1ee5e2dc83b8c4a9dd1aef03a5a62","subject":"Merge \"Not all distros include a symlink from euca-describe-group to euca-describe-groups\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/131774e004d1ee5e2dc83b8c4a9dd1aef03a5a62"}]}],"author":{"name":"Gabriel Hurley","email":"gabriel@strikeawe.com","date":"2012-02-16 01:39:05.000000000","tz":-480},"committer":{"name":"Gabriel Hurley","email":"gabriel@strikeawe.com","date":"2012-02-16 01:39:05.000000000","tz":-480},"subject":"Converts all tables and connections (except Nova) to UTF8.","message":"Converts all tables and connections (except Nova) to UTF8.\n\nNova cannot be converted at this time becuase an auto-generated\nkey in the nova migrations exceeds MySQL\u0027s internal 1000-byte limit\nfor key names when encoded on the 3-byte UTF8 instead of the 1-byte\nlatin-1.\n\nChange-Id: Ifdbdd1649b7688c5e7fdad421b49437f9df4664e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/b5b8df9f404614490160d9793d1a5bd63a923510"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/b5b8df9f404614490160d9793d1a5bd63a923510"}]},"branch":"refs/heads/master"},"3da2f8cab14154e22df3dde2b74c2f8ade4719fa":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2012-02-16 01:41:20.000000000","uploader":{"_account_id":1816,"name":"Gabriel Hurley","email":"gabriel.hurley@nebula.com","username":"gabriel-hurley"},"ref":"refs/changes/21/4221/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/devstack","ref":"refs/changes/21/4221/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/devstack refs/changes/21/4221/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/devstack refs/changes/21/4221/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/devstack refs/changes/21/4221/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/devstack refs/changes/21/4221/2"}}},"commit":{"parents":[{"commit":"131774e004d1ee5e2dc83b8c4a9dd1aef03a5a62","subject":"Merge \"Not all distros include a symlink from euca-describe-group to euca-describe-groups\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/131774e004d1ee5e2dc83b8c4a9dd1aef03a5a62"}]}],"author":{"name":"Gabriel Hurley","email":"gabriel@strikeawe.com","date":"2012-02-16 01:39:05.000000000","tz":-480},"committer":{"name":"Gabriel Hurley","email":"gabriel@strikeawe.com","date":"2012-02-16 01:40:57.000000000","tz":-480},"subject":"Converts all tables and connections (except Nova) to UTF8.","message":"Converts all tables and connections (except Nova) to UTF8.\n\nNova cannot be converted at this time becuase an auto-generated\nkey in the nova migrations exceeds MySQL\u0027s internal 1000-byte limit\nfor key names when encoded on the 3-byte UTF8 instead of the 1-byte\nlatin-1.\n\nReferences bug 933208.\n\nChange-Id: Ifdbdd1649b7688c5e7fdad421b49437f9df4664e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/3da2f8cab14154e22df3dde2b74c2f8ade4719fa"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/devstack/commit/3da2f8cab14154e22df3dde2b74c2f8ade4719fa"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}