A lot of queries were locked by other queries

New Member Joined: Aug 02, 2006 Posts: 2

Hi there,
The company that is hosting my website has disabled my access to the database because 'A lot of queries were locked by other queries.'
I have to fix my code, but I have no idea what happened.
Can anyone shed a little bit of light?
Many thanks
Daniel

This is the message that I received.

Quote:

Hello
Thank you for the word to support.

We've just reenabled access to your database. Following queries need to be fixed:
Execution time: 368453
INSERT INTO `nuke_nsnst_tracked_ips` (`user_id`, `username`, `date`, `ip_addr`, `page`, `user_agent`

Execution time: 332925
SHOW TABLE STATUS FROM `romani1_nuke1`

Execution time: 296688
LOCK TABLES `nuke_authors` READ /*!32311 LOCAL */,`nuke_autonews` READ /*!32311 LOCAL */,`nuke_banne
A lot of queries were locked by other queries.
Please fix this from your end and let us know when this will be done, that we can check this from our end. Thanks for your cooperation.

Should you have any further questions, please feel free to contact us anytime, we are available 24/7.
Kind regards,

registered · Posted: Wed Aug 01, 2007 7:27 am

My first reaction would be to say "Time to find a new host". Sad

However, the LOCK TABLES thing is interesting. To my knowledge Nuke doesn't explicitly lock any tables. What version of Nuke are you running and are you running any non-standard modules or add-ons?

registered · Posted: Wed Aug 01, 2007 8:13 am

phpNuke is a database-intensive script. And with addons like Sentinel and the additional usage of page tracking, it can require many queries to execute one page load.

It doesn't mean that a server can't handle it, our sites do. It probably means that your site is hosted on a shared server and your host is crap. Wink

MySQL does lock tables.. at least until a query is executed and returns back to the system. Otherwise you may have multiple query changes in sequence and not know which order it actually executes.

Posted: Wed Aug 01, 2007 8:35 am

evaders99, yes that is probably what is happening with regard to lock tables. It is a behind the scenes thing. There isn't any explicit LOCK TABLES SQL in stock Nuke that I know of. (I had to use LOCK TABLES in a photo of the day module that I wrote, otherwise two users accessing the site at midnight had a race condition updating multiple tables).

So maybe my first reaction was close to the mark. Your host may be having troubles administering MySQL or juggling shared hosting.

Posted: Wed Aug 01, 2007 1:54 pm

Could be the host has a limit on the number of queries it will allow to be executed within a specific timeframe. The problem as evaders mentioned is that if the query is halted mid stream it's possible the table remains locked. You may be able to use phpmyadmin to run a fix.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

That might be correct, but to evaders' and Gremmie's point, the question is why should you need to do that??

Posted: Wed Aug 01, 2007 2:38 pm

Thats an easy one, it's called greed. It means the host can get more accounts per server.