Code: Select all
DBD::mysql::st execute failed: The table 'Logs' is full at /usr/share/perl5/ZoneMinder/Logger.pm line 609
I can't do anything via the gui to clean up things, as it returns a popup saying
Code: Select all
Can't write log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1409335374.894321, 'web_php', 6812, -3, 'FAT', 'SQL-ERR \'Got error 28 from storage engine\', statement was \'select E.Id,E.MonitorId,M.Name As MonitorName,M.DefaultScale,E.Name,E.Width,E.Height,E.Cause,E.Notes,E.StartTime,E.Length,E.Frames,E.AlarmFrames,E.TotScore,E.AvgScore,E.MaxScore,E.Archived from Monitors as M inner join Events as E on (M.Id = E.MonitorId) where 1 and ( E.StartTime < \'2014-08-29 11:02:54\' ) order by E.StartTime asc\'', '/usr/share/zoneminder/includes/database.php', 78 )': The table 'Logs' is full
- how do I clear it so I can restart zoneminder
- how do I prevent it happening in the future
- what cron jobs should I have to maintain the system hands-off
Any ideas ?