Re: syslog enabled causes random hangs?
От | Arthur Ward |
---|---|
Тема | Re: syslog enabled causes random hangs? |
Дата | |
Msg-id | 16572.68.62.129.152.1060190049.squirrel@www.dominionsciences.com обсуждение исходный текст |
Ответ на | Re: syslog enabled causes random hangs? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: syslog enabled causes random hangs?
|
Список | pgsql-admin |
> It looks to me like the guy doing VACUUM is simply waiting for the other > guy to release a page-level lock. The other guy is running a deferred > trigger and so I'd expect him to be holding one or two page-level locks, > on the page or pages containing the tuple or tuples passed to the > trigger. Nothing evidently wrong there. If I remember what I was working on the other day when this whole thing started, I think it was a single backend and a checkpoint that collided. I'll trace that combination, assuming it happens again. > The real question is why does vsyslog() have anything to block on, when > it's running in an unthreaded process? Seeing that you are using > plpython, I wonder if Python is confusing matters somehow. Oof. I'm using plpython all over the place; I don't think this problem has happened in any location that can work without it easily. :-/
В списке pgsql-admin по дате отправления: