From: Steve Midgley <science@misuse.org>
To: Yevgeny <jebjick@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Stucks in the middle
Date: Tue, 29 Dec 2015 10:23:11 -0800
Message-ID: <CAJexoS+_J=eeMF3dptbs0GAgCcmMjQuiBeXZjJ_DBzsAYHBpog@mail.gmail.com> (raw)
In-Reply-To: <1451387504879-5879395.post@n5.nabble.com>
References: <1451387504879-5879395.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: science@misuse.org, jebjick@gmail.com
Subject: Re: Stucks in the middle
In-Reply-To: <CAJexoS+_J=eeMF3dptbs0GAgCcmMjQuiBeXZjJ_DBzsAYHBpog@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox