Help - Search - Members - Calendar
Full Version: errno: 145
Big Red Spark Forums > Big Red Spark.com Forums > Unit Command Climate Assessment and Survey System (UCCASS)
mha
The configutation has not changed, but I can no longer access results that previously were accessible.
uccass reports:

Error retrieving questions: Can't open file: 'results_text.MYI' (errno: 145)

But the .MYI file exists, I can see it in /var/lib/mysql/uccass and it has the right permissions.
Question is: what could be the reason why uccass cannot open it.
Is there another way I can open and read it?

Mike
mha
QUOTE(mha @ Oct 30 2008, 04:50 AM) *

The configutation has not changed, but I can no longer access results that previously were accessible.
uccass reports:

Error retrieving questions: Can't open file: 'results_text.MYI' (errno: 145)

But the .MYI file exists, I can see it in /var/lib/mysql/uccass and it has the right permissions.
Question is: what could be the reason why uccass cannot open it.
Is there another way I can open and read it?

Mike



Further information...
I moved the whole uccass tree to another machine, and this time uccass reports:

Error retrieving questions: Table './uccass/results_text' is marked as crashed and should be repaired

I can't find how to repair in the documentation.

Basically I just need to read that binary results file somehow.


mha
QUOTE(mha @ Oct 30 2008, 05:57 AM) *

Further information...
I moved the whole uccass tree to another machine, and this time uccass reports:

Error retrieving questions: Table './uccass/results_text' is marked as crashed and should be repaired

I can't find how to repair in the documentation.

Basically I just need to read that binary results file somehow.



How to fix this....

I discovered errno 145 comes from mysql, not from uccass. It's caused by some corruption in the table. To fix it logon to your mysql, use the uccass database, and run the command:

mysql> repair table results_text

Job done.
Mike
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.