"Craig A. James" <[EMAIL PROTECTED]> writes:
> I guess I misinterpreted the Postgress manual, which says (in 31.9, "C
> Language Functions"),
> "When allocating memory, use the PostgreSQL functions palloc and pfree
> instead of the corresponding C library functions malloc and free."
> I
Tom Lane wrote:
>My suspicion is that it's an incompatibility between malloc()
>libraries.
On Linux there's only supposed to be one malloc, ie, glibc's version.
On other platforms I'd be worried about threaded vs non-threaded libc
(because the backend is not threaded), but not Linux.
I guess I
"Craig A. James" <[EMAIL PROTECTED]> writes:
> My suspicion is that it's an incompatibility between malloc()
> libraries.
On Linux there's only supposed to be one malloc, ie, glibc's version.
On other platforms I'd be worried about threaded vs non-threaded libc
(because the backend is not threaded
Chris wrote:
This is a deadly bug, because our web site goes dead when this
happens, ...
Sounds like a deadlock issue.
...
stats_command_string = true
and restart postgresql.
then you'll be able to:
select * from pg_stat_activity;
to see what queries postgres is running and that might give yo
""Craig A. James"" <[EMAIL PROTECTED]> wrote
> I'm having a rare but deadly problem. On our web servers, a process
> occasionally gets stuck, and can't be unstuck. Once it's stuck, all
> Postgres activities cease. "kill -9" is required to kill it --
> signals 2 and 15 don't work, and "/etc/
This is a deadly bug, because our web site goes dead when this happens,
and it requires an administrator to log in and kill the stuck postgres
process then restart Postgres. We've installed failover system so that
the web site is diverted to a backup server, but since this has happened
twice
I'm having a rare but deadly problem. On our web servers, a process occasionally gets stuck, and
can't be unstuck. Once it's stuck, all Postgres activities cease. "kill -9" is required
to kill it -- signals 2 and 15 don't work, and "/etc/init.d/postgresql stop" fails.
Here's what the process
