I am replicating the froxlor db (with many other DBs) to a SLAVE mysql server that is used to make backups.
I've found an error in the SLAVE:
Could not execute Delete_rows event on table froxlor.panel_sessions; Can't find record in 'panel_sessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000350, end_log_pos 6002396
This is probably because panel_sessions is using a HEAP/MEMORY engine and the SLAVE was rebooted.
Being a MEMORY table, I guess it's not a very important table and it is safe to skip panel_sessions from the replication to avoid such errors.
What is it used this table for? Do you think it's safe to skip replicating it?
Question
lanbo
Hi!
I am replicating the froxlor db (with many other DBs) to a SLAVE mysql server that is used to make backups.
I've found an error in the SLAVE:
This is probably because panel_sessions is using a HEAP/MEMORY engine and the SLAVE was rebooted.
Being a MEMORY table, I guess it's not a very important table and it is safe to skip panel_sessions from the replication to avoid such errors.
What is it used this table for? Do you think it's safe to skip replicating it?
Thanks!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.