database crashed.

Panupat

Panupat

Well-known member
My forum is giving me this error

Code: 
Server Error

Mysqli prepare error: Table './afxenforo/xf_session' is marked as crashed and should be repaired

    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/Session.php at line 429
    XenForo_Session->save() in XenForo/Controller.php at line 386
    XenForo_Controller->updateSession() in XenForo/Controller.php at line 350
    XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 317
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /home/www/virtual/all-final.com/htdocs/index.php at line 13

Can anyone help me please? What should I do? I've never repaired database before.
 
Sort by date Sort by votes
If you are unable to do it yourself and unwilling to grant access to a third party, you will have to contact your host and they should be able to resolve it for you.
 
Upvote 0 Downvote
Webby said:
I contacted them.
Click to expand...
Was it you that said you were with Arvixe? And that they were upgrading the servers?
That error can happen if the mysql server is out of free inodes.

EDIT:
Yep, it was you.
And I think you answered your own question
Yeah I was having other problems(Error 500,mysqli statement execute error:diskfull) earlier today
Click to expand...
And looks like they may STILL have a disk full issue.
 
Last edited:
Upvote 0 Downvote
Tracy Perry said:
Was it you that said you were with Arvixe? And that they were upgrading the servers?
That error can happen if the mysql server is out of free inodes.

EDIT:
Yep, it was you.
And I think you answered your own question

And looks like they may STILL have a disk full issue.
Click to expand...
Ahh. I'll run that thought past them. I have been talking with them for days but they are still beating around the bush.

Let's assume that the xf_search_index table is messed up, can I get a replacement table and use that? What data is in that table anyway?
 
Upvote 0 Downvote
Now I have the same problem again and the host is not helping. What should I expect the host to do to resolve this problem. I am using Arvixe.

Edit:

I just truncated the xf_search_index table and rebuilt it. The forum is now working again. What could the cause of this problem be. Will I have to be repeating this step regularly?

@Brogan
 
Last edited:
Upvote 0 Downvote
Mike Edge said:
Considering there is no such thing as unlimited hard drives.. unlimited sisk space really doesn't exist. I don't get why so many fall sucker to this marketing scheme..
Click to expand...
Because we assume that it is illegal to sell A and then give B to the customer. This is America not a banana republic.

Look at this bs, I think this is the problem:

MySQL usage:

MySQL abuse is the most common reason for servers at Arvixe to experience high loads or crash all together. Without proper throttling, it takes only a single out of control query to send a server over the edge. As such, we have the following limits across all of our shared plans to lessen the chances of that happening.

  • Run any MySQL queries longer than 30 seconds. MySQL tables should be indexed appropriately.
Where we draw the line:

Executions:

Executions are how many times processes are run to serve your website. Every PHP page loaded and delivered from your site is an execution. Every video or audio file uploaded and/or converted is an execution. Every fetch process from your website is an execution.

What are NOT executions are things like files included from an executed script, static content (HTML, JavaScript, Images, Videos, Audio Files) downloaded from your pages, MySQL queries, e-mails, FTP sessions, your control panel.

With that in mind, here are the execution limits for your account:

  • Reseller Class - 7500 executions/hr , 75000 executions/day
  • Personal Class - 10,000 executions/hr, 100,000 executions/day
  • Business Class - 20,000 executions/hr, 200,000 executions/day
Realtime:

Realtime CPU Usage is how many ticks your executions take. As mentioned in the article linked above, ticks are CPU seconds. 1 tick equals 100% of a single core for 1 second. For a server with 24 cores, that means that there are 24 ticks available in a second on that server.

The following limits are currently in place for Realtime ticks:

  • Reseller Class - 7500 ticks/hr , 75,000 ticks/day
  • Personal Class - 10,000 ticks/hr, 100,000 ticks/day
  • Business Class - 20,000 ticks/hr, 200,000 ticks/day
MySQL Queries:

Queries are when your website "queries" your database. Each page execution can have multiple queries, sometimes even to multiple databases. Most queries complete in a matter of milliseconds, but really large ones can take minutes to finish. Because of the very variable nature of MySQL queries, this section will expand beyond a simple count of queries once the proper metrics have been tested and put in place.

The current MySQL query limits for your account are:

  • Reseller Class - 75,000 queries/hr , 750,000 queries/day
  • Personal Class - 100,000 queries/hr, 1,000,000 queries/day
  • Business Class - 200,000 queries/hr, 2,000,000 queries/day

https://support.arvixe.com/index.php?/Knowledgebase/Article/View/192/4/resource-usage-explained
 
Upvote 0 Downvote
You must log in or register to reply here.
Top Bottom