Lost connection to MySQL server during query

  • 141Views
  • Last Post 26 August 2021
0
votes
AJ Khanijow posted this 25 May 2021

Hi there I am receiving the error: Lost connection to MySQL server during query

When trying to run a package. I have increased the command and connection timeout to 3600 in skyvia. Any assistance would be much appreciated. This package ran (almost) fine on its first run, so not sure what the issue is. 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Nataliia Nikulina posted this 27 May 2021

Hello Aj,

Thank you for contacting Skyvia Support team!

We are investigating the issue and will contact you as soon as we have any updates.

Kind regards,

Nataliia

 

0
votes
Nataliia Nikulina posted this 26 August 2021

Hello Aj,  

 

Please perform the following steps:


Increase the "Command Timeout" value for your MySQL connection.

For this switch to the Connections page and click your MySQL connection.


Then click Edit. In the connection editor click Advanced, and then set a bigger value for the "Command Timeout"

property. 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 result. 



Best regards,

Nataliia,

Customer Support Engineer    

Close