{"action":"created","issue":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/6383","labels_url":"https://api.github.com/repos/dmwm/WMCore/issues/6383/labels{/name}","comments_url":"https://api.github.com/repos/dmwm/WMCore/issues/6383/comments","events_url":"https://api.github.com/repos/dmwm/WMCore/issues/6383/events","html_url":"https://github.com/dmwm/WMCore/pull/6383","id":115278292,"number":6383,"title":"dbsbuffer changes to work around race condition between dbs and phedex updates","user":{"login":"hufnagel","id":1798355,"avatar_url":"https://avatars.githubusercontent.com/u/1798355?v=3","gravatar_id":"","url":"https://api.github.com/users/hufnagel","html_url":"https://github.com/hufnagel","followers_url":"https://api.github.com/users/hufnagel/followers","following_url":"https://api.github.com/users/hufnagel/following{/other_user}","gists_url":"https://api.github.com/users/hufnagel/gists{/gist_id}","starred_url":"https://api.github.com/users/hufnagel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hufnagel/subscriptions","organizations_url":"https://api.github.com/users/hufnagel/orgs","repos_url":"https://api.github.com/users/hufnagel/repos","events_url":"https://api.github.com/users/hufnagel/events{/privacy}","received_events_url":"https://api.github.com/users/hufnagel/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dmwm/WMCore/labels/Medium%20Priority","name":"Medium Priority","color":"d7e102"}],"state":"closed","locked":false,"assignee":{"login":"hufnagel","id":1798355,"avatar_url":"https://avatars.githubusercontent.com/u/1798355?v=3","gravatar_id":"","url":"https://api.github.com/users/hufnagel","html_url":"https://github.com/hufnagel","followers_url":"https://api.github.com/users/hufnagel/followers","following_url":"https://api.github.com/users/hufnagel/following{/other_user}","gists_url":"https://api.github.com/users/hufnagel/gists{/gist_id}","starred_url":"https://api.github.com/users/hufnagel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hufnagel/subscriptions","organizations_url":"https://api.github.com/users/hufnagel/orgs","repos_url":"https://api.github.com/users/hufnagel/repos","events_url":"https://api.github.com/users/hufnagel/events{/privacy}","received_events_url":"https://api.github.com/users/hufnagel/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/dmwm/WMCore/milestones/118","html_url":"https://github.com/dmwm/WMCore/milestones/WMAgent1511","labels_url":"https://api.github.com/repos/dmwm/WMCore/milestones/118/labels","id":1245708,"number":118,"title":"WMAgent1511","description":"","creator":{"login":"ticoann","id":1247993,"avatar_url":"https://avatars.githubusercontent.com/u/1247993?v=3","gravatar_id":"","url":"https://api.github.com/users/ticoann","html_url":"https://github.com/ticoann","followers_url":"https://api.github.com/users/ticoann/followers","following_url":"https://api.github.com/users/ticoann/following{/other_user}","gists_url":"https://api.github.com/users/ticoann/gists{/gist_id}","starred_url":"https://api.github.com/users/ticoann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ticoann/subscriptions","organizations_url":"https://api.github.com/users/ticoann/orgs","repos_url":"https://api.github.com/users/ticoann/repos","events_url":"https://api.github.com/users/ticoann/events{/privacy}","received_events_url":"https://api.github.com/users/ticoann/received_events","type":"User","site_admin":false},"open_issues":31,"closed_issues":14,"state":"open","created_at":"2015-08-07T15:47:51Z","updated_at":"2015-11-19T20:03:36Z","due_on":"2015-11-30T06:00:00Z","closed_at":null},"comments":19,"created_at":"2015-11-05T12:57:25Z","updated_at":"2015-11-20T19:30:51Z","closed_at":"2015-11-18T17:45:50Z","pull_request":{"url":"https://api.github.com/repos/dmwm/WMCore/pulls/6383","html_url":"https://github.com/dmwm/WMCore/pull/6383","diff_url":"https://github.com/dmwm/WMCore/pull/6383.diff","patch_url":"https://github.com/dmwm/WMCore/pull/6383.patch"},"body":"Both PhEDExInjector and DBS3Buffer components update dbsbuffer_file records. They do it in a way that the two updates can deadlock each other. General slow performance of dbsbuffer related code makes this quite likely to happen, therefor rework and simplify the schema (add some indexes, remove triggers, general cleanup).\r\n\r\nNo functional changes and the cleanup and indexes are only done on Oracle for now as some of it is very Oracle specific. We could sync the MySQL version later if so desired.\r\n\r\nAlso put in recovery logic to at least retry once in each component if deadlock occurs."},"comment":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/comments/158502663","html_url":"https://github.com/dmwm/WMCore/pull/6383#issuecomment-158502663","issue_url":"https://api.github.com/repos/dmwm/WMCore/issues/6383","id":158502663,"user":{"login":"ticoann","id":1247993,"avatar_url":"https://avatars.githubusercontent.com/u/1247993?v=3","gravatar_id":"","url":"https://api.github.com/users/ticoann","html_url":"https://github.com/ticoann","followers_url":"https://api.github.com/users/ticoann/followers","following_url":"https://api.github.com/users/ticoann/following{/other_user}","gists_url":"https://api.github.com/users/ticoann/gists{/gist_id}","starred_url":"https://api.github.com/users/ticoann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ticoann/subscriptions","organizations_url":"https://api.github.com/users/ticoann/orgs","repos_url":"https://api.github.com/users/ticoann/repos","events_url":"https://api.github.com/users/ticoann/events{/privacy}","received_events_url":"https://api.github.com/users/ticoann/received_events","type":"User","site_admin":false},"created_at":"2015-11-20T19:30:51Z","updated_at":"2015-11-20T19:30:51Z","body":"Hmm, I didn't get this error on my test either."}}