List:General Discussion« Previous MessageNext Message »
From:Brent Clark Date:March 26 2012 12:48pm
Subject:1 client is using or hasn't closed the table properly
View as plain text  
Hi Guys

I got a problem whereby replication (Master - Master) is broken between my two nodes.

But whats really interesting is that, when I try and recover, i.e. take a LVM snapshot
(mylvmbackup), and uncompress / recover  on the slave. On starting mysql, I just see a
range of

Mar 26 14:43:54 xyz-web02 mysqld: 120326 14:43:54 [ERROR] /usr/sbin/mysqld: Table
'./db/comm_opens' is marked as crashed and should be repaired
Mar 26 14:43:54 xyz-web02 mysqld: 120326 14:43:54 [Warning] Checking table:  
'./db/comm_opens'
Mar 26 14:43:54 xyz-web02 mysqld: 120326 14:43:54 [ERROR] 1 client is using or hasn't
closed the table properly

Would anyone know what is causing this, and how I can go about fixing it.
Do you think the problem could be on node 1?

Kind Regards
Brent Clark
Thread
1 client is using or hasn't closed the table properlyBrent Clark26 Mar
  • Re: 1 client is using or hasn't closed the table properlyJohan De Meersman26 Mar