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 the mod_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 single software 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 person with this issue.

Thanks!

Tom Lane wrote:
>
> Buddy Lee Haystack <haystack(at)email(dot)rentzone(dot)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