WordPress database error Lock wait timeout exceeded

  • macbrush723

    (@macbrush723)


    4 years ago

    One of our WordPress sites has developed this error, not sure how long it’s been, but recently the main page sometimes takes nearly a min to load, so I suspect this might have something to do with it. Below is some of the log, they’re all the same. I’ve looked into the database, there are like over 600,000 entries in wppa_session table, most of them say “expired”. Any pointer to how to begin diagnosing this issue would be very much appreciated.

    Thanks
    Kenneth

    P.S. I am a network administrator, but our residence WordPress expert has recently left the company to immigrate overseas, so I might need somewhat more help.

    [Fri May 06 16:09:37.022997 2022] [php7:notice] [pid 30964] [client 207.244.234.219:50696] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp1_wppa_session\r\n\t\t\t\t\t\t SET ip = ”, user = ”, data = ”\r\n\t\t\t\t\t\t WHERE status = ‘expired’\r\n\t\t\t\t\t\t AND data NOT LIKE ‘%”isrobot”;b:1;%’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, wppa_session_start, referer: https://gemy.link/81L8v

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    4 years ago

    The expired entries should be removed automatically by cron process ‘wppa_cleanup’ that runs every hour.

    Make sure you did not disable cron processes in any way.

    You may ‘manually’ TRUNCATE TABLE wp1_wppa_session at any time.

    Thread Starter macbrush723

    (@macbrush723)

    4 years ago

    Thanks for the quick reply. I have looked through Tools -> Cron Events, and couldn’t find anything look similar to wppa, perhaps they weren’t installed? Any way I could trigger wppa to reinstall cron jobs?

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    4 years ago

    Just run Setup on Advanced settings -> Maintenance -> I -> Item 1, and make sure Item 0 is UNtcked

    Thread Starter macbrush723

    (@macbrush723)

    4 years ago

    Thank you, I’ll give it a go tonight. Better not do anything rush in production hour.

    Will report back.

    Thread Starter macbrush723

    (@macbrush723)

    4 years ago

    Sorry, but one question. How do I run setup? I could only see Settings -> Do a quick initial setup.

    Thanks

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    4 years ago

    Are you up to rev? 8.1.09.008 is current

    On the Photo Albums -> Settings admin page: Advanced Settings -> Maintenance -> I -> Item 1: it reads: Setup Re-initialize plugin.
    At the right hand side there is a Do it! button. Press the button.

    This is almost equivalent to de-activate and re-activate the plugin.

    Again: Make sure that at Item 1 on the same page: Postpone cron the box is UNchecked.

    Thread Starter macbrush723

    (@macbrush723)

    4 years ago

    Thanks, we have an old version of WPPA+, probably time for an update.

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    4 years ago

    The old version will also work for this, just run the quick setup, it takes a second or so, you can do it harmless on a production site.

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

The topic ‘WordPress database error Lock wait timeout exceeded’ is closed to new replies.