Lock issue when upgraded to MySQL 8 via Percona-XtraDB-Cluster

  • Resolved Lukasz

    (@wpfed)


    1 month, 2 weeks ago

    It looks like plugin does not work well with MySQL cluster now that strict mode is ENFORCING, single mysql should be fine, any suggestions or fixes for this, it’s showing in my debug log repeatedly.

    [30-Oct-2025 23:00:55 UTC] WordPress database error Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING for query SELECT GET_LOCK(‘blc_lock’, 0) made by do_action(‘wp_ajax_blc_work’), WP_Hook->do_action, WP_Hook->apply_filters, wsBrokenLinkChecker->ajax_work, wsBrokenLinkChecker->work, wsBrokenLinkChecker->acquire_lock, WPMutex::acquire

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    1 month, 1 week ago

    Hi @wpfed,

    I’m bringing this further to our BLC team’s attention to check if there are any improvements that could be implemented regarding such instances.

    Will keep you posted once we get further feedback.

    Regards,

    Nithin

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    1 month ago

    Hi @wpfed,

    I would like to update that our BLC team will be looking to improve this down the roadmap in future updates. At the moment, we don’t have an exact ETA to provide, as it’s still in its early phase.

    Regards,
    Nithin

    Thread Starter Lukasz

    (@wpfed)

    1 month ago

    thanks for the update @wpmudevsupport11

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

  • 3 replies
  • 2 participants
  • Last reply from: Lukasz
  • Last activity: 1 month ago
  • Status: resolved