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?
Timeout of mySQL components
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Timeout of mySQL components
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.
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.
-
- Posts: 9
- Joined: Thu 26 Oct 2017 14:52
Re: Timeout of mySQL components
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...
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)
-
- Posts: 9
- Joined: Thu 26 Oct 2017 14:52
Re: Timeout of mySQL components
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!
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!