We are observing multiple intermittent runtime and database‑related errors for database operations. These errors are consistently captured in Datadog logs and traces.

[vmeganathan81]

Observed Errors (from Datadog)

Database (ODBC)‑related
pyodbc.OperationalError

Observed during:

INSERT operations into application logging tables
SELECT queries with parameters
Join queries fetching application configuration / prompt metadata
Example (masked):
SQLINSERT INTO <masked_table>(transaction_id, log_identifier, log_value)VALUES (?)Show more lines
SQLSELECT col1, col2FROM <masked_table_1>JOIN <masked_table_2> WITH (NOLOCK) ON ...WHERE ...``Show more lines

Observability

The issue has been observed and confirmed in Datadog, across:

Open Questions / Areas for Investigation

Are long‑running DB queries or locks contributing to OperationalError? Does these affect operational database operations ?

Or Its just false positive from Datadog ?

Is it datadog isssue or the issue is within code of application ?

[bkline]

@vmeganathan81 Can you provide a more detailed description of the pyodbc-specific behavior you believe is unexpected? This ticket reads more like internal investigation notes than an actionable bug report — it's not clear what you're asking the pyodbc maintainers to look into or fix.