{"action":"closed","issue":{"url":"https://api.github.com/repos/rcbops/rpc-openstack/issues/556","labels_url":"https://api.github.com/repos/rcbops/rpc-openstack/issues/556/labels{/name}","comments_url":"https://api.github.com/repos/rcbops/rpc-openstack/issues/556/comments","events_url":"https://api.github.com/repos/rcbops/rpc-openstack/issues/556/events","html_url":"https://github.com/rcbops/rpc-openstack/issues/556","id":115850474,"number":556,"title":"Race in `Create rpc_support backup user`","user":{"login":"byronmccollum","id":954353,"avatar_url":"https://avatars.githubusercontent.com/u/954353?v=3","gravatar_id":"","url":"https://api.github.com/users/byronmccollum","html_url":"https://github.com/byronmccollum","followers_url":"https://api.github.com/users/byronmccollum/followers","following_url":"https://api.github.com/users/byronmccollum/following{/other_user}","gists_url":"https://api.github.com/users/byronmccollum/gists{/gist_id}","starred_url":"https://api.github.com/users/byronmccollum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/byronmccollum/subscriptions","organizations_url":"https://api.github.com/users/byronmccollum/orgs","repos_url":"https://api.github.com/users/byronmccollum/repos","events_url":"https://api.github.com/users/byronmccollum/events{/privacy}","received_events_url":"https://api.github.com/users/byronmccollum/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-11-09T10:42:18Z","updated_at":"2015-11-12T10:33:03Z","closed_at":"2015-11-12T10:33:03Z","body":"When using more than 1 Galera node, there is a potential for a race condition here. Should probably add a `when:` criteria to target only the 1st Galera node. This has gone mostly unnoticed up until `successerator` was removed from the deployment script, as subsequent runs would report OK for all nodes.\r\n\r\n```\r\nTASK: [rpc_support | Create rpc_support backup user] ************************** \r\nchanged: [6b42452f-infra1_galera_container-9e5a76b6] => (item={'priv': '*.*:ALL', 'state': 'present', 'password': u'xxxxxxxxxx', 'host': '%', 'name': 'rpc_support'})\r\nchanged: [6b42452f-infra1_galera_container-9e5a76b6] => (item={'priv': '*.*:ALL', 'state': 'present', 'password': u'xxxxxxxxxx', 'host': 'localhost', 'name': 'rpc_support'})\r\nok: [6b42452f-infra1_galera_container-eee49e6c] => (item={'priv': '*.*:ALL', 'state': 'present', 'password': u'xxxxxxxxxx', 'host': '%', 'name': 'rpc_support'})\r\nok: [6b42452f-infra1_galera_container-eee49e6c] => (item={'priv': '*.*:ALL', 'state': 'present', 'password': u'xxxxxxxxxx', 'host': 'localhost', 'name': 'rpc_support'})\r\nfailed: [6b42452f-infra1_galera_container-3cefeb83] => (item={'priv': '*.*:ALL', 'state': 'present', 'password': u'xxxxxxxxxx', 'host': '%', 'name': 'rpc_support'}) => {\"failed\": true, \"item\": {\"host\": \"%\", \"name\": \"rpc_support\", \"password\": \"xxxxxxxxxx\", \"priv\": \"*.*:ALL\", \"state\": \"present\"}}\r\nmsg: (1396, \"Operation CREATE USER failed for 'rpc_support'@'%'\")\r\nok: [6b42452f-infra1_galera_container-3cefeb83] => (item={'priv': '*.*:ALL', 'state': 'present', 'password': u'xxxxxxxxxx', 'host': 'localhost', 'name': 'rpc_support'})\r\n```"}}