Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-9799

Event parameter refactor breaks Auto-Acknowledgements for Notifications

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 21.0.0, 21.0.1, 21.0.2
    • 21.0.4
    • Security Level: Default (Default Security Scheme)
    • Horizon - Jan 3rd 2018, Horizon - Jan 10th 2018, Horizon - Jan 17th 2018, Horizon - Jan 24th 2018

    Description

      In the notifd-configuration it is possible to match on particular event parameters to auto-acknowledge notices. With HZN-1147 the event parameters have moved to their own table and this breaks that functionality.

      2017-12-23 16:37:40,730 ERROR [Notifd:BroadcastEventProcessor-Thread] o.o.n.n.BroadcastEventProcessor: Failed to auto acknowledge notice.
      org.postgresql.util.PSQLException: ERROR: column e.eventparms does not exist
      Position: 115
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458) ~[postgresql-9.4.1211.jar:9.4.1211]
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158) ~[postgresql-9.4.1211.jar:9.4.1211]
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:291) ~[postgresql-9.4.1211.jar:9.4.1211]
      at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432) ~[postgresql-9.4.1211.jar:9.4.1211]
      at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358) ~[postgresql-9.4.1211.jar:9.4.1211]
      at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:171) ~[postgresql-9.4.1211.jar:9.4.1211]
      at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:119) ~[postgresql-9.4.1211.jar:9.4.1211]
      at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-2.5.1.jar:?]
      at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-2.5.1.jar:?]
      at org.opennms.netmgt.config.NotificationManager.acknowledgeNotice(NotificationManager.java:597) ~[opennms-config-21.0.2.jar:?]
      at org.opennms.netmgt.notifd.BroadcastEventProcessor.automaticAcknowledge(BroadcastEventProcessor.java:298) [opennms-services-21.0.2.jar:?]
      at org.opennms.netmgt.notifd.BroadcastEventProcessor.onEvent(BroadcastEventProcessor.java:212) [opennms-services-21.0.2.jar:?]
      at org.opennms.netmgt.eventd.EventIpcManagerDefaultImpl$EventListenerExecutor$2.run(EventIpcManagerDefaultImpl.java:183) [org.opennms.features.events.daemon-21.0.2.jar:?]
      at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626) [?:1.8.0_151]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
      at org.opennms.core.concurrent.LogPreservingThreadFactory$2.run(LogPreservingThreadFactory.java:106) [opennms-util-21.0.2.jar:?]
      at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]

      Attachments

        Issue Links

          Activity

            People

              j-white Jesse White
              tarus Tarus Balog
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: