Page 1 of 1

Timeout of mySQL components

Posted: Tue 05 Dec 2017 15:49
by 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?

Re: Timeout of mySQL components

Posted: Fri 08 Dec 2017 14:45
by 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.

Re: Timeout of mySQL components

Posted: Mon 11 Dec 2017 13:58
by 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)

Re: Timeout of mySQL components

Posted: Mon 11 Dec 2017 16:21
by 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!