[Koha-devel] 3.18 search speed

[Paul A]

I'm really looking for some help here, please, my brain (whatever is left!) 
is swimming in Perl code.

I'm getting the notion that maybe the db conversion (3.08 => 3.18, which 
reported all done) missed something, or that after two years of use, 
there's possibly something corrupt.  If not, there's maybe a "config file" 
that's missing somewhere with some fine detail. All perl modules are 
present (except 3.18 tells me that Readonly::XS (1.02) is not installed, 
but I have 1.05), permissions have been verified, ps -u koha shows the 
daemon and zebrasrv running, mysqlcheck is clean, etc.

Wireshark/pcap gives (repeatable):
http://koha-admin318/cgi-bin/koha/catalogue/search.pl?q=t   slow (~20 secs) 
and finds all results absolutely perfectly

but http://koha-admin318/cgi-bin/koha/cataloguing/addbooks.pl?q=t is fast 
(~0.7 secs) and finds all the same results plus 73 records in 
reservoir.  Maybe addbooks.pl doesn't need this $limit (or whatever) that 
search.pl requires, although the results are identical

So, tried Perl debug (I don't know how to input the cookie data for admin 
staff, so this is the opac search, times identical):

koha at hood:/usr/share/koha/opac/cgi-bin/opac$ perl -d -w ./opac-search.pl ?q=t
Loading DB routines from perl5db.pl version 1.39_10
C4::Tags::CODE(0xa633720)(/usr/share/koha/lib/C4/Tags.pm:73):
73:         $ext_dict and $Lingua::Ispell::path = $ext_dict;
   DB<1> c

=====>  Romps instantaneously through 16 "Use of uninitialized value" 
warnings (snipped, basically in "value in string eq", $ENV{"SERVER_PORT"} 
and "value in concatenation (.) or string" in Auth.pm; $index, $_ and first 
mention of $limit in Search.pm) up to

Use of uninitialized value $limit in concatenation (.) or string at 
/usr/share/koha/lib/C4/Search.pm line 1769.
  at /usr/share/koha/lib/C4/Search.pm line 1769.
         C4::Search::buildQuery('ARRAY(0xa7aaea0)', 'ARRAY(0xa7b5b58)', 
'ARRAY(0xa7aaf60)', 'ARRAY(0xa7b5e58)', 'ARRAY(0xa7aa1b0)', 0, 'en') called 
at opac-search.pl line 473

=====>  stops, no screen action, here for ~19 seconds, then resumes...

Use of uninitialized value $expanded_facet in string eq at 
/usr/share/koha/lib/C4/Search.pm line 527.
  at /usr/share/koha/lib/C4/Search.pm line 527.
         C4::Search::__ANON__[/usr/share/koha/lib/C4/Search.pm:627](1, 
25397) called at /usr/share/koha/lib/C4/Search.pm line 2567
         C4::Search::_ZOOM_event_loop('ARRAY(0x72799a8)', 
'ARRAY(0x72799f0)', 'CODE(0xb0b5878)') called at 
/usr/share/koha/lib/C4/Search.pm line 628
         C4::Search::getRecords('(rk=(Title-cover,ext,r1="s" or 
ti,ext,r2="s" or Title-cover,p...', 's', 'ARRAY(0xa7aa1b0)', 
'ARRAY(0xa7aad80)', 20, 0, undef, 'HASH(0xa8e8990)', 'HASH(0x7b80a90)', 
...) called at opac-search.pl line 552
         eval {...} called at opac-search.pl line 551

=====>  and romps instantaneously through (snip, basically $priority (in 
Reserves.pm), $expanded_facet, $transfertwhen and plain vanilla "value in 
hash element" in Search.pm) 770 lines of "Use of uninitialized value" 
warnings, then completes:

Status: 200 OK
Set-Cookie: CGISESSID=d62edfbbd23aa65c2acea0f49974cb31; path=/; HttpOnly
/... expected HTML, css, scripts, etc .../
</body>
</html>

The complete list of uninitialized values from $ perl 
-Mdiagnostics=-traceonly ./opac-search.pl ?q=t  runs about 180 lines but I 
can supply it if required.

I can possibly ghost 3.8.5 (also tarball) onto this machine, but I'd really 
like to get 3.18 up and running. I recognize that this install is tarball, 
but it's too late now to make radical changes, it's a big server with a lot 
of other databases and websites.  Nothing new compared to our existing 
production box, except Ubuntu 14.04.1 LTS and Koha 3.18

Help, pointers, suggestions warmly welcomed.

Thanks -- Paul
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20150103/de0b64f9/attachment.html>