1 client is using or hasn't closed the table properly

2012-03-26 Thread Brent Clark
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

Re: 1 client is using or hasn't closed the table properly

2012-03-26 Thread Johan De Meersman
- Original Message - From: Brent Clark brentgclarkl...@gmail.com 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 That needs a 'repair table' command; probably because the snapshot was