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-me... 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 <sowen@almaschools.net> 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 Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha