The connection can be tested successfully. The other package https://app.skyvia.com/#/91436/packages/143798 in the workspace doesn't encounter the connection error.
https://app.skyvia.com/#/91436/packages/141837/log failed to complete the replication due to Lost connection to MySQL server during query.
Hello Michael,
Thank you for contacting Skyvia Support team.
> "Lost connection to MySQL server during query"
Please perform the following steps to overcome the issue.
1. Increase the "Command Timeout"/"Connection Timeout" values for your MySQL connection.
For this switch to the Connections page and find your MySQL connection.
Then click Edit, open Advanced Settings, and then set bigger values for both parameters.
2. Increase the values of the following parameters at your MySQL Server:
- max_allowed_packet
- net_read_timeout
- net_write_timeout
For more information, please refer to http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Please inform us about the results.
We look forward to hearing from you.
Best regards,
Nataliia,
Customer Support Engineer
Hello Michael,
Thank you for the update.
Please increase the values to 3600 for net_read_timeout and _net_write_timeout variables.
Also please send us wait_timeout and max_allowed_packet values.
We look forward to hearing from you.
Best regards,
Nataliia,
Customer Support Engineer
