Re: [Postgres-xc-developers] Repeated rollback gets different error code from PostgreSQL

[Masataka S. <pg...@gm...>]

I made a ticket for this issue.
https://sourceforge.net/p/postgres-xc/bugs/457/

The test case is also failing to XC 1.0.0.
XC 1.0.0 returns same error code as XC on the master branch.

The test is introduced only to master branch after branch
REL9_2_STABLE, which I use to test XC 1.1 was created.
It is why REL1_1_STABLE branch passes the JDBC regression test.

Regards.

On Mon, Oct 7, 2013 at 11:42 PM, Ahsan Hadi <ahs...@en...> wrote:
> Thanks Masataka.
>
> Can you create a source-forge ticket for this please? Attach a reproducible
> test case with the ticket.
>
>
>
> On Thu, Oct 3, 2013 at 2:45 PM, Masataka Saito <pg...@gm...> wrote:
>>
>> Hello, all.
>>
>> I found Postgres-XC returns different error code from PostgreSQL's one
>> for repeated rollback, and it makes a pgjdbc's regression test case
>> fail.
>>
>> PostgreSQL returns error code 42704 which is defined as
>> ERRCODE_UNDEFINED_OBJECT. It is maybe returned in
>> src/backend/access/transam/twophase.c::LockGXact.
>> Postgres-XC returns error code XX000 which is defined as
>> ERRCODE_INTERNAL_ERROR It is maybe returned in
>> src/backend/pgxc/pool/execRemote.c::FinishRemotePreparedTransaction.
>>
>> Error messages are quite similar. I will show it at the next line.
>> > prepared transaction with identifier
>> > "0_8fHx8fF5/OCyZd9xZmJ2MSPCE1olci037CNQYoXoVCKbi63JcZIoUeJxU7PKl/t4qI4xV1agFPE+9gRrzheGHA==_BAUGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=="
>> > does not exist.
>>
>> Does anyone know ...
>>  * Why they have different error codes, and is it reasonable?
>>  * To fix the code affects other components?
>>
>> You can reproduce using pgjdbc's regression test. The source code of
>> the test is
>> org.postgresql.test.xa.XADataSourceTest.testRepeatedRolledBack.
>> >
>> > http://sourceforge.net/p/postgres-xc/pgjdbc-xc/ci/master/tree/org/postgresql/test/xa/XADataSourceTest.java#l331
>>
>> Regards.
>>
>>
>> ------------------------------------------------------------------------------
>> October Webinars: Code for Performance
>> Free Intel webinars can help you accelerate application performance.
>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>> from
>> the latest Intel processors and coprocessors. See abstracts and register >
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>
>
>
> --
> Ahsan Hadi
> Snr Director Product Development
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Phone: +92-51-8358874
> Mobile: +92-333-5162114
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com/
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
> This e-mail message (and any attachment) is intended for the use of the
> individual or entity to whom it is addressed. This message contains
> information from EnterpriseDB Corporation that may be privileged,
> confidential, or exempt from disclosure under applicable law. If you are not
> the intended recipient or authorized to receive this for the intended
> recipient, any use, dissemination, distribution, retention, archiving, or
> copying of this communication is strictly prohibited. If you have received
> this e-mail in error, please notify the sender immediately by reply e-mail
> and delete this message.