[Koha-devel] z3950 search problems

[Sullivan,Deric [CMC]]

Hi,

	I've had a problem with the z3950 search client and I've noticed
that others have had a similar problem.  It's the problem where the database
connection is lost and reported in one of the log files.  Here's what I did
to get rid of the symptoms.  I'm not a Koha expert, nor a Perl expert, and I
usually use PostgreSQL instead of MySQL so I make no guaranties that this
fix is correct, but it does stop processz3950queue from complaining the way
it did and it seems to make sense that a forked process that terminates
should not be using, in the default fashion, any handles that the parent
process is relying on.  The forked process used a new name ($dbi) for the
handle, but it was the same handle.  Although even using "my $dbi =
C4::Context->new_dbh" instead of "my $dbi = C4::Context->dbh" would not have
worked since the child still keeps the reference to the parents handle
(because it was created before the fork) and this handle would be destroyed
when the child terminated.  At least that's how I see it.  There are
probably other problems because even after these modifications, the search
client still did not seem to work.

Replace:
my $dbi = C4::Context->dbh;
with:
$dbh->{"InactiveDestroy"} = "true";

Replace all references to dbi with dbh.


Deric
The views expressed here are mine and do not reflect the official position
of my employer or the organization through which the Internet was accessed.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20040224/b08994fa/attachment-0002.htm>