{"action":"created","issue":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/267","repository_url":"https://api.github.com/repos/2ndQuadrant/bdr","labels_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/267/labels{/name}","comments_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/267/comments","events_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/267/events","html_url":"https://github.com/2ndQuadrant/bdr/issues/267","id":186853246,"number":267,"title":"Necessary permissions on bdr.bdr_conflict_handlers not granted automatically","user":{"login":"bneumeier","id":9076,"avatar_url":"https://avatars.githubusercontent.com/u/9076?v=3","gravatar_id":"","url":"https://api.github.com/users/bneumeier","html_url":"https://github.com/bneumeier","followers_url":"https://api.github.com/users/bneumeier/followers","following_url":"https://api.github.com/users/bneumeier/following{/other_user}","gists_url":"https://api.github.com/users/bneumeier/gists{/gist_id}","starred_url":"https://api.github.com/users/bneumeier/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bneumeier/subscriptions","organizations_url":"https://api.github.com/users/bneumeier/orgs","repos_url":"https://api.github.com/users/bneumeier/repos","events_url":"https://api.github.com/users/bneumeier/events{/privacy}","received_events_url":"https://api.github.com/users/bneumeier/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-02T16:36:16Z","updated_at":"2016-11-03T01:10:14Z","closed_at":null,"body":"With PostgreSQL built from git a831a73, and BDR built from git ead4f36, replication has been observed to break arbitrarily after running fine for some time (usually days).\r\n\r\nLog messages indicate the issue is with permissions on `bdr.bdr_conflict_handlers`:\r\n\r\n> 2016-10-30 02:31:17.001717500  LOG:  starting background worker process \"bdr (6327299559032024525,1,17613,)->bdr (632320401233966418\r\n> 9,1,\"\r\n> 2016-11-01 14:38:08.467930500  ERROR:  permission denied for relation bdr_conflict_handlers\r\n> 2016-11-01 14:38:08.467942500  CONTEXT:  SQL statement \"SELECT ch_fun::regprocedure, ch_type::text ch_type, ch_timeframe FROM bdr.bdr_conflict_handlers   WHERE ch_reloid = $1 ORDER BY ch_type, ch_name\"\r\n> 2016-11-01 14:38:08.467944500   apply UPDATE from remote relation public.users in commit 0/8C3B478, xid 9897 commited at 2016-11-01 09:38:08.318049-05 (action #3) from node (6323204010697114938,1,17578)\r\n> 2016-11-01 14:38:08.468861500  LOG:  worker process: bdr (6327299559032024525,1,17613,)->bdr (6323204010697114938,1, (PID 14489) exited with exit code 1\r\n\r\nWe've been able to correct the situation by granting select on bdr.bdr_conflict_handlers to the application user that performed the change, and granting that permission to public is an easy workaround, so this is not really a critical issue; but it seems as though others are likely to run into it as well."},"comment":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/comments/258045110","html_url":"https://github.com/2ndQuadrant/bdr/issues/267#issuecomment-258045110","issue_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/267","id":258045110,"user":{"login":"ringerc","id":274337,"avatar_url":"https://avatars.githubusercontent.com/u/274337?v=3","gravatar_id":"","url":"https://api.github.com/users/ringerc","html_url":"https://github.com/ringerc","followers_url":"https://api.github.com/users/ringerc/followers","following_url":"https://api.github.com/users/ringerc/following{/other_user}","gists_url":"https://api.github.com/users/ringerc/gists{/gist_id}","starred_url":"https://api.github.com/users/ringerc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ringerc/subscriptions","organizations_url":"https://api.github.com/users/ringerc/orgs","repos_url":"https://api.github.com/users/ringerc/repos","events_url":"https://api.github.com/users/ringerc/events{/privacy}","received_events_url":"https://api.github.com/users/ringerc/received_events","type":"User","site_admin":false},"created_at":"2016-11-03T01:10:14Z","updated_at":"2016-11-03T01:10:14Z","body":"Good catch. Thanks. I'll prep a fix to bdr-plugin/next and bdr-plugin/REL9_4_STABLE soon. It just missed the 1.0.2 release though."}}
{"actor":{"display_login":"ringerc"}}