1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 xf_search_index crashed (Too many open files)

Discussion in 'Troubleshooting and Problems' started by DRaver, Aug 13, 2014.

  1. DRaver

    DRaver Active Member

    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?
  2. Walter

    Walter Well-Known Member

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

    AndyB Well-Known Member

    Glad to hear the forum is working again.

    How many posts do you have?
  4. DRaver

    DRaver Active Member

    ca. 600.000

    The "too many open files" need a solution.
  5. Mike

    Mike XenForo Developer Staff Member

  6. AndyB

    AndyB Well-Known Member

    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.

Share This Page