[instrumentation-mysql2] tests time out for mysql2@3.11.5

[pichlermarc]

Description

On main the TAV tests for mysql2@3.11.5 are currently timing out. Since assertions are failing on that version, I'd assume that also telemetry is being dropped, hence categorizing this as priority:p2.

See release: https://github.com/sidorares/node-mysql2/releases/tag/v3.11.5
See failing workflow: https://github.com/open-telemetry/opentelemetry-js-contrib/actions/runs/12107327068/job/33754171979

[pichlermarc]

looks like connection and query got split and now it's not patching it correctly anymore.

[pichlermarc]

I believe that this is related to sidorares/node-mysql2#3081
Edit: and #1511

[pichlermarc]

This is a release blocker for core 1.29.0/0.56.0 - see open-telemetry/opentelemetry-js#5232