At 10:48 PM 1/3/2015 -0700, Christopher Davis wrote:
Paul,
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.
Christopher, Thanks for your reply -- we have none of the "services" (including cover images, etc) turned on. Yesterday I verified every page in Home : Administration : System preferences (and compared to our workhorse 3.8.5 installation) to make sure we have a truly no-frills environment. Regards -- Paul
HTH,
Christopher Davis, MLS Systems & Electronic Services Librarian Uintah County Library cgdavis@co.uintah.ut.us (435) 789-6261 <http://uintahlibrary.org>uintahlibrary.org <http://facebook.com/uintahcountylibrary>facebook.com/uintahcountylibrary
On January 3, 2015 6:17:33 PM MST, Paul A <paul.a@navalmarinearchive.com> wrote: 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@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
----------
Koha-devel mailing list
Koha-devel@lists.koha-community.org
website : <http://www.koha-community.org>http://www.koha-community.org/
git : <http://git.koha-community.org>http://git.koha-community.org/
bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/
--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>