postgres-xc-bugs

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

[Dimitrije R. <tem...@gm...>]

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

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

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

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

> 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
>
> Thanks for the bug report.
I found the origin of the problem and committed the fix with id c3e01a6:
https://github.com/postgres-xc/postgres-xc/commit/c3e01a6277f1d1d94c6d45114a710d47ddc6ece2

The fix has also been applied to 1.0 stable branch, so it will be included
in next maintenance release of 1.0.
You can still apply the commit to your 1.0.0 source if you want to avoid
the problem for the time being.

Regards,
-- 
Michael Paquier
http://michael.otacoo.com

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

[Dimitrije R. <tem...@gm...>]

Thanks for quick response and fix, Michael! I am so glad people are working
hard to make Postgres-XC ready for production. I will continue testing
today, and will report if I find any more problems.

Dimitrije

2012/6/15 Michael Paquier <mic...@gm...>

>
> 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
>>
>> Thanks for the bug report.
> I found the origin of the problem and committed the fix with id c3e01a6:
>
> https://github.com/postgres-xc/postgres-xc/commit/c3e01a6277f1d1d94c6d45114a710d47ddc6ece2
>
> The fix has also been applied to 1.0 stable branch, so it will be included
> in next maintenance release of 1.0.
> You can still apply the commit to your 1.0.0 source if you want to avoid
> the problem for the time being.
>
> Regards,
> --
> Michael Paquier
> http://michael.o <http://michael.otacoo.com>

*.0 stable branch, so it will be included in next maintenance release of
> 1.0.*

*You can still apply the commit to your 1.0.0 source if you want to avoid
> the problem for the time being.*

tacoo.com <http://michael.otacoo.com>

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

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

On Fri, Jun 15, 2012 at 3:50 PM, Dimitrije Radojevic
<tem...@gm...>wrote:

> Thanks for quick response and fix, Michael! I am so glad people are
> working hard to make Postgres-XC ready for production. I will continue
> testing today, and will report if I find any more problems.

Thanks. You're welcome.
-- 
Michael Paquier
http://michael.otacoo.com