Investigate component conformance tests

[mikeee]

The last passing conformance test for all components was 4 months ago on the 12th of February.

Consistent failures are:

• bindings.azure.eventgrid
• secretstores.azure.keyvault.certificate
• state.mysql.mysql - fix: conformance - state.mysql.mysql #3458

state.mysql.mysql

Running tests for TestStateConformance/state/mysql.mysql ... 
Source Pacakge:  github.com/dapr/components-contrib/state/mysql,github.com/dapr/components-contrib/common/component/sql
=== RUN   TestStateConformance
=== RUN   TestStateConformance/mysql.mysql
    state.go:100: Base key for test: 9b9981936d0a4c8e8c7d365408e9e800
=== RUN   TestStateConformance/mysql.mysql/init
time="2024-06-22T00:04:36.343217069Z" level=debug msg="Initializing MySql state store" instance=fv-az2036-733 scope=testLogger type=log ver=unknown
time="2024-06-22T00:04:36.343980749Z" level=error msg="dial tcp [::1]:3306: connect: connection refused" instance=fv-az2036-733 scope=testLogger type=log ver=unknown
    state.go:401: 
        	Error Trace:	/home/runner/work/components-contrib/components-contrib/tests/conformance/state/state.go:401
        	Error:      	Received unexpected error:
        	            	dial tcp [::1]:3306: connect: connection refused
        	Test:       	TestStateConformance/mysql.mysql/init
--- FAIL: TestStateConformance/mysql.mysql/init (0.00s)
    state.go:406: Init failed, stopping further tests
--- FAIL: TestStateConformance/mysql.mysql (0.00s)
--- FAIL: TestStateConformance (0.00s)
FAIL
coverage: 12.2% of statements in github.com/dapr/components-contrib/state/mysql, github.com/dapr/components-contrib/common/component/sql
FAIL	github.com/dapr/components-contrib/tests/conformance	0.038s

=== Failed
=== FAIL: tests/conformance TestStateConformance/mysql.mysql/init (0.00s)
time="2024-06-22T00:04:36.343217069Z" level=debug msg="Initializing MySql state store" instance=fv-az2036-733 scope=testLogger type=log ver=unknown
time="2024-06-22T00:04:36.343980749Z" level=error msg="dial tcp [::1]:3306: connect: connection refused" instance=fv-az2036-733 scope=testLogger type=log ver=unknown
    state.go:401: 
        	Error Trace:	/home/runner/work/components-contrib/components-contrib/tests/conformance/state/state.go:401
        	Error:      	Received unexpected error:
        	            	dial tcp [::1]:3306: connect: connection refused
        	Test:       	TestStateConformance/mysql.mysql/init

=== FAIL: tests/conformance TestStateConformance/mysql.mysql (0.00s)
    state.go:100: Base key for test: 9b9981936d0a4c8e8c7d365408e9e800
    state.go:406: Init failed, stopping further tests

=== FAIL: tests/conformance TestStateConformance (0.00s)

DONE 3 tests, 3 failures in 128.963s
Completed tests for TestStateConformance/state/mysql.mysql ... 
Setting CONFORMANCE_FAILURE

Release Note

RELEASE NOTE:

[mikeee]

/assign

[mikeee]

The azure related components I am unable to test / the root cause would likely be resolved by a migration to use the azure sdk for go which I am unable to block out time for at the moment. Conformance tests minus the few azure issues seem fine for now so I'm closing this issue.