3 Replies Latest reply on Nov 3, 2019 12:56 AM by Glen Conway

    Hung Sessions in SQL Developer - AppHangB1

    2799477

      I am getting hung sessions in SQL Developer.   I suspect it's something in the communication layer and not the database.

       

      The symptoms I am seeing are when I run a SQL statement it does not return for 10, 30 minutes, or longer, if at all.  This is intermittent.  I can be working along fine for an hour, and then suddenly it hangs, even though I ran the same script a few minutes before and got sub-second response time.  When I try to cancel, it remains hung with that annoying cylon-eye inspired "working bar" thing going back and forth.  I have to cancel the task, and of course I lose my work that I forgot to save...

      while this is going on, I will switch over to sqlcl an run the SQL script there.  Runs fine (most of the time), sometimes not.

       

      One hypothesis:  Sometimes it seems to be on an error in SQL statement, like it didn't get the error message back.

       

      Running  SQLDeveloper Version 19.2.0.206 on win10

       

      I see in the event viewer an AppHangB1 event.

       

       

       

       

      Fault bucket , type 0

      Event Name: AppHangB1

      Response: Not available

      Cab Id: 0

       

      Problem signature:

      P1: sqldeveloper64W.exe

      P2: 19.2.0.206

      P3: 5c747444

      P4: 683b

      P5: 67246080

      P6:

      P7:

      P8:

      P9:

      P10:

       

        

       

      SQL Developer Log entries

      SEVERE 408 0 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.dbtools.raptor.startpage.StartPageViewer.updateDocument(StartPageViewer.java:288)
      SEVERE 418 17162 oracle.dbtools.raptor.insight.InsightCache InsightCache.fillIn() time = 8853  ret.size()= 339167
      SEVERE 425 25868 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.dbtools.raptor.startpage.StartPageViewer.updateDocument(StartPageViewer.java:288)
      SEVERE 438 47666 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at oracle.dbtools.raptor.startpage.StartPageViewer.updateDocument(StartPageViewer.java:288)
      SEVERE 541 797121 oracle.dbtools.raptor.insight.InsightCache InsightCache.fillIn() time = 13852  ret.size()= 383004
      SEVERE 578 17234 oracle.dbtools.raptor.insight.InsightableOracleDatabase ORA-01013: user requested cancel of current operation

      SEVERE 579 3594 oracle.dbtools.raptor.insight.InsightableOracleDatabase ORA-01013: user requested cancel of current operation

       

       

       

      Could it be something is blocking two-way communication between the DB and SQL Developer?