Error 134 in zmaudit.log

Ruler · Post by **Ruler** » Tue Nov 23, 2004 9:28 pm

I'm getting an error in zmaudit.log that I have as of yet been unable to fix. I would be appreciative if anybody has any ideas as to how to resolve the problem. I'm on Slackware 10.

Code: Select all

Found orphaned frame records for event "nnnnn"; deleting
DBD::mysql::st execute failed: Got error 134 from table handler at /usr/local/bin/zmaudit.pl line 278
Can't execute: Got error 134 from table handler at /usr/local/bin/zmaudit.pl line 278

I'm guessing that this is why some of the mysql databases are quite large... I've already installed the perl modules DBI and DBD::mysql and they didn't affect it at all.

Post by **zoneminder** » Wed Nov 24, 2004 8:36 am

A quick google (always a good first move) comes up with this.

So I would suggest running mysqlcheck on your database first and if that doesn't work then try to dump your data, drop your table, recreate your table and reload. Assuming you want to kep the data of course. I would also suggest stopping ZM before you do this.

Phil,

Ruler · Post by **Ruler** » Wed Nov 24, 2004 8:33 pm

Thanks Phil - since I wasn't having any other problems, I was assuming that it was a ZM setup problem. After doing the REPAIR TABLE command on all the tables in the zoneminder database as advised by that link, the problem disappeared.