[GE users] ARCO database crash

Arturo Giner Gracia artginer at bifi.es
Thu Sep 18 11:29:17 BST 2008

    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "ISO-8859-10" character set.  ]
    [ Some special characters may be displayed incorrectly. ]

Hi all,

Almost every day I find in the dbwriter.log file errors like this:

18/09/2008 12:20:31|lxsrv2|cordManager.batchErrorHandling|W|Error in SQL 
Statement: INSERT INTO sge_host_values (hv_id, hv_parent, hv_time_start, 
hv_time_end, hv_variable, hv_svalue, hv_dvalue, hv_dconfig) VALUES 
(94801413, 5, {ts '2008-09-18 12:20:07.0'}, {ts '2008-09-18 
12:20:07.0'}, 'cpu', '100.000000', 100.0, 0.0) 
java.sql.BatchUpdateException: Incorrect key file for table 
'./ARCO/sge_host_values.MYI'; try to repair it

How can I fix this? Do you think the table is too big?

I'm using SGE 6.1u4 & mysql-5.0.26-16. 


Arturo Giner Gracia
System Administrator
Instituto de Biocomputación y Física de Sistemas Complejos
de la Universidad de Zaragoza (BIFI)
e-mail: artginer at bifi.es    artginer at unizar.es
phone: (+34)976562212 ext.224 

To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
For additional commands, e-mail: users-help at gridengine.sunsource.net

More information about the gridengine-users mailing list