Save session information from JDBC Connection in object DbRequest to correlate RDBMS logs with opentelemetry tracing

[igor-suhorukov]

Is your feature request related to a problem? Please describe.

When investigating incidents in an application for correlating RDBMS logs with OpenTelemetry tracing, it would be convenient to have information about the database session in the trace. In the case of PostgreSQL this is the backend PID.

Describe the solution you'd like

I expect a db.session field in io.opentelemetry.instrumentation.jdbc.internal.DbRequest that is populated from the database connection

Describe alternatives you've considered

No response

Additional context

For PostgreSQL it is possible to get PID form Connection object without any additional network request with

((PgConnection) connection).getBackendPID()

[breedx-splk]

Hi @igor-suhorukov this seems like a reasonable idea, with a couple of important notes:

• I'm not how feasible it is with every database client to get the remote pid. Would be great to even know if there are any other than postgres that provide such a thing.
• db.session is not specified in the database client semantic conventions, so we would probably want that fleshed out there as well. Can you help us to understand if using host/port instead could suffice for your correlation needs? The only thing I can think of is if the logs rotate after the server process is restarted or something....but time host/port/time should suffice, right?

[oehme]

Can you help us to understand if using host/port instead could suffice for your correlation needs?

A single host can serve many concurrent sessions (called java.sql.Connection in jdbc). You don't want to sift through the logs of all the unrelated sessions that ran at the same time. For postgres, each session gets its own process on the server, so the process id serves as a session id. Other databases have a different mechanism, but I think it generally makes sense to identify the session that a query came from. For example, MySQL has com.mysql.cj.MysqlConnection#getId