sql_exporter

SQL Exporter v0.15.0

What's Changed

• feat: drop scrape_errors_total metric with a configurable interval by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/551
• refactor: reload targets and collectors, support SIGHUP by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/548
• refactor: add --log.format param, deprecate --log.json flag by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/561
• docs: revisit README.md by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/545

Precompiled binaries are built with Go v1.21.11

Updated dependencies

Database drivers

• Clickhouse 2.26.0
• PostgreSQL(pgx) 5.6.0

Others

• prometheus/common 0.55.0
• aws/aws-sdk-go-v2/config 1.27.23
• aws/aws-sdk-go-v2 1.30.1
• aws/aws-sdk-go-v2/secretsmanager 1.32.1
• azure/azure-sdk-for-go/azidentity 1.6.0 (CVE-2024-35255)

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.4...0.15.0

SQL Exporter v0.14.4

What's Changed

• fix: use the passed jf jobFilters parameter by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/521
• chore: update promu to v0.17 by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/534
• build: disable symbol table, DWARF generation for builds by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/535

Precompiled binaries are built with Go v1.21.11

Updated dependencies

Database drivers

• MSSQL 1.7.2
• Snowflake 1.10.1
• Clickhouse 2.25.0

Others

• sethvargo/go-envconfig 1.0.3
• google.golang.org/protobuf 1.34.1
• prometheus/client_golang 1.19.1
• dburl 0.23.1
• aws/aws-sdk-go-v2/config 1.27.16
• aws/aws-sdk-go-v2/secretsmanager 1.29.1

New Contributors

• @Neaj-Morshad-101 made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/522

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.3...0.14.4

SQL Exporter v0.14.3

What's Changed

• fix(build): update gomod version to fix codeql warnings by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/491
• fix(build): sync go versions between promu crossbuild and docker images by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/494
• fix(build): wrong go version reference [skip ci] by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/511

Precompiled binaries are built with Go v1.21.9

Updated dependencies

Database drivers

• MSSQL 1.7.1
• Clickhouse 2.23.2

Others

• golang.org/x/net 0.23.0
• google.golang.org/protobuf 1.34.0
• prometheus/common 0.53.0
• prometheus/client_model 0.6.1
• dburl 0.23.0
• aws/aws-sdk-go-v2/config 1.27.11

New Contributors

• @Fapiko made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/496
• @jluckett-panw made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/509

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.2...0.14.3

SQL Exporter v0.14.2

What's Changed

• PostgreSQL (pgx) driver upgrade v4 (4.18.2) > v5 (5.5.5).

Precompiled binaries are built with Go v1.21.9

Updated dependencies

Database drivers

• PostgreSQL(pgx) 5.5.5
• Snowflake 1.9.0
• MySQL 1.8.1
• Clickhouse 2.23.0

Others

• google.golang.org/protobuf 1.33.0 (CVE-2024-24786)
• prometheus/common 0.51.1
• dburl 0.22.0
• aws/aws-sdk-go-v2 1.26.1
• aws/aws-sdk-go-v2/config 1.27.10
• aws/aws-sdk-go-v2/service/secretsmanager 1.28.6

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.1...0.14.2

SQL Exporter v0.14.1

What's Changed

• Security fix for PostgreSQL(pgx) driver (CVE-2024-27289);
• Clickhouse driver upgrade v1 > v2 (v1 driver is deprecated).

Precompiled binaries are built with Go v1.21.8

Updated dependencies

Database drivers

• PostgreSQL(pgx) 4.18.2
• Clickhouse 2.21.1

Others

• prometheus/client_golang 1.19.0
• prometheus/client_model 0.6.0
• prometheus/common 0.49.0

New Contributors

• @ferrous26 made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/457
• @qfritz made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/462
• @puneetloya made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/463

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.0...0.14.1

SQL Exporter v0.14.0

What's Changed

