#461 Repeated rollback gets different error code from PostgreSQL

1.3 Dev Q
open
nobody
None
5
2013-12-03
2013-12-02
cbx
No

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.

Discussion

  • cbx

    cbx - 2013-12-02
    • summary: GROUP BY clause with JOIN clause and DISTINCT clause and combination of implicit/explicit table specification --> Repeated rollback gets different error code from PostgreSQL
     
  • Koichi Suzuki

    Koichi Suzuki - 2013-12-03
    • Group: 1.2 Dev Q --> 1.3 Dev Q
     

Log in to post a comment.