[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