{"action":"created","issue":{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/141","labels_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/141/labels{/name}","comments_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/141/comments","events_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/141/events","html_url":"https://github.com/postgres-x2/postgres-x2/issues/141","id":77539635,"number":141,"title":"Catalog corrupted.","user":{"login":"Jasonysli","id":9444459,"avatar_url":"https://avatars.githubusercontent.com/u/9444459?v=3","gravatar_id":"","url":"https://api.github.com/users/Jasonysli","html_url":"https://github.com/Jasonysli","followers_url":"https://api.github.com/users/Jasonysli/followers","following_url":"https://api.github.com/users/Jasonysli/following{/other_user}","gists_url":"https://api.github.com/users/Jasonysli/gists{/gist_id}","starred_url":"https://api.github.com/users/Jasonysli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jasonysli/subscriptions","organizations_url":"https://api.github.com/users/Jasonysli/orgs","repos_url":"https://api.github.com/users/Jasonysli/repos","events_url":"https://api.github.com/users/Jasonysli/events{/privacy}","received_events_url":"https://api.github.com/users/Jasonysli/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/milestones/3","html_url":"https://github.com/postgres-x2/postgres-x2/milestones/1.3","labels_url":"https://api.github.com/repos/postgres-x2/postgres-x2/milestones/3/labels","id":1139168,"number":3,"title":"1.3","description":"","creator":{"login":"koichi-szk","id":985469,"avatar_url":"https://avatars.githubusercontent.com/u/985469?v=3","gravatar_id":"","url":"https://api.github.com/users/koichi-szk","html_url":"https://github.com/koichi-szk","followers_url":"https://api.github.com/users/koichi-szk/followers","following_url":"https://api.github.com/users/koichi-szk/following{/other_user}","gists_url":"https://api.github.com/users/koichi-szk/gists{/gist_id}","starred_url":"https://api.github.com/users/koichi-szk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/koichi-szk/subscriptions","organizations_url":"https://api.github.com/users/koichi-szk/orgs","repos_url":"https://api.github.com/users/koichi-szk/repos","events_url":"https://api.github.com/users/koichi-szk/events{/privacy}","received_events_url":"https://api.github.com/users/koichi-szk/received_events","type":"User","site_admin":false},"open_issues":71,"closed_issues":0,"state":"open","created_at":"2015-05-29T04:01:44Z","updated_at":"2015-06-18T05:22:40Z","due_on":"2016-09-29T15:00:00Z","closed_at":null},"comments":25,"created_at":"2015-05-18T07:26:44Z","updated_at":"2015-07-03T05:03:24Z","closed_at":null,"body":"catalog corrupted.Under high pressure, when running DDL and DML, sometimes we got inconsistant catalogs among coords and datanodes."},"comment":{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/comments/118234744","html_url":"https://github.com/postgres-x2/postgres-x2/issues/141#issuecomment-118234744","issue_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/141","id":118234744,"user":{"login":"Jasonysli","id":9444459,"avatar_url":"https://avatars.githubusercontent.com/u/9444459?v=3","gravatar_id":"","url":"https://api.github.com/users/Jasonysli","html_url":"https://github.com/Jasonysli","followers_url":"https://api.github.com/users/Jasonysli/followers","following_url":"https://api.github.com/users/Jasonysli/following{/other_user}","gists_url":"https://api.github.com/users/Jasonysli/gists{/gist_id}","starred_url":"https://api.github.com/users/Jasonysli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jasonysli/subscriptions","organizations_url":"https://api.github.com/users/Jasonysli/orgs","repos_url":"https://api.github.com/users/Jasonysli/repos","events_url":"https://api.github.com/users/Jasonysli/events{/privacy}","received_events_url":"https://api.github.com/users/Jasonysli/received_events","type":"User","site_admin":false},"created_at":"2015-07-03T05:03:24Z","updated_at":"2015-07-03T05:03:24Z","body":"Here is the transaction status query result, xid 2855831 was committed on both coords, but unknown on all datanodes.\r\npsql -p 30005 postgres \r\npsql (PGXC , based on PG 9.4beta1)\r\nType \"help\" for help.\r\n\r\npostgres=# select pgxc_is_committed('2855831'::xid);\r\n pgxc_is_committed \r\n-------------------\r\n t\r\n(1 row)\r\n\r\npostgres=# select xmin, xmax, oid,relname from pg_class where relname = 'test';\r\n  xmin   |  xmax   |  oid   | relname \r\n---------+---------+--------+---------\r\n 2855831 | 2856575 | 516311 | test\r\n(1 row)\r\n\r\npostgres=#  select pgxc_is_committed('2856575'::xid);       \r\n pgxc_is_committed \r\n-------------------\r\n f\r\n(1 row)\r\npsql -p 30004 postgres                   \r\npsql (PGXC , based on PG 9.4beta1)\r\nType \"help\" for help.\r\n\r\npostgres=# select pgxc_is_committed('2855831'::xid);\r\n pgxc_is_committed \r\n-------------------\r\n t\r\n(1 row)\r\n\r\npostgres=# EXECUTE DIRECT ON (db1) 'select pgxc_is_committed(''2855831''::xid);'; \r\n pgxc_is_committed \r\n-------------------\r\n \r\n(1 row)\r\n\r\npostgres=# EXECUTE DIRECT ON (db2) 'select pgxc_is_committed(''2855831''::xid);'; \r\n pgxc_is_committed \r\n-------------------\r\n \r\n(1 row)\r\n\r\npostgres=# EXECUTE DIRECT ON (db3) 'select pgxc_is_committed(''2855831''::xid);'; \r\n pgxc_is_committed \r\n-------------------\r\n \r\n(1 row)\r\n\r\npostgres=# EXECUTE DIRECT ON (db4) 'select pgxc_is_committed(''2855831''::xid);'; \r\n pgxc_is_committed \r\n-------------------\r\n \r\n(1 row)\r\n\r\npostgres=# select * from pgxc_node;\r\n node_name | node_type | node_port |   node_host    | nodeis_primary | nodeis_preferred |   node_id   \r\n-----------+-----------+-----------+----------------+----------------+------------------+-------------\r\n coord1    | C         |     30004 | 10.241.103.148 | f              | f                |  1885696643\r\n coord2    | C         |     30005 | 10.241.103.148 | f              | f                | -1197102633\r\n db1       | D         |     20008 | 10.241.103.148 | t              | t                |    -2885965\r\n db2       | D         |     20009 | 10.241.103.148 | f              | t                |   -79866771\r\n db3       | D         |     20010 | 10.241.103.148 | f              | t                | -1472228704\r\n db4       | D         |     20011 | 10.241.103.148 | f              | t                |  -972212898\r\n(6 rows)\r\n\r\npostgres=# \r\n\r\n"}}