Hi Scott, Have you any error/warning on your mysql log that might give you a clue?
Might it be that mysql runs out of allowed connections or memory? See this: https://tecadmin.net/check-update-max-connections-value-mysql https://www.percona.com/blog/2018/06/28/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/ Also, you can check mysql config/performance with: https://github.com/major/MySQLTuner-perl In addition, you are not running memcached it will give an extra boost to your koha. Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le jeu. 3 déc. 2020 à 11:34, Scott Owen <[email protected]> a écrit : > Hi All, > > I have been getting some random errors for the last couple of months on all > of my Koha boxes: > > Software error: > DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't > connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' > (2) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1490. at > /usr/share/koha/lib/Koha/Database.pm line 102 > For help, please send mail to the webmaster ([no address given]), giving > this error message and the time and date of the error. > > > > Current version information (at least for this one installation...other > versions may differ): > > Koha version: 17.11.18.000 > OS version ('uname -a'): Linux Pine 3.16.0-4-686-pae #1 SMP Debian > 3.16.51-3 (2017-12-13) i686 > Perl interpreter: /usr/bin/perl > Perl version: 5.020002 > Perl @INC: /usr/share/koha/lib > /etc/perl > /usr/local/lib/i386-linux-gnu/perl/5.20.2 > /usr/local/share/perl/5.20.2 > /usr/lib/i386-linux-gnu/perl5/5.20 > /usr/share/perl5 > /usr/lib/i386-linux-gnu/perl/5.20 > /usr/share/perl/5.20 > /usr/local/lib/site_perl > . > MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686) > using readline 6.3 > Apache version: Server version: Apache/2.4.10 (Debian) > Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config > read from: Nowhere Note that the right place to define the memcached config > is in your $KOHA_CONF file. Currently you do not have a valid memcached > configuration defined. | Effective caching method: > Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free > software, covered by the GNU General Public License, and you are welcome to > change it and/or distribute copies of it under certain conditions. > > I've done some "googling" but couldn't find a definitive "fix" for this > issue.... > Any idea where I should start on this ?? MySql config ??? Koha config ??? > any ideas what I should be looking for ? Known issue ?? > Thank you, > > -Scott > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
