)]}'
{"nova/db/sqlalchemy/migrate_repo/versions/077_convert_to_utf8.py":[{"author":{"_account_id":100,"name":"Johannes Erdfelt","email":"johannes@erdfelt.com","username":"johannes.erdfelt"},"change_message_id":"4a1ed9a21e5a151f97d578ae5fa91e8bb4feaec6","unresolved":false,"context_lines":[{"line_number":33,"context_line":"        # foreign_key_checks has to be disabled inside of the execute command"},{"line_number":34,"context_line":"        # that converts the instances table."},{"line_number":35,"context_line":"        migrate_engine.execute(\"SET foreign_key_checks \u003d 0;\""},{"line_number":36,"context_line":"            \"ALTER TABLE instances CONVERT TO CHARACTER SET utf8\")"},{"line_number":37,"context_line":"        tables \u003d [\"agent_builds\", \"aggregate_hosts\", \"aggregate_metadata\","},{"line_number":38,"context_line":"            \"aggregates\", \"auth_tokens\", \"block_device_mapping\","},{"line_number":39,"context_line":"            \"bw_usage_cache\", \"certificates\", \"compute_nodes\", \"console_pools\","}],"source_content_type":"text/x-python","patch_set":5,"id":"AAAAEn%2F%2F75Y%3D","line":36,"updated":"2012-02-10 23:38:46.000000000","message":"Why is this alter table separate from all of the other ones?","commit_id":"b196f4be831659904d33fe1e3955eaf5224497e0"},{"author":{"_account_id":1955,"name":"Alan Pevec","email":"alan.pevec@redhat.com","username":"apevec"},"change_message_id":"8ab49eebc48be4bc046778f240dde865b33cd56b","unresolved":false,"context_lines":[{"line_number":33,"context_line":"        # foreign_key_checks has to be disabled inside of the execute command"},{"line_number":34,"context_line":"        # that converts the instances table."},{"line_number":35,"context_line":"        migrate_engine.execute(\"SET foreign_key_checks \u003d 0;\""},{"line_number":36,"context_line":"            \"ALTER TABLE instances CONVERT TO CHARACTER SET utf8\")"},{"line_number":37,"context_line":"        tables \u003d [\"agent_builds\", \"aggregate_hosts\", \"aggregate_metadata\","},{"line_number":38,"context_line":"            \"aggregates\", \"auth_tokens\", \"block_device_mapping\","},{"line_number":39,"context_line":"            \"bw_usage_cache\", \"certificates\", \"compute_nodes\", \"console_pools\","}],"source_content_type":"text/x-python","patch_set":5,"id":"AAAAEn%2F%2F7Vo%3D","line":36,"in_reply_to":"AAAAEn%2F%2F75I%3D","updated":"2012-02-13 22:43:30.000000000","message":"I got errno 150 on table \u0027projects\u0027 with mysql db - shouldn\u0027t that table be handled separately too?","commit_id":"b196f4be831659904d33fe1e3955eaf5224497e0"},{"author":{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},"change_message_id":"20d6da208951f4dda35673b184007b3d69854ebc","unresolved":false,"context_lines":[{"line_number":33,"context_line":"        # foreign_key_checks has to be disabled inside of the execute command"},{"line_number":34,"context_line":"        # that converts the instances table."},{"line_number":35,"context_line":"        migrate_engine.execute(\"SET foreign_key_checks \u003d 0;\""},{"line_number":36,"context_line":"            \"ALTER TABLE instances CONVERT TO CHARACTER SET utf8\")"},{"line_number":37,"context_line":"        tables \u003d [\"agent_builds\", \"aggregate_hosts\", \"aggregate_metadata\","},{"line_number":38,"context_line":"            \"aggregates\", \"auth_tokens\", \"block_device_mapping\","},{"line_number":39,"context_line":"            \"bw_usage_cache\", \"certificates\", \"compute_nodes\", \"console_pools\","}],"source_content_type":"text/x-python","patch_set":5,"id":"AAAAEn%2F%2F75I%3D","line":36,"in_reply_to":"AAAAEn%2F%2F75Y%3D","updated":"2012-02-10 23:40:54.000000000","message":"The instances table has to be converted early on because of foreign key issues. I put the rest of the tables in alphabetical order.","commit_id":"b196f4be831659904d33fe1e3955eaf5224497e0"},{"author":{"_account_id":998,"name":"Naveed Massjouni","email":"naveedm9@gmail.com","username":"ironcamel"},"change_message_id":"7cc62010ea547f96c7c2d725fd7a9e53aee69d2c","unresolved":false,"context_lines":[{"line_number":33,"context_line":"        # foreign_key_checks has to be disabled inside of the execute command"},{"line_number":34,"context_line":"        # that converts the instances table."},{"line_number":35,"context_line":"        migrate_engine.execute(\"SET foreign_key_checks \u003d 0;\""},{"line_number":36,"context_line":"            \"ALTER TABLE instances CONVERT TO CHARACTER SET utf8\")"},{"line_number":37,"context_line":"        tables \u003d [\"agent_builds\", \"aggregate_hosts\", \"aggregate_metadata\","},{"line_number":38,"context_line":"            \"aggregates\", \"auth_tokens\", \"block_device_mapping\","},{"line_number":39,"context_line":"            \"bw_usage_cache\", \"certificates\", \"compute_nodes\", \"console_pools\","}],"source_content_type":"text/x-python","patch_set":5,"id":"AAAAEn%2F%2F6SU%3D","line":36,"in_reply_to":"AAAAEn%2F%2F7Vo%3D","updated":"2012-02-15 19:34:40.000000000","message":"Alan, you may be right. I never tested this upgrade with real data in the db. Though I\u0027m not sure if having data in the projects table or not should matter. The reason there was a special case with the instances table was due to foreign keys. Mysql did not like it when the key column and its parent column were of different encodings.","commit_id":"b196f4be831659904d33fe1e3955eaf5224497e0"}]}