XF 1.4 Session table crashed

[ceptime]

sorry problem mysql database session table crashed
#0 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /var/www/vhosts/***net/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /var/www/vhosts/***net/httpdocs/library/XenForo/Session.php(814): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
#5 /var/www/vhosts//***net/httpdocs/library/XenForo/Session.php(532): XenForo_Session->saveSessionToSource('4f74b097b6c6051...', false)
#6 /var/www/vhosts//***net/httpdocs/library/XenForo/Controller.php(414): XenForo_Session->save()
#7 /var/www/vhosts//***net/httpdocs/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#8 /var/www/vhosts//***net/httpdocs/library/XenForo/FrontController.php(354): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Index')
#9 /var/www/vhosts//***net/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/vhosts//***net/httpdocs/index.php(13): XenForo_FrontController->run()
#11 {main}



array(3) {
["url"] => string(68) "http://***net/search/3744989/?searchform=1&q=search+zil&o=date"
["_GET"] => array(3) {
["searchform"] => string(1) "1"
["q"] => string(11) "Samsung zil"
["o"] => string(4) "date"
}
["_POST"] => array(0) {
}
}

 

[Paul B]

You can try repairing the table first.
If that doesn't work, truncating it should work.

 

[ceptime]

You can try repairing the table first.
If that doesn't work, truncating it should work.

Is it any problems truncate?
Total 5.409.883 query

 

[Paul B]

You have 5.5 million records in the session table?

 

[ceptime]

You have 5.5 million records in the session table?

yes
total 5409926, Query 11.5912 second

 

[Paul B]

Considering the size of your forum, that doesn't sound right.

However, repairing or truncating will be required to fix the error.

 

[ceptime]

Considering the size of your forum, that doesn't sound right.

However, repairing or truncating will be required to fix the error.

Yes truncating xf_session xf_search