Re: too many LWLocks taken

Поиск
Список
Период
Сортировка
От Alex Vinogradovs
Тема Re: too many LWLocks taken
Дата
Msg-id 1207585149.81391.26.camel@localhost
обсуждение исходный текст
Ответ на Re: too many LWLocks taken  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
It appears the errors were caused by table corruption. I've
truncated and reloaded some large table (300m entries),
and the problem disappeared. Table corruption was probably
caused by hardware failure, not by PostgreSQL :)


On Fri, 2008-04-04 at 20:15 -0400, Tom Lane wrote:
> Alex Vinogradovs <AVinogradovs@Clearpathnet.com> writes:
> > Version is 8.2.5 running on FreeBSD 6.2. I can try upgrading
> > to 8.2.7, if you think that would help.
>
> Well, an upgrade would be a good idea on general principles, but
> I doubt it will fix a previously unknown bug.
>
> Does the postmaster log show any other odd behavior around these
> errors?  Which process is throwing the error anyway?  If it's
> a regular backend, what query is it executing?
>
>             regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tony Caduto
Дата:
Сообщение: Re: edb-debugger, debugging pl/pgsql
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: edb-debugger, debugging pl/pgsql