Database error disrupts MySQL replication

[michael_baxter]

I have Quforms installed on several websites, and one of them is an enterprise system with MySQL replication configured. Quforms is breaking MySQL replication with repeated MySQL errors. These errors are present in every system where Quforms is installed.

WordPress database error Duplicate entry 'Pzbu2fBqAcfAXvsfdtiXkDSfrFI8t1pF9DiYsMHs' for key 'id' for query INSERT INTO prd_quform_sessions (id, payload, last_activity) VALUES ( ...

Please update your system to prevent these issues, or tell me how to update MySQL to prevent these issues. Quforms is a great product, and I don’t want to quit using it, but I cannot leave the Enterprise at risk of data loss because this one plugin breaks MySQL replication.

I am attaching a portion of our most recent log file, in case you find this useful for troubleshooting.

Attachments:

You must be logged in to view attached files.

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[michael_baxter]

I had already attempted the suggested update on one of my servers, with no luck. As of this morning, it was still throwing warnings, and I have rebooted and cleared the cache since applying the update.

So, to ensure I hadn’t missed something I added variants. In all, here are the entries that I added:

• quform_sessions (recommended)
• quform_session
• quform_sessions_
• quform_session_

I’m not sure which of these worked, but one of these entries helped. I copied these settings to several of my sites, and they all appear to have stopped throwing the PHP warning reported earlier.
NOTE: I had to purge all W3TC caches for this to work, but it worked almost immediately after that.

If you can review which variants might have worked and confirm that it appears to be the additional of “quform_session_” or “quform_sessions_”. It would be really helpful to update the page you linked to.

Thanks for the continued support!

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[michael_baxter]

As a follow-up… I double-checked my log files this morning. Much to my dismay, the most important installation still has that error occurring every few minutes.

There are two major differences between other installations and this one:

• This server is a “Networked” or “Multisite” environment.
• This server is running on Microsoft IIS, not Apache/Linux.

I cannot figure out why your suggestion worked in all other environments, but not the most important one. Is there any chance that you could investigate, or recommend a course of investigation?

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[Author]

Posts