FATAL: GTM error, could not obtain snapshot. Current XID = 0, Autovac = 0

Asked May 25 '16 at 15:13

Active May 25 '16 at 15:28

Viewed 608 times

After running virtually any command (e.g. createdb test) from GTM host inside pgxc_ctl tool, I am getting the following error:

FATAL:  GTM error, could not obtain snapshot. Current XID = 0, Autovac = 0

PostgresXL is configured and installed on 4 nodes (/etc/hosts):

172.23.102.115 coordinator001
172.23.102.116 datanode001
172.23.103.0 datanode002
172.23.102.114 gtm001

So that each can ssh into another one and pg_hba.conf contains:

host    all             all             0.0.0.0/0               trust

GTM node has this configuration

Would appreciate any tips or ideas where to dig next.

[edit]

Getting this error during the direct connection:

psql -h coordinator001 -p 6668 -U postgres testdb
psql: FATAL:  GTM error, could not obtain snapshot. Current XID = 0, Autovac = 0

edited May 25 '16 at 15:28

asked May 25 '16 at 15:13

Yauhen Yakimovich

I get impression my config is a mess. Now trying a correct one from here http://deepdive.stanford.edu/using-pgxl – Yauhen Yakimovich May 25 '16 at 16:22
checking firewall and following the above scenario seems to work. Once pgxc_ctl exports configs to the remote nodes, it helps a lot to check them – Yauhen Yakimovich May 30 '16 at 13:09
Network seems to be the most plausible cause. Happened during the network fluctuation. – Yauhen Yakimovich Aug 24 '16 at 12:58

0 Answers0