Database error disrupts MySQL replication

Home Forums Quform WordPress Database error disrupts MySQL replication

This topic is: resolved

This topic contains 5 replies, has 2 voices, and was last updated by  Ally 4 months, 3 weeks ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #28891

    michael_baxter
    Participant

    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.
    #28910

    Ally
    Support Staff

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

    #28930

    michael_baxter
    Participant

    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!

    #28933

    Ally
    Support Staff

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

    #28940

    michael_baxter
    Participant

    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?

    #28954

    Ally
    Support Staff

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

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.

Be inspired. © 2019 ThemeCatcher Ltd. 20-22 Wenlock Road, London, England, N1 7GU | Company No. 08120384 | Built with React | Privacy Policy