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)?
The
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 large
file
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
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