prometheus-community / prometheus-community/stackdriver_exporter

logging.googleapis.com/log_entry_count yields out-of-order timestamps

Open
#134 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
295
Forks
117
Avg merge
9d 14h
Merged PRs (30d)
7

Description

When scraping metrics for this prefix we're seeing timestamps that are reported out-of-order

the timestamp first appears normally, but then seems to start repeating the same period of 1 min over and over until it stops being reported again; (have focused on one series here, but this happens for multiple series under this prefix)

Fri 12 Nov 2021 15:45:04 UTC - [not present]
Fri 12 Nov 2021 15:45:14 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731854869
Fri 12 Nov 2021 15:45:25 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731865720
Fri 12 Nov 2021 15:45:37 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 1 1636731877555
Fri 12 Nov 2021 15:45:48 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 1 1636731888213
Fri 12 Nov 2021 15:45:58 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 1 1636731898808
Fri 12 Nov 2021 15:46:09 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 1 1636731909404
Fri 12 Nov 2021 15:46:19 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 1 1636731920053
Fri 12 Nov 2021 15:46:30 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731930897
Fri 12 Nov 2021 15:46:41 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731941582
Fri 12 Nov 2021 15:46:51 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731952158
Fri 12 Nov 2021 15:47:02 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731962754
Fri 12 Nov 2021 15:47:13 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731973352
Fri 12 Nov 2021 15:47:23 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731983953
Fri 12 Nov 2021 15:47:34 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731994541
Fri 12 Nov 2021 15:47:44 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732005151
Fri 12 Nov 2021 15:47:55 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732015816
Fri 12 Nov 2021 15:48:06 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731966456
Fri 12 Nov 2021 15:48:16 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731977097
Fri 12 Nov 2021 15:48:27 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731987756
Fri 12 Nov 2021 15:48:38 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731998349
Fri 12 Nov 2021 15:48:48 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732008940
Fri 12 Nov 2021 15:48:59 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732019521
Fri 12 Nov 2021 15:49:09 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731970144
Fri 12 Nov 2021 15:49:20 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731980742
Fri 12 Nov 2021 15:49:31 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731991344
Fri 12 Nov 2021 15:49:41 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732002005
Fri 12 Nov 2021 15:49:52 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732013088
Fri 12 Nov 2021 15:50:03 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731963677
Fri 12 Nov 2021 15:50:14 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731974304
Fri 12 Nov 2021 15:50:25 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731985262
Fri 12 Nov 2021 15:50:35 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731996007
Fri 12 Nov 2021 15:50:46 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732006768
Fri 12 Nov 2021 15:50:57 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732017408
Fri 12 Nov 2021 15:51:07 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731968078
Fri 12 Nov 2021 15:51:18 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731978712
Fri 12 Nov 2021 15:51:29 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731989356
Fri 12 Nov 2021 15:51:39 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731999962
Fri 12 Nov 2021 15:51:50 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732010603
Fri 12 Nov 2021 15:52:01 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731961217
Fri 12 Nov 2021 15:52:11 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731971879
Fri 12 Nov 2021 15:52:22 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731982514
Fri 12 Nov 2021 15:52:33 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731993254
Fri 12 Nov 2021 15:52:43 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732003911
Fri 12 Nov 2021 15:52:54 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732014548
Fri 12 Nov 2021 15:53:04 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731965157
Fri 12 Nov 2021 15:53:15 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731975831
Fri 12 Nov 2021 15:53:26 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731986469
Fri 12 Nov 2021 15:53:37 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731997860
Fri 12 Nov 2021 15:53:48 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732008760
Fri 12 Nov 2021 15:53:59 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732019456
Fri 12 Nov 2021 15:54:01 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731961719
Fri 12 Nov 2021 15:54:12 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731972309
Fri 12 Nov 2021 15:54:22 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731982983
Fri 12 Nov 2021 15:54:33 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636731993651
Fri 12 Nov 2021 15:54:44 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732004268
Fri 12 Nov 2021 15:54:54 UTC - stackdriver_cloudsql_database_logging_googleapis_com_log_entry_count{log="cloudsql.googleapis.com/mysql.err",severity="WARNING",unit="1"} 0 1636732015059
Fri 12 Nov 2021 15:55:05 UTC - [not present]
Fri 12 Nov 2021 15:55:16 UTC - [not present]
Fri 12 Nov 2021 15:55:26 UTC - [not present]
Fri 12 Nov 2021 15:55:38 UTC - [not present]

stackdriver_exporter version: 0.11.0

Args:

--monitoring.metrics-offset=60s
--monitoring.metrics-interval=8m
--monitoring.metrics-type-prefixes "logging.googleapis.com/log_entry_count"

Guessing this might be an interaction between the 8m interval and this metric only having a single event in the window above?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by tracing the exporter path exercised by --monitoring.metrics-type-prefixes, --monitoring.metrics-offset, and --monitoring.metrics-interval for logging.googleapis.com/log_entry_count. Reproduce the repeated timestamps using the supplied configuration and determine how the metric window is handled; done means the exported series no longer reports out-of-order timestamps for this case.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, google-cloud
Domain
observability-sre
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.