{"action":"closed","issue":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/161","repository_url":"https://api.github.com/repos/2ndQuadrant/bdr","labels_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/161/labels{/name}","comments_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/161/comments","events_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/161/events","html_url":"https://github.com/2ndQuadrant/bdr/issues/161","id":127972382,"number":161,"title":"In table bdr.bdr_nodes node_status keeps being \"initializing\" for one node","user":{"login":"pierre-sion","id":7983414,"avatar_url":"https://avatars.githubusercontent.com/u/7983414?v=3","gravatar_id":"","url":"https://api.github.com/users/pierre-sion","html_url":"https://github.com/pierre-sion","followers_url":"https://api.github.com/users/pierre-sion/followers","following_url":"https://api.github.com/users/pierre-sion/following{/other_user}","gists_url":"https://api.github.com/users/pierre-sion/gists{/gist_id}","starred_url":"https://api.github.com/users/pierre-sion/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pierre-sion/subscriptions","organizations_url":"https://api.github.com/users/pierre-sion/orgs","repos_url":"https://api.github.com/users/pierre-sion/repos","events_url":"https://api.github.com/users/pierre-sion/events{/privacy}","received_events_url":"https://api.github.com/users/pierre-sion/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"PJMODOS","id":761741,"avatar_url":"https://avatars.githubusercontent.com/u/761741?v=3","gravatar_id":"","url":"https://api.github.com/users/PJMODOS","html_url":"https://github.com/PJMODOS","followers_url":"https://api.github.com/users/PJMODOS/followers","following_url":"https://api.github.com/users/PJMODOS/following{/other_user}","gists_url":"https://api.github.com/users/PJMODOS/gists{/gist_id}","starred_url":"https://api.github.com/users/PJMODOS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PJMODOS/subscriptions","organizations_url":"https://api.github.com/users/PJMODOS/orgs","repos_url":"https://api.github.com/users/PJMODOS/repos","events_url":"https://api.github.com/users/PJMODOS/events{/privacy}","received_events_url":"https://api.github.com/users/PJMODOS/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/milestones/6","html_url":"https://github.com/2ndQuadrant/bdr/milestones/0.10.0","labels_url":"https://api.github.com/repos/2ndQuadrant/bdr/milestones/6/labels","id":1048259,"number":6,"title":"0.10.0","description":"Work for the next devel branch","creator":{"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},"open_issues":11,"closed_issues":8,"state":"open","created_at":"2015-04-01T07:36:23Z","updated_at":"2016-05-07T01:46:09Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-01-21T17:08:32Z","updated_at":"2016-05-07T01:46:09Z","closed_at":"2016-05-07T01:46:09Z","body":"Hello,\r\n\r\nI am using BDR 0.9.3. I have a setup with 2 nodes, say node1 and node2. \r\nThe BDR group was created from node1. When node2 joined the group, a conflict was registered in the bdr.bdr_conflict_history table:\r\n\r\nconflict_id              | 1\r\nlocal_node_sysid         | 6241795782928356619\r\nlocal_conflict_xid       | 1837\r\nlocal_conflict_lsn       | 0/1ABF9E0\r\nlocal_conflict_time      | 2016-01-20 11:05:49.869761+01\r\nobject_schema            | bdr\r\nobject_name              | bdr_nodes\r\nremote_node_sysid        | 6241795796634624909\r\nremote_txid              | 1857\r\nremote_commit_time       | 2016-01-20 11:05:42.242831+01\r\nremote_commit_lsn        | 0/1C53100\r\nconflict_type            | update_update\r\nconflict_resolution      | last_update_wins_keep_local\r\nlocal_tuple              | {\"node_sysid\":\"6241795796634624909\",\"node_timeline\":\"1\",\"node_dboid\":\"17935\",\"node_status\":\"i\",\"node_name\":\"node2\",\"node_local_dsn\":\"host=172.26.2.95 port=5432 db\r\nname=bdrdemo\",\"node_init_from_dsn\":\"host=172.26.2.94 port=5432 dbname=bdrdemo\"}\r\nremote_tuple             | {\"node_sysid\":\"6241795796634624909\",\"node_timeline\":\"1\",\"node_dboid\":\"17935\",\"node_status\":\"r\",\"node_name\":\"node2\",\"node_local_dsn\":\"host=172.26.2.95 port=5432 db\r\nname=bdrdemo\",\"node_init_from_dsn\":\"host=172.26.2.94 port=5432 dbname=bdrdemo\"}\r\nlocal_tuple_xmin         | 1832\r\n\r\nAs as result, the node_status of bdr.bdr_nodes is inconsistent between node1 and node2.\r\n\r\n**From node1:**\r\nbdrdemo=# select * from bdr.bdr_nodes;\r\n-[ RECORD 1 ]------+------------------------------------------\r\nnode_sysid         | 6241795782928356619\r\nnode_timeline      | 1\r\nnode_dboid         | 16385\r\nnode_status        | r\r\nnode_name          | node1\r\nnode_local_dsn     | host=172.26.2.94 port=5432 dbname=bdrdemo\r\nnode_init_from_dsn |\r\n-[ RECORD 2 ]------+------------------------------------------\r\nnode_sysid         | 6241795796634624909\r\nnode_timeline      | 1\r\nnode_dboid         | 17935\r\n**node_status        | i**\r\nnode_name          | node2\r\nnode_local_dsn     | host=172.26.2.95 port=5432 dbname=bdrdemo\r\nnode_init_from_dsn | host=172.26.2.94 port=5432 dbname=bdrdemo\r\n\r\n**From node2:**\r\nbdrdemo=# select * from bdr.bdr_nodes;\r\n-[ RECORD 1 ]------+------------------------------------------\r\nnode_sysid         | 6241795782928356619\r\nnode_timeline      | 1\r\nnode_dboid         | 16385\r\nnode_status        | r\r\nnode_name          | node1\r\nnode_local_dsn     | host=172.26.2.94 port=5432 dbname=bdrdemo\r\nnode_init_from_dsn |\r\n-[ RECORD 2 ]------+------------------------------------------\r\nnode_sysid         | 6241795796634624909\r\nnode_timeline      | 1\r\nnode_dboid         | 17935\r\n**node_status        | r**\r\nnode_name          | node2\r\nnode_local_dsn     | host=172.26.2.95 port=5432 dbname=bdrdemo\r\nnode_init_from_dsn | host=172.26.2.94 port=5432 dbname=bdrdemo\r\n\r\nFrom node1's perspective, the status of node2 keeps being \"initializing\".\r\nFrom node2's perspective, the status of node2 is \"ready\" (correct).\r\n\r\nI restarted PostgreSQL on both nodes, but to no avail; the content of bdr.bdr_nodes remains incoherent.\r\n\r\nThis does not prevent the replication from working correctly.\r\n\r\nThank you for your attention,\r\nBest regards,\r\nPierre Sion"}}