• feat: return metric with an explicit timestamp from the configured column by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/429
• feat: provide configuration subset via env variables by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/430
• feat: scrape selected jobs via query params by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/433
• fix: nil dereference on wrong log level values, cleanup by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/421
• fix: add flag to ignore results with missing values by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/422
• fix: expand env vars while parsing DB URL by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/428
• fix: if timestamp_value is empty, no need to reserve a column by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/431
• refactor: split config.go, break down long functions by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/423
• docs: fix PostgreSQL DSN example by @rc5hack in https://github.com/burningalchemist/sql_exporter/pull/436

Precompiled binaries are built with Go v1.21.7

Updated dependencies

Database drivers

• Snowflake 1.8.0
• MSSQL 1.7.0

Others

• google.golang.org/protobuf 1.32.0
• klog-gokit v3.4.0
• prometheus/client_golang 1.18.0
• prometheus/client_model 0.6.0
• prometheus/common 0.48.0
• xo/dburl 0.21.1
• aws-sdk-go-v2 1.25.2
• aws-sdk-go-v2/service/secretmanager 1.28.1
• aws-sdk-go-v2/config 1.27.4

New Contributors

• @rc5hack made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/436

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.13.1...0.14.0

SQL Exporter v0.13.1 - Christmas edition 🎄

What's Changed

• fix: support NULL metrics, don't collect them by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/408
• security fix: golang.org/x/crypto - CVE-2023-48795
• security fix: dvsekhvalnov/jose2go - GHSA-mhpq-9638-x6pw

Precompiled binaries are built with Go v1.21.5

Updated dependencies

Database drivers

• Snowflake 1.7.1

Others

• xo/dburl 0.20.0
• golang.org/x/crypto to 0.17.0
• prometheus/exporter-toolkit 0.11.0
• dvsekhvalnov/jose2go 1.6.0
• aws-sdk-go-v2 1.24.0
• aws-sdk-go-v2/service/secretmanager 1.25.6
• aws-sdk-go-v2/config 1.26.2

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.13.0...0.13.1

SQL Exporter v0.13.0

What's Changed

⚠️ Breaking change: 'instance' label is changed to 'target' by default. It can be overridden with --config.target-label parameter.

• feat: 'scrape_errors_total' metric by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/339
• feat: set 'static_value' per metric config by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/335
• feat: add a helm chart with the releaser action by @allanger in https://github.com/burningalchemist/sql_exporter/pull/349
• refactor!: 'instance' label is configurable, 'target' by default by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/333
• refactor: configure ping for a target or per job by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/323
• fix: enable-ping flag nil dereference by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/340
• fix: revisit errors package, match the error by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/350
• fix: error type conversion by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/353
• fix: don't cache invalid metrics by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/355
• build: update Go to 1.21 as the main version by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/341

Precompiled binaries are built with Go v1.21.3

Updated dependencies

Database drivers

• Snowflake 1.6.25

Others

• golang.org/x/net from 0.17.0
• prometheus/client_golang 1.17.0
• prometheus/common 0.45.0
• prometheus/client_model 0.5.0
• aws-sdk-go-v2 1.21.6
• aws-sdk-go-v2/service/secretmanager 1.23.0
• aws-sdk-go-v2/config 1.22.1

New Contributors

• @allanger made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/349
• @eugenekainara made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/373

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.12.3...0.13.0

SQL Exporter v0.12.3

What's Changed

• docs: example - avoid duplicate metrics with same name and labels by @corporate-gadfly in https://github.com/burningalchemist/sql_exporter/pull/320
• fix: log message for collector files by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/322
• fix: support NULL values for key labels by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/321
• fix: regression, don't overwrite constLabels by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/330
• fix: return partial results for multiple targets by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/331

Precompiled binaries are built with Go v1.20.8.

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.12.2...0.12.3

SQL Exporter v0.12.2

What's Changed

