[Postgres-xc-developers] Nodes Out of Sync

[David E. W. <da...@ju...>]

XCers,

I was trying to diagnose this issue:

    psql --set ON_ERROR_ROLLBACK=1 --set ON_ERROR_STOP=1 --file pg.sql
    psql:pg.sql:3: ERROR:  SAVEPOINT is not yet supported.

The first three lines are:

    BEGIN;

    SET client_min_messages = warning;
    CREATE SCHEMA sqitch;

I had thought that it was the CREATE SCHEMA statement it was complaining about, so I tried this:

    psql -d repcluster --set ON_ERROR_ROLLBACK=1 -c 'BEGIN; CREATE SCHEMA foo; COMMIT;'
    ERROR:  Failed to PREPARE the transaction on one or more nodes

So that's annoying. So I tired it again:

    psql --set ON_ERROR_ROLLBACK=1 -c 'BEGIN; CREATE SCHEMA foo; COMMIT;'
    ERROR:  schema "foo" already exists

That’s not good. I looked at all my nodes, four coordinators and four data nodes, and the schema is present in all but one, that one being the coordinator I actually ran the statement against.

I thought that was not possible. So how do I fix this? I can't drop it, because it doesn't exist on that one coordinator. I can't even drop it if I connect to another coordinator. And I can't create it, either, since it already exists in 7 out of the 8 places it ought to. :-(

Meanwhile, What part of my original file does XC think is a SAVEPOINT? Is it the SET statement?

Thanks,

David