Support

Home › Forums › Event Espresso Premium › Mysql queries EventEspresso and Firewall

Mysql queries EventEspresso and Firewall

Posted: April 15, 2016 at 8:30 am


bdearth

April 15, 2016 at 8:30 am

We are having a problem that we believe started following the EE update to 4.8.39p. But that may have been coincidental. Our tech support says the ssh/sftp is not working and it appears MySQL queries are getting stuck trying to retrieve the massive ee_locked_transactions row (2.4 MB). Does this need to be 2.4 MB in size? Is this a known EE problem? Other explanation? Whatever is happening, it ground the server to a halt and the ISP had to disable our site because there are other sites on the same server.

Event Espresso – 4.8.39.p
WordPress 4.5


Josh

  • Support Staff

    •

April 15, 2016 at 9:07 am

Hi there,

The ee_locked_transactions row shouldn’t get anywhere near that big under normal circumstances. You can delete the option row entirely, then EE4 will re-add the row later.

Then, it may help to prevent further junk locked transactions if you can install a bot trap, like this plugin:

https://wordpress.org/plugins/blackhole-bad-bots/


bdearth

April 15, 2016 at 9:25 am

Thanks, Josh. We will try this and see how it works.

The support post ‘Mysql queries EventEspresso and Firewall’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by  bdearth 8 years ago ago

Topic Tags

Tagged: ,

Notifications

This topic is:
pending
Event Espresso