[Koha] software error

Tue Sep 29 06:11:40 NZDT 2015

I'll have to wait until some of my people are back to see if I can reliably
reproduce the error ...(training day today)

But...I do know that the error happens mostly (so far) as the librarian at
the desk is mass-checking-in books.

I don't know if there is a "magic number" of titles (checked in) that
causes the error, or any specific details, but that seems to be when the
error happens.

-S

On Mon, Sep 28, 2015 at 12:37 PM, Jonathan Druart <
jonathan.druart at bugs.koha-community.org> wrote:

> Sorry, you have provided all details before!
> If you manage to reproduce the error on-demand it would be good to
> test with the master branch and with the patch on bug 14778 (not in
> master yet).
>
> 2015-09-28 17:26 GMT+01:00 Scott Owen <sowen at edzone.net>:
> > Nope, SQL runs on the same server.
> >
> >
> > On Mon, Sep 28, 2015 at 12:14 PM, Jonathan Druart <
> > jonathan.druart at bugs.koha-community.org> wrote:
> >
> >> Does your mysql server run on another server?
> >> If so, it should be defined in the koha-conf.xml, search the config
> >> section, then hostname.
> >>
> >> 2015-09-28 16:44 GMT+01:00 Scott Owen <sowen at edzone.net>:
> >> > Looks like here is where things go south....
> >> >
> >> > ******************************
> >> >
> >> > [Fri Sep 25 15:20:03 2015] Auth.pm: DBI
> >> > connect('dbname=koha_dlpms;host=localhost;port=3306','koha_dlpms',...)
> >> > failed: Lost connection to MySQL server at 'sending authentication
> >> > information', system error: 32 at /usr/share/perl5/DBIx/Connector.pm
> >> > line 32
> >> >
> >> > ********************************
> >> >
> >> >
> >> >
> >> > Could i just have a typo somewhere ????
> >> >
> >> > *************************************
> >> >
> >> > opac-search.pl?q=middol+school
> >> >
> >> > **************************************
> >> >
> >> >
> >> >
> >> > Rather than "localhost" should I hardcode in the system IP ??
> >> >
> >> > ***************************************
> >> >
> >> > 'dbname=koha_dlpms;host=localhost;port=3306'
> >> >
> >> > ****************************************
> >> >
> >> >
> >> >
> >> > _____________________________________log
> >> > snip______________________________________________
> >> >
> >> > [Fri Sep 25 15:19:40.358978 2015] [cgi:error] [pid 6777] [client
> >> > 10.1.1.111:36648] AH01215: [Fri Sep 25 15:19:18 2015] opac-user.pl:
> >> > BEGIN failed--compilation aborted at
> >> > /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 25., referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:27.363750 2015] [cgi:warn] [pid 6424] [client
> >> > 10.1.1.111:15692] AH01220: Timeout waiting for output from CGI script
> >> > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:40.317727 2015] [cgi:warn] [pid 6427] [client
> >> > 10.1.1.111:15697] AH01220: Timeout waiting for output from CGI script
> >> > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:40.418439 2015] [cgi:error] [pid 6424] [client
> >> > 10.1.1.111:15692] Script timed out before returning headers:
> >> > opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:40.523899 2015] [cgi:error] [pid 6427] [client
> >> > 10.1.1.111:15697] Script timed out before returning headers:
> >> > opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:40.751819 2015] [cgi:error] [pid 6414] [client
> >> > 10.1.1.111:15685] Script timed out before returning headers:
> >> > opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:40.318628 2015] [cgi:warn] [pid 6432] [client
> >> > 10.1.1.111:15700] AH01220: Timeout waiting for output from CGI script
> >> > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:19:41.062151 2015] [cgi:error] [pid 6432] [client
> >> > 10.1.1.111:15700] Script timed out before returning headers:
> >> > opac-search.pl, referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> > [Fri Sep 25 15:20:03.586683 2015] [cgi:error] [pid 6847] [client
> >> > 10.1.1.111:36745] AH01215: ., referer:
> >> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> >> >
> >> >
> >>
> ___________________________________________________________________________________
> >> >
> >> >
> >> > Thanks for any pointers of where to go from here ....
> >> >
> >> > -S
> >> >
> >> >
> >> >
> >> > On Tue, Sep 22, 2015 at 10:48 PM, Robin Sheat <robin at catalyst.net.nz>
> >> wrote:
> >> >
> >> >> Scott Owen schreef op di 22-09-2015 om 22:25 [-0400]:
> >> >> > Hummm.....database is located on the same box....so I think a
> >> >> > conductivity
> >> >> > issue is unlikely. Guess I'll start digging through logs in my free
> >> >> > time....any particular log that might be a good place to start? any
> >> >> > key
> >> >> > words I should be looking for ?
> >> >>
> >> >> Nothing in particular, but I'd look for anything odd in syslog,
> perhaps
> >> >> turn the mysql logging level up a bit and see what it says, and so
> >> >> forth. Note that I'm not 100% sure that this is the cause of your
> issue,
> >> >> but it looks like it from the surface.
> >> >>
> >> >> --
> >> >> Robin Sheat
> >> >> Catalyst IT Ltd.
> >> >> ✆ +64 4 803 2204
> >> >> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
> >> >>
> >> >> _______________________________________________
> >> >> Koha mailing list  http://koha-community.org
> >> >> Koha at lists.katipo.co.nz
> >> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >> >>
> >> >>
> >> > _______________________________________________
> >> > Koha mailing list  http://koha-community.org
> >> > Koha at lists.katipo.co.nz
> >> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >> _______________________________________________
> >> Koha mailing list  http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>