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

[John Milton]

-------- Original Message --------
Subject: Re: Big database problem on Hamilton site  was:  Re: 2700 
emails from deskaheh, help!
Date: Mon, 4 Jul 2005 23:24:11 -0400
From: a.h.s. boy (dadaIMC) <spud at dadaimc.org>
To: john at johnmilton.ca
References: <42C98CD1.8080102 at johnmilton.ca> 
<28EE6877-2CA2-4A0B-B77B-4547852A9A71 at dadaimc.org> 
<42C9DE9A.1050709 at johnmilton.ca>

Well, in theory you should have a MySQL backup, if we were lucky
enough to get one that isn't corrupted. "Read error for block" sounds
like a straightforward hardware issue to me. What you probably need
to do is run fsck and any other available disk utilities, but someone
else could speak better about this.

spud.




On Jul 4, 2005, at 9:12 PM, 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/
>> -------------------------------------------------------------
>>
>
> -- 
> 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/
-------------------------------------------------------------




-- 
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