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

That's the core output. I double checked it. I' unfamiliar with doing anything to a core file other then deleting it, but wouldn't the fact that it is a dump of a crashed program mean that some of the program dump is going to be garbled?

Thanks!

"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

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@co.centre.pa.us

--
BLH
www.RentZone.org