[Postgres-xc-general] connection reset on CREATE TABLE

[Marcin K. <mr...@gm...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello everyone,

I have successfully (?) configured XC on two nodes (the cluster
successfully created database and role and granted privileges on the
db), however I have encountered a problem:

postgres=# \c etest;
psql (8.4.3)
You are now connected to database "etest".
etest=# CREATE TABLE "user" (
etest(#         id SERIAL NOT NULL,
etest(#         name VARCHAR,
etest(#         fullname VARCHAR,
etest(#         srv1 VARCHAR,
etest(#         srv2 VARCHAR,
etest(#         PRIMARY KEY (id)
etest(# )
etest-# ;
NOTICE:  CREATE TABLE will create implicit sequence "user_id_seq" for
serial column "user.id"
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

The SQL code is simple enough I thought?

The snag is I'm using ORM (SQLAlchemy 0.6.5) and this is what generated
that code.

After restart of a cluster I'm getting:

postgres=# \c etest
psql (8.4.3)
You are now connected to database "etest".
etest=# create table "testme" (id INTEGER, name VARCHAR);
ERROR:  Could not commit (or autocommit) data node connection



- --

Regards,
mk

- --
Premature optimization is the root of all fun.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNJN5+AAoJEFMgHzhQQ7hOEsQH/2VaXQovjZhR6IT085Jim1Gb
RM3B5UMZ/rWfRaqDRUdtY3SaV5HDNQd+vtsCoHg71ftAFjutAlUC6JNB4hlypxiR
MFvRO1nsCq3arQWEALxtbL4plHeHN28b1uJesB1vchjYJCvyR9MIIVSBU2P0Rnv+
qutNm/0rhbDhCo+7xOmK3J0r9VdBKvA+9NgYAi9AH9m7sMbIAvMcABZ9ws8QMSeG
/aOCeWYSQCmUtG8/YPcQxdruKC7+G/d0lgY+BK2jP4iu0wnWSYA4ihzBI+FuKq8t
ZAOvN2ku6DNvVGSeEnesOL9uK0dUOK1nkENmAd1AMMQ81jHcFB9hADrO/7oO530=
=4/r3
-----END PGP SIGNATURE-----