[Postgres-xc-general] Interday Degradation

[Aaron J. <aja...@re...>]

Given my past experience with compiler issues, I'm a little hesitant to even report this.  That said, I have a three node cluster, each with a coordinator, data node and gtm proxy.  I have a standalone gtm instance without a slave.  Often, when I come in after the servers have been up for a while, I'm greeted with a variety of issues.

There are several warnings in the coordinator and data node logs, that read "Do not have a GTM snapshot available" - I've discarded these as mostly benign for the moment.

The coordinator is much worse..

30770 | 2014-05-22 15:53:06 UTC | ERROR:  current transaction is aborted, commands ignored until end of transaction block
30770 | 2014-05-22 15:53:06 UTC | STATEMENT:  DISCARD ALL
4560 | 2014-05-22 15:54:30 UTC | LOG:  failed to connect to Datanode
4560 | 2014-05-22 15:54:30 UTC | LOG:  failed to connect to Datanode
4560 | 2014-05-22 15:54:30 UTC | WARNING:  can not connect to node 16390
30808 | 2014-05-22 15:54:30 UTC | LOG:  failed to acquire connections

Usually, I reset the coordinator and datanode and the world is happy again.  However, it makes me somewhat concerned that I'm seeing these kinds of failures on a daily basis.  I wouldn't rule out the compiler again as it's been the reason for previous failures, but has anyone else seen anything like this??

Aaron