Details

    • Type: Sub-task
    • Status: Resolved (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 26.1.3
    • Component/s: None
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None
    • Sprint:
      Horizon 2020 - May 27, Horizon 2020 - June 10, Horizon 2020 - June 24, Horizon 2020 - July 8

      Description

      When using the Time Series Storage (TSS) API, rendering the "choose resource" page from the OpenNMS Web UI for a particular node ends up calling getMetrics nearly 300 times.

      URL: /opennms/graph/chooseresource.jsp?node=1&reports=all
      API Method: https://github.com/OpenNMS/opennms-integration-api/blob/v0.4.1/api/src/main/java/org/opennms/integration/api/v1/timeseries/TimeSeriesStorage.java#L46

      Each call includes a query for a single tag - these look like:

      10:36:47.165 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx3=(snmp:fs:NODES:localhost,5)] (#1)                                            
      10:36:47.301 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx3=(snmp:fs:NODES:localhost,6)] (#2)                                          
      10:36:47.311 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx1=(response:192.168.238.128,3)] (#3)                                         
      10:36:47.320 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:sec4to20maIndex,7)] (#4)                      
      10:36:47.323 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:aixFilesystem,7)] (#5)                    
      10:36:47.327 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:aixPagingSpace,7)] (#6)                       
      10:36:47.365 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:aixPhysicalVolume,7)] (#7)                    
      10:36:47.367 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:aixPrintQueue,7)] (#8)                    
      10:36:47.369 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:aixVolumeGroup,7)] (#9)                     
      10:36:47.371 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:hhmsSensorArrayTemp,7)] (#10)               
      10:36:47.374 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:hhmsSensorArrayHumid,7)] (#11)
      10:36:47.382 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:rPDULoadStatusIndex,7)] (#12)  
      10:36:47.386 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:apH323SAStatIdx,7)] (#13)   
      10:36:47.392 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:apSipSAStatIdx,7)] (#14)     
      10:36:47.395 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:secAirflowIndex,7)] (#15)     
      10:36:47.398 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:pipePosition,7)] (#16)
      10:36:47.400 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:vcPipePosition,7)] (#17)
      10:36:47.402 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:astChanType,7)] (#18)
      10:36:47.405 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:bgpPeerEntry,7)] (#19)
      10:36:47.409 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:bmp,7)] (#20)
      10:36:47.413 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:dhcpSubnetIP,7)] (#21)
      10:36:47.415 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:swFCPortIndex,7)] (#22)
      10:36:47.417 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:xmpFilesys,7)] (#23)
      10:36:47.419 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:procStats,7)] (#24)
      10:36:47.421 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:cbgpPeerAddrFamilyPrefixEntry,7)] (#25)
      10:36:47.428 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:ciscoApCntIndex,7)] (#26)
      10:36:47.430 INFO [qtp1516060208-14671] Retrieving metrics for tags: [_idx4=(snmp:fs:NODES:localhost:ciscoMemoryPoolType,7)] (#27)
      

      We should improve the indexing/queries/caching in a way that reduce the number of calls to the API for these queries.

       

        Attachments

          Activity

            People

            Assignee:
            patrick.schweizer Patrick Schweizer
            Reporter:
            patrick.schweizer Patrick Schweizer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: