source-mysql and source-mssql failing due to missing arm64 image

[bnchrch]

Problem

When running either of

• airbyte-ci connectors --name=source-mysql test
• airbyte-ci connectors --name=source-mssql test

Locally or in CI we get the following failure:

Could not pull image: no matching manifest for linux/arm64/v8 in the manifest list entries

Possible Causes

test containers do not have proper variant

Quote from @alafanechere

we've put a bit more reflection on the source-mysql testing issue with Ben.
So this connector uses testcontainers to spin up test db instance in docker containers.
I think the local root cause of your error is because this tools uses a mysql image which does not have an AMD variant (cf this stack overflow link).
In the CI (running on ARM) we do not have this problem. We have another one. The tests can't connect to the test containers db.
I think this is because there's some networking tweaks required to happen when running testcontainers inside a container like we do with dagger... I overcame this kind of issue in the past for source-postgres with this PR. I think it's worthwile trying to implement the same changes I did for source-postgres for source-mysql. I did not do it for this connector in the past because I wanted airbyte-ci to be on par with /legacy-test for GA connectors mainly.

However there is a variant for the mysql test container

Appenix

• https://airbytehq-team.slack.com/archives/C03VDJ4FMJB/p1691797268994649

[postamar]

This can be closed now: source-mysql is fixed and source-mssql fails for some other, unrelated reason involving secrets. Feel free to reopen if/when applicable.