Re: pqReadData() -- backend closed the channel unexpectedly

I just sent this, but in reply to a thread that ended in "unexp"; consequently, it went to a different place.


Houston, we've got a problem with SMP boxes...

I commented out the first simple query that counted records in the database at script startup, and the problems
disappeared.I "THINK" the threading was closing the statement handle before the results of the query were returned to
themod_perl scripts on the SMP box. 

The SMP box was a bit too fast! I'd like to reiterate that I have the same, IDENTICAL software on 2 systems [every
singlesoftware package & patch]. No problems on the 4.5 year old single processor Intel box I use for development. For
now,I'll run the scaled down version on the production box, but this issue should be addressed. I can't be the only
personwith this issue. 

Thanks!


Tom Lane wrote:
>
> Buddy Lee Haystack <haystack@email.rentzone.org> writes:
> > Here's the program stack of the core file using gdb [I learn something new every day!]:
>
> > (gdb) bt
> > #0  0x8096243 in ?? ()
> > #1  0x8092f3e in ?? ()
> > #2  0x8092279 in ?? ()
> > #3  0x809197e in ?? ()
>
> Not much help there :-(.  Can you recompile with -g and try it again?
>
>                         regards, tom lane

--
BLH
www.RentZone.org