{"action":"created","issue":{"url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/494","labels_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/494/labels{/name}","comments_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/494/comments","events_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/494/events","html_url":"https://github.com/revive-adserver/revive-adserver/issues/494","id":63004722,"number":494,"title":"DB Deadlock","user":{"login":"onaydenov","id":11557435,"avatar_url":"https://avatars.githubusercontent.com/u/11557435?v=3","gravatar_id":"","url":"https://api.github.com/users/onaydenov","html_url":"https://github.com/onaydenov","followers_url":"https://api.github.com/users/onaydenov/followers","following_url":"https://api.github.com/users/onaydenov/following{/other_user}","gists_url":"https://api.github.com/users/onaydenov/gists{/gist_id}","starred_url":"https://api.github.com/users/onaydenov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/onaydenov/subscriptions","organizations_url":"https://api.github.com/users/onaydenov/orgs","repos_url":"https://api.github.com/users/onaydenov/repos","events_url":"https://api.github.com/users/onaydenov/events{/privacy}","received_events_url":"https://api.github.com/users/onaydenov/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-03-19T14:32:17Z","updated_at":"2015-04-05T07:55:31Z","closed_at":"2015-04-05T07:55:31Z","body":"Deadlock found when tried to unlink campaigns from zone.\r\nDetails:\r\nAn error occurred while accessing the database\r\n\r\nDue to a problem with the database Revive Adserver couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Revive Adserver. Please report the following information to the creators of Revive Adserver. Also try to describe the actions that led to this error as clearly as possible.\r\n\r\nVersion:    Revive Adserver v3.0.5\r\nPHP/DB: PHP 5.4.33 / MySQL 5.6.20-68.0-log\r\nPage: /admin/zone-include.php\r\nError: Deadlock found when trying to get lock; try restarting transaction\r\nQuery: \r\nDELETE FROM rv_ad_zone_assoc  WHERE (  rv_ad_zone_assoc.zone_id = 461 )  AND (  rv_ad_zone_assoc.ad_id = 707 )\r\n$_POST: \r\nEmpty\r\n$_GET: \r\nArray\r\n(\r\n    [affiliateid] => 93\r\n    [zoneid] => 461\r\n    [campaignid] => 399\r\n    [action] => remove\r\n)"},"comment":{"url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/comments/89731778","html_url":"https://github.com/revive-adserver/revive-adserver/issues/494#issuecomment-89731778","issue_url":"https://api.github.com/repos/revive-adserver/revive-adserver/issues/494","id":89731778,"user":{"login":"mbeccati","id":282388,"avatar_url":"https://avatars.githubusercontent.com/u/282388?v=3","gravatar_id":"","url":"https://api.github.com/users/mbeccati","html_url":"https://github.com/mbeccati","followers_url":"https://api.github.com/users/mbeccati/followers","following_url":"https://api.github.com/users/mbeccati/following{/other_user}","gists_url":"https://api.github.com/users/mbeccati/gists{/gist_id}","starred_url":"https://api.github.com/users/mbeccati/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbeccati/subscriptions","organizations_url":"https://api.github.com/users/mbeccati/orgs","repos_url":"https://api.github.com/users/mbeccati/repos","events_url":"https://api.github.com/users/mbeccati/events{/privacy}","received_events_url":"https://api.github.com/users/mbeccati/received_events","type":"User","site_admin":false},"created_at":"2015-04-05T07:55:31Z","updated_at":"2015-04-05T07:55:31Z","body":"Closing for now. Please re-open / comment if it happens again."}}