I have a dbt-core setup to connect to mysql database which is installed on a localhost on my personal machine. The connectivity from dbt-core to mysql was working fine until I recently upgraded dbt-core to the latest version.
As the latest dbt-core is incompatible with the latest mysql plugin, I have reverted dbt-core to the previous setup and then I face this weird issue that when I execute “dbt run” or “dbt snpashot” it runs without any error, but it is not connecting to the database.
I have verified the database is up and running on the localhost, I have verified profile.yml and db credentials, I have done a complete “dbt clean” and even deleted existing python virtual environment and created new but still no luck.
I see that “dbt run” or “dbt snapshot” is trying to create a new connection with mysql and then stopped without any errors and no further tracing.
(dbt-venv) PS C:\Users\krish\OneDrive\Desktop\Learning\dbt_repo\mysql> **dbt snapshot --select tmp_snapshot --debug**
11:01:12 Sending event: {‘category’: ‘dbt’, ‘action’: ‘invocation’, ‘label’: ‘start’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002362EBE6510>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002363179C050>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002363179C190>]}
11:01:12 Running with dbt=1.7.19
11:01:12 running dbt with arguments {‘printer_width’: ‘80’, ‘indirect_selection’: ‘eager’, ‘log_cache_events’: ‘False’, ‘write_json’: ‘True’, ‘partial_parse’: ‘True’, ‘cache_selected_only’: ‘False’, ‘profiles_dir’: ‘C:\Users\krish\.dbt’, ‘version_check’: ‘True’, ‘warn_error’: ‘None’, ‘log_path’: ‘C:\Users\krish\OneDrive\Desktop\Learning\dbt_repo\mysql\logs’, ‘debug’: ‘True’, ‘fail_fast’: ‘False’, ‘use_colors’: ‘True’, ‘use_experimental_parser’: ‘False’, ‘no_print’: ‘None’, ‘quiet’: ‘False’, ‘warn_error_options’: ‘WarnErrorOptions(include=, exclude=)’, ‘invocation_command’: ‘dbt snapshot --select tmp_snapshot --debug’, ‘log_format’: ‘default’, ‘introspect’: ‘True’, ‘target_path’: ‘None’, ‘static_parser’: ‘True’, ‘send_anonymous_usage_stats’: ‘True’}
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘project_id’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000023631857950>]}
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘adapter_info’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000002363194B020>]}
11:01:13 Registered adapter: mysql=1.7.0
11:01:13 checksum: a8d43cdff37d0f32d7fbe4c5c25bea4bb6c86e162f8ce8fdb1a38cdcf7495431, vars: {}, profile: , target: , version: 1.7.19
11:01:13 Partial parsing enabled: 0 files deleted, 0 files added, 0 files changed.
11:01:13 Partial parsing enabled, no changes found, skipping parsing
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘load_project’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000023631B22B50>]}
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘resource_counts’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x00000236319873E0>]}
11:01:13 Found 12 models, 8 snapshots, 1 test, 24 sources, 0 exposures, 0 metrics, 491 macros, 0 groups, 0 semantic models
11:01:13 Sending event: {‘category’: ‘dbt’, ‘action’: ‘runnable_timing’, ‘label’: ‘90307415-c08a-480c-ac91-a19cc1dc28b3’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x0000023632B57070>]}
11:01:13
11:01:13 Acquiring new mysql connection ‘master’
11:01:13 Acquiring new mysql connection ‘list_schemas’
11:01:13 Using mysql connection “list_schemas”
11:01:13 On list_schemas: /* {“app”: “dbt”, “dbt_version”: “1.7.19”, “profile_name”: “mysql”, “target_name”: “dev”, “connection_name”: “list_schemas”} */
select distinct schema_name
from information_schema.schemata
**11:01:13 Opening a new connection, currently in state init**
(dbt-venv) PS C:\Users\krish\OneDrive\Desktop\Learning\dbt_repo\mysql>
