[Postgres-xc-general] Unable to create sequences

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

I tried to create a database as follows ...

CREATE TABLE Schema.TableFoo(
    SomeId serial NOT NULL,
    ForeignId int NOT NULL,
    ...
) WITH (OIDS = FALSE);

The server returned the following...

ERROR:  GTM error, could not create sequence

Looked at the server logs for the gtm_proxy, nothing so I went to the gtm.

LOCATION:  pq_copymsgbytes, pqformat.c:554
1:140488486782720:2014-06-02 21:10:58.870 UTC -WARNING:  No transaction handle for gxid: 0
LOCATION:  GTM_GXIDToHandle, gtm_txn.c:163
1:140488486782720:2014-06-02 21:10:58.870 UTC -WARNING:  Invalid transaction handle: -1
LOCATION:  GTM_HandleToTransactionInfo, gtm_txn.c:213
1:140488486782720:2014-06-02 21:10:58.870 UTC -ERROR:  Failed to get a snapshot
LOCATION:  ProcessGetSnapshotCommandMulti, gtm_snap.c:420
1:140488478390016:2014-06-02 21:10:58.871 UTC -ERROR:  insufficient data left in message
LOCATION:  pq_copymsgbytes, pqformat.c:554
1:140488486782720:2014-06-02 21:10:58.871 UTC -ERROR:  insufficient data left in message
LOCATION:  pq_copymsgbytes, pqformat.c:554

I'm definitely confused here.  This cluster has been running fine for several days now.  And now the GTM is failing. I performed a restart of the gtm and proxies (each using gtm_ctl to stop and restart the instance).  Nothing has changed, the GTM continues to fail and will not create the sequence.

Any ideas?

Aaron