Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 7.4.10 hanging on delete

From: Jonathan Parkin <jonathan(dot)parkin(at)legendplc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Admin Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL 7.4.10 hanging on delete
Date: 2005-12-21 18:24:51
Message-ID: 1135189491.27921.104.camel@jparkin.local (view raw or flat)
Thread:
Lists: pgsql-admin
> Given the stack traces, I no longer think it's a data corruption issue
> --- somehow libc is screwing up.  Backends are single-threaded and there
> is *no* reason for pthread_mutex_lock to block, ever.
> 
> I have a vague recollection that we saw something similar reported once
> before, but it was awhile ago [ digs... ]  Here it is:
> http://archives.postgresql.org/pgsql-admin/2003-07/msg00303.php
> and later
> http://archives.postgresql.org/pgsql-admin/2003-08/msg00064.php
> 
> We never did figure out what was up, but it is striking that the other
> reporter was also using plpython.  It begins to look like Python is
> somehow contributing to the problem.  What versions of python and
> glibc are you running, exactly?

glibc-2.3.2
python-2.2.2
postgresql-python-7.4.10

Linux 2.4.20

> If you just want to get your production machine back to stability,
> I'd recommend the workaround suggested in that thread, which is to
> not use syslog-based logging.

Which indeed appears to have stopped this from being a problem.

Thank you very much for all the help.  If you'd like any more
information (e.g. on versions of things) I may not be around until the
new year, but I'll happily provide them once I'm back.

Thanks again,

Jon
-- 
Best Regards

Jonathan Parkin
Developer

Legend Communications plc
T: 0844 390 2049
F: 0844 390 2001
E: jonathan(dot)parkin(at)legendplc(dot)com
W: http://www.legend.co.uk/

The information in this message is confidential and may be legally
privileged. Unauthorised disclosure, copying or distribution, either
whole or in part; or action taken in reliance on its content is
prohibited. If you are not the intended recipient, please notify Legend
Communications immediately.


In response to

pgsql-admin by date

Next:From: baraiDate: 2005-12-21 19:42:56
Subject: PostgreSQL crashing
Previous:From: Jaime CasanovaDate: 2005-12-21 18:19:10
Subject: Re: cache lookup failed for type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group