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

promoteQueueData should not be stored on the events table.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.11.3, 1.10.8
    • 1.10.9, 1.11.90
    • Database
    • Security Level: Default (Default Security Scheme)
    • None

    Description

      On a customer site, I saw that this event became the most popular one on the event table, taking the first position of the event histogram.

      This event has more than the 50% of the events stored on the DB, where the event table has more than 4 millions of events.

      This can make the DB actually slow, because the auto_vacuum feature doesn't work well with a storm of write operations, and this event can cause an event storm if the user is trying to generate lots of graphs, which BTW is the case.

      The solution is to change the logMessage's destination from logonly to donotpersist.

      Attachments

        Activity

          People

            agalue Alejandro Galue
            agalue Alejandro Galue
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: