XF 1.3 xf_search_index crashed (Too many open files)

[DRaver]

My DB crashed with this message:

Mysqli prepare error: Table './neu@002dxxxx/xf_search_index' is marked as crashed and last (automatic?) repair failed

So I delete the table an rebuild the XF search index.
Now the forum is working again

I want to find the cause.

The first error message in XF was that:

Zend_Db_Adapter_Mysqli_Exception: Can't read dir of './neu@002dxxxx/' (errno: 24 - Too many open files) - library/Zend/Db/Adapter/Mysqli.php:144

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Out of resources when opening file './neu@002dxxxx/xf_search_index.MYD' (Errcode: 24 - Too many open files) - library/Zend/Db/Statement/Mysqli.php:77

What was wrong an how can I fix the problem?

 

[Walter]

Your search index is destroyed. Try deleting and rebuilding the search index.
Maybe you have restarted Mysql?

 

[AndyB]

Now the forum is working again

Glad to hear the forum is working again.

How many posts do you have?

 

[DRaver]

How many posts do you have?

ca. 600.000

The "too many open files" need a solution.

 

[Mike]

You need to adjust your server configuration:

http://duntuk.com/how-raise-ulimit-open-files-and-mysql-openfileslimit
http://stackoverflow.com/questions/502545/too-many-open-files-error-on-ubuntu-8-04

 

[AndyB]

ca. 600.000

The "too many open files" need a solution.

With that many posts, I suggest you purchase the Enhanced Search option from XenForo. That way you can empty the xf_search_index as it will no longer be needed.