[Postgres-xl-bugs] Prepared transactions

Макар Махинько makar.makhinko at mkechinov.ru
Mon Apr 10 05:40:34 PDT 2017


Hi!
Version Postgres-XL 9.5r1.4 from git.

pgxc_clean: connecting to database "postgres", host: "localhost", port: 5432
pgxc_clean: connected successfully
pgxc_clean: Connected to the node "coord1"
pgxc_clean: Databases visible from the node "coord1":  "template1"
"postgres" "recommender"
pgxc_clean: Node list visible from the node "coord1"
Name: coord1, host: IP, port: 5432, type: coordinator
Name: datanode_1, host: IP, port: 40001, type: datanode
Name: datanode_2, host: IP, port: 40001, type: datanode
pgxc_clean: 2PC transaction list.
Database: "template1":
Database: "postgres":
Database: "recommender":
    gxid: 53438, xid:
"_$XC$53438:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53440, xid:
"_$XC$53440:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53439, xid:
"_$XC$53439:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53437, xid:
"_$XC$53437:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53449, xid:
"_$XC$53449:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53448, xid:
"_$XC$53448:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53455, xid:
"_$XC$53455:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53461, xid:
"_$XC$53461:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53468, xid:
"_$XC$53468:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53477, xid:
"_$XC$53477:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53483, xid:
"_$XC$53483:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
    gxid: 53491, xid:
"_$XC$53491:coord1:T:2:1:-675012441:-1047623914:1885696643",
owner: postgres
        node: coord1, status: aborted
        node: datanode_1, status: prepared
        node: datanode_2, status: prepared
pgxc_clean: disconnecting
pgxc_clean: recovering 2PC for database "template1"
pgxc_clean: connected to the database "template1"
pgxc_clean: recovering 2PC for database "postgres"
pgxc_clean: connected to the database "postgres"
pgxc_clean: recovering 2PC for database "recommender"
*Failed to set xc_maintenance_mode. ()*
*Skipping database recommender.*

But manual *xc_maintenance_mode *its work and i can rollback transaction





2017-04-09 18:19 GMT+03:00 Koichi Suzuki <koichi.dbms at gmail.com>:

> 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/cea9e438/attachment.htm>


More information about the postgres-xl-bugs mailing list