FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » help! fud search broken...
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
help! fud search broken... [message #24967] Fri, 20 May 2005 00:44 Go to next message
newnumbertwo is currently offline  newnumbertwo   United States
Messages: 38
Registered: June 2004
Karma: 0
Member
I initiated a search index rebuild on our server. After 30 minutes, the shell became unresponsive and after 45 the entire machine seemed to hang. I had our ISP reboot the server, now searches fail with ERROR 1016 (HY000): Can't open file: 'fud26_search.MYI' (errno: 144)

Likewise, trying to do a select count(*) from fud26_search.MYI fails as well.

First, how can I recover from this and second, how can I update my search index without hanging the server ?

Help!
Re: help! fud search broken... [message #24968 is a reply to message #24967] Fri, 20 May 2005 01:00 Go to previous messageGo to next message
newnumbertwo is currently offline  newnumbertwo   United States
Messages: 38
Registered: June 2004
Karma: 0
Member
i dropped the fud26_search table and rebuilt it. however, i'm not sure how to repopulate it without killing the server like i did last time.

is there a way to rebuild the search index without running it through the web server?
Re: help! fud search broken... [message #24971 is a reply to message #24968] Fri, 20 May 2005 02:01 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You can run the rebuild script via command line, there are instructions on how to do it in the comments at the top of the script.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: attachments on secure connection & IE
Next Topic: The anti-bots code not showing well at registration
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 19:52:58 GMT 2024

Total time taken to generate the page: 0.04124 seconds