[GE users] ARCO database crash

alena plestilova Alena.Plestilova at Sun.COM
Thu Sep 18 12:35:07 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 Artur,

there is a known issue that all foreign and primary keys are defined as 
type integer, so the overflow can happen (see 
http://gridengine.sunsource.net/issues/show_bug.cgi?id=2626), however 
this is not problem of your database.

Do you have enough space on your disk?

Regards,
aja


Arturo Giner Gracia wrote:
> 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.
>
> Thanks
> Arturo
>
-2147483648 to +2147483647
                                     94801413

-- 
aja & sun
e-mail: aja at sun.com


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