| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Andrew Berman <rexxe98(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Streaming Replication Randomly Locking Up |
| Date: | 2013-08-16 17:12:19 |
| Message-ID: | CAMkU=1z9k0=2pk5b5hhYYohqurC39udG+wYD43Bwiycq=YJguQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Aug 16, 2013 at 9:45 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Thu, Aug 15, 2013 at 1:28 PM, Andrew Berman <rexxe98(at)gmail(dot)com> wrote:
>> Hi Jeff,
>>
>> Here is the full process list at the time it stopped working (I have changed
>> the actual username, db and IP for security). Would the idle in transaction
>> process be the culprit?
>
> Most likely, yes. You should be able to dig into pg_locks to verify.
Actually, you can't. The waiting doesn't show up in pg_locks, because
it polls in a sleep-loop, rather than doing a normal wait on the lock.
Still, that idle in transaction process is almost surely the culprit.
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Berman | 2013-08-16 17:24:01 | Re: Streaming Replication Randomly Locking Up |
| Previous Message | Jeff Janes | 2013-08-16 16:45:34 | Re: Streaming Replication Randomly Locking Up |