Troubleshooting the Snowflake Connector for MySQL

Note

The Snowflake Connector for MySQL is subject to the Connector Terms.

Issues

This section contains tips to resolve and troubleshoot issues related to Snowflake Connector for MySQL. If your issue is not listed here, see Contact Snowflake Support.

Ingestion

If you suspect that the ingestion process is stuck for a long time, you can run a stored procedure that attempts to repair the connector. To initiate a repair process, run the following command:

CALL PUBLIC.REPAIR_CONNECTOR();
Copy

Note

The procedure does not solve all problems with the connector. It is safe to run the procedure multiple times.

Contact Snowflake Support

If you encounter any issues while using the connector, submit a support case. When submitting a support case, we recommend that you share the logs for a quicker resolution. This is because Snowflake distributes the connector through the Native App Framework and metric data is not automatically returned to Snowflake.

The connector uses two types of log streams:

  • Native App logs collected by the native application.

  • Logs collected by the database agent, which runs in your infrastructure.

Sharing the Native App logs

The Native App Logs are gathered in the account event table. The Native App Framework offers a feature to enable log sharing back to the provider.

ALTER APPLICATION <app_db_name> SET SHARE_EVENTS_WITH_PROVIDER = TRUE;
Copy

Note

Historical log sharing is currently unavailable. If the issue arose before logs could be shared back to the provider, please download the application’s event table and share it as a zip file.

Sharing the database agent logs

The agent replicates its Native App counterpart. To send the agent logs back to Snowflake:

  1. Access the agent logs table as described in Viewing the agent logs.

  1. Select Download or View Results.

  2. Click Export.

  3. Send the downloaded log file and a description of the issue to your sales engineer.

Note

Snowflake recommends compressing the downloaded log files since they are often large and can easily be compressed.

Language: English