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
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/