Re: [opennms-devel] Race condition between alarmd and vaccumd

[Obi Reddy]

I have temporarily changed the clearing alarms from 5 minutes to 2 minutes to
avoid the race condition.

 <action name="deletePastClearedAlarms" >
      <statement>
        DELETE FROM alarms
         WHERE severity &lt;= 3
           AND COALESCE(lastautomationtime, lasteventtime) &lt; now() -
interval '2 minutes'
           AND (alarmacktime IS NULL AND (tticketState IS NULL OR
tticketState = 3))
      </statement>
    </action>





--
View this message in context: 
http://opennms.530661.n2.nabble.com/Race-condition-between-alarmd-and-vaccumd-tp7584646p7584800.html
Sent from the OpenNMS - devel mailing list archive at Nabble.com.

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this 
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel