Jump to content
Froxlor Forum
  • 0

Table panel_sessions, MEMORY engine, bad for replication, can it be skipped?




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?


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...