[Postgres-xl-bugs] Prepared transactions

asvany asvany at gmail.com
Mon Apr 10 02:29:50 PDT 2017


Hello,


I solve this situations with the following pattern:

EXECUTE DIRECT ON (data_pg01) 'SELECT * FROM pg_prepared_xacts';

If I get some result like you, I run :

EXECUTE DIRECT ON (data_pg07) E'ROLLBACK PREPARED
''_$XC$13423597:coord_pg00:F:8:0:-1701578581:-115878879:-340290245:-381459043:-616459380:198262771:2058224329:1910162606''
;';



,As


On 04/07/2017 09:39 PM, Макар Махинько wrote:
>
> Hello!
>
> I have suspended transactions, see them only on datanode and I can not
> do anything with them!
> Please help, tried everything you can already.
>
> postgres=# EXECUTE DIRECT on (datanode_1) 'select * from
> pg_prepared_xacts;';
> transaction | gid | prepared | owner | database
> -------------+-----------------------------------------------------------+-------------------------------+----------+-------------
> 53423 | /$XC$53423:coord1:T:2:1:-675012441:-1047623914:1885696643 |
> 2017-04-07 21:23:47.211722+02 | postgres | recommender
> 53430 | /$XC$53430:coord1:T:2:1:-675012441:-1047623914:1885696643 |
> 2017-04-07 21:23:47.251503+02 | postgres | recommender
> 53436 | /$XC$53436:coord1:T:2:1:-675012441:-1047623914:1885696643 |
> 2017-04-07 21:23:47.285763+02 | postgres | recommender
> 53451 | /$XC$53451:coord1:T:2:1:-675012441:-1047623914:1885696643 |
> 2017-04-07 21:23:47.528553+02 | postgres | recommender
> 53434 | /$XC$53434:coord1:T:2:1:-675012441:-1047623914:1885696643 |
> 2017-04-07 21:23:47.281449+02 | postgres | recommender
> 53460 | /$XC$53460:coord1:T:2:1:-675012441:-1047623914:1885696643 |
> 2017-04-07 21:23:48.623635+02 | postgres | recommender
> (6 rows)
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Postgres-xl-bugs mailing list
> Postgres-xl-bugs at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-bugs

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20170410/1659a662/attachment.htm>


More information about the postgres-xl-bugs mailing list