[Postgres-xc-bugs] Fix a bug about UPDATE ... RETURNNING...

[ZhangJulian <jul...@ou...>]

[zhangzl@compute-22-05 PGXC]$ for i in `seq 1 10`; do psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2" & done
[1] 10046
[2] 10047
[3] 10048
[4] 10049
[5] 10050
[6] 10051
[7] 10052
[8] 10053
[9] 10054
[10] 10055
[zhangzl@compute-22-05 PGXC]$  c2 
----
 18
(1 row)

UPDATE 1
ERROR:  deadlock detected
DETAIL:  Process 10080 waits for AccessExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10080.
ERROR:  deadlock detected
DETAIL:  Process 10081 waits for AccessExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10081.
ERROR:  deadlock detected
DETAIL:  Process 10082 waits for AccessExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10082.
ERROR:  deadlock detected
DETAIL:  Process 10083 waits for AccessExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10083.
ERROR:  deadlock detected
DETAIL:  Process 10084 waits for AccessExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10084.
ERROR:  deadlock detected
DETAIL:  Process 10085 waits for AccessExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10085.
WARNING:  unexpected EOF on datanode connection
ERROR:  deadlock detected
DETAIL:  Process 10070 waits for ExclusiveLock on tuple (0,35) of relation 16648 of database 12919; blocked by process 10079.
Process 10079 waits for ShareLock on transaction 44113; blocked by process 10070.
WARNING:  unexpected EOF on datanode connection
WARNING:  unexpected EOF on datanode connection
ERROR:  Failed to read response from Datanodes
WARNING:  unexpected EOF on datanode connection
ERROR:  Failed to read response from Datanodes

[1]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[2]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[3]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[4]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[5]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[6]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[7]   Done                    psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[8]   Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[9]-  Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"
[10]+  Exit 1                  psql postgres -c "update t1 set c2 = c2 + 1 where c1 = 1 returning c2"