Website now hanging

[vickichiki]

I havent touched my website in about a week (so havent 'done' anything to it) and received a couple of emails from customers yesterday telling me it was down so had a squiz I cant see anything, I submitted a support ticket with my host and they said they havent done anything however they did say that the cart is still talking to the database and that this piece of code is hanging

$configuration = $db->Execute('select configuration_key as cfgkey, configuration_value as cfgvalue
from ' . TABLE_CONFIGURATION, '', $use_cache, 150);

website is www.bubblebubs.com/shop

Thanks for any help :)

Vicki

[DrByte]

That "piece of code" *is* the communication to the database, which indicates, if that line is hanging, then the database is not responding.

Did your host make any suggestions about checking your database for errors?

Do you have a hosting control panel (such as cPanel) where you can access a MySQL area that manages your databases? On that same page, you should have a link to "Repair Database". You should click that.
You could do similarly in phpMyAdmin, under the "Operations" tab.

[vickichiki]

I thought it was an sql error

I do have access to myphpadmin however the repair tools wont load for some reason, I ran mysqlcheck and it came back with a couple of errors of people not closing the tables however I cant find the command to force a repair from the command line

[DrByte]

if you can log in to MySQL from the command line, try at least this:

repair table configuration;

and repeat for the other tables that it suggested may have problems


If some particular query has the configuration table locked (which should almost never happen), then it may be necessary to stop and restart MySQL if the lock never clears and the query cannot be cancelled.

[vickichiki]

oh sorry by command line I meant an ssh connection to my website sorry!

I did go into myphpadmin and clicked the configuration table and then the repair link but didnt work

Would it be worthwhile backing up, deleting the database and recreating?

[DrByte]

Would it be worthwhile backing up, deleting the database and recreating?

That's an extremely drastic measure.

Is your host being of any help?


In phpMyAdmin, you have an option to "Show Processes" This lists all actively-running queries on your database. What's listed there?

[vickichiki]

sorry for the long delay I had to go to work and I have no net access at my shop and the time difference isnt helping lol :)

Here are the processes
5790 vickichiki localhost None Query 0 --- SHOW PROCESSLIST

I do realise that a re-install is a last resort but my site has been down for nearly 2 days now so its kinda getting to that.

My host is good but I dont think they have a lot of ZC knowledge *sigh* I will fiddle more with it tonight

[vickichiki]

Oh I have an answer :) My host has just confirmed that the monitoring company has installed upgrades to MYSQL on my server and that has caused the problems so its being fixed :)

Thanks so much for you time