Thread: [Postgres-xc-developers] Problem with GTM and sequences

Hi All,
If I run make installcheck successively on the same data cluster, I get GTM
error "ERROR:  GTM error, could not create sequence", whenever a sequence
is attempted to be created. It comes because open_sequence() and in turn
CreateSequenceGTM return non-zero value. This code does not report why the
GTM threw error.

Is anybody else seeing this error? Can we improve code here, to report the
exact cause of the failure. The error above is too vague for user to take
corrective measure.

-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company

On Thu, May 31, 2012 at 8:50 PM, Ashutosh Bapat <
ash...@en...> wrote:

> Hi All,
> If I run make installcheck successively on the same data cluster, I get
> GTM error "ERROR:  GTM error, could not create sequence", whenever a
> sequence is attempted to be created. It comes because open_sequence() and
> in turn CreateSequenceGTM return non-zero value. This code does not report
> why the GTM threw error.
>
> Is anybody else seeing this error? Can we improve code here, to report the
> exact cause of the failure. The error above is too vague for user to take
> corrective measure.

I have never seen it.
Yes this code could be improved, we could add an enum with the list of
possible errors and return that to Coordinator.
The possible errors I have in mind are:
- GTM internal error
- sequence already existing on GTM
-- 
Michael Paquier
http://michael.otacoo.com