Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
danmih
New Member
New Member


Joined: Aug 02, 2006
Posts: 2

PostPosted: Wed Aug 01, 2007 5:45 am Reply with quote

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,
 
View user's profile Send private message
Gremmie
Former Moderator in Good Standing


Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Wed Aug 01, 2007 7:27 am Reply with quote

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?

_________________
Only registered users can see links on this board! Get registered or login! - An Event Calendar for PHP-Nuke
Only registered users can see links on this board! Get registered or login! - A Google Maps Nuke Module 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Wed Aug 01, 2007 8:13 am Reply with quote

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.

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Gremmie
PostPosted: Wed Aug 01, 2007 8:35 am Reply with quote

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.
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Wed Aug 01, 2007 1:54 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Wed Aug 01, 2007 2:36 pm Reply with quote

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

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Guardian2003
PostPosted: Wed Aug 01, 2007 2:38 pm Reply with quote

Thats an easy one, it's called greed. It means the host can get more accounts per server.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©