[Lxr-dev] trouble with postgres -- connection closing

[Kevin W. <kev...@ov...>]

i'm attempting to use lxr to index the FreeBSD kernel source tree, in CVS
format, in the first pass i'm just indexing the head.  i'm doing this on a
redhat 7.1 machine, with postgresql 7.1.2, for what it's worth.

after a little over two minutes if i'm hitting already referenced code, or
after a long, variable amount of time if it's actually using the database
i end up getting the error:

DBD::Pg::st execute failed: PQsendQuery() -- There is no connection to the =
backend. at lib//LXR/Index/Postgres.pm line 253.

I'm not sure how I should go about adding in something that does...

if (!$dbh->ping()) {=20
	$dbh =3D DBI->connect($dbname);
	$die($DBI::errstr) unless $dbh;
}

because then I also have to update all the $foo_select, $foo_nextval,
$foo_insert, $foo_update vars whould would still be referencing an invalid
database handle.

Anybody have any suggestions for how they feel this bug should be fixed?

Kevin Way