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)