gpdb
gpdb copied to clipboard
Published
20 hours ago •
greenplum-db
greenplum-db
The `ABORT TRANSACTION` invoked by `postgres_fdw` always remains in the active state and does not terminate.
Bug Report
Greenplum version or build
- 6.24.4
OS version and uname -a
autoconf options used ( config.status --config )
Installation information ( pg_config )
Expected behavior
Actual behavior
[gpadmin@gp6mdw greenplum]$ psql F6_BDC
psql (9.4.26)
Type "help" for help.
F6_BDC=# select pid,
F6_BDC-# datname,
F6_BDC-# usename,
F6_BDC-# client_addr,
F6_BDC-# application_name,
F6_BDC-# query,
F6_BDC-# -- wait_event,
F6_BDC-# -- wait_event_type,
F6_BDC-# waiting,
F6_BDC-# backend_xid,
F6_BDC-# xact_stay,
F6_BDC-# query_stay,
F6_BDC-# state,
F6_BDC-# waiting_reason
F6_BDC-# from
F6_BDC-# (select pid,
F6_BDC(# datname,
F6_BDC(# usename,
F6_BDC(# client_addr,
F6_BDC(# application_name,
F6_BDC(# -- wait_event,
F6_BDC(# -- wait_event_type,
F6_BDC(# waiting,
F6_BDC(# waiting_reason,
F6_BDC(# backend_start,
F6_BDC(# backend_xid,
F6_BDC(# xact_start,
F6_BDC(# age(now(), xact_start) as xact_stay,
F6_BDC(# query_start,
F6_BDC(# age(now(), query_start) as query_stay,
F6_BDC(# query,
F6_BDC(# state
F6_BDC(# from pg_stat_activity
F6_BDC(# where state != 'idle'
F6_BDC(# -- and usename != 'pgexporter' and usename != 'replicator'
F6_BDC(# and application_name = 'postgres_fdw'
F6_BDC(# -- and wait_event not in ('WalSenderMain', 'WalSenderWaitForWAL')
F6_BDC(# ) active_connections
F6_BDC-# order by query_stay asc
F6_BDC-# -- limit 10
F6_BDC-# ;
pid | datname | usename | client_addr | application_name | query | waiting | backend_xid | xact_stay | query_stay | state | waiting_reason
---------+---------+----------+----------------+------------------+-------------------+---------+-------------+-----------------+-----------------+--------+----------------
2611105 | F6_BDC | bdcenter | 192.168.16.118 | postgres_fdw | ABORT TRANSACTION | f | | 22:35:12.900014 | 22:34:26.668364 | active |
2610868 | F6_BDC | bdcenter | 192.168.16.118 | postgres_fdw | ABORT TRANSACTION | f | | 22:37:11.393401 | 22:36:39.277979 | active |
(2 rows)
F6_BDC=# show statement_timeout;
statement_timeout
-------------------
15min
(1 row)
F6_BDC=# \q
[gpadmin@gp6mdw greenplum]$ gpssh -f /opt/greenplum/config/hostlist 'ps -ef | grep con522310 | grep -v idle'
[ gp6mdw] gpadmin 2610868 1394586 0 Sep13 ? 00:03:12 postgres: 5432, bdcenter F6_BDC 192.168.16.118(56188) con522310 cmd71 ROLLBACK
[ gp6mdw] gpadmin 2893747 2893721 0 16:13 pts/16 00:00:00 grep --color=auto con522310
[gp6sdw1] gpadmin 701022 18211 0 Sep13 ? 00:01:35 postgres: 40000, bdcenter F6_BDC 172.17.239.146(41338) con522310 seg0 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 701023 18218 0 Sep13 ? 00:01:26 postgres: 40001, bdcenter F6_BDC 172.17.239.146(41372) con522310 seg1 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 701024 18221 0 Sep13 ? 00:01:26 postgres: 40002, bdcenter F6_BDC 172.17.239.146(38406) con522310 seg2 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 701025 18219 0 Sep13 ? 00:01:27 postgres: 40003, bdcenter F6_BDC 172.17.239.146(47314) con522310 seg3 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 2618004 2617958 0 16:13 pts/0 00:00:00 grep --color=auto con522310
[gp6sdw3] gpadmin 683316 4191499 0 Sep13 ? 00:01:33 postgres: 40000, bdcenter F6_BDC 172.17.239.146(36776) con522310 seg8 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 683317 4191495 0 Sep13 ? 00:01:35 postgres: 40003, bdcenter F6_BDC 172.17.239.146(40412) con522310 seg11 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 683318 4191501 0 Sep13 ? 00:01:32 postgres: 40001, bdcenter F6_BDC 172.17.239.146(56614) con522310 seg9 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 683319 4191497 0 Sep13 ? 00:01:34 postgres: 40002, bdcenter F6_BDC 172.17.239.146(36014) con522310 seg10 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 2602384 2602338 0 16:13 pts/0 00:00:00 grep --color=auto con522310
[gp6sdw2] gpadmin 741408 60538 0 Sep13 ? 00:01:41 postgres: 40001, bdcenter F6_BDC 172.17.239.146(57702) con522310 seg5 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 741409 60547 0 Sep13 ? 00:01:40 postgres: 40002, bdcenter F6_BDC 172.17.239.146(57262) con522310 seg6 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 741410 60545 0 Sep13 ? 00:01:40 postgres: 40003, bdcenter F6_BDC 172.17.239.146(45872) con522310 seg7 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 741411 60541 0 Sep13 ? 00:01:41 postgres: 40000, bdcenter F6_BDC 172.17.239.146(36614) con522310 seg4 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 2657002 2656956 0 16:13 pts/0 00:00:00 grep --color=auto con522310
[gp6smdw] gpadmin 3429 3407 0 16:13 pts/0 00:00:00 grep --color=auto con522310
[gp6sdw5] gpadmin 657408 4172048 0 Sep13 ? 00:01:29 postgres: 40000, bdcenter F6_BDC 172.17.239.146(47334) con522310 seg16 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 657409 4172043 0 Sep13 ? 00:01:29 postgres: 40002, bdcenter F6_BDC 172.17.239.146(42884) con522310 seg18 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 657410 4172037 0 Sep13 ? 00:01:29 postgres: 40001, bdcenter F6_BDC 172.17.239.146(41530) con522310 seg17 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 657411 4172047 0 Sep13 ? 00:01:28 postgres: 40003, bdcenter F6_BDC 172.17.239.146(41712) con522310 seg19 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 2572755 2572709 0 16:13 pts/0 00:00:00 grep --color=auto con522310
[gp6sdw4] gpadmin 693741 14080 0 Sep13 ? 00:01:51 postgres: 40001, bdcenter F6_BDC 172.17.239.146(50114) con522310 seg13 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 693742 14082 0 Sep13 ? 00:01:52 postgres: 40003, bdcenter F6_BDC 172.17.239.146(59162) con522310 seg15 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 693743 14072 0 Sep13 ? 00:01:52 postgres: 40002, bdcenter F6_BDC 172.17.239.146(51080) con522310 seg14 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 693744 14075 0 Sep13 ? 00:01:53 postgres: 40000, bdcenter F6_BDC 172.17.239.146(60428) con522310 seg12 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 2608951 2608905 0 16:13 pts/0 00:00:00 grep --color=auto con522310
[gpadmin@gp6mdw greenplum]$ gpssh -f /opt/greenplum/config/hostlist 'ps -ef | grep con522398 | grep -v idle'
[ gp6mdw] gpadmin 2611105 1394586 0 Sep13 ? 00:03:21 postgres: 5432, bdcenter F6_BDC 192.168.16.118(59966) con522398 cmd113 ROLLBACK
[ gp6mdw] gpadmin 2893845 2893823 0 16:13 pts/16 00:00:00 grep --color=auto con522398
[gp6sdw2] gpadmin 743456 60541 0 Sep13 ? 00:01:41 postgres: 40000, bdcenter F6_BDC 172.17.239.146(55802) con522398 seg4 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 743457 60538 0 Sep13 ? 00:01:41 postgres: 40001, bdcenter F6_BDC 172.17.239.146(38626) con522398 seg5 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 743458 60547 0 Sep13 ? 00:01:40 postgres: 40002, bdcenter F6_BDC 172.17.239.146(60256) con522398 seg6 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 743459 60545 0 Sep13 ? 00:01:39 postgres: 40003, bdcenter F6_BDC 172.17.239.146(60740) con522398 seg7 cmd15 slice1 MPPEXEC SELECT
[gp6sdw2] gpadmin 2657064 2657042 0 16:13 pts/0 00:00:00 grep --color=auto con522398
[gp6sdw5] gpadmin 659456 4172048 0 Sep13 ? 00:01:29 postgres: 40000, bdcenter F6_BDC 172.17.239.146(50108) con522398 seg16 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 659457 4172037 0 Sep13 ? 00:01:29 postgres: 40001, bdcenter F6_BDC 172.17.239.146(41066) con522398 seg17 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 659458 4172043 0 Sep13 ? 00:01:28 postgres: 40002, bdcenter F6_BDC 172.17.239.146(55176) con522398 seg18 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 659459 4172047 0 Sep13 ? 00:01:29 postgres: 40003, bdcenter F6_BDC 172.17.239.146(59266) con522398 seg19 cmd15 slice1 MPPEXEC SELECT
[gp6sdw5] gpadmin 2572817 2572795 0 16:13 pts/0 00:00:00 grep --color=auto con522398
[gp6sdw3] gpadmin 685368 4191499 0 Sep13 ? 00:01:33 postgres: 40000, bdcenter F6_BDC 172.17.239.146(40188) con522398 seg8 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 685369 4191501 0 Sep13 ? 00:01:33 postgres: 40001, bdcenter F6_BDC 172.17.239.146(57336) con522398 seg9 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 685370 4191497 0 Sep13 ? 00:01:34 postgres: 40002, bdcenter F6_BDC 172.17.239.146(58058) con522398 seg10 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 685371 4191495 0 Sep13 ? 00:01:33 postgres: 40003, bdcenter F6_BDC 172.17.239.146(34364) con522398 seg11 cmd15 slice1 MPPEXEC SELECT
[gp6sdw3] gpadmin 2602446 2602424 0 16:13 pts/0 00:00:00 grep --color=auto con522398
[gp6sdw1] gpadmin 703072 18211 0 Sep13 ? 00:01:35 postgres: 40000, bdcenter F6_BDC 172.17.239.146(39372) con522398 seg0 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 703073 18218 0 Sep13 ? 00:01:26 postgres: 40001, bdcenter F6_BDC 172.17.239.146(45772) con522398 seg1 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 703074 18221 0 Sep13 ? 00:01:27 postgres: 40002, bdcenter F6_BDC 172.17.239.146(34716) con522398 seg2 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 703075 18219 0 Sep13 ? 00:01:26 postgres: 40003, bdcenter F6_BDC 172.17.239.146(43980) con522398 seg3 cmd15 slice1 MPPEXEC SELECT
[gp6sdw1] gpadmin 2618066 2618044 0 16:13 pts/0 00:00:00 grep --color=auto con522398
[gp6smdw] gpadmin 3475 3453 0 16:13 pts/0 00:00:00 grep --color=auto con522398
[gp6sdw4] gpadmin 695789 14075 0 Sep13 ? 00:01:52 postgres: 40000, bdcenter F6_BDC 172.17.239.146(42670) con522398 seg12 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 695790 14072 0 Sep13 ? 00:01:52 postgres: 40002, bdcenter F6_BDC 172.17.239.146(59266) con522398 seg14 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 695791 14080 0 Sep13 ? 00:01:52 postgres: 40001, bdcenter F6_BDC 172.17.239.146(41104) con522398 seg13 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 695792 14082 0 Sep13 ? 00:01:51 postgres: 40003, bdcenter F6_BDC 172.17.239.146(33874) con522398 seg15 cmd15 slice1 MPPEXEC SELECT
[gp6sdw4] gpadmin 2609013 2608991 0 16:13 pts/0 00:00:00 grep --color=auto con522398
