[Deskaheh-sysadmin] hardware problems on deskaheh

[finn c.]

Hi all,

Aotearoa's database [nzdada] crashed today, looks like it may be caused
by a UDMA problem: 

http://lists.freebsd.org/pipermail/freebsd-stable/2003-November/005116.html

REPAIR table output:

+-----------------+--------+----------+-------------------------------------------------------+
| Table           | Op     | Msg_type | Msg_text											  |
+-----------------+--------+----------+-------------------------------------------------------+
| nzdada.articles | repair | info     | Read error for block at: 17676244 (error: 5); Skipped |
| nzdada.articles | repair | info     | Read error for block at: 17676285 (error: 5); Skipped |
| nzdada.articles | repair | error    | 134 for record at pos 17679128						  |
| nzdada.articles | repair | status   | Operation failed									  |
+-----------------+--------+----------+-------------------------------------------------------+

/var/log/messages errors caused during a REPAIR table:

Jun 10 03:15:17 deskaheh /kernel: ad4s1e: hard error reading fsbn
51519998 of 25235680-25235935 (ad4s1 bn 51519998;
cn 3206 tn 247 sn 47) status=59 error=40

I'm trying to repair the database using an old db dump. Does anyone have
any idea how to fix this?

If _anyone_ has the root passwd for mysqld, now would be a good time to
give it to me.

seeya,
finn

--
pgp encrypted mail welcome - 
keyid: DB8FD9D4      keyserver: keys.indymedia.org
00DE FE12 A499 B1B9 4507  6490 D013 155B DB8F D9D4
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.indymedia.org/pipermail/deskaheh-sysadmin/attachments/20050610/3c7329f2/attachment.pgp