Elastic exporter not picking up DB queries

[bhupesh-sf]

I am using elastic exporter and when I go to elastic it shows me trace and shows only one pg query whereas it has 4-5 queries. If I use elastic agent it shows me all.

Steps to reproduce
My flow is I call a facade from postman which calls a service which makes DB request 3-4 times and then calls another service which again calls db and then fails.

What did you expect to see?
I should be seeing everything logged in trace as its been with elastic agent.

What did you see instead?
DB queries are completely missing also no 40 not found badge which comes when I use elastic agent

What version did you use?
Version: v0.17.0

What config did you use?
Config:

`

receivers:

otlp:
  protocols:
    http:
      endpoint: 127.0.0.1:55681
      cors_allowed_origins:
      - http://*
      - https://*

  processors:
      batch: null
      queued_retry: null
      resourcedetection/system:
        detectors: [env, system]
        timeout: 2s
        override: false
  
  exporters:
      elastic:
        apm_server_url: 'http://localhost:8200'
  
  service:
      pipelines:
        traces:
          receivers: [otlp]
          processors: [batch, resourcedetection/system]
          exporters: [elastic]

Environment
OS: Ubuntu 20.04

[bhupesh-sf]

Any update here?

[andrewhsu]

from the collector sig triage today, cc @axw @simitt @jalvz for this issue because it is related to elasticexporter

[axw]

Thanks for the ping @andrewhsu!

@bhupesh-sf can you please add a logging exporter to the traces pipeline, capture the output, and point out which spans are not being captured in Elastic APM? Providing a screenshot of a trace waterfall in Elastic APM may also be helpful.

[cyrille-leclerc]

Hello @bhupesh-sf , friendly ping, can you provide more details as @axw asked?

[github-actions]

This issue has been inactive for 60 days. It will be closed in 60 days if there is no activity. To ping code owners by adding a component label, see Adding Labels via Comments, or if you are unsure of which component this issue relates to, please ping @open-telemetry/collector-contrib-triagers. If this issue is still relevant, please ping the code owners or leave a comment explaining why it is still relevant. Otherwise, please close it.

[github-actions]

This issue has been closed as inactive because it has been stale for 120 days with no activity.