Got error 127 from storage engine

[Alain]

On various operations (such as viewing events, or sometimes even clicking only on the "Filters" button), I get this error:

Code: Select all

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/fun/webmast/zoneminder/zm_html_view_event.php on line 54
Got error 127 from storage engine

(This example from attempting to view an event)

For the events, it mostly happens for the 10 or so oldest events in the list. When I delete those oldest events, the next oldest ones in the list often "inherit" the error (but sometimes, less events inherit the error than those who initially had it. For example if initially 12 events had the error, then after deleting those 12, only two new ones would get it. It's rather random)

For the filter button, it seems to be related to the Date/Time criterion. When it happens, it only happens if the filter uses Date/Time, but not other criteria (such as Date, or Time, or MonitorId)

[Alain]

... Please disregard my post. I just noticed that it actually was a mysql problem (db file corruption probably due to the frequent crashes while setting up the spca5xx driver for our Phillips SPC300NC cams...)

[zoneminder]

Good (I guess ). Thanks for letting us know.

[bosskong]

I'm getting this error now. It's also probably db corruption in my case, because it started after I pulled the power without shutting down. Can any mysql experts give me some tips on repairing the database?

[bosskong]

Nevermind, I ran this and fixed it:
mysqlcheck --all-databases --auto-repair -pzm_pass -u zm_user