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
