Got error 127 from storage engine
Posted: Mon Mar 06, 2006 11:08 am
On various operations (such as viewing events, or sometimes even clicking only on the "Filters" button), I get this error:
(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)
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
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)
). Thanks for letting us know.