{"action":"created","issue":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/603","repository_url":"https://api.github.com/repos/HangfireIO/Hangfire","labels_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/603/labels{/name}","comments_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/603/comments","events_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/603/events","html_url":"https://github.com/HangfireIO/Hangfire/pull/603","id":163144810,"number":603,"title":"Drop constraints on Server.Id prior to altering it to avoid conflicts","user":{"login":"ranieuwe","id":2513121,"avatar_url":"https://avatars.githubusercontent.com/u/2513121?v=3","gravatar_id":"","url":"https://api.github.com/users/ranieuwe","html_url":"https://github.com/ranieuwe","followers_url":"https://api.github.com/users/ranieuwe/followers","following_url":"https://api.github.com/users/ranieuwe/following{/other_user}","gists_url":"https://api.github.com/users/ranieuwe/gists{/gist_id}","starred_url":"https://api.github.com/users/ranieuwe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ranieuwe/subscriptions","organizations_url":"https://api.github.com/users/ranieuwe/orgs","repos_url":"https://api.github.com/users/ranieuwe/repos","events_url":"https://api.github.com/users/ranieuwe/events{/privacy}","received_events_url":"https://api.github.com/users/ranieuwe/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-06-30T11:40:15Z","updated_at":"2016-07-12T12:27:32Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/pulls/603","html_url":"https://github.com/HangfireIO/Hangfire/pull/603","diff_url":"https://github.com/HangfireIO/Hangfire/pull/603.diff","patch_url":"https://github.com/HangfireIO/Hangfire/pull/603.patch"},"body":"Currently running schema 3, and the alter statements for [Hangfire].[Server].[Id] in the schema 4 => 5 transition table fail because of a the clustered index that is referencing the [Id].\r\n\r\nThis is solved by dropping the constraint, doing the alter, and adding the constraint back. \r\n\r\nSurprisingly enough I could not replay this with a default run of the (Default)Install.sql script. I can only replicate this with a copy of our production database. Manually recreating the table (drop + create to from SSMS) did not recreate this issue either. "},"comment":{"url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/comments/232032245","html_url":"https://github.com/HangfireIO/Hangfire/pull/603#issuecomment-232032245","issue_url":"https://api.github.com/repos/HangfireIO/Hangfire/issues/603","id":232032245,"user":{"login":"odinserj","id":1078718,"avatar_url":"https://avatars.githubusercontent.com/u/1078718?v=3","gravatar_id":"","url":"https://api.github.com/users/odinserj","html_url":"https://github.com/odinserj","followers_url":"https://api.github.com/users/odinserj/followers","following_url":"https://api.github.com/users/odinserj/following{/other_user}","gists_url":"https://api.github.com/users/odinserj/gists{/gist_id}","starred_url":"https://api.github.com/users/odinserj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/odinserj/subscriptions","organizations_url":"https://api.github.com/users/odinserj/orgs","repos_url":"https://api.github.com/users/odinserj/repos","events_url":"https://api.github.com/users/odinserj/events{/privacy}","received_events_url":"https://api.github.com/users/odinserj/received_events","type":"User","site_admin":false},"created_at":"2016-07-12T12:27:32Z","updated_at":"2016-07-12T12:27:32Z","body":"Thanks for submitting the PR, @ranieuwe, merging!"}}
{"actor":{"display_login":"odinserj"}}