Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=misuse.org;
 b=X/qfhMkj7GepGUY44miKSR1Dq/rZoMpM3Jihl7erJzxwHCRoypbfzyi86radKlQEZBoSoYdNh3OoFmVMKPEbUvB7KsZtPeov8S/l+SCkeIN2OFxHImcwyPEzc1+tss4l
 ;
MIME-Version: 1.0
In-Reply-To: <1451387504879-5879395.post@n5.nabble.com>
References: <1451387504879-5879395.post@n5.nabble.com>
Date: Tue, 29 Dec 2015 10:23:11 -0800
Message-ID: 
 <CAJexoS+_J=eeMF3dptbs0GAgCcmMjQuiBeXZjJ_DBzsAYHBpog@mail.gmail.com>
Subject: Re: Stucks in the middle
From: Steve Midgley <science@misuse.org>
To: Yevgeny <jebjick@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=001a113d30b69bb0dd05280d8318
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

--001a113d30b69bb0dd05280d8318
Content-Type: text/plain; charset=UTF-8

On Tue, Dec 29, 2015 at 3:11 AM, Yevgeny <jebjick@gmail.com> wrote:

> Hello,
>
> I have a problem. Sometimes the whole sites stucks in the middle (doesn't
> matter which page is opened) because of some sql issue.
> When i reboot postresql it starts working good immediately.
> But when it's stuck i can see in the log that new and new queries are
> running, meaning it's stuck only for my session.
>
> What can be a reason and how can i solve this problem?
>

There are a lot of possible reasons, and I think you'll need to provide
more details to get any accuracy on guesses from the list. Here are a few
ideas:

   - You have a middle tier app which is failing to release cursor or other
   type of open query
   - You have a deadlock situation in Pg where you are mutually locking a
   row in some way that prevents your process from completing
   - You are executing a query that is very long running (not optimized) so
   your connection appears blocked but is in fact just taking forever to
   complete

Steve

--001a113d30b69bb0dd05280d8318
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On T=
ue, Dec 29, 2015 at 3:11 AM, Yevgeny <span dir=3D"ltr">&lt;<a href=3D"mailt=
o:jebjick@gmail.com" target=3D"_blank">jebjick@gmail.com</a>&gt;</span> wro=
te:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-=
left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
I have a problem. Sometimes the whole sites stucks in the middle (doesn&#39=
;t<br>
matter which page is opened) because of some sql issue.<br>
When i reboot postresql it starts working good immediately.<br>
But when it&#39;s stuck i can see in the log that new and new queries are<b=
r>
running, meaning it&#39;s stuck only for my session.<br>
<br>
What can be a reason and how can i solve this problem?<br></blockquote><div=
><br></div><div>There are a lot of possible reasons, and I think you&#39;ll=
 need to provide more details to get any accuracy on guesses from the list.=
 Here are a few ideas:</div><div><ul><li>You have a middle tier app which i=
s failing to release cursor or other type of open query<br></li><li>You hav=
e a deadlock situation in Pg where you are mutually locking a row in some w=
ay that prevents your process from completing</li><li>You are executing a q=
uery that is very long running (not optimized) so your connection appears b=
locked but is in fact just taking forever to complete</li></ul><div>Steve</=
div></div></div></div></div>

--001a113d30b69bb0dd05280d8318--