EPrints Technical Mailing List Archive

Message: #04696


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

[EP-tech] Re: EPrints 3.3.13 Crash


Hi Greg,

First thing I’d do is (get your sysadmin to) check your database server disk space.

We had a build-up of old binlogs which filled our database server and made everything fall over.

This caused mysqlcheck to not work too.

 

I think this was useful in that process: http://www.thegeekstuff.com/2011/12/mysqlcheck/

 

In terms of anything you have access to – I’m not sure - sorry!

 

Cheers,

John

 

From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Greg Whitney
Sent: 16 September 2015 14:49
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] EPrints 3.3.13 Crash

 

Hello,

 

First time for everything. Our EPrints 3.3.13 production instance crashed with the following error messages below:

 

Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

150915 14:06:40 [ERROR] mysqld: Table './Ecole/eprint' is marked as crashed and should be repaired
150915 14:06:40 [Warning] Checking table:   './Ecole/eprint'
150915 14:06:41 [ERROR] mysqld: Table './Ecole/eprint_divisions' is marked as crashed and should be repaired
150915 14:06:41 [Warning] Checking table:   './Ecole/eprint_divisions'
150915 14:08:32 [ERROR] mysqld: Table './Ecole/eprint__ordervalues_en' is marked as crashed and should be repaired
150915 14:08:32 [Warning] Checking table:   './Ecole/eprint__ordervalues_en'
150915 14:10:21 [ERROR] mysqld: Table './Ecole/eprint__rindex' is marked as crashed and should be repaired
150915 14:10:21 [Warning] Checking table:   './Ecole/eprint__rindex'
150916  8:49:32 [Note] /usr/libexec/mysqld: Normal shutdown





Our sysadmin tried to to a mysqlcheck on these tables and it failed.  Is there any program in the /bin directory which I can run to rebuild or check these tables periodically myself. as I don't have mysql access to EPrints.



Thanks!!



Greg Whitney

Polytechnique Montreal Library