Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

🐛 Destination MySQL: database argument missing at connection time #9484

Closed
alafanechere opened this issue Jan 13, 2022 · 2 comments · Fixed by #11470
Closed

🐛 Destination MySQL: database argument missing at connection time #9484

alafanechere opened this issue Jan 13, 2022 · 2 comments · Fixed by #11470
Labels
area/connectors Connector related issues autoteam connectors/destination/mysql connectors/destinations-database normalization priority/critical Critical priority! type/bug Something isn't working

Comments

@alafanechere
Copy link
Contributor

Environment

  • Airbyte version: 0.35.4-alpha
  • OS Version / Instance: Windows 10 Pro
  • Deployment: Docker
  • Destination Connector and version: Mysql 0.1.15
  • Severity: Critical
  • Step where error happened: Sync job

Current Behavior

During normalization DBT can't connect to the targetted database because of _mysql_connector.MySQLInterfaceError: No database selected error.
Replication of raw data works as expected.

Expected Behavior

The normalization process should run flawlessly.

Logs

sync logs
dbt SQL model

Steps to Reproduce

  1. Set up a connection with MySQL destination and enable basic normalization
  2. Run the sync
@alafanechere alafanechere added type/bug Something isn't working area/connectors Connector related issues priority/critical Critical priority! normalization labels Jan 13, 2022
@alafanechere
Copy link
Contributor Author

This error was fixed on the dbt-mysql adapter in this PR.
Our normalization mysql.Dockerfile installs the adapter through pip but the latest fixes on the adapter are not released on Pypi since February 2021.
We can try installing the branch directly from GitHub to get the most recent fixes:
RUN pip install git+https://github.com/dbeatty10/dbt-mysql.git@dev/0.19.0

@alafanechere alafanechere mentioned this issue Jan 13, 2022
Closed
@alafanechere
Copy link
Contributor Author

alafanechere commented Mar 28, 2022 •
edited
Loading

The maintainer of dbt-mysql published the latest version of the adapter to Pypi. We need to upgrade dbt-mysql to 1.0.0 and dbt image used by normalization MySQL to 1.0.0 too.

@alafanechere alafanechere mentioned this issue Mar 28, 2022
Merged
@alafanechere alafanechere linked a pull request Mar 28, 2022 that will close this issue
Normalization: Upgrade MySQL to dbt 1.0.0 #11470
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/connectors Connector related issues autoteam connectors/destination/mysql connectors/destinations-database normalization priority/critical Critical priority! type/bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Normalization: Upgrade MySQL to dbt 1.0.0 airbytehq/airbyte
3 participants
@bleonard @alafanechere @igrankova