Netezza Performance Server

 View Only
Expand all | Collapse all

.NET Driver Timeout problem

  • 1.  .NET Driver Timeout problem

    Posted Sat November 25, 2023 03:56 AM
    Edited by Krzysztof Duśko Sat November 25, 2023 04:02 AM

    Hi.
    in .NET driver is problem with command timeout. Value greater than ~4294 is not handled properly. (setting 4295 timeout is effective same as setting it to 2 sec, 4296 -> 3 sec.. )

    when using show external code in Visual Studio is clear what is going on,

    Socket.Poll Method (System.Net.Sockets) | Microsoft Learn 

    Parameters

    microSeconds
    Int32

    The time to wait for a response, in microseconds.

    Poll method accepts integer.. For some reason negative values also works but still 2* MAX_INT ~= 4293 (sec) is very limited. Of course solution is Very easy. Wait should be done by chunks of with chunk less than max int value



    ------------------------------
    Krzysztof Duśko
    ------------------------------