sql_exporter

Helm chart release.

Helm chart release.

Helm chart release.

Helm chart release.

Helm chart release.

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

Helm chart release.

Helm chart release.

Helm chart release.

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.