Wrong data in metrics

[ChernykhAN]

Hello,

The sap connection has been run throw load balance server.

I using exporter with config metrics:

[[TableMetrics]]
  Name = "sap_users"
  Help = "sm04 help"
  MetricType = "counter"
  TagFilter = ["users"]
  FunctionModule = "TH_USER_LIST"
  AllServers = true
  Table = "USRLIST"
  [TableMetrics.Params]
  [TableMetrics.RowCount]
  mandt = ["000","900"]
  [TableMetrics.RowFilter]

 [[FieldMetrics]]
  Name = "sap_ma_errors"
  Help = "SAP CRM Loy MA Errors"
  MetricType = "gauge"
  TagFilter = []
  AllServers = true
  FunctionModule = "ZLOY_MON_MA_GET"
  FieldLabels = ["EV_COUNT_MA"]
  [FieldMetrics.Params]
   IV_ESTAT = "E0005"

My listing at *9663/metrics contains a lots of data, for example:

# HELP go_gc_duration_seconds A summary of the pause duration of garbage collection cycles.
# TYPE go_gc_duration_seconds summary
go_gc_duration_seconds{quantile="0"} 1.9562e-05
go_gc_duration_seconds{quantile="0.25"} 4.8896e-05
go_gc_duration_seconds{quantile="0.5"} 5.8457e-05
go_gc_duration_seconds{quantile="0.75"} 7.3996e-05
go_gc_duration_seconds{quantile="1"} 0.000145196
go_gc_duration_seconds_sum 0.001742321
go_gc_duration_seconds_count 27
# HELP go_goroutines Number of goroutines that currently exist.
# TYPE go_goroutines gauge
go_goroutines 13
# HELP go_info Information about the Go environment.
# TYPE go_info gauge
go_info{version="go1.15.3"} 1
# HELP go_memstats_alloc_bytes Number of bytes allocated and still in use.
# TYPE go_memstats_alloc_bytes gauge
go_memstats_alloc_bytes 2.995584e+06
# HELP go_memstats_alloc_bytes_total Total number of bytes allocated, even if freed.
# TYPE go_memstats_alloc_bytes_total counter
go_memstats_alloc_bytes_total 7.4896712e+07
# HELP go_memstats_buck_hash_sys_bytes Number of bytes used by the profiling bucket hash table.
# TYPE go_memstats_buck_hash_sys_bytes gauge
go_memstats_buck_hash_sys_bytes 1.451492e+06
# HELP go_memstats_frees_total Total number of frees.
# TYPE go_memstats_frees_total counter
go_memstats_frees_total 273941
# HELP go_memstats_gc_cpu_fraction The fraction of this program's available CPU time used by the GC since the program started.
# TYPE go_memstats_gc_cpu_fraction gauge
go_memstats_gc_cpu_fraction 7.84741736744209e-05
# HELP go_memstats_gc_sys_bytes Number of bytes used for garbage collection system metadata.
# TYPE go_memstats_gc_sys_bytes gauge
go_memstats_gc_sys_bytes 4.644088e+06
# HELP go_memstats_heap_alloc_bytes Number of heap bytes allocated and still in use.
# TYPE go_memstats_heap_alloc_bytes gauge
go_memstats_heap_alloc_bytes 2.995584e+06
# HELP go_memstats_heap_idle_bytes Number of heap bytes waiting to be used.
# TYPE go_memstats_heap_idle_bytes gauge
go_memstats_heap_idle_bytes 6.2447616e+07
# HELP go_memstats_heap_inuse_bytes Number of heap bytes that are in use.
# TYPE go_memstats_heap_inuse_bytes gauge
go_memstats_heap_inuse_bytes 4.071424e+06
# HELP go_memstats_heap_objects Number of allocated objects.
# TYPE go_memstats_heap_objects gauge
go_memstats_heap_objects 7412
# HELP go_memstats_heap_released_bytes Number of heap bytes released to OS.
# TYPE go_memstats_heap_released_bytes gauge
go_memstats_heap_released_bytes 6.2070784e+07
# HELP go_memstats_heap_sys_bytes Number of heap bytes obtained from system.
# TYPE go_memstats_heap_sys_bytes gauge
go_memstats_heap_sys_bytes 6.651904e+07
# HELP go_memstats_last_gc_time_seconds Number of seconds since 1970 of last garbage collection.
# TYPE go_memstats_last_gc_time_seconds gauge
go_memstats_last_gc_time_seconds 1.6043270470749338e+09
# HELP go_memstats_lookups_total Total number of pointer lookups.
# TYPE go_memstats_lookups_total counter
go_memstats_lookups_total 0
# HELP go_memstats_mallocs_total Total number of mallocs.
# TYPE go_memstats_mallocs_total counter
go_memstats_mallocs_total 281353
# HELP go_memstats_mcache_inuse_bytes Number of bytes in use by mcache structures.
# TYPE go_memstats_mcache_inuse_bytes gauge
go_memstats_mcache_inuse_bytes 6944
# HELP go_memstats_mcache_sys_bytes Number of bytes used for mcache structures obtained from system.
# TYPE go_memstats_mcache_sys_bytes gauge
go_memstats_mcache_sys_bytes 16384
# HELP go_memstats_mspan_inuse_bytes Number of bytes in use by mspan structures.
# TYPE go_memstats_mspan_inuse_bytes gauge
go_memstats_mspan_inuse_bytes 67456
# HELP go_memstats_mspan_sys_bytes Number of bytes used for mspan structures obtained from system.
# TYPE go_memstats_mspan_sys_bytes gauge
go_memstats_mspan_sys_bytes 98304
# HELP go_memstats_next_gc_bytes Number of heap bytes when next garbage collection will take place.
# TYPE go_memstats_next_gc_bytes gauge
go_memstats_next_gc_bytes 4.194304e+06
# HELP go_memstats_other_sys_bytes Number of bytes used for other system allocations.
# TYPE go_memstats_other_sys_bytes gauge
go_memstats_other_sys_bytes 950564
# HELP go_memstats_stack_inuse_bytes Number of bytes in use by the stack allocator.
# TYPE go_memstats_stack_inuse_bytes gauge
go_memstats_stack_inuse_bytes 589824
# HELP go_memstats_stack_sys_bytes Number of bytes obtained from system for stack allocator.
# TYPE go_memstats_stack_sys_bytes gauge
go_memstats_stack_sys_bytes 589824
# HELP go_memstats_sys_bytes Number of bytes obtained from system.
# TYPE go_memstats_sys_bytes gauge
go_memstats_sys_bytes 7.4269696e+07
# HELP go_threads Number of OS threads created.
# TYPE go_threads gauge
go_threads 10
# HELP process_cpu_seconds_total Total user and system CPU time spent in seconds.
# TYPE process_cpu_seconds_total counter
process_cpu_seconds_total 0.84
# HELP process_max_fds Maximum number of open file descriptors.
# TYPE process_max_fds gauge
process_max_fds 1024
# HELP process_open_fds Number of open file descriptors.
# TYPE process_open_fds gauge
process_open_fds 12
# HELP process_resident_memory_bytes Resident memory size in bytes.
# TYPE process_resident_memory_bytes gauge
process_resident_memory_bytes 3.227648e+07
# HELP process_start_time_seconds Start time of the process since unix epoch in seconds.
# TYPE process_start_time_seconds gauge
process_start_time_seconds 1.60432697996e+09
# HELP process_virtual_memory_bytes Virtual memory size in bytes.
# TYPE process_virtual_memory_bytes gauge
process_virtual_memory_bytes 1.389203456e+09
# HELP process_virtual_memory_max_bytes Maximum amount of virtual memory available in bytes.
# TYPE process_virtual_memory_max_bytes gauge
process_virtual_memory_max_bytes -1
# HELP promhttp_metric_handler_requests_in_flight Current number of scrapes being served.
# TYPE promhttp_metric_handler_requests_in_flight gauge
promhttp_metric_handler_requests_in_flight 1
# HELP promhttp_metric_handler_requests_total Total number of scrapes by HTTP status code.
# TYPE promhttp_metric_handler_requests_total counter
promhttp_metric_handler_requests_total{code="200"} 20
promhttp_metric_handler_requests_total{code="500"} 0
promhttp_metric_handler_requests_total{code="503"} 0
# HELP sap_ma_errors SAP CRM Loy MA Errors
# TYPE sap_ma_errors gauge
sap_ma_errors{EV_COUNT_MA="13 a",server="chq",system="chq",usage="test"} 1
# HELP sap_users sm04 help
# TYPE sap_users counter
sap_users{count="mandt_000",server="chq",system="chq",usage="test"} 1
sap_users{count="mandt_900",server="chq",system="chq",usage="test"} 0

