Menu

#79 Prepared transactions

Undecided
open
nobody
None
5
None
nobody
2017-04-07
2017-04-07
No

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)

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.