Hi:
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> > What can cause a stuck spinlock?
> In theory, that shouldn't ever happen. Can you
> reproduce it?
> > regards, tom lane
I could not reproduce it, but I'll describe how
error happen. I have a program that read a file larg
Ludwig Isaac Lim <[EMAIL PROTECTED]> writes:
>I'm guessing that the spinlock error occurs after
> there are around hundreds (or thousands) of queued
> postmaster processes.
Thousands? How large is your max_connections parameter, anyway
(and do you really have big enough iron to support it)?
Ludwig Isaac Lim <[EMAIL PROTECTED]> writes:
> What can cause a stuck spinlock?
In theory, that shouldn't ever happen. Can you reproduce it?
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmas
Hi:
I notice the following error message in my
postgresql log file:
FATAL : s_lock (0x401db020) at lwlock.c Stuck
spinlock. Aborting
Version of my postgresql :
PostgreSQL 7.2.3 on i686-pc-linux-gnu compiled by
GCC 2.96
Operating System : RedHat 7.1
What can cause a stuck spinl
Hi:
I notice the following error message in my
postgresql log file:
FATAL : s_lock (0x401db020) at lwlock.c Stuck
spinlock. Aborting
Version of my postgresql :
PostgreSQL 7.2.3 on i686-pc-linux-gnu compiled by GCC
2.96
Operating System : RedHat 7.1
Thanks in advance,
ludwig lim
_
