-
Pro-Cache5 Tape Crash Error “Table ‘file’ marked as crashed…”
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 -
2 Replies
-
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 stopmyisamchk -rofm /media/catalog/database/mysql/catalog/*.MYI
/etc/init.d/mysqld start
/etc/init.d/httpd start
/etc/init.d/tapemgr startrestart your Cache-A
Tom Goldberg
TGCS
30201 Rainbow Hill Rd.
Evergreen, CO 80439
mailto:tomgoldberg@gmail.com
https://tomgoldberg.net -
Thank you so much Tom, this worked like a charm!
I appreciate the response. Take care
– Ryan
Reply to this Discussion! Login or Sign Up