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. – Dominic Xigen Nov 4 at 12:58
  • magento1.9 sql queries – Naresh Prajapati Nov 4 at 13:07
  • Below is a process list of running queries for your analysis need to see this output – Dominic Xigen Nov 4 at 13:13
  • @DominicXigen I have attached the image of executing queries, please check – Naresh Prajapati Nov 5 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 – Dominic Xigen Nov 5 at 8:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.