All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog and this project adheres to Semantic Versioning.
Unreleased section should follow Release Toolkit
- Upgrade go to 1.23.2
- Upgrade integrations SDK so the interval is variable and allows intervals up to 5 minutes
- Updated golang version to v1.23.1
- Updated golang version to v1.22.5
- A wrong custom query could cause a panic. Now the error is managed properly.
- Updated Golang version to address some vulnerabilities
- Updated Godror dependency
- Fixed two queries. Now the integration correctly collects
sga.logBufferRedoAllocationRetries,sga.logBufferRedoEntries,sorts.memoryInBytes,sorts.diskInBytes,sga.fixedSizeInBytes, andsga.redoBuffersInBytes
- Updated github.com/jmoiron/sqlx to v1.4.0 - Changelog 🔗
- Updated github.com/newrelic/infra-integrations-sdk to v3.8.2+incompatible
- Updated github.com/data-dog/go-sqlmock to v1.5.2 - Changelog 🔗
- Updated github.com/data-dog/go-sqlmock to v1.5.2 - Changelog 🔗
- Updated github.com/data-dog/go-sqlmock to v1.5.1 - Changelog 🔗
- publish as well for RHEL 15.5 and bookworm
- Restore golang docker image to buster
- Restore golang version to 1.19 to ensure compatibility
- bumped golang version pinning 1.20.6
- Add support for PDB Sys metrics by setting up the new config field
SYS_METRICS_SOURCE. - Include additional extended metrics in Sys metrics group.
- Bump dependencies.
- Removed 200 tablespace limitation. Use
TABLESPACEconfig parameter to limit the number of tablespaces monitored. - Bumped dependencies
- Add
SKIP_METRICS_GROUPSconfig: Metrics collected are group together depending on the query used to obtain the data. These metric groups are here and can be skipped from collection by adding the name of the group to SKIP_METRICS_GROUPS in Json array format. By default no group is skipped so no breaking changes are added.
- Bumped dependencies
- Change pipeline to use Go 1.18
- Metrics
tablespace.spaceConsumedInBytesandtablespace.spaceReservedInBytespreviously reported in block sizes are now reported in Bytes (#94)
- Added warning log when a query returns no results (#87)
- Fix missing event type on custom metric config (#86)
- Strip spaces from logged result query (#88)
- Moved default config.sample to V4, added a dependency for infra-agent version 1.20.0
Please notice that old V3 configuration format is deprecated, but still supported.
- Integration SDK has been upgrade to 3.6.7, which fixes a bug that caused scrambled metrics when integration autodiscovery was used (#67)
- Additionally, this PR also switches to go modules, go 1.16, and upgrades the driver used to connect to the database to its latest version
Since these changes involve a change of the oracle database driver, a major version bump has been issued. While we have not detected any breakage during our tests, we encourage users to monitor the solution to ensure their use case has not been impacted.
- Added configuration option to enable disabling the connection pool. There are cases where the connection pool does not properly re-use cnnections and leads to errors getting new connections thus failing some queries. Disabling the connection pool can lead to lower performance, but removes the issue of not being able to execute some queries.
- Fixed case where sample name for custom metrics was not being set properly
- Custom query YAML configuration
- Panic on empty custom query result
- Custom metrics query now does not require special column names, and returns each row as a separate sample with the column names as the metric names. This fixes issues with overwriting metric names as well as increases flexibility of collection so that the queries are less awkward to write. This is a breaking change since metric types are no longer defineable, (numerics are assumed to be gauges) and metric names are defined by the column name.
- Tablespace usage percent calculation
- Connections not being closed cleanly
custom_metrics_queryto capture metrics that the integration does not query for by default
- CDB and PDB metrics now respect tablespace whitelist
- Renamed the integration executable from nr-oracledb to nri-oracledb in order to be consistent with the package naming. Important Note: if you have any security module rules (eg. SELinux), alerts or automation that depends on the name of this binary, these will have to be updated.
- Windows MSI resources
- Run all DB queries concurrently to avoid deadlock
- Avoid panicking or blocking when inventory connection fails.
- Close rows objects when finished to allow recycling of connections
- A number of requested metrics, including RAC
- Add
connection_stringargument to enable more custom / manual configuration
- Expose pool connection params as arguments
- Updated goracle dependency
- Default max datafile size to 2G
- lockedAccounts metric
- tablespace.offlinePDBDatafiles metric
- tablespace.offlineCDBDatafiles metric
- tablespace.pdbDatafilesNonWrite metric
- Updated SDK
- Made entity keys more unique
- Prefixed namespaces
- Timing out when waiting for a connection
- Don't force exit if ORACLE_HOME is unset
- Log error message if ORACLE_HOME is unset
- Use correct protocol version
- Divide by zero error in query
- Properly specified inventory prefix
- DBID and Global Name to all entities
- Updated to version 1.0.0
- Configuration prefix for consistency
- Changed operating command from
inventoryormetricstoall_data
- Removed a leftover misleading comment in the definition file
- Instances using IDs rather than names
- Tablespace whitelist configuration parameter
- Hard coded limit for the number of tablespaces that can be collected
- Renamed nr-oracledb-config.yml.template to oracledb-config.yml.sample
- Renamed nr-oracledb-definition.yml to oracledb-definition.yml
- Initial version: Includes Metrics and Inventory data