We are getting an issue with the database.

Below is the message we are getting from the server.

Our system detected a lock condition in your database. Multiple queries were running too long.

The queries were killed to maintain your site's availability. Below is a process list of running queries for your analysis.

enter image description here

  • What are the queries? Need to include these too. Nov 4, 2019 at 12:58
  • magento1.9 sql queries Nov 4, 2019 at 13:07
  • Below is a process list of running queries for your analysis need to see this output Nov 4, 2019 at 13:13
  • @DominicXigen I have attached the image of executing queries, please check Nov 5, 2019 at 5:17
  • That type query is the result of a product collection. It could literally be anything that builds a product collection like going to a category page or a cron running something which builds a product feed. If this is causing you issues it is likely that you need more resource via more expensive hosting Nov 5, 2019 at 8:39


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.