{"action":"created","issue":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/163","labels_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/163/labels{/name}","comments_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/163/comments","events_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/163/events","html_url":"https://github.com/2ndQuadrant/bdr/issues/163","id":128435704,"number":163,"title":"BDR disconnect node","user":{"login":"volga629","id":3235221,"avatar_url":"https://avatars.githubusercontent.com/u/3235221?v=3","gravatar_id":"","url":"https://api.github.com/users/volga629","html_url":"https://github.com/volga629","followers_url":"https://api.github.com/users/volga629/followers","following_url":"https://api.github.com/users/volga629/following{/other_user}","gists_url":"https://api.github.com/users/volga629/gists{/gist_id}","starred_url":"https://api.github.com/users/volga629/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/volga629/subscriptions","organizations_url":"https://api.github.com/users/volga629/orgs","repos_url":"https://api.github.com/users/volga629/repos","events_url":"https://api.github.com/users/volga629/events{/privacy}","received_events_url":"https://api.github.com/users/volga629/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-25T00:16:15Z","updated_at":"2016-01-25T00:17:25Z","closed_at":null,"body":"Hello Everyone,\r\nI am trying disconnect node from the group and having issue with DDL operations. I market desire node as K and tried delete from table, but get error.\r\n\r\nAny help thank you.\r\n\r\n```\r\n[root@db1 pg_log]# rpm -qa | grep postgres\r\npostgresql-bdr94-9.4.5_bdr1-1_2ndQuadrant.fc22.x86_64\r\npostgresql-bdr94-bdr-0.9.3-1_2ndQuadrant.fc22.x86_64\r\npostgresql-bdr94-server-9.4.5_bdr1-1_2ndQuadrant.fc22.x86_64\r\n\r\n```\r\n\r\n\r\n```\r\n 6242988909397161566 |             1 |      16387 | k           | dbm3      | host=db1.networklab.prod port=5432 dbnam\r\ne=db_prod01 | host=db1.networklab.prod port=5432 dbname=db_prod01\r\n 6242981939774453042 |             1 |      16387 | k           | dbm2      | host=db2.networklab.prod port=5432 dbnam\r\ne=db_prod01 | host=db1.networklab.prod port=5432 dbname=db_prod01\r\n 6242730220644137235 |             1 |      16387 | k           | dbm1      | host=db3.networklab.prod port=5432 dbnam\r\ne=db_prod01 | \r\n(3 rows)\r\n\r\ndb_prod01=# delete from bdr.bdr_nodes where node_status = 'k';\r\nERROR:  Database is locked against DDL operations\r\nHINT:  Node (6242730220644137235,1,16387) in the cluster is already performing DDL\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/comments/174355729","html_url":"https://github.com/2ndQuadrant/bdr/issues/163#issuecomment-174355729","issue_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/163","id":174355729,"user":{"login":"volga629","id":3235221,"avatar_url":"https://avatars.githubusercontent.com/u/3235221?v=3","gravatar_id":"","url":"https://api.github.com/users/volga629","html_url":"https://github.com/volga629","followers_url":"https://api.github.com/users/volga629/followers","following_url":"https://api.github.com/users/volga629/following{/other_user}","gists_url":"https://api.github.com/users/volga629/gists{/gist_id}","starred_url":"https://api.github.com/users/volga629/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/volga629/subscriptions","organizations_url":"https://api.github.com/users/volga629/orgs","repos_url":"https://api.github.com/users/volga629/repos","events_url":"https://api.github.com/users/volga629/events{/privacy}","received_events_url":"https://api.github.com/users/volga629/received_events","type":"User","site_admin":false},"created_at":"2016-01-25T00:17:25Z","updated_at":"2016-01-25T00:17:25Z","body":"duplicate"}}