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

[Michael P. <mic...@gm...>]

Postgres-XC does not support yet serial tables (sequence created at the same
time as a table).
This has been reported by bug 3110406.
https://sourceforge.net/tracker/?func=detail&aid=3110406&group_id=311227&atid=1310232


On Thu, Jan 6, 2011 at 6:11 AM, Marcin Krol <mr...@gm...> wrote:

> -----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-----
>
>
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment,
> and,
> should the need arise, upgrade to a full multi-node Oracle RAC database
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



-- 
Michael Paquier
http://michaelpq.users.sourceforge.net