rendered paste body AND alarmacktime IS NULL
2008-02-25 16:16:22,265 DEBUG [VacuumdScheduler-2 Pool-fiber0] AutomationProcessor$ActionProcessor: createPrepareStat
ement: This action SQL:
DELETE from alarms
WHERE severity <= 3
AND COALESCE(lastautomationtime, lasteventtime) < now() - interval '2 minutes'
AND alarmacktime IS NULL
Turned into this:
DELETE from alarms
WHERE severity <= 3
AND COALESCE(lastautomationtime, lasteventtime) < now() - interval '2 minutes'
AND alarmacktime IS NULL
2008-02-25 16:16:26,294 DEBUG [VacuumdScheduler-2 Pool] LegacyScheduler: run: found ready runnable ScheduleEntry[expC
ode=1] for org.opennms.netmgt.vacuumd.AutomationProcessor@1c8b0fb (ready in 0ms)
2008-02-25 16:16:54,725 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 52223050ms remaining to execution.
2008-02-25 16:17:44,920 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 52172855ms remaining to execution.
2008-02-25 16:18:35,521 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 52122254ms remaining to execution.
2008-02-25 16:19:26,160 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 52071615ms remaining to execution.
2008-02-25 16:20:16,779 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 52020996ms remaining to execution.
2008-02-25 16:21:07,286 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51970489ms remaining to execution.
2008-02-25 16:21:57,870 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51919905ms remaining to execution.
2008-02-25 16:22:48,065 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51869710ms remaining to execution.
2008-02-25 16:23:38,658 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51819117ms remaining to execution.
2008-02-25 16:24:29,281 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51768495ms remaining to execution.
2008-02-25 16:25:19,886 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51717889ms remaining to execution.
2008-02-25 16:26:10,463 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51667312ms remaining to execution.
2008-02-25 16:27:01,066 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51616709ms remaining to execution.
2008-02-25 16:27:51,290 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51566485ms remaining to execution.
2008-02-25 16:28:41,887 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51515888ms remaining to execution.
2008-02-25 16:29:32,488 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51465287ms remaining to execution.
2008-02-25 16:30:23,126 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51414649ms remaining to execution.
2008-02-25 16:31:13,706 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51364069ms remaining to execution.
2008-02-25 16:32:04,308 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51313467ms remaining to execution.
2008-02-25 16:32:54,698 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51263077ms remaining to execution.
2008-02-25 16:33:45,118 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51212657ms remaining to execution.
2008-02-25 16:34:35,742 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51162033ms remaining to execution.
2008-02-25 16:35:26,248 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51111527ms remaining to execution.
2008-02-25 16:36:16,917 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51060858ms remaining to execution.
2008-02-25 16:37:07,497 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 51010278ms remaining to execution.
2008-02-25 16:37:57,703 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50960072ms remaining to execution.
2008-02-25 16:38:48,393 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50909382ms remaining to execution.
2008-02-25 16:39:38,898 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50858877ms remaining to execution.
2008-02-25 16:40:29,454 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50808321ms remaining to execution.
2008-02-25 16:41:20,090 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50757685ms remaining to execution.
2008-02-25 16:42:10,645 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50707130ms remaining to execution.
2008-02-25 16:43:00,847 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50656928ms remaining to execution.
2008-02-25 16:43:51,383 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50606392ms remaining to execution.
2008-02-25 16:44:42,075 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50555700ms remaining to execution.
2008-02-25 16:45:32,695 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50505080ms remaining to execution.
2008-02-25 16:46:23,244 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50454531ms remaining to execution.
2008-02-25 16:47:13,817 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50403958ms remaining to execution.
2008-02-25 16:48:04,010 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50353765ms remaining to execution.
2008-02-25 16:48:54,655 DEBUG [Vacuumd-Thread] Vacuumd: Vacuumd: 50303120ms remaining to execution.