Q1:How could I disable exporting unnecessary info?

Q2: The sap_users counter contains wrong values in the most responses. Only 10-20 % of responses contains correct data.

promhttp_metric_handler_requests_total{code="200"} 37
promhttp_metric_handler_requests_total{code="500"} 0
promhttp_metric_handler_requests_total{code="503"} 0
# HELP sap_ma_errors SAP CRM Loy MA Errors
# TYPE sap_ma_errors gauge
sap_ma_errors{EV_COUNT_MA="15 a",server="chq",system="chq",usage="test"} 1
# HELP sap_users sm04 help
# TYPE sap_users counter
sap_users{count="mandt_000",server="chq",system="chq",usage="test"} 1
sap_users{count="mandt_900",server="chq",system="chq",usage="test"} 1
incorrect!!!

promhttp_metric_handler_requests_total{code="200"} 38
promhttp_metric_handler_requests_total{code="500"} 0
promhttp_metric_handler_requests_total{code="503"} 0
# HELP sap_ma_errors SAP CRM Loy MA Errors
# TYPE sap_ma_errors gauge
sap_ma_errors{EV_COUNT_MA="15 a",server="chq",system="chq",usage="test"} 1
# HELP sap_users sm04 help
# TYPE sap_users counter
sap_users{count="mandt_000",server="chq",system="chq",usage="test"} 2
sap_users{count="mandt_900",server="chq",system="chq",usage="test"} 22
correct!!!

promhttp_metric_handler_requests_total{code="200"} 39
promhttp_metric_handler_requests_total{code="500"} 0
promhttp_metric_handler_requests_total{code="503"} 0
# HELP sap_ma_errors SAP CRM Loy MA Errors
# TYPE sap_ma_errors gauge
sap_ma_errors{EV_COUNT_MA="14 a",server="chq",system="chq",usage="test"} 1
# HELP sap_users sm04 help
# TYPE sap_users counter
sap_users{count="mandt_000",server="chq",system="chq",usage="test"} 1
sap_users{count="mandt_900",server="chq",system="chq",usage="test"} 0
incorrect!!!

Q3: The field EV_COUNT_MA contains wrong value also. That field type CHAR 10, should contains number of error without any chars. And it's vallue changing randomly in any next responses.

Please help to resolve issues.

[ulranh]

Q1: The other metrics are from the prometheus client. If you don't need them just ignore these metrics. Q2: I just compared the sap_users metric for some of our test systems with the result of the function module TH_USER_LIST and got the same values. In larger system it's difficult to compare exactly because the values can change immediately.

The MetricType must be "gauge" in this case. I used the following metric:

[[TableMetrics]]                                                                                                                                                                                                
   Name = "sap_users"                                                                                                                                                                                            
  Help = "sm04 help"                                                                                                                                                                                            
  MetricType = "gauge"                                                                                                                                                                                          
  TagFilter = []                                                                                                                                                                                                
  AllServers = true                                                                                                                                                                                             
  FunctionModule = "TH_USER_LIST"                                                                                                                                                                               
  Table = "USRLIST"                                                                                                                                                                                             
  [TableMetrics.Params]                                                                                                                                                                                         
  [TableMetrics.RowCount]                                                                                                                                                                                       
    MANDT = ["000", "010", "100"]

Q3: I can't say anything regarding Q3, because ZLOY_MON_MA_GET is a custom function module.