[Flaky Test] x-pack/metricbeat/module/sql/query TestOracle/fetch

[AndersonQ]

Flaky Test

• Test Name: x-pack/metricbeat/module/sql/query TestOracle/fetch
• Link:

  beats/x-pack/metricbeat/module/sql/query/query_integration_test.go

  Line 252 in c6714c5

  require.Empty(t, errs)

• Branch: 8.19, updatecli_8.19_bump-elastic-stack-snapshot-8.19
• Artifact Link:
  • updatecli_8.19_bump-elastic-stack-snapshot-8.19:
    • https://buildkite.com/elastic/beats-xpack-metricbeat/builds/19261/steps/canvas?jid=019813e2-8e0a-4470-b47f-e0dd6b25aa0f
  • 8.19:
    • https://buildkite.com/elastic/beats-xpack-metricbeat/builds/19006/steps/canvas?sid=0197f994-a501-4fd9-b641-7b2bb70193f7
    • https://buildkite.com/elastic/beats-xpack-metricbeat/builds/18969/steps/canvas?sid=0197f65b-2cee-42ee-8adc-9991ec38dcde
• Notes: Additional details about the test. e.g. theory as to failure cause

It seems to be a failure when connecting to the database

Stack Trace

=== Failed
=== FAIL: x-pack/metricbeat/module/sql/query TestOracle/fetch (0.32s)
    query_integration_test.go:252:
        	Error Trace:	/go/src/github.com/elastic/beats/x-pack/metricbeat/module/sql/query/query_integration_test.go:252
        	            				/go/src/github.com/elastic/beats/x-pack/metricbeat/module/sql/query/query_integration_test.go:245
        	Error:      	Should be empty, but was [cannot open connection: testing connection: user="sys" standalone params={authMode:2 connectionClass:<nil> connectionClassLength:0 purity:0 newPassword:<nil> newPasswordLength:0 appContext:<nil> numAppContext:0 externalAuth:0 externalHandle:<nil> pool:<nil> tag:<nil> tagLength:0 matchAnyTag:0 outTag:<nil> outTagLength:0 outTagFound:0 shardingKeyColumns:<nil> numShardingKeyColumns:0 superShardingKeyColumns:<nil> numSuperShardingKeyColumns:0 outNewSession:0}: ORA-12547: TNS:lost contact]
        	Test:       	TestOracle/fetch

[botelastic]

This issue doesn't have a Team:<team> label.

[pierrehilbert]

Similar to #35297

[AndersonQ]

I happened backports to 9.0 and 9.1 as well:

• https://buildkite.com/elastic/beats-xpack-metricbeat/builds/19431/steps/canvas?sid=01981e21-a2f3-4d0c-b31c-6de8c3c388b3
• https://buildkite.com/elastic/beats-xpack-metricbeat/builds/19432/steps/canvas?jid=01981e44-8a50-4598-8861-4241f17aa89b