[Postgres-xl-bugs] Prepared transactions

Koichi Suzuki koichi.dbms at gmail.com
Sun Apr 9 08:19:01 PDT 2017


Please try pgxc_clean.  If it does not work, pleas try xc_maintenance_mode,
which enables all the updating queries to any of datanode/coordinator.
Please be extremely careful not to cause inconsistency among nodes by
xc_maintenancre_mode.

---
Koichi Suzuki
https://www.linkedin.com/in/koichidbms


2017-04-08 4:39 GMT+09:00 Макар Махинько <makar.makhinko at mkechinov.ru>:

> 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 | recommender53430 | *
> $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 | recommender53451 | *
> $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 | recommender53460 | *
> $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/36261082/attachment.htm>


More information about the postgres-xl-bugs mailing list