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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql