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)

Reply via email to