{"action":"opened","issue":{"url":"https://api.github.com/repos/2ndQuadrant/pglogical/issues/24","repository_url":"https://api.github.com/repos/2ndQuadrant/pglogical","labels_url":"https://api.github.com/repos/2ndQuadrant/pglogical/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/2ndQuadrant/pglogical/issues/24/comments","events_url":"https://api.github.com/repos/2ndQuadrant/pglogical/issues/24/events","html_url":"https://github.com/2ndQuadrant/pglogical/issues/24","id":166079847,"number":24,"title":"spurious CONFLICTs detected","user":{"login":"moench-tegeder","id":7943408,"avatar_url":"https://avatars.githubusercontent.com/u/7943408?v=3","gravatar_id":"","url":"https://api.github.com/users/moench-tegeder","html_url":"https://github.com/moench-tegeder","followers_url":"https://api.github.com/users/moench-tegeder/followers","following_url":"https://api.github.com/users/moench-tegeder/following{/other_user}","gists_url":"https://api.github.com/users/moench-tegeder/gists{/gist_id}","starred_url":"https://api.github.com/users/moench-tegeder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moench-tegeder/subscriptions","organizations_url":"https://api.github.com/users/moench-tegeder/orgs","repos_url":"https://api.github.com/users/moench-tegeder/repos","events_url":"https://api.github.com/users/moench-tegeder/events{/privacy}","received_events_url":"https://api.github.com/users/moench-tegeder/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-18T12:13:41Z","updated_at":"2016-07-18T12:13:41Z","closed_at":null,"body":"Setup: two PostgreSQL instances db1 (port 5433) and db2 (port 5434). Data is the pgbench database with an added primary key on pgbench_history (dbname is bench). The db2 instance's \"bench\" will be subscriber to the db1 instance's \"bench\".\r\n\r\nNo matter wether I set up db2 via `pglogical_create_subscriber` or via SQL `pglogical.create_subscription(..., synchronize_structure = 't', synchronize_data := 't')` an update to `pgbench_accounts` (`update pgbench_accounts update set abalance = abalance + 1 where aid = 1;`) results in a CONFLICT log message:\r\n`LOG:  CONFLICT: remote UPDATE on relation public.pgbench_accounts. Resolution: apply_remote.`\r\nSubsequent UPDATEs to the same row do not yield CONFLICT messages. (Other tables are affected, too - but this is the straight forward reproducer).\r\n\r\nVersions: \r\n\r\n- `PostgreSQL 9.5.3 on x86_64-unknown-freebsd10.3, compiled by gcc (FreeBSD Ports Collection) 4.8.5, 64-bit`, behaviour also reproducable on Linux\r\n- pg_logical 1.1.2 (as per pg_extension), also reproducable with currently released Debian packages"}}
{"actor":{"display_login":"moench-tegeder"}}