newrelic-dotnet-agent icon indicating copy to clipboard operation
newrelic-dotnet-agent copied to clipboard

Published 20 hours ago • verified publisher icon newrelic

MySQL version 8.0.29 causes explain plans to break (and other unbounded tests to fail)

Open JcolemanNR opened this issue 3 years ago • 2 comments

Description After rebuilding our unbounded services, I noticed that MySQL unbounded tests were consistently failing. After digging into this, I noticed that Version 8.0.29 of MySQL had been released in the past month.

The integration test failures relate to explain plans not being present, and procedure creation failing (non agent related).

The smoking gun here is that the MySQL release notes mention changes to explain plan functionality, and procedure creation.

When we go to resolve this issue, we should revert the changes introduced in: https://github.com/newrelic/newrelic-dotnet-agent/pull/1111

Expected Behavior Explain plans work, and all unbounded integration tests pass

Steps to Reproduce Run unbounded integration tests against MySQL v8.0.29

JcolemanNR avatar May 26 '22 00:05 JcolemanNR

Severity on not supporting retrieval of explain plan - Medium.

** Community developers, if you disagree with this statement please thumbs down so that we can prioritize accordingly **.

angelatan2 avatar May 31 '22 17:05 angelatan2

https://issues.newrelic.com/browse/NEWRELIC-3655

workato-integration[bot] avatar Sep 16 '22 20:09 workato-integration[bot]

Work has been completed on this issue.

workato-integration[bot] avatar Jun 01 '23 20:06 workato-integration[bot]