Rudder

Bug #14003

Updated by Alexis Mousset over 5 years ago

On a 5.0 server, I have a nodecompliancelevels table containing old entries, and the table does not seems to be archived/purged. 

 archivedruddersysevents is correctly cleaned though. 

 <pre> 
 rudder=> select min(executiontimestamp) from archivedruddersysevents; 
           min            
 ------------------------ 
  2018-12-10 00:00:12+01 
 (1 row) 
 </pre> 

 <pre> 
 rudder=> select min(runtimestamp) from nodecompliancelevels; 
           min            
 ------------------------ 
  2018-12-04 00:00:01+01 
 (1 row) 
 </pre> 

 <pre> 
 rudder=> select * from archivedreportsexecution; 
  nodeid | date | complete | nodeconfigid | insertionid  
 --------+------+----------+--------------+------------- 
 (0 rows) 
 </pre> 

 <pre> 
 rudder=> select min(begindate) from archivednodeconfigurations; 
             min              
 ---------------------------- 
  2018-12-10 15:09:45.282+01 
 (1 row) 

 </pre>

Back