Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

wildvettes

MYSQL Query Limit Reached shutting down my site.

8 posts in this topic

I have Ipage and I am now regularly getting this error while working on my site and I'm guessing with my limited number of visits this is going to get completely and totally out of control with a live site and actual customers.

 

Any thoughts?

 

1226 - User 'wildvettes' has exceeded the 'max_questions' resource (current value: 75000)

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

Should I switch hosts? Is it my website causing the problem? What steps should I take to switch hosts? What hosts does everyone use?

Share this post


Link to post
Share on other sites

Ok, so I'm hoping I figured it out.

 

When I installed Mindsparx admin panel I must have just copied over because it deleted some of my addon files.

 

Long story short the Auto-Backup setup file was deleted, but the actual process itself and the code changes were still active. Basically it appears as though it was backing up my entire database constantly creating hundreds and hundreds of database backups.

 

Hopefully the problem will be rectified now.

 

 

*correction thousands and thousands*

Share this post


Link to post
Share on other sites

Fixed

 

Would like to know what steps you took to eliminate the issue. Because I get the same error and iPage told me after I exceed the limit, I have to wait one hour before I am able to access my site again. It is a very big pain in the ---! So if there is a fix, I would appreciate hearing about it, so that I will have not to look for another host.

 

Thanks.

Share this post


Link to post
Share on other sites

Would like to know what steps you took to eliminate the issue. Because I get the same error and iPage told me after I exceed the limit, I have to wait one hour before I am able to access my site again. It is a very big pain in the ---! So if there is a fix, I would appreciate hearing about it, so that I will have not to look for another host.

 

Thanks.

 

 

My auto_backup_setup.php file was missing from my /admin/.

 

This allowed my auto_backup_db.php in my /admin/includes to run non-stop which was causing the query problems.

 

If you have this add-on I would check it is functioning properly first, if not you have something on your site caught in a check sql loop. I doubt your site could be busy enough to have thousands of customers an hour, but that is also a possibility.

Share this post


Link to post
Share on other sites

And NOPE getting the error again. I give up.

 

What is even better was the fact that I have been away from my PC for the last 45 mins. So who exactly was doing the sql queries?

Share this post


Link to post
Share on other sites

Is it possible this could be caused by a search engine, hacker, etc...?

 

Otherwise I can't possible understand how I could be hitting 75,000 an hour. Unless something is going on with my host. I have all of the recommended security enhancements installed...is it possible the site has been hacked?

 

Nothing seems to be weird other than this message.

Share this post


Link to post
Share on other sites

Got an IP ban about 5 minutes after the most recent shut down, getting the message about every hour or so...this is the first IP ban though.

Share this post


Link to post
Share on other sites