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

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!


>         my($sql11,$sth11);
>
>         if (! defined $sth11) {
>                 $sql11 = 'select count(1) from rzlist where  rzactive =1';
>
>                 $sth11 = $dbh->prepare($sql11)
>                         or die "Couldn't prepare statement: " . $dbh->errstr;
>         }
>
>         $sth11->execute()
>                 or die "Couldn't execute statement: " . $sth11->errstr;
>
>         my $HOWMANY = $sth11->fetchrow_array();
>
>         $sth11->finish;



"Robert D. Nelson" wrote:
>
> >Core was generated by `/usr/bin/postgres localhos'.
>
> >and trying to run any mod_perl script connecting to a databse I'm greated
> >with a connect
> >DB error that questions if postmaster is running on port.... It is...
>
> Uh, the first line stood out as an answer to the second section. Either you
> didn't quote the gdb output properly, or somewhere you're trying to connect
> to localhos, not localhost.
>
> Rob Nelson
> rdnelson@co.centre.pa.us

--
BLH
www.RentZone.org