opentelemetry sqltelemetry not showing db but only applications .net8"

[feiliu-Docu]

Hi team,

we saw some logs has application name with or without db name.
using OpenTelemetry.Trace;

// ...

builder.Services.AddOpenTelemetry()
.WithTracing(tracerProviderBuilder => tracerProviderBuilder
.AddSource(MySource.Name)
.AddSqlClientInstrumentation(options =>
{
// Optional: Include the SQL statement in the span attributes
options.SetDbStatementForText = true;
})

what's the possible cause and fix for this ?

[svrnm]

@feiliu-Docu can you specify which language you are talking about, I assume .NET but I am not 100% sure?

[feiliu-Docu]

@feiliu-Docu can you specify which language you are talking about, I assume .NET but I am not 100% sure?

Yes, it is .Net 8

[martincostello]

Can you clarify your issue please? You mention logs but the code snippets are for traces.

[feiliu-Docu]

Can you clarify your issue please? You mention logs but the code snippets are for traces.

my bad, it is not the log. it is the automatic instrumentation for sql telemetry traces. the traces sometime have db name sometime does not.

for reference : https://www.nuget.org/packages/OpenTelemetry.Instrumentation.sqlclient

[Kielek]

@feiliu-Docu, could you provide as Minimal, Reproducible Example?

It will be much easier to investigate it with full perspective. Separate repo, if possible with dockerized dependencies helps a lot.

[feiliu-Docu]

@feiliu-Docu, could you provide as Minimal, Reproducible Example?

It will be much easier to investigate it with full perspective. Separate repo, if possible with dockerized dependencies helps a lot.

Hi Kielek, do you have any troubleshooting instructions ? or any possible fix ? it is automatic instrumentation using AddSqlClientInstrumentation in any asp.net core application.

No other custom code was added.

We won't be able to provide the confidential code due to policy.

[martincostello]

You should be able to put together a minimal reproducible example, as well some details of what you are seeing (or not), without providing any of your own proprietary/confidential code.

If you are using actual automatic instrumentation, that's actually another repository again: https://github.com/open-telemetry/opentelemetry-dotnet-instrumentation

[feiliu-Docu]

You should be able to put together a minimal reproducible example, as well some details of what you are seeing (or not), without providing any of your own proprietary/confidential code.

If you are using actual automatic instrumentation, that's actually another repository again: https://github.com/open-telemetry/opentelemetry-dotnet-instrumentation

we are using this nuget https://www.nuget.org/packages/OpenTelemetry.Instrumentation.sqlclient. this is the correct repo ?

[martincostello]

It is, but you also said:

it is automatic instrumentation

Automatic instrumentation is dealt with separately in the repo I linked to previously.

It depends what you meant by saying "automatic instrumentation",
but I'm guessing you mean "whatever the library does by default" rather than "I'm using auto-instrumentation", so that would be here.

However, your issue as written is quite vague as it just sounds like "it's not working", but given how many tests we have as a broad statement that is unlikely.

A minimal reproducible example that shows what you're doing and the effect it's having that you are having a problem that we can run ourselves will give us something concrete to investigate further.

[feiliu-Docu]

It is, but you also said:

it is automatic instrumentation

Automatic instrumentation is dealt with separately in the repo I linked to previously.

It depends what you meant by saying "automatic instrumentation", but I'm guessing you mean "whatever the library does by default" rather than "I'm using auto-instrumentation", so that would be here.

However, your issue as written is quite vague as it just sounds like "it's not working", but given how many tests we have as a broad statement that is unlikely.

A minimal reproducible example that shows what you're doing and the effect it's having that you are having a problem that we can run ourselves will give us something concrete to investigate further.

let me work on a "A minimal reproducible example", it might take some time