<html><head></head><body>Paul,<br>
<br>
I don't know if someone else has already mentioned this, but does your institution utilize any catalog enhancements such as cover art images, series lists, or book reviews? I remember last year when Syndetics added twenty seconds to our OPAC searches until we disabled it. Try turning off any or all of these services and then re-measure the performance.<br>
<br>
HTH,<br>
<br>
Christopher Davis, MLS<br>
Systems & Electronic Services Librarian<br>
Uintah County Library<br>
cgdavis@co.uintah.ut.us<br>
(435) 789-6261<br>
<a href="http://uintahlibrary.org">uintahlibrary.org</a><br>
<a href="http://facebook.com/uintahcountylibrary">facebook.com/uintahcountylibrary</a><br>
<br><br><div class="gmail_quote">On January 3, 2015 6:17:33 PM MST, Paul A <paul.a@navalmarinearchive.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I'm really looking for some help here, please, my brain (whatever is
left!) is swimming in Perl code.<br /><br />
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.<br /><br />
Wireshark/pcap gives (repeatable):<br />
<a href="http://koha-admin318/cgi-bin/koha/catalogue/search.pl?q=t" eudora="autourl">http://koha-admin318/cgi-bin/koha/catalogue/search.pl?q=t</a>
slow (~20 secs) and finds all results absolutely perfectly<br /><br />
but
<a href="http://koha-admin318/cgi-bin/koha/cataloguing/addbooks.pl?q=t" eudora="autourl">http://koha-admin318/cgi-bin/koha/cataloguing/addbooks.pl?q=t</a>
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 <br /><br />
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):<br /><br />
koha@hood:/usr/share/koha/opac/cgi-bin/opac$ perl -d -w ./opac-search.pl ?q=t<br />
Loading DB routines from perl5db.pl version 1.39_10<br />
C4::Tags::CODE(0xa633720)(/usr/share/koha/lib/C4/Tags.pm:73):<br />
73: $ext_dict and $Lingua::Ispell::path = $ext_dict;<br />
DB<1> c<br />
<br />
=====> 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<br /><br />
Use of uninitialized value $limit in concatenation (.) or string at /usr/share/koha/lib/C4/Search.pm line 1769.<br />
at /usr/share/koha/lib/C4/Search.pm line 1769.<br />
C4::Search::buildQuery('ARRAY(0xa7aaea0)', 'ARRAY(0xa7b5b58)', 'ARRAY(0xa7aaf60)', 'ARRAY(0xa7b5e58)', 'ARRAY(0xa7aa1b0)', 0, 'en') called at opac-search.pl line 473<br /><br />
=====> stops, no screen action, here for ~19 seconds, then resumes...<br /><br />
Use of uninitialized value $expanded_facet in string eq at /usr/share/koha/lib/C4/Search.pm line 527.<br />
at /usr/share/koha/lib/C4/Search.pm line 527.<br />
C4::Search::__ANON__[/usr/share/koha/lib/C4/Search.pm:627](1, 25397) called at /usr/share/koha/lib/C4/Search.pm line 2567<br />
C4::Search::_ZOOM_event_loop('ARRAY(0x72799a8)', 'ARRAY(0x72799f0)', 'CODE(0xb0b5878)') called at /usr/share/koha/lib/C4/Search.pm line 628<br />
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<br />
eval {...} called at opac-search.pl line 551<br />
<br />
=====> 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:<br /><br />
Status: 200 OK<br />
Set-Cookie: CGISESSID=d62edfbbd23aa65c2acea0f49974cb31; path=/; HttpOnly<br />
/... expected HTML, css, scripts, etc .../<br />
</body><br />
</html><br /><br />
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.<br /><br />
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<br /><br />
Help, pointers, suggestions warmly welcomed.<br /><br />
Thanks -- Paul<br />
<p style="margin-top: 2.5em; margin-bottom: 1em; border-bottom: 1px solid #000"></p><pre class="k9mail"><hr /><br />Koha-devel mailing list<br />Koha-devel@lists.koha-community.org<br /><a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br />website : <a href="http://www.koha-community.org">http://www.koha-community.org</a>/<br />git : <a href="http://git.koha-community.org">http://git.koha-community.org</a>/<br />bugs : <a href="http://bugs.koha-community.org/">http://bugs.koha-community.org/</a></pre></blockquote></div></body></html>