събота, май 30, 2009

mantis MySQL troubles

При опит да се работи с mantis-a се получава

Database query failed. Error received from database was #145: Table './dbname/mantis_bug_history_table' is marked as crashed and should be repaired for the query: INSERT INTO mantis_bug_history_table
( user_id, bug_id, date_modified, type, old_value, new_value, field_name )
VALUES
( '1', '22044', '2009-05-30 10:02:06', '1', '', '', '' ).


Голяма греда като за добро утро...

mysqlcheck -u root -p dbname дава че всичко е ОК, но пък mysql> SELECT COUNT(*)
-> FROM mantis_bug_monitor_table
-> WHERE user_id='3' AND bug_id='21975';
ERROR 145 (HY000): Table './dbname/mantis_bug_monitor_table' is marked as crashed
and should be repaired ... след като той така тогава аз така:
mysqlcheck --auto-repair -u root -p dbname
Enter password:
dbname.mantis_bug_history_table
error : Table './dbname/mantis_bug_history_table' is marked as crashed and should be repaired

Repairing tables
dbname.mantis_bug_history_table
warning : Number of rows changed from 318190 to 318192

status : OK

и после пак греда:

mysqldump --create-options --add-drop-table --no-data --default-character-set=utf8 dbname -u root -p > dbname-nodata.sql
Enter password:
mysqldump: Got error: 145: Table './dbname/mantis_bug_history_table' is marked as crashed and should be repaired when using LOCK TABLES


Ех да умреш от сол в кофите с боклук дано ...

~/var/lib/mysql/dbname# myisamchk -cs *.MYI
myisamchk: MyISAM file mantis_bug_monitor_table.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: warning: Size of datafile is: 252999 Should be: 252990
MyISAM-table 'mantis_bug_monitor_table.MYI' is usable but should be fixed
myisamchk: MyISAM file mantis_user_table.MYI
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table 'mantis_user_table.MYI' is usable but should be fixed


В крайна сметка възможно най-лесното решение се оказа:
mysqlcheck --auto-repair -u root -p dbname mantis_bug_history_table ... това беше ключа за палатката... да упомена изрично таблица която искам да ми repair-не




Reblog this post [with Zemanta]

2 коментара:

Анонимен каза...

Thank you very much Eol!!!

Adam from Hungary

Eol® каза...

You are welcome Adam from Hungary :)