{"action":"created","issue":{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/259","labels_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/259/labels{/name}","comments_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/259/comments","events_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/259/events","html_url":"https://github.com/postgres-x2/postgres-x2/issues/259","id":93026171,"number":259,"title":"too much LOG:  xid was less than ShmemVariableCache->nextXid","user":{"login":"wurenny","id":6622574,"avatar_url":"https://avatars.githubusercontent.com/u/6622574?v=3","gravatar_id":"","url":"https://api.github.com/users/wurenny","html_url":"https://github.com/wurenny","followers_url":"https://api.github.com/users/wurenny/followers","following_url":"https://api.github.com/users/wurenny/following{/other_user}","gists_url":"https://api.github.com/users/wurenny/gists{/gist_id}","starred_url":"https://api.github.com/users/wurenny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wurenny/subscriptions","organizations_url":"https://api.github.com/users/wurenny/orgs","repos_url":"https://api.github.com/users/wurenny/repos","events_url":"https://api.github.com/users/wurenny/events{/privacy}","received_events_url":"https://api.github.com/users/wurenny/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/labels/Improvement","name":"Improvement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-07-04T16:26:54Z","updated_at":"2015-07-07T07:41:02Z","closed_at":"2015-07-07T02:35:54Z","body":"i run pgbench use the lastest branch of REL_1_2_STABLE, i found too much these log records on coordinator:\r\nLOG:  xid (2969482) was less than ShmemVariableCache->nextXid (2969484), IS_PGXC_COORDINATOR:1, IS_PGXC_DATANODE:0, REMOTE_CONN_TYPE:0, regen now\r\nSTATEMENT:  SELECT abalance FROM pgbench_accounts WHERE aid = 740761;\r\nLOG:  xid (2969578) was less than ShmemVariableCache->nextXid (2969580), IS_PGXC_COORDINATOR:1, IS_PGXC_DATANODE:0, REMOTE_CONN_TYPE:0, regen now\r\nSTATEMENT:  SELECT abalance FROM pgbench_accounts WHERE aid = 1379227;\r\nLOG:  xid (2969588) was less than ShmemVariableCache->nextXid (2969590), IS_PGXC_COORDINATOR:1, IS_PGXC_DATANODE:0, REMOTE_CONN_TYPE:0, regen now\r\nSTATEMENT:  SELECT abalance FROM pgbench_accounts WHERE aid = 634828;\r\nLOG:  xid (2969595) was less than ShmemVariableCache->nextXid (2969597), IS_PGXC_COORDINATOR:1, IS_PGXC_DATANODE:0, REMOTE_CONN_TYPE:0, regen now\r\nSTATEMENT:  SELECT abalance FROM pgbench_accounts WHERE aid = 791938;\r\n\r\n\r\nand on datanode:\r\nxid (11353) does not follow ShmemVariableCache->nextXid (11355)\r\nxid (11517) does not follow ShmemVariableCache->nextXid (11519)\r\nxid (11585) does not follow ShmemVariableCache->nextXid (11587)\r\nxid (11657) does not follow ShmemVariableCache->nextXid (11659)\r\nxid (19750) does not follow ShmemVariableCache->nextXid (19755)\r\nxid (19824) does not follow ShmemVariableCache->nextXid (19826)\r\nxid (19897) does not follow ShmemVariableCache->nextXid (19899)\r\nxid (20523) does not follow ShmemVariableCache->nextXid (20525)\r\nxid (20528) does not follow ShmemVariableCache->nextXid (20533)\r\n\r\nwhether there are some harmful effect to the cluster ?"},"comment":{"url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/comments/119105656","html_url":"https://github.com/postgres-x2/postgres-x2/issues/259#issuecomment-119105656","issue_url":"https://api.github.com/repos/postgres-x2/postgres-x2/issues/259","id":119105656,"user":{"login":"wurenny","id":6622574,"avatar_url":"https://avatars.githubusercontent.com/u/6622574?v=3","gravatar_id":"","url":"https://api.github.com/users/wurenny","html_url":"https://github.com/wurenny","followers_url":"https://api.github.com/users/wurenny/followers","following_url":"https://api.github.com/users/wurenny/following{/other_user}","gists_url":"https://api.github.com/users/wurenny/gists{/gist_id}","starred_url":"https://api.github.com/users/wurenny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wurenny/subscriptions","organizations_url":"https://api.github.com/users/wurenny/orgs","repos_url":"https://api.github.com/users/wurenny/repos","events_url":"https://api.github.com/users/wurenny/events{/privacy}","received_events_url":"https://api.github.com/users/wurenny/received_events","type":"User","site_admin":false},"created_at":"2015-07-07T07:41:02Z","updated_at":"2015-07-07T07:41:02Z","body":"INFO is similar to NOTICE, printed in client message too, i have tried it."}}