[EP-tech] Apache log getting a lot of errors and Mysql Going away

[yurj at alfa.it (Yuri)]

I think it happens when you've a lot of connections on mysql. Rise up 
the number of connection in mysql and use some script in a cronjob to 
check if mysql has gone away and notify you.

The problem can go even worse when you've a lot of Apache threads and it 
eats al the RAM available, you've to rise or lower the apache threads 
according to the load.


Il 24/03/2017 19:26, Mathieu Perron ha scritto:
>
> Hi,
>
> We are using ePrints v3.3.13 and lately we have been experiencing some 
> crashes due to MySQL going away.  I looked in the Apache log and I see 
> a lot of the following errors:
>
> ?[error] Software caused connection abort at /eprints3/cgi/exportview 
> line 108.\n?
>
> I looked at the cgi script and searched in the files and this script 
> has something to do with the Views.pm module.  I can?t seem to make 
> the error happen on demand and I?m wondering if anyone could help me 
> with this.  I don?t know if the MySQL server going away is related to 
> these errors or not.
>
> Thank you for your time!
>
> *Mathieu Perron*
> Charg? de projet informatique et technologique
>
>
> Service des technologies de l'information
> Universit? du Qu?bec ? Chicoutimi
> 555, boul. de l'Universit?
> Chicoutimi (Qu?bec) G7H 2B1
>
> *Mathieu_Perron at uqac.ca* <mailto:Mathieu_Perron at uqac.ca>
>
>
>
> *logo uqac* <http://www.uqac.ca/>
>
> Le pr?sent document (y compris les pi?ces qui y sont annex?es, le cas 
> ?ch?ant) s'adresse au destinataire indiqu? et peut contenir des 
> renseignements de caract?re priv? ou confidentiel. Si vous n'?tes pas 
> le destinataire de ce document, nous vous signalons qu'il est 
> strictement interdit de le diffuser, de le distribuer ou de le 
> reproduire. Si ce message vous a ?t? transmis par erreur, veuillez en 
> informer l'exp?diteur et le supprimer imm?diatement. Avant d'imprimer, 
> pensez ? l'environnement!
>
>
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
> *** EPrints developers Forum: http://forum.eprints.org/