EPrints Technical Mailing List Archive

Message: #05288


< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: EPrints MySQL Error


Also, check the mysql error log (it should be in the 'data' directory of the database) - filename ends with '.err'.
This should lead you to the cause.

One other thing that bit me once - if you're doing any form of database replication using binlogs, and you're not purging old binlogs, they can take up a lot of space.

mysql> show binary logs;

will list them (and their filesizes).

Cheers,
John

-----Original Message-----
From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Adam Field
Sent: 05 January 2016 08:15
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] Re: EPrints MySQL Error

I would strongly advise that you make sure you have a good understanding of what these commands do before you run them. 

--
Adam

> On 5 Jan 2016, at 05:17, Mahalingam S <smal@ccmb.res.in> wrote:
> 
> Hello
> 
> Try this out.
> 
> Solution:
> 
> 1. stop the mysqld service
> 2. delete the old or existing file called mysql.sock in /var/lib/mysql/mysql.sock
> 3. chown mysql.mysql -R /var/lib/muysql/*
> 4. chmod 755 -R /var/lib/mysql/*
> 5. restart the mysqld service.
> 
> contact the forum if you have any further issue in this regard.
> 
> with best wishes
> s.mahalingam
> 
> 
> S Mahalingam
> Sr. Technical Officer, IT Group,
> Centre for Cellular and Molecular Biology(CCMB) - CSIR.
> Habsiguda, Uppal Road
> Hyderabad 500 007
> 
> Ph:+91-40-27192772,27192774
>   +91-40-27160222-41, Ext:2772,2774
> Cell: +91-9490682527
> 
> ----- Original Message -----
> From: "Andrew Beeken" <anbeeken@lincoln.ac.uk>
> To: eprints-tech@ecs.soton.ac.uk
> Sent: Tuesday, January 5, 2016 5:36:38 AM
> Subject: [EP-tech] Re: EPrints MySQL Error
> 
> This has happened to us before when we've run out of drive space. Could be that?
> 
> 
> 
> 
> On Mon, Jan 4, 2016 at 11:25 AM -0800, "Greg Whitney" <greg.whitney@polymtl.ca<mailto:greg.whitney@polymtl.ca>> wrote:
> 
> Hello,
> 
> Happy New Year to everyone!!
> 
> We have EPrints 3.3.13 and it is been acting up since December, crashing a couple times a day.
> 
> The latest error is the following:
> 
> EPrints System Error
> Error connecting to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
> 
> Any ideas that I can give our sysadmin on what to check + fix??  *&%$!!
> 
> 
> 
> Thanks!
> 
> Greg Whitney
> Polytechnique Montreal Library
> 
> The University of Lincoln, located in the heart of the city of Lincoln, has established an international reputation based on high student satisfaction, excellent graduate employment and world-class research.
> 
> The information in this e-mail and any attachments may be confidential. If you have received this email in error please notify the sender immediately and remove it from your system. Do not disclose the contents to another person or take copies.
> 
> Email is not secure and may contain viruses. The University of Lincoln makes every effort to ensure email is sent without viruses, but cannot guarantee this and recommends recipients take appropriate precautions.
> 
> The University may monitor email traffic data and content in accordance with its policies and English law. Further information can be found at: http://lincoln.ac.uk/legal.
> 
> *** 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/
> <smal.vcf>
> *** 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/

*** 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/