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 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!

> 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(at)co(dot)centre(dot)pa(dot)us

--
BLH
www.RentZone.org