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

promoteQueueData should not be stored on the events table.

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.11.3, 1.10.8
    • Fix Version/s: 1.10.9, 1.11.90
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: