Failed to connect to MySQL

  • 35Views
  • Last Post 26 October 2021
0
votes
Michael Wu posted this 19 October 2021

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.

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Nataliia Nikulina posted this 20 October 2021

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 

 

0
votes
Michael Wu posted this 22 October 2021

It still didn't work after making the recommeded changes.

0
votes
Nataliia Nikulina posted this 26 October 2021

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 

 

Close