Can't Open file Frames.MYI

james · Post by **james** » Tue Jun 13, 2006 9:18 am

FC 4 / ZM 1.22 / 8 Monitors MoDect

/tmp/zmdc.log

DBD::mysql::st execute failed: Can't open file: 'Frames.MYI' (ernno 145) at /usr/local/bin/zmaudit.pl line 280

Every 10 seconds in my logs

+ "Can't open file: 'Frames.MYI' (ernno 145) "
When I want to watch events

I already tried the alldatabse repair.

Thank You.

Post by **zoneminder** » Tue Jun 13, 2006 9:34 am

It sounds like the table has become corrupted. If you google for 'mysql error 145' you will get lots of matches and hints. If mysqlcheck doesn't work then maybe myisamcheck will help?

Post by **cordel** » Thu Jun 15, 2006 6:48 am

See this thread:
http://www.zoneminder.com/forums/viewtopic.php?t=5657

Regards,
Corey

james · Post by **james** » Thu Jun 15, 2006 10:50 am

Thank you,

Code: Select all

myisamchk --silent --force --fast --update-state -O key_buffer=64M \
-O sort_buffer=64M -O read_buffer=1M -O write_buffer=1M \
/var/lib/mysql/*/*.MYI

did the trick.

Thank you again.

ps : I have lost all events since this error occured for the first time.
I had plenty of 0 sec events. I suppose the error blocked ZM to record new things in the DB.