lundi 20 avril 2015

Postgres keeps transaction idle after killing the program that created it

My Postgres 9.2 seems to keep some transactions in idle status, even after killing the program the created it.

Example: I open a transaction in a program, then I debug the program from Visual Studio, then I stop the debugging and the program is killed.

But the PgAdmin still show the transaction as idle:

enter image description here

No VSHost or similar process are active, the transaction remains idle even after closing the Visual Studio or shutting down the pc.

Aucun commentaire:

Enregistrer un commentaire