[Deskaheh-sysadmin] Big database problem on Hamilton site was: Re: 2700 emails from deskaheh, help!

[Treesong]

Hello,

Big Muddy IMC's database also appears to be screwed up again. I'm 
looking into it but I'm not sure what to do...

Love and Healing,

Treesong

John Milton wrote:

> O.K. (Well, pretty fucking far from o.k. actually)
>
> I did as you suggested, this is the output from the SQL Interface:
> ----------------------------------------------
> Record: 0
> Table = hamiltondada.articles
> Op = repair
> Msg_type = info
> Msg_text = Read error for block at: 30099823 (error: 5); Skipped
>
> Record: 1
> Table = hamiltondada.articles
> Op = repair
> Msg_type = warning
> Msg_text = Number of rows changed from 10724 to 7883
>
> Record: 2
> Table = hamiltondada.articles
> Op = repair
> Msg_type = status
> Msg_text = OK
> ------------------------------------------------
>
> I then went to "maintainance" and flushed the cache.
>
> Now when I look at the site the most recent feature story is from July 
> 2004, and the most recent wire story is from Aug 1 2004.
>
> I see that the number of rows in the table has been changed from 10724 
> to 7883, I assume that is where our content has gone...
>
> Help, please!
>
> a.h.s. boy (dadaIMC) wrote:
>
>> Wow...harsh. I've never seen that. Error 127 is apparently an  
>> "Unknown error/Record file crashed" problem, which would indicate  
>> some sort of serious MySQL problem.
>>
>> If you can, try running
>>
>> REPAIR TABLE articles;
>>
>> in MySQL, and see if that helps. You should be able to do it 
>> straight  from Admin->SQL if you don't have shell access.
>>
>> spud.
>>
>> On Jul 4, 2005, at 3:24 PM, john milton wrote:
>>
>>> Hmmm... So, I went out of town for a weekend and when I got back  
>>> there were 2,700 (two thousand seven hundred) emails from deskaheh  
>>> waiting for me that looked sort of like this:
>>> ----------------------------------------------------------
>>> [Hamilton IMC][2005-07-01 12:05:54] from  
>>> (45c868fd8f15882827387903d4e6ffa3)
>>>             Error: Got error 127 from table handler
>>>            Server: hamilton.indymedia.org
>>>              Args: limit_start=2600
>>>           User IP: 10.0.0.254
>>> SQL: SELECT articles.* FROM articles WHERE articles.feature = 0 AND  
>>> articles.parentid = 0 AND articles.displayable = 1 AND  
>>> articles.deleted = 0 ORDER BY articles.edit_datetime DESC LIMIT  
>>> 2600,10
>>>              Page: /newswire/display_printable/1156/index.php
>>> -------------------------------------------------------------
>>>
>>> Thus I have turned off error logging , hope a guru can help with  
>>> some insight
>>> -- 
>>> Peace: John Milton
>>>
>>> Email: john at johnmilton.ca
>>> Web: johnmilton.ca
>>>
>>> PGP encrypted mail is welcome, my key is here: http://www.hwcn.org/ 
>>> ~aa492/security.htm
>>>
>>>
>>
>> -------------------------------------------------------------
>> a.h.s. boy
>> support at dadaimc.org
>> dadaIMC support
>> http://www.dadaimc.org/
>> -------------------------------------------------------------
>>
>>
>>
>