EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #09496


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

Re: [EP-tech] Subject: Error 1194 - 'Access' Table Issue - Repair Required?


CAUTION: This e-mail originated outside the University of Southampton.

Hi!

 it happened to me several times in the past and repair has always been successful. It happens when the machine crash badly or mysql/mariadb process is killed/creash, so maybe you've also another general issue.

In any case, the access tables carry only the site visitor ip and other info, it does not carry any eprint data. I use also the automysqlbackup to make dumps of databases and regular backups so it is quite difficult to lose data in these days.

Il 01/12/23 08:58, Noorhafizah Mohd Akil ha scritto:
CAUTION: This e-mail originated outside the University of Southampton.
CAUTION: This e-mail originated outside the University of Southampton.
Hello all.

I encountered an error for the 'access' table as follows:

Error 1194: Table 'access' is marked as crashed and should be repaired when dumping table 'access' at row 34762479.

The total in the 'access' table is:

sql
Copy code
SELECT count(*) FROM iiumprints.access;
-- Result: 34772338


Do I need to repair it? Is there a risk of data loss, or will a database crash occur?

Thank you in advance.

*** Options: https://wiki.eprints.org/w/Eprints-tech_Mailing_List
*** Archive: https://www.eprints.org/tech.php/
*** EPrints community wiki: https://wiki.eprints.org/