{"action":"created","issue":{"url":"https://api.github.com/repos/openSUSE/open-build-service/issues/1017","labels_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/1017/labels{/name}","comments_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/1017/comments","events_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/1017/events","html_url":"https://github.com/openSUSE/open-build-service/issues/1017","id":99381963,"number":1017,"title":"20150716124906 AddTypeToProject migration fails","user":{"login":"adrianschroeter","id":1067148,"avatar_url":"https://avatars.githubusercontent.com/u/1067148?v=3","gravatar_id":"","url":"https://api.github.com/users/adrianschroeter","html_url":"https://github.com/adrianschroeter","followers_url":"https://api.github.com/users/adrianschroeter/followers","following_url":"https://api.github.com/users/adrianschroeter/following{/other_user}","gists_url":"https://api.github.com/users/adrianschroeter/gists{/gist_id}","starred_url":"https://api.github.com/users/adrianschroeter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adrianschroeter/subscriptions","organizations_url":"https://api.github.com/users/adrianschroeter/orgs","repos_url":"https://api.github.com/users/adrianschroeter/repos","events_url":"https://api.github.com/users/adrianschroeter/events{/privacy}","received_events_url":"https://api.github.com/users/adrianschroeter/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openSUSE/open-build-service/labels/api","name":"api","color":"DDDDDD"},{"url":"https://api.github.com/repos/openSUSE/open-build-service/labels/Bug","name":"Bug","color":"eb6420"},{"url":"https://api.github.com/repos/openSUSE/open-build-service/labels/P2","name":"P2","color":"eb6420"},{"url":"https://api.github.com/repos/openSUSE/open-build-service/labels/Regression","name":"Regression","color":"ff00ff"}],"state":"closed","locked":false,"assignee":{"login":"hennevogel","id":514785,"avatar_url":"https://avatars.githubusercontent.com/u/514785?v=3","gravatar_id":"","url":"https://api.github.com/users/hennevogel","html_url":"https://github.com/hennevogel","followers_url":"https://api.github.com/users/hennevogel/followers","following_url":"https://api.github.com/users/hennevogel/following{/other_user}","gists_url":"https://api.github.com/users/hennevogel/gists{/gist_id}","starred_url":"https://api.github.com/users/hennevogel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hennevogel/subscriptions","organizations_url":"https://api.github.com/users/hennevogel/orgs","repos_url":"https://api.github.com/users/hennevogel/repos","events_url":"https://api.github.com/users/hennevogel/events{/privacy}","received_events_url":"https://api.github.com/users/hennevogel/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2015-08-06T08:07:09Z","updated_at":"2015-08-06T15:12:14Z","closed_at":"2015-08-06T13:37:08Z","body":"The new migration fails, luckily after all important things happened and manual cleanup can be done without service disruption. However, we need to find the reason for it at least.\r\n\r\n-- remove_foreign_key(:projects, {:name=>\"projects_ibfk_1\"})\r\nrake aborted!\r\nStandardError: An error has occurred, all later migrations canceled:\r\n\r\nMysql2::Error: Error on rename of './obs_production/projects' to './obs_production/#sql2-503a-26837' (errno: 152): ALTER TABLE `projects` DROP FOREIGN KEY projects_ibfk_1/srv/www/obs/api/db/migrate/20150716124906_add_type_to_project.rb:19:in `up'\r\n/usr/bin/rake.ruby2.2:33:in `<main>'\r\nActiveRecord::StatementInvalid: Mysql2::Error: Error on rename of './obs_production/projects' to './obs_production/#sql2-503a-26837' (errno: 152): ALTER TABLE `projects` DROP FOREIGN KEY projects_ibfk_1\r\n/srv/www/obs/api/db/migrate/20150716124906_add_type_to_project.rb:19:in `up'\r\n/usr/bin/rake.ruby2.2:33:in `<main>'\r\nMysql2::Error: Error on rename of './obs_production/projects' to './obs_production/#sql2-503a-26837' (errno: 152)\r\n/srv/www/obs/api/db/migrate/20150716124906_add_type_to_project.rb:19:in `up'\r\n/usr/bin/rake.ruby2.2:33:in `<main>'\r\nTasks: TOP => db:migrate\r\n(See full trace by running task with --trace)\r\n"},"comment":{"url":"https://api.github.com/repos/openSUSE/open-build-service/issues/comments/128406839","html_url":"https://github.com/openSUSE/open-build-service/issues/1017#issuecomment-128406839","issue_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/1017","id":128406839,"user":{"login":"hennevogel","id":514785,"avatar_url":"https://avatars.githubusercontent.com/u/514785?v=3","gravatar_id":"","url":"https://api.github.com/users/hennevogel","html_url":"https://github.com/hennevogel","followers_url":"https://api.github.com/users/hennevogel/followers","following_url":"https://api.github.com/users/hennevogel/following{/other_user}","gists_url":"https://api.github.com/users/hennevogel/gists{/gist_id}","starred_url":"https://api.github.com/users/hennevogel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hennevogel/subscriptions","organizations_url":"https://api.github.com/users/hennevogel/orgs","repos_url":"https://api.github.com/users/hennevogel/repos","events_url":"https://api.github.com/users/hennevogel/events{/privacy}","received_events_url":"https://api.github.com/users/hennevogel/received_events","type":"User","site_admin":false},"created_at":"2015-08-06T15:12:14Z","updated_at":"2015-08-06T15:12:14Z","body":"This production issues now tracked in https://progress.opensuse.org/issues/8440"}}