Database corruption

Support and queries relating to all previous versions of ZoneMinder
Locked
gola10
Posts: 150
Joined: Wed Nov 01, 2006 3:16 pm
Location: Panama

Database corruption

Post by gola10 »

On zm 1.223 and ZM 1.23 on Mandriva 2007 i see that once in a while i have database corruption and running
mysqlcheck --all-databases --auto-repair -ppassword -uuser
will repair it.
One of the messages i see while repairing the database mentions that 3 users has not logout or something like this.
If users do not logout but simply close the ZM browser session, could cause this problems? If so, how do i instruct ZM to automatically logout users that has sessions open for certain time?
User avatar
Lee Sharp
Posts: 1069
Joined: Sat Mar 31, 2007 9:18 pm
Location: Houston, TX

Post by Lee Sharp »

You need to stop the zoneminder process first. It is still "in the database" when you fix it.
User avatar
cordel
Posts: 5210
Joined: Fri Mar 05, 2004 4:47 pm
Location: /USA/Washington/Seattle

Post by cordel »

Lee Sharp wrote:You need to stop the zoneminder process first. It is still "in the database" when you fix it.
and Apache if others also access the server so that nothing is using the database at the time.

This can also be created by the server losing power and the tables not being properly closed.
gola10
Posts: 150
Joined: Wed Nov 01, 2006 3:16 pm
Location: Panama

Post by gola10 »

Thanks,
So it does no harm if a user login and then do no logout but close the browser windows?
User avatar
Lee Sharp
Posts: 1069
Joined: Sat Mar 31, 2007 9:18 pm
Location: Houston, TX

Post by Lee Sharp »

Your browser has nothing to do with it. The ZM service must be stopped however.
Locked