[Reconnoiter-users] Rollup cron job

Julian Seidenberg julian at silverstripe.com
Thu Nov 5 16:04:54 EST 2009


Hi again,
I noticed that the rollup cron job gives the following error whenever  
run:

NOTICE:  (20m,2009-11-05 13:00:00+13)
NOTICE:  (30m,2009-11-05 13:00:00+13)
NOTICE:  v_sql was (SELECT * FROM stratcon.window_robust_derive 
('2009-11-05 13:00:00+13'))
NOTICE:  (20m,2009-11-05 13:00:00+13)
NOTICE:  (30m,2009-11-05 13:00:00+13)
NOTICE:  v_sql was (SELECT * FROM stratcon.window_robust_derive 
('2009-11-05 13:05:00+13'))
NOTICE:  function array_agg(integer) does not exist
ERROR:  control reached end of function without RETURN
CONTEXT:  PL/pgSQL function "rollup_metric_numeric"

The end result is that the "metric_numeric_rollup_queue" table is the  
only one of the rollup tables that contains any data. Is this a bug  
with the cron job or the stratcon.functions?

Julian

-------
Julian Seidenberg


More information about the Reconnoiter-users mailing list