Skip to content
View in the app

A better way to browse. Learn more.
Froxlor Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

lanbo
in General Discussion

Featured Replies

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: 

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?

Thanks!

it holds sessions and does not need long-term storage, that's why it's HEAP/MEMORY - you can safely skip it fr replication

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.