From: ZhangJulian <jul...@ou...> - 2014-07-03 06:05:07
|
[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" |