XF 2.0 Database error

[coolbreeze86]

Hi team,

For the past 3 days we are facing continous crash in the database tables. cant even login to the backend. getting errors like this.

XF\Db\Exception: MySQL statement prepare error [145]: Table './youth_xenforo/xf_session' is marked as crashed and should be repaired in src/XF/Db/AbstractStatement.php at line 212

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 40
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
5. XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
6. XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
7. XF\Session\Session->save() in src/XF/Admin/Controller/Login.php at line 136
8. XF\Admin\Controller\Login->completeLogin() in src/XF/Admin/Controller/Login.php at line 70
9. XF\Admin\Controller\Login->actionLogin() in src/XF/Mvc/Dispatcher.php at line 249
10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
13. XF\App->run() in src/XF.php at line 328
14. XF::runApp() in admin.php at line 13

When trying to repair the table getting error lost connectivity to the database table.

how shall i proceed, server team help is very poor not answering quickly.

Please help as soon as possible.

thank you

 

[AndyB]

Use phpMyAdmin and truncate the xf_session table.

 

[Pierce]

yes don't bother repairing the sessions table. its only a temp table.

If your hosting is not responding, make a backup and move somewhere else.

 

[coolbreeze86]

Use phpMyAdmin and truncate the xf_session table.

Hi tried truncating tables, but connection to database getting lost...

That particular table alone shows as "in use".

any other solution for this.

thank u

 

[Ozzy47]

It sounds like mySQL is stopping for unexpected reasons, not enough disk space can make this happen. You need to check the mysql logs to see what (if any) error is showing up in it.

 

[Pierce]

Hi tried truncating tables, but connection to database getting lost...

That particular table alone shows as "in use".

any other solution for this.

thank u

Honestly it shouldn't be happening.

Truncating a table and losing the dB doesn't sound good. It sounds like it's not setup or the server has some busy sites and all connections are occupied....

 

[AndyB]

Hi tried truncating tables, but connection to database getting lost...

Contact your web host, tell them to truncate that table.

 

[dknife]

Are you getting errors like that, with other errors showing similar problems with other tables? Or that specific error for that table every time?