core_search_index is crashed

[Fighter]

hello, I'm in 4.4.2 I can't use the search function on my site, or view profiles, it says the core_search_index table is crashed and the automatic repair failed.

 

when trying to search:

IPS\Db\Exception: Table './mi/forums_core_search_index' is marked as crashed and last (automatic?) repair failed (144)
#0 /home/mi/public_html/forums/system/Db/Db.php(462): IPS\_Db->query('SHOW FULL COLUM...', true, false)
#1 /home/mi/public_html/forums/system/Db/Db.php(1924): IPS\_Db->forceQuery('SHOW FULL COLUM...')
#2 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(1413): IPS\_Db->getTableDefinition('core_search_ind...')
#3 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(1154): IPS\Content\Search\Mysql\_Query::termAsWordsArray('pre-order')
#4 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(921): IPS\Content\Search\Mysql\_Query::matchClause('index_content,i...', 'pre-order', '+')
#5 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(1265): IPS\Content\Search\Mysql\_Query->_searchWhereClause('pre-order', NULL, 17, 'and')
#6 /home/mi/public_html/forums/applications/core/modules/front/search/search.php(658): IPS\Content\Search\Mysql\_Query->search('pre-order', NULL, 17, 'and')
#7 /home/mi/public_html/forums/applications/core/modules/front/search/search.php(73): IPS\core\modules\front\search\_search->_results()
#8 /home/mi/public_html/forums/system/Dispatcher/Controller.php(96): IPS\core\modules\front\search\_search->manage()
#9 /home/mi/public_html/forums/system/Dispatcher/Dispatcher.php(152): IPS\Dispatcher\_Controller->execute()
#10 /home/mi/public_html/forums/index.php(13): IPS\_Dispatcher->run()
#11 {main}

 

when trying to see profiles:

SELECT COUNT(*) FROM `forums_core_search_index` AS `core_search_index` WHERE index_class='IPS\core\Statuses\Status' AND index_container_id=1
IPS\Db\Exception: Table './madonnai_forums2019/forums_core_search_index' is marked as crashed and last (automatic?) repair failed (144)
#0 /home/mi/public_html/forums/system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\Content\\S...', Array, true)
#1 /home/mi/public_html/forums/system/Db/Select.php(436): IPS\Db\_Select->runQuery()
#2 /home/mi/public_html/forums/system/Db/Select.php(355): IPS\Db\_Select->rewind()
#3 /home/mi/public_html/forums/system/Content/Search/Mysql/Query.php(293): IPS\Db\_Select->first()
#4 /home/mi/public_html/forums/applications/core/modules/front/members/profile.php(240): IPS\Content\Search\Mysql\_Query->filterForProfile(Object(IPS\Member))
#5 /home/mi/public_html/forums/system/Dispatcher/Controller.php(96): IPS\core\modules\front\members\_profile->manage()
#6 /home/mi/public_html/forums/applications/core/modules/front/members/profile.php(73): IPS\Dispatcher\_Controller->execute()
#7 /home/mi/public_html/forums/system/Dispatcher/Dispatcher.php(152): IPS\core\modules\front\members\_profile->execute()
#8 /home/mi/public_html/forums/index.php(13): IPS\_Dispatcher->run()
#9 {main}

when I check my dabatase on cpanel it shows this

 [forums_core_search_index] Table is marked as crashed and last repair failed    
    [forums_core_search_index] 3 clients are using or haven't closed the table properly    
    [forums_core_search_index] Found 72 keys of 783707    

I've tried the Support tool with "Something isn't working correctly" and nothing. This all started with a big server spike because of high traffic. 

 

Any help?

Thank you.

[Fighter]

Well, I managed to fix it after being really desperate....

Here's the solution in case it happens to anyone else:

if you have access to your server root via ssh, login and delete the tmd file for the table with the problem, in my case I did it like:

rm /var/lib/mysql/*DBNAME*/forums_core_search_index.tmd

Now on phpmyadmin, I selected the table and at the bottom I clicked the repair button and it was fixed without errors. The problem was that phpmyadmin didn't want to overwrite the temporary file.

Now everything seems to be fixed!

[James]

The question(s) in this support topic have been answered and the topic author has resolved their issue. This topic is now closed. If you have other questions, please open a new topic.