ZoneMinder Forums

codeking2011 wrote:Hello all,

We had a power failure and the ZoneMinder server was improperly shut down. After I have restarted it again I got the following error: -

#service zm status
httpd (pid 1858 1857 1856 1855 1854 1853 1852 1851 1850 1833) is running...
mysqld (pid 1719) is running...
DBD::mysql::st execute failed: Table './zm/Logs' is marked as crashed and should be repaired at /usr/local/share/perl5/ZoneMinder/Logger.pm line 609.

While I tried to http the server I got another error: -

Can't write log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1368195917.303554, 'web_php', 1856, -3, 'FAT', 'SQL-ERR \'Table \'./zm/Logs\' is marked as crashed and should be repaired\', statement was \'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc\'', '/home/www/html/zm/includes/database.php', 78 )': Table './zm/Logs' is marked as crashed and should be repaired

In Logs

May 10 15:59:32 Video zmpkg[2105]: FAT [Can't execute log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( ?, ?, ?, ?, ?, ?, ?, NULL )': Table './zm/Logs' is marked as crashed and should be repaired]

May 10 16:16:46 Video web_php[1853]: FAT [SQL-ERR 'Table './zm/Logs' is marked as crashed and should be repaired', statement was 'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc']
May 10 16:16:46 Video web_php[1853]: FAT [Can't write log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1368195406.295318, 'web_php', 1853, -3, 'FAT', 'SQL-ERR \'Table \'./zm/Logs\' is marked as crashed and should be repaired\', statement was \'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc\'', '/home/www/html/zm/includes/database.php', 78 )': Table './zm/Logs' is marked as crashed and should be repaired]
May 10 16:17:22 Video zmpkg[2180]: FAT [Can't execute log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( ?, ?, ?, ?, ?, ?, ?, NULL )': Table './zm/Logs' is marked as crashed and should be repaired]
May 10 16:17:23 Video web_php[1855]: FAT [SQL-ERR 'Table './zm/Logs' is marked as crashed and should be repaired', statement was 'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc']
May 10 16:17:23 Video web_php[1855]: FAT [Can't write log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1368195443.018944, 'web_php', 1855, -3, 'FAT', 'SQL-ERR \'Table \'./zm/Logs\' is marked as crashed and should be repaired\', statement was \'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc\'', '/home/www/html/zm/includes/database.php', 78 )': Table './zm/Logs' is marked as crashed and should be repaired]


How can I repair this issue??
Any advice/help would be appreciated
Thanks

codeking2011 wrote:Thanks alot bb99 it works like a magic

How do I repair the MySQL Database?

There is two ways to go about this. In most cases you can run from the command prompt ->

mysqlcheck --all-databases --auto-repair -pyour_database_password -u your_databse_user

If that does not work then you will have to make sure that ZoneMinder is stopped then run the following (nothing should be using the database while running this and you will have to adjust for your correct path if it is different). ->

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


How do I repair the MySQL Database when the cli fails?

In Ubuntu, the commands listed above do not seem to work. However, actually doing it by hand from within MySQL does. (But that is beyond the scope of this document) But that got me thinking... And phpmyadmin does work. Bring up a terminal.

sudo apt-get install phpmyadmin

Now go to http://zoneminder_IP/ and stop the ZM service. Continue to http://zoneminder_IP/phpmyadmin and select the zoneminder database. Select and tables marked 'in use' and pick the action 'repare' to fix. Restart the zoneminder service from the web browser. Remove or disable the phpmyadmin tool, as it is not always the most secure thing around, and opens your database wide to any skilled hacker.

sudo apt-get remove phpmyadmin

# cat /etc/zm/zm.conf | grep ZM_DB
ZM_DB_TYPE=mysql
ZM_DB_HOST=localhost
ZM_DB_NAME=zm
ZM_DB_USER=zmuser
ZM_DB_PASS=zmpass

# mysqlcheck --all-databases --auto-repair -pzmpass -u zmuser
Warning: Using a password on the command line interface can be insecure.
zm.Config                                          OK
zm.ControlPresets                                  OK
zm.Controls                                        OK
zm.Devices                                         OK
zm.Events                                          OK
zm.Filters                                         OK
zm.Frames                                          OK
zm.Groups                                          OK
zm.Logs                                            OK
zm.MonitorPresets                                  OK
zm.Monitors                                        OK
zm.Servers                                         OK
zm.States                                          OK
zm.Stats
Warning  : InnoDB: Index 'EventId' contains 186064 entries, should be 186095.
Warning  : InnoDB: Index 'MonitorId' contains 186064 entries, should be 186095.
Warning  : InnoDB: Index 'ZoneId' contains 186064 entries, should be 186095.
error    : Corrupt
zm.TriggersX10                                     OK
zm.Users                                           OK
zm.ZonePresets                                     OK
zm.Zones                                           OK

Repairing tables
zm.Stats
note     : The storage engine for the table doesn't support repair


# 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
myisamchk: unknown option '-O'