Re: [GENERAL] (Never?) Kill Postmaster?

Tom Lane wrote:
> Hah, I've got it. (Should have searched Red Hat's bugzilla sooner.)
> What you are hitting is a glibc bug, as explained here:
> http://sources.redhat.com/ml/libc-hacker/2007-10/msg00010.html
> If libpthread is loaded after first use of dcgettext, then subsequent
> uses are at risk of hanging because they start to use a mutex lock
> that was never initialized. And libperl brings in libpthread.
>

Many thanks for your efforts which have been crowned with success at last!!

What remains inscrutable to me is why this problem did not arise earlier. I cannot remember any changes that I have made to the system recently. Or maybe it has been a defective update of the glibc? I did not see in the bug report any hint about when this bug has been introduced. Obviously it has something to do with the users having disconnects, but we have been working with dial-up connections for many years and did never see this bug.

By the way, does the "--enable-thread-safety" switch have anything to do with the problem?

> So you need to pester SuSE for a glibc with that fix in it ...
>

Phew, that might be hard work, but I will give it a try. Until I have success I will probably restart the database server once in a week to remove those old connections.

Thanks a lot for your help!

    Christian

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

P.S.: Can I change the root password again?

-- 
Deriva GmbH                         Tel.: +49 551 489500-42
Financial IT and Consulting         Fax:  +49 551 489500-91
Hans-Böckler-Straße 2                  
http://www.deriva.de
D-37079 Göttingen

Deriva CA Certificate: 
http://www.deriva.de/deriva-ca.cer


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster