I’m running FM Data Server, and using a query that supposed to fetch ~100K records from mySql.
It worked nicely last night.
Now, when I’m loading the server, it gets an error:
on one run I got:
2020-12-01 14:33:44.3677|FATAL|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
2020-12-01 14:33:44.3895|FATAL|Flexmonster.DataServer.Program|Timeout in IO operation
and when tried again I got:
2020-12-01 14:39:08.1986|FATAL|Microsoft.AspNetCore.Hosting.Diagnostics|Application startup exception
2020-12-01 14:39:08.2191|FATAL|Flexmonster.DataServer.Program|Timeout can be only be set to ‘System.Threading.Timeout.Infinite’ or a value > 0. (Parameter ‘value’)
Using workbench I get the 100K lines from the DB (it takes about 50 sec)
Is there a way to control the timeout? anything else to apply?
Thank you for reaching out to us.
We assume the issue can be caused by the default command timeout limitation of the driver. By default, it is set to 30 seconds.
You can increase the timeout by specifying it as a parameter of the connection string.
Please refer to the following page for more information about this parameter. You will also find an example of the connection string with the
default command timeout parameter specified.
Please let us know if it helps.
We are looking forward to hearing from you.