Re: Server hangs on multiple connections - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Server hangs on multiple connections
Date
Msg-id 3172.1032469840@sss.pgh.pa.us
Whole thread Raw
In response to Server hangs on multiple connections  (David Christian <davidc@comtechmobile.com>)
Responses Re: Server hangs on multiple connections  (David Christian <davidc@comtechmobile.com>)
List pgsql-bugs
David Christian <davidc@comtechmobile.com> writes:
> The problem I'm describing is only happening when I install on the
> following platform:  Yellow Dog Linux 2.3 on PowerPC (PowerMac G4
> QuickSilver, dual processor) with 1.5GB RAM.

Hmm ... I'm not sure whether anyone's tried it with a dual-processor PPC
system before.  I wonder if there's some problem with the PPC spinlock
code given multiple CPUs?

Could you build with --enable-debug and --enable-cassert (if you didn't
already), repeat the 'make check' scenario, and then attach to a few of
the stuck backend processes with gdb and get stack traces from them?
That would give us a little more info to work with.

> I have run PostgreSQL since 7.1 successfully on Red Hat Linux i386 and
> Mac OS X 10.2 ppc (the very box I am currently having problems with)
> without the lockup problem.

Have you run 7.2.* on this same box under OS X?  (Ie, could the problem
be specific to YDL?)

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'
Next
From: Tom Lane
Date:
Subject: Re: Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'