[GE users] ARCo dbwriter not deleting outdated records

rafaarco rafaarco at ugr.es
Fri Aug 28 13:20:31 BST 2009


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

I forgot: we're using SGE 6.2, ARCo 6.2u3 (this combination works
flawlessly with the exception of the outdated records) and Oracle 9i.

Regards,

Rafa

El vie, 28-08-2009 a las 14:14 +0200, Rafael Arco Arredondo escribió:
> Hello,
> 
> We have an issue with outdated records in ARCo database. Our
> configuration is the default one: raw host values are kept for 7 days
> and dbwriter runs in continuous mode (i.e., deletion should happen once
> in an hour). However, the query
> 
> SELECT MIN(hv_time_start) FROM sge_host_values WHERE hv_variable = 'cpu'
> 
> returns
> 
> 2009-08-13 11:39:37.0
> 
> And the table sge_host_values keeps growing.
> 
> Since today is August 28th, I expected this minimum value to be
> 2009-08-21. So it's seems that old rows are not deleted.
> 
> Any ideas?
> 
> Thank you in advance,
> 
> Rafa
> 
-- 
Rafael Arco Arredondo
Centro de Servicios de Informática y Redes de Comunicaciones
Universidad de Granada

------------------------------------------------------
http://gridengine.sunsource.net/ds/viewMessage.do?dsForumId=38&dsMessageId=214739

To unsubscribe from this discussion, e-mail: [users-unsubscribe at gridengine.sunsource.net].



More information about the gridengine-users mailing list