Re: [GENERAL] Idle Sessions inTransaction with RELEASE_EXEC_SVP queries and locks

2014-12-10 Thread Adrian Klaver
On 12/08/2014 02:05 AM, chris.jur...@primesoft.ph wrote: ​I am having a problem with having idle sessions in transactions. In pgAdmin Server Status, it is showing "RELEASE_EXEC_SVP_XX" (XX data are varied) as its query and it's locks also contain a lot of these "RELEASE_EXEC_SVP_XX" e

Re: [GENERAL] Idle Sessions inTransaction with RELEASE_EXEC_SVP queries and locks

2014-12-09 Thread Sameer Kumar
On 10 Dec 2014 08:52, wrote: > > ​I am having a problem with having idle sessions in transactions. In pgAdmin Server Status, it is showing "RELEASE_EXEC_SVP_XX" (XX data are varied) as its query and it's locks also contain a lot of these "RELEASE_EXEC_SVP_XX" entries. What do these mea

[GENERAL] Idle Sessions inTransaction with RELEASE_EXEC_SVP queries and locks

2014-12-09 Thread chris . jurado
​I am having a problem with having idle sessions in transactions. In pgAdmin Server Status, it is showing "RELEASE_EXEC_SVP_XX" (XX data are varied) as its query and it's locks also contain a lot of these "RELEASE_EXEC_SVP_XX" entries. What do these mean? These commonly cause lock b