• fix: wrap remaining errors in klog.Errorf() by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/304
• fix: revisit reloadCollectors function, support jobs reloading by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/298
• fix: return better error msg on context deadline exceeded by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/314
• fix: enable up and duration for target if named by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/315

Precompiled binaries are built with Go v1.21.1.

Updated dependencies

Database drivers

• MSSQL 1.6.0
• Snowflake 1.6.24

Others

• aws-sdk-go-v2 1.21.0
• aws-sdk-go-v2/service/secretmanager 1.21.3
• aws-sdk-go-v2/config 1.18.39

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.12.1...0.12.2

SQL Exporter v0.12.1

What's Changed

• fix: adopt driver-picking logic from dburl 0.16 by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/291
• docs: add multiple connections section, formatting by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/290

Precompiled binaries are built with Go v1.20.7.

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.12.0...0.12.1

SQL Exporter v0.12.0

What's Changed

• feat: add AWS Secret Manager feature to store DSN by @elturkym in https://github.com/burningalchemist/sql_exporter/pull/273
• docs: Include scrape_timeout in the example sql_exporter.yml by @mafrosis in https://github.com/burningalchemist/sql_exporter/pull/258
• docs: update Windows service snippet by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/260

Precompiled binaries are built with Go v1.20.7.

Updated dependencies

Database drivers

• MSSQL 1.5.0
• Vertica 1.3.3
• Snowflake 1.6.23

Others

• prometheus/client_golang 1.16.0
• protobuf 1.31.0
• dburl 0.16.0

New Contributors

• @mafrosis made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/258
• @elturkym made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/273

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.11.1...0.12.0

SQL Exporter v0.11.1 - Security release

Several vulnerabilities have been reported for the underlying dependencies of https://github.com/microsoft/go-mssqldb v1.0.0 (MSSQL driver):

CVE-2020-14040
CVE-2021-38561
CVE-2022-32149

The release contains the updated MSSQL driver, addressing mentioned security issues.

Precompiled binaries are built with Go v1.20.4.

Updated dependencies

Database drivers

• MSSQL 1.1.0

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.11.0...0.11.1

SQL Exporter v0.11.0

• feat: add ability to not prepare statements by @fffinkel in https://github.com/burningalchemist/sql_exporter/pull/217
• fix: set clampLevel to 3 for debug logs by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/233
• fix: type constants by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/234
• fix: create /etc/sql_exporter in postinstall by @dupondje in https://github.com/burningalchemist/sql_exporter/pull/236
• fix: typo and wrong file reference for rpm by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/243
• docs: Update README.md on the special characters by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/244
• chore: update Go to 1.20 as the main version by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/249

Precompiled binaries are built with Go v1.20.4.

Updated dependencies

Database drivers

• MySQL 1.7.1
• pq(PostgreSQL) 1.10.9

Others

• prometheus/common 0.44.0
• prometheus/exporter-toolkit 0.10.0

New Contributors

• @fffinkel made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/217
• @dupondje made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/236

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.10.1...0.11.0

SQL Exporter v0.10.1

🎉 Container image for linux/arm64 is now available on Dockerhub.

• fix: don't fail immediately in resolveCollectorRefs nested loop by @unix-way in https://github.com/burningalchemist/sql_exporter/pull/208
• docs: add examples and grafana dashboard for Azure SQL MI by @corporate-gadfly in https://github.com/burningalchemist/sql_exporter/pull/209
• build: build arm64 container images by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/219
• fix: add unit tests and minor fixes for resolveCollectorRefs() by @hhromic in https://github.com/burningalchemist/sql_exporter/pull/220
• fix: handling is fixed in the upstream dburl by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/226
• build: containers via multi-platform Dockerfile by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/229

Precompiled binaries are built with Go v1.19.8.

Updated dependencies

Database drivers

• MSSQL 0.21.0
• Vertica 1.3.2
• pq(PostgreSQL) 1.10.8

Others

