FORUMS: list search recent posts

Pro-Cache5 Tape Crash Error "Table 'file' marked as crashed..."

COW Forums : Archiving and Back-Up

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Ryan Hardy
Pro-Cache5 Tape Crash Error "Table 'file' marked as crashed..."
on Jan 18, 2019 at 6:56:03 pm

We had a tape crash mid transfer yesterday and now we are experiencing tape issues that are prohibiting us from fully accessing the tape. It is giving us this error in the File Manager:

"1194 - Table 'file' is marked as crashed and should be repaired

SELECT filename,id,parent_id,type,size,mtime FROM file WHERE (toc_id=281 && parent_id=0) GROUP BY (filename) ORDER BY filename,mtime DESC;

[TEP STOP]"

In the logs we are seeing this error:
"Table 'file' is marked as crashed and should be repaired at /usr/cache-a/lib/CatalogLib.pl line 1413. "

If anyone has any suggestions on how to remedy this, we would greatly appreciate it, as there is no longer support for this model.

Thank you
Ryan


Return to posts index

Tom Goldberg
Re: Pro-Cache5 Tape Crash Error "Table 'file' marked as crashed..."
on Jan 19, 2019 at 2:35:43 am

Ryan,

You have a classic Cache-A database problem...
Here are the instructions for a Cache-A [TEP STOP] fix:

Log into your Cache-A from a terminal - click this to download instructions if you don’t know how to do that.

Then issue the following commands in order exactly as below:


/etc/init.d/tapemgr stop
/etc/init.d/httpd stop
/etc/init.d/mysqld stop

myisamchk -rofm /media/catalog/database/mysql/catalog/*.MYI

/etc/init.d/mysqld start
/etc/init.d/httpd start
/etc/init.d/tapemgr start


restart your Cache-A

Tom Goldberg
TGCS
30201 Rainbow Hill Rd.
Evergreen, CO 80439
mailto:tomgoldberg@gmail.com
http://tomgoldberg.net




Return to posts index

Ryan Hardy
Re: Pro-Cache5 Tape Crash Error "Table 'file' marked as crashed..."
on Jan 21, 2019 at 2:56:38 pm

Thank you so much Tom, this worked like a charm!
I appreciate the response. Take care
- Ryan


Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2019 CreativeCOW.net All Rights Reserved
[TOP]