elastic / elastic/integrations

[Stack 8.19.17-SNAPSHOT] [oracle] Failing test daily: system test: (elastic-agent logs - performance) in oracle.performance

Open
#19,776 0 comments 0 reactions 0 assignees View on GitHub
automation flaky-test Integration:oracle Team:Obs-InfraObs
Dominant language
Handlebars
Stars
333
Forks
647
Avg merge
3d 4h
Merged PRs (30d)
209

Description

- Stack version: 8.19.17-SNAPSHOT
- Package: oracle
- Failing test: system test: (elastic-agent logs - performance)
- DataStream: performance
- Owners:
- @elastic/obs-infraobs-integrations

Failure:
```
test case failed: one or more errors found while examining elastic-agent.logs282642031: [0] found error "Unit state changed sql/metrics-default-sql/metrics-oracle-52f3c868-3f86-4cd6-9bf3-ad1160dcb1a2 (HEALTHY->DEGRADED): Error fetching data for metricset sql.query: cannot open connection: testing connection: user=\"sys\" standalone params={authMode:2 connectionClass: connectionClassLength:0 purity:0 newPassword: newPasswordLength:0 appContext: numAppContext:0 externalAuth:0 externalHandle: pool: tag: tagLength:0 matchAnyTag:0 outTag: outTagLength:0 outTagFound:0 shardingKeyColumns: numShardingKeyColumns:0 superShardingKeyColumns: numSuperShardingKeyColumns:0 outNewSession:0}: ORA-12541: TNS:no listener"
```

First build failed: https://buildkite.com/elastic/integrations/builds/45081

Latest failed builds:
- https://buildkite.com/elastic/integrations/builds/45169

Contributor guide

Open the contributing guide

Research direction

Start with the oracle.performance system test and the elastic-agent logs/sql.query failure described in the issue. Compare the first and latest Buildkite runs to determine the scope of the ORA-12541 listener failure. Done means the performance test passes without the reported degraded metricset error.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.