Timeout of mySQL components

[adameverington]

Hi Guys,

We're struggling when using components with long running queries. We're trying to set timeout limits via the connection string and also log in as a user with no time out settings on the server to no avail. Do you have any advice short of changing the server level variables?

[Pinturiccio]

Please increase the "Default Command Timeout" parameter value in Devart MySql Connection Manager.

The error can also be on the server side. Try increasing values of the following server variables: net_read_timeout, net_write_timeout and max_allowed_packet.

[adameverington]

Hi,

Tried the suggested but unfortunately it seems to be timing out during the validation of the package so as soon as the package opens I'm getting the error...

Code: Select all

[Dest-tblInvoice [43]] Error: System.Exception: An error occurred with the following error message: "Lost connection to MySQL server during query"
   at Devart.SSIS.Common.PipelineComponentBase.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

[adameverington]

A combination of:

connect_timeout=60000
interactive_timeout=60000
wait_timeout=60000;
net_read_timeout=6000;
net_write_timeout=6000;
max_allowed_packet = (1024 * 1024 * 256);

Seemed to work!