Re: [Postgres-xc-bugs] Failed to recreate sequence after dropping database

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

Thanks for the report and even more the test case.
I will try to look at that today.

Michael

On 2012/06/14, at 23:47, Dimitrije Radojevic <tem...@gm...> wrote:

> Hi all,
> 
> I am considering Postgres-XC as a database backend for my project, and I have decided to give it some testing. I think I encountered a bug, so here are steps to reproduce (I am using version 1.0.0, compiled from tarball, with initial setup as described here: http://postgres-xc.sourceforge.net/docs/1_0/install-short.html):
> 1) create a database (CREATE DATABASE test WITH OWNER=postgres;)
> 2) create a table with serial primary key (CREATE TABLE test_table(id SERIAL NOT NULL, data int4, PRIMARY KEY(id)) tablespace data; - not sure if specifying tablespace has anything to do with this, this data tablespace was created earlier)
> 3) drop database (DROP DATABASE test;)
> 4) repeat step 1-2)
> 5) this results in ERROR:  GTM error, could not create sequence
> 
> Here's relevant part of GTM log:
> ----
> 1:140436113319680:2012-06-14 16:04:42.847 CEST -LOG:  Sending transaction id 11949
> LOCATION:  ProcessBeginTransactionGetGXIDCommand, /home/dimitrijer/Projekti/pgxc/build/../src/gtm/main/gtm_txn.c:1164
> 1:140436113319680:2012-06-14 16:04:42.851 CEST -LOG:  Sequence with the given key already exists
> LOCATION:  seq_add_seqinfo, /home/dimitrijer/Projekti/pgxc/build/../src/gtm/main/gtm_seq.c:177
> 1:140436113319680:2012-06-14 16:04:42.851 CEST -ERROR:  Failed to open a new sequence
> LOCATION:  ProcessSequenceInitCommand, /home/dimitrijer/Projekti/pgxc/build/../src/gtm/main/gtm_seq.c:883
> 1:140436113319680:2012-06-14 16:04:42.851 CEST -LOG:  Cancelling transaction id 11949
> ----
> 
> Kind regards,
> Dimitrije
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-bugs mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs