Hi,
I've got the database_attachments plugin enabled because I have multiple machines with a memcached session store. It seems to work fairly well... except that I am replicating the database to a read-only slave for redundancy (and read-balancing) and the replication keeps breaking.
The slave will get this error:
Could not execute Delete_rows event on table roundcube.cache; Can't find record in 'cache', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000151, end_log_pos 182376
I've got a db_dnsw and db_dnsr configured in my roundcube config, could it be that roundcube is also writing to the db_dnsr causing entries to be removed on the slave, and then when the replication happens it fails because it has been removed on the slave already?
I tried to look at mysql-bin.000151 for the 182376 event, but couldn't find it.
Ideally, I wouldn't even replicate the roundcube.cache table, because its a *lot* of data, but if I dont replicate it, I suspect the db_dnsr would fail to find the records?
thanks for any suggestions for things to check, micah