Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-8272890

DB Queries takes longer than expected with SocketInputStream.socketRead0 error

    XMLWordPrintable

    Details

    • Subcomponent:
    • CPU:
      x86_64
    • OS:
      windows_10

      Description

      ADDITIONAL SYSTEM INFORMATION :
      OS - Windows 10
      Tested on Java 8 and Java 11

      A DESCRIPTION OF THE PROBLEM :
      There's a specific DB query that runs fine for the first 9 times and starts timing out the 10th time onwards. Analysis -
      Tried debugging the code further and found that the queries are actually not timing out but it takes too long to respond from the 10th execution. The code gets stuck at java.net.SocketInputStream.socketRead() method.
      Performance Analysis -
      While running the query for the 10th time where it took 150seconds to return the response out of which socketRead method took 149.74 seconds to return response.


      FREQUENCY : always


        Attachments

          Activity

            People

            Assignee:
            rsurianaraya Rajagopal Surianarayanan
            Reporter:
            webbuggrp Webbug Group
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: