2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowShareLock at character 15 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] AccessShareLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockRelease: lock [16458,16459] AccessShareLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockRelease, lock.c:1751 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowShareLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] AccessExclusiveLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: new: lock(0x7f026fdff6a0) id(16458,16459,0,7,3,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(AccessExclusiveLock) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: new: proclock(0x7f026fe85280) lock(0x7f026fdff6a0) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockCheckConflicts: no conflict: proclock(0x7f026fe85280) lock(0x7f026fdff6a0) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: GrantLock: lock(0x7f026fdff6a0) id(16458,16459,0,7,3,1) grantMask(100) req(0,0,0,0,0,0,0)=1 grant(0,0,0,0,0,0,0)=1 wait(0) type(AccessExclusiveLock) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowExclusiveLock at character 30 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowExclusiveLock 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockRelease: lock [16458,16459] AccessExclusiveLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockRelease, lock.c:1751 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockRelease: found: lock(0x7f026fdff6a0) id(16458,16459,0,7,3,1) grantMask(100) req(0,0,0,0,0,0,0)=1 grant(0,0,0,0,0,0,0)=1 wait(0) type(AccessExclusiveLock) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockRelease: found: proclock(0x7f026fe85280) lock(0x7f026fdff6a0) method(1) proc(0x7f027009e0e0) hold(100) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: UnGrantLock: updated: lock(0x7f026fdff6a0) id(16458,16459,0,7,3,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(AccessExclusiveLock) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: LockAcquire: lock [16458,16459] ExclusiveLock 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: LockAcquire: new: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(ExclusiveLock) 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: UnGrantLock: updated: proclock(0x7f026fe85280) lock(0x7f026fdff6a0) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: CleanUpLock: deleting: proclock(0x7f026fe85280) lock(0x7f026fdff6a0) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: CleanUpLock: deleting: lock(0x7f026fdff6a0) id(16458,16459,0,7,3,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(INVALID) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: SELECT * FROM t WHERE col1 = 1 FOR UPDATE; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: LockAcquire: new: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(0) 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowExclusiveLock at character 30 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowExclusiveLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: lock [16458,16459] ExclusiveLock 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: LockCheckConflicts: no conflict: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(0) 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19671] (psql) LOG: 00000: GrantLock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,1)=1 wait(0) type(ExclusiveLock) 2013-09-19 19:29:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: found: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,1)=1 wait(0) type(ExclusiveLock) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockAcquire: new: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: LockCheckConflicts: conflicting: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19670] (psql) LOG: 00000: WaitOnLock: sleeping on lock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,1)=1 wait(0) type(ExclusiveLock) 2013-09-19 19:29:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19673] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowExclusiveLock at character 30 2013-09-19 19:29:19 JST [19673] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19673] (psql) LOG: 00000: LockAcquire: lock [16458,16459] RowExclusiveLock 2013-09-19 19:29:19 JST [19673] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19673] (psql) LOG: 00000: LockAcquire: lock [16458,16459] ExclusiveLock 2013-09-19 19:29:19 JST [19673] (psql) LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19673] (psql) LOG: 00000: LockAcquire: found: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,1)=1 wait(1) type(ExclusiveLock) 2013-09-19 19:29:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19673] (psql) LOG: 00000: LockAcquire: new: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:29:19 JST [19673] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:19 JST [19673] (psql) LOG: 00000: WaitOnLock: sleeping on lock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(1) type(ExclusiveLock) 2013-09-19 19:29:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockAcquire: lock [16458,16459] ShareUpdateExclusiveLock 2013-09-19 19:29:28 JST [19704] LOCATION: LockAcquireExtended, lock.c:729 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockAcquire: new: lock(0x7f026fdff4a8) id(16458,16459,0,0,0,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(ShareUpdateExclusiveLock) 2013-09-19 19:29:28 JST [19704] LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockAcquire: new: proclock(0x7f026fe84fb0) lock(0x7f026fdff4a8) method(1) proc(0x7f027009ef40) hold(0) 2013-09-19 19:29:28 JST [19704] LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockCheckConflicts: no conflict: proclock(0x7f026fe84fb0) lock(0x7f026fdff4a8) method(1) proc(0x7f027009ef40) hold(0) 2013-09-19 19:29:28 JST [19704] LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:28 JST [19704] LOG: 00000: GrantLock: lock(0x7f026fdff4a8) id(16458,16459,0,0,0,1) grantMask(10) req(0,0,0,1,0,0,0)=1 grant(0,0,0,1,0,0,0)=1 wait(0) type(ShareUpdateExclusiveLock) 2013-09-19 19:29:28 JST [19704] LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockReleaseAll: proclock(0x7f026fe84fb0) lock(0x7f026fdff4a8) method(1) proc(0x7f027009ef40) hold(10) 2013-09-19 19:29:28 JST [19704] LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockReleaseAll: lock(0x7f026fdff4a8) id(16458,16459,0,0,0,1) grantMask(10) req(0,0,0,1,0,0,0)=1 grant(0,0,0,1,0,0,0)=1 wait(0) type(INVALID) 2013-09-19 19:29:28 JST [19704] LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:28 JST [19704] LOG: 00000: UnGrantLock: updated: lock(0x7f026fdff4a8) id(16458,16459,0,0,0,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(ShareUpdateExclusiveLock) 2013-09-19 19:29:28 JST [19704] LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:28 JST [19704] LOG: 00000: UnGrantLock: updated: proclock(0x7f026fe84fb0) lock(0x7f026fdff4a8) method(1) proc(0x7f027009ef40) hold(0) 2013-09-19 19:29:28 JST [19704] LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:28 JST [19704] LOG: 00000: LockReleaseAll: updated: lock(0x7f026fdff4a8) id(16458,16459,0,0,0,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(INVALID) 2013-09-19 19:29:28 JST [19704] LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:29:28 JST [19704] LOG: 00000: CleanUpLock: deleting: proclock(0x7f026fe84fb0) lock(0x7f026fdff4a8) method(1) proc(0x7f027009ef40) hold(0) 2013-09-19 19:29:28 JST [19704] LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:29:28 JST [19704] LOG: 00000: CleanUpLock: deleting: lock(0x7f026fdff4a8) id(16458,16459,0,0,0,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(INVALID) 2013-09-19 19:29:28 JST [19704] LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: DumpAllLocks: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(80) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: DumpAllLocks: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: DumpAllLocks: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: DumpAllLocks: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: DumpAllLocks: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: DumpAllLocks: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: process 19671 detected deadlock while waiting for ShareLock on transaction 133499 after 60000.461 ms 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: ProcSleep, proc.c:1232 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: waiting on: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(80) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: DumpAllLocks: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: process 19670 still waiting for ExclusiveLock on tuple (0,8) of relation 16459 of database 16458 after 60000.498 ms 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: ProcSleep, proc.c:1238 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) ERROR: 40P01: deadlock detected 2013-09-19 19:30:19 JST [19671] (psql) DETAIL: Process 19671 waits for ShareLock on transaction 133499; blocked by process 19670. Process 19670 waits for ExclusiveLock on tuple (0,8) of relation 16459 of database 16458; blocked by process 19671. Process 19671: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; Process 19670: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) HINT: See server log for query details. 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: DeadLockReport, deadlock.c:956 2013-09-19 19:30:19 JST [19671] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: LockReleaseAll: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(80) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: LockReleaseAll: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,3)=3 grant(0,0,0,0,0,0,1)=1 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: UnGrantLock: updated: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(0) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,0)=0 wait(2) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: UnGrantLock: updated: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(0) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: LockReleaseAll: updated: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(0) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,0)=0 wait(2) type(INVALID) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: CleanUpLock: deleting: proclock(0x7f026fe85280) lock(0x7f026fdff898) method(1) proc(0x7f027009de00) hold(0) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: LockCheckConflicts: no conflict: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: GrantLock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,1)=1 wait(2) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19671] (psql) LOG: 00000: LockCheckConflicts: conflicting: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:30:19 JST [19671] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: process 19670 acquired ExclusiveLock on tuple (0,8) of relation 16459 of database 16458 after 60001.231 ms 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: ProcSleep, proc.c:1242 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: WaitOnLock: wakeup on lock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,1)=1 wait(1) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: LockAcquire: granted: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(80) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: LockAcquire: granted: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,1)=1 wait(1) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: LockRelease: lock [16458,16459] ExclusiveLock 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LockRelease, lock.c:1751 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: LockRelease: found: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,2)=2 grant(0,0,0,0,0,0,1)=1 wait(1) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: LockRelease: found: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(80) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: UnGrantLock: updated: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(0) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,0)=0 wait(1) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: UnGrantLock: updated: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: CleanUpLock: deleting: proclock(0x7f026fe851a8) lock(0x7f026fdff898) method(1) proc(0x7f027009e0e0) hold(0) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: LockCheckConflicts: no conflict: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19670] (psql) LOG: 00000: GrantLock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,1)=1 wait(1) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19670] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19670] (psql) STATEMENT: UPDATE /* SELECTandUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: WaitOnLock: wakeup on lock: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,1)=1 wait(0) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: LockAcquire: granted: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(80) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: LockAcquire: granted: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,1)=1 wait(0) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: LockRelease: lock [16458,16459] ExclusiveLock 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: LockRelease, lock.c:1751 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: LockRelease: found: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(80) req(0,0,0,0,0,0,1)=1 grant(0,0,0,0,0,0,1)=1 wait(0) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: LockRelease: found: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(80) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: UnGrantLock: updated: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(ExclusiveLock) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: UnGrantLock: updated: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: CleanUpLock: deleting: proclock(0x7f026fe85238) lock(0x7f026fdff898) method(1) proc(0x7f027009e3c0) hold(0) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: PROCLOCK_PRINT, lock.c:330 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1; 2013-09-19 19:30:19 JST [19673] (psql) LOG: 00000: CleanUpLock: deleting: lock(0x7f026fdff898) id(16458,16459,0,8,3,1) grantMask(0) req(0,0,0,0,0,0,0)=0 grant(0,0,0,0,0,0,0)=0 wait(0) type(INVALID) 2013-09-19 19:30:19 JST [19673] (psql) LOCATION: LOCK_PRINT, lock.c:318 2013-09-19 19:30:19 JST [19673] (psql) STATEMENT: UPDATE /* onlyUPDATE */ t SET col2 = 'A' WHERE col1 = 1;