• prometheus/client_golang 1.15.0
• prometheus/common 0.42.0
• prometheus/exporter-toolkit 0.9.1
• google.golang.org/protobuf 1.30.0
• xo/dburl 0.14.2
• promu 0.14.0
• golang.org/x/crypto v0.8.0
• golang.org/x/exp v0.0.0-20230321023759-10a507213a29
• golang.org/x/mod v0.10.0
• golang.org/x/net v0.9.0
• golang.org/x/oauth2 v0.7.0
• golang.org/x/sys v0.7.0
• golang.org/x/term v0.7.0
• golang.org/x/text v0.9.0
• golang.org/x/tools v0.8.0

New Contributors

• @unix-way made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/208
• @corporate-gadfly made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/209

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.10.0...0.10.1

SQL Exporter v0.10.0

• feat: add globbing support to collector refs in config by @hhromic in https://github.com/burningalchemist/sql_exporter/pull/194

Precompiled binaries are built with Go v1.19.6.

Updated dependencies

Database drivers

• pgx(PostgreSQL) 4.18.1
• Snowflake 1.6.18

Others

• golang.org/x/net 0.7.0 (CVE-2022-41723)
• prometheus/common 0.40.0

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.9.3...0.10.0

SQL Exporter v0.9.3

• fix: exporter panics on config corner cases by @hhromic in https://github.com/burningalchemist/sql_exporter/pull/185
• fix: detect fedauth for AzureSQL and assign a correct driver name by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/187
• build: Update actions/setup-go and actions/checkout to v3 by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/177
• build: github actions - add docker build by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/191
• build: adjust docker tag inference by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/193

Precompiled binaries are built with Go v1.19.5.

Updated dependencies

Database drivers

• MSSQL 0.20.0
• Vertica 1.3.1
• Snowflake 1.6.17

New Contributors

• @hhromic made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/185

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.9.2...0.9.3

SQL Exporter v0.9.2 🎄 Christmas edition

• fix: address CVE-2022-46146 by @alex1989hu in https://github.com/burningalchemist/sql_exporter/pull/167
• fix: address CVE-2022-32149 by @alex1989hu in https://github.com/burningalchemist/sql_exporter/pull/168
• chore: add darwin/arm64 arch to promu in https://github.com/burningalchemist/sql_exporter/pull/176

Precompiled binaries are built with Go v1.19.4.

Updated dependencies

Database drivers

• MSSQL 0.19.0
• MySQL 1.7.0
• Vertica 1.3.0
• Snowflake 1.6.16

Others

• kardianos/minwinsvc 1.0.2
• prometheus/client_golang 1.14.0
• prometheus/common 0.39.0
• prometheus/client_model 0.3.0
• xo/dburl 0.13.0

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.9.1...0.9.2

SQL Exporter v0.9.1

• fix: address CVE-2022-27664
• fix: don't close SQL statements

Precompiled binaries are built with Go v1.19.1.

SQL Exporter v0.9.0

• feat: add TLS/BasicAuth via exporter-toolkit/web - #124
• feat: add flags to write json logs, to set log level - #125
• feat: import azuread (also imports regular driver) - #148
• fix: mssql - switch to microsoft go-mssqldb - #123
• fix: set default loglevel to info, update level for init msgs - #134
• build: add nfpm, prepare deb/rpm packages - #126
• build: update Dockerfile - #132
• chore: remove deprecated io/ioutil package usage - #130
• chore: fix formatting since 1.19 - #131
• refactor: adopt xo/dburl to parse connection strings consistently - #129

Precompiled binaries are built with Go v1.19.1.

Updated dependencies

Database drivers

• pgx(PostgreSQL) 4.17.2
• pq(PostgreSQL) 1.10.7
• MSSQL 0.17.0
• Snowflake 1.6.13

Others

• klog 2.70.1
• prometheus/client_golang 1.12.2
• prometheus/common 0.37.0