Try to check your MySQL tables using myisamchk utility.
[EMAIL PROTECTED] wrote:
>
> No difference... i'm going to try downgrading and see what happens..:)
>
> Paul
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Alexander F.
> Avdonkin
> Sent: February 19, 2001 10:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [aseek-users] Problems with 1.0.2 searchd
>
> Possibly, it is due to very old bug in "searchd". This bug will be fixed in
> 1.0.3
> To fix it now, replace all occurences (4) of "pos[s]" to "pos[s - 1]" in
> "search.cpp" and recompile searchd.
>
> Alexander.
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 20, 2001 10:59 AM
> Subject: [aseek-users] Problems with 1.0.2 searchd
>
> > hi there...
> >
> > I recently upgraded from 0.9.9 to 1.0.2 and am having problems with
> > searching...
> >
> > Before I upgraded everything was fine.... did I miss something in an
> > upgrade? I moved s.cgi to my cgi-bin and overwrote my old one... the only
> > old thing I kept is my configs...
> >
> > Everytime I run a search via s.cgi, the searchd comes back with:
> >
> > 14784 root 14 0 337M 125M 28 R 0 4.7 50.1 0:05 searchd
> >
> > The memory goes through the roof and I get "an error has occured" from the
> > web.
> >
> > Has anyone seen this happen? Redhat linux 6.2 is the O/S and MySQl:
> >
> > Server version 3.23.32
> > Protocol version 10
> > Connection Localhost via UNIX socket
> > UNIX socket /tmp/mysql.sock
> > Uptime: 18 days 4 hours 29 min 24 sec
> >
> > Threads: 1 Questions: 67543059 Slow queries: 540 Opens: 408 Flush
> > tables: 1
> > Open tables: 64 Queries per second avg: 42.984
> >
> > Here's my database if that helps:
> >
> > -rw-rw---- 1 root root 180465980 Feb 19 19:50 citation.MYD
> > -rw-rw---- 1 root root 20218880 Feb 19 19:50 citation.MYI
> > -rw-rw---- 1 root root 8592 Jan 14 13:27 citation.frm
> > -rw-rw---- 1 root root 34964 Feb 19 19:50 robots.MYD
> > -rw-rw---- 1 root root 14336 Feb 19 19:50 robots.MYI
> > -rw-rw---- 1 root root 8586 Jan 14 13:27 robots.frm
> > -rw-rw---- 1 root root 5674544 Feb 19 19:51 sites.MYD
> > -rw-rw---- 1 root root 5444608 Feb 19 19:51 sites.MYI
> > -rw-rw---- 1 root root 8584 Jan 14 13:27 sites.frm
> > -rw-rw---- 1 root root 0 Feb 19 19:51 spaces.MYD
> > -rw-rw---- 1 root root 1024 Feb 19 19:51 spaces.MYI
> > -rw-rw---- 1 root root 8592 Jan 14 13:27 spaces.frm
> > -rw-rw---- 1 root root 348532 Feb 19 19:51 stat.MYD
> > -rw-rw---- 1 root root 1024 Feb 19 19:51 stat.MYI
> > -rw-rw---- 1 root root 8844 Jan 14 13:27 stat.frm
> > -rw-rw---- 1 root root 0 Feb 19 19:51 subsets.MYD
> > -rw-rw---- 1 root root 1024 Feb 19 19:51 subsets.MYI
> > -rw-rw---- 1 root root 8588 Jan 14 13:27 subsets.frm
> > -rw-rw---- 1 root root 2411397 Feb 19 19:51 tmpurl.MYD
> > -rw-rw---- 1 root root 1024 Feb 19 19:51 tmpurl.MYI
> > -rw-rw---- 1 root root 8586 Jan 14 13:27 tmpurl.frm
> > -rw-rw---- 1 root root 317975760 Feb 19 19:21 urlword.MYD
> > -rw-rw---- 1 root root 176052224 Feb 19 21:45 urlword.MYI
> > -rw-rw-r-- 1 root root 297271296 Feb 19 21:44 urlword.TMD
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlword.frm
> > -rw-rw---- 1 root root 350314964 Feb 19 19:25 urlwords00.MYD
> > -rw-rw---- 1 root root 933888 Feb 19 19:25 urlwords00.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords00.frm
> > -rw-rw---- 1 root root 347779436 Feb 19 19:30 urlwords01.MYD
> > -rw-rw---- 1 root root 943104 Feb 19 19:30 urlwords01.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords01.frm
> > -rw-rw---- 1 root root 347084876 Feb 19 19:34 urlwords02.MYD
> > -rw-rw---- 1 root root 937984 Feb 19 19:34 urlwords02.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords02.frm
> > -rw-rw---- 1 root root 351470948 Feb 19 19:38 urlwords03.MYD
> > -rw-rw---- 1 root root 942080 Feb 19 19:38 urlwords03.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords03.frm
> > -rw-rw---- 1 root root 346606352 Feb 19 19:42 urlwords04.MYD
> > -rw-rw---- 1 root root 937984 Feb 19 19:42 urlwords04.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords04.frm
> > -rw-rw---- 1 root root 346113408 Feb 19 19:46 urlwords05.MYD
> > -rw-rw---- 1 root root 940032 Feb 19 19:46 urlwords05.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords05.frm
> > -rw-rw---- 1 root root 348837444 Feb 18 14:43 urlwords06.MYD
> > -rw-rw---- 1 root root 925696 Feb 18 18:41 urlwords06.MYI
> > -rw-rw-r-- 1 root root 87289856 Feb 19 19:47 urlwords06.TMD
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords06.frm
> > -rw-rw---- 1 root root 344896196 Feb 18 14:43 urlwords07.MYD
> > -rw-rw---- 1 root root 919552 Feb 18 18:41 urlwords07.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords07.frm
> > -rw-rw---- 1 root root 348559112 Feb 18 14:43 urlwords08.MYD
> > -rw-rw---- 1 root root 922624 Feb 18 21:51 urlwords08.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords08.frm
> > -rw-rw---- 1 root root 345697088 Feb 18 14:43 urlwords09.MYD
> > -rw-rw---- 1 root root 928768 Feb 18 18:41 urlwords09.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords09.frm
> > -rw-rw---- 1 root root 349708972 Feb 18 14:43 urlwords10.MYD
> > -rw-rw---- 1 root root 920576 Feb 18 14:43 urlwords10.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords10.frm
> > -rw-rw---- 1 root root 349483436 Feb 18 14:43 urlwords11.MYD
> > -rw-rw---- 1 root root 930816 Feb 18 14:43 urlwords11.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords11.frm
> > -rw-rw---- 1 root root 348941936 Feb 18 14:43 urlwords12.MYD
> > -rw-rw---- 1 root root 919552 Feb 18 21:51 urlwords12.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords12.frm
> > -rw-rw---- 1 root root 345565032 Feb 18 14:43 urlwords13.MYD
> > -rw-rw---- 1 root root 919552 Feb 18 21:51 urlwords13.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords13.frm
> > -rw-rw---- 1 root root 350027204 Feb 18 14:43 urlwords14.MYD
> > -rw-rw---- 1 root root 925696 Feb 18 21:27 urlwords14.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords14.frm
> > -rw-rw---- 1 root root 348747024 Feb 18 14:43 urlwords15.MYD
> > -rw-rw---- 1 root root 919552 Feb 18 18:41 urlwords15.MYI
> > -rw-rw---- 1 root root 8952 Jan 14 13:27 urlwords15.frm
> > -rw-rw---- 1 root root 4877964 Feb 19 00:02 wordsite.MYD
> > -rw-rw---- 1 root root 1781760 Feb 19 00:02 wordsite.MYI
> > -rw-rw---- 1 root root 8580 Jan 14 13:27 wordsite.frm
> > -rw-rw---- 1 root root 268435996 Feb 18 21:51 wordurl.MYD
> > -rw-rw---- 1 root root 60120064 Feb 18 21:51 wordurl.MYI
> > -rw-rw---- 1 root root 8676 Jan 14 13:27 wordurl.frm
> > -rw-rw---- 1 root root 0 Jan 16 21:45 wordurl1.MYD
> > -rw-rw---- 1 root root 1024 Jan 16 21:45 wordurl1.MYI
> > -rw-rw---- 1 root root 8676 Jan 14 13:27 wordurl1.frm
> >
> >
> > thanks,
> >
> > Paul Stewart
> >
-- [EMAIL PROTECTED] http://kir.sever.net ICQ 7551596 --
Join CCAUWM - Citizens' Campaign for Abolition of the Use
of the Word Microsoft (or of Microsoft Word - you choose)
