Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Window 10 (1803) SQL Developer suddenly close

Leo HungMay 9 2018 — edited May 16 2018

After I updated my Windows 10 to 1803. The SQL Developer will suddenly close very often. Anyone has similar problem?

My SQL Developer version (4.1.5.21.78-x64; 17.3.1.279.0537-x64)

This post has been answered by Glen Conway on May 15 2018
Jump to Answer

Comments

thatJeffSmith-Oracle

Your OS is much newer than your SQLDev (and probably Java).

Try upgrading to 18.1 and Java 9

Leo Hung

Hi Jeff,

I just donwload the latest SQL developer (18.1) with JDK bundled. But still the suddenly close.

Did you tried Window 10 v1803 with SQL developer?

thatJeffSmith-Oracle

Start SQLDev from the bin directory from a cmd window.

Then when SQLDev borks, check the cmd window for a Java stack dump

Leo Hung

The error as below:

# A fatal error has been detected by the Java Runtime Environment:

#

#  EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000059bb65b5, pid=12844, tid=0x0000000000000bd4

#

# JRE version: Java(TM) SE Runtime Environment (8.0_152-b16) (build 1.8.0_152-b16)

# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.152-b16 mixed mode windows-amd64 compressed oops)

# Problematic frame:

# C  0x0000000059bb65b5

#

# Failed to write core dump. Minidumps are not enabled by default on client versions of Windows

#

and part of the error log in the log file:

Deoptimization events (10 events):

Event: 69.647 Thread 0x0000000018a19800 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000005b28754 method=java.awt.EventQueue.coalesceEvent(Ljava/awt/AWTEvent;I)Z @ 77

Event: 69.663 Thread 0x0000000018a19800 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000005b041fc method=java.awt.EventQueue.coalesceEvent(Ljava/awt/AWTEvent;I)Z @ 77

Event: 70.978 Thread 0x000000001fa83000 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000005d2f1a0 method=java.util.concurrent.ThreadPoolExecutor.getTask()Ljava/lang/Runnable; @ 100

Event: 75.277 Thread 0x0000000018a19800 Uncommon trap: reason=unstable_if action=reinterpret pc=0x00000000062ab824 method=sun.java2d.pipe.Region.dimAdd(II)I @ 1

Event: 75.277 Thread 0x0000000018a19800 Uncommon trap: reason=unstable_if action=reinterpret pc=0x00000000039c3bb8 method=sun.java2d.pipe.Region.dimAdd(II)I @ 1

Event: 80.874 Thread 0x0000000018a19800 Uncommon trap: reason=unstable_if action=reinterpret pc=0x0000000005e51068 method=javax.swing.JComponent.paintChildren(Ljava/awt/Graphics;)V @ 455

Event: 80.879 Thread 0x0000000018a19800 Uncommon trap: reason=unstable_if action=reinterpret pc=0x00000000064dab84 method=java.awt.Container.hasHeavyweightDescendants()Z @ 8

Event: 80.879 Thread 0x0000000018a19800 Uncommon trap: reason=unstable_if action=reinterpret pc=0x0000000004069f84 method=java.awt.Container.hasHeavyweightDescendants()Z @ 8

Event: 80.880 Thread 0x0000000018a19800 Uncommon trap: reason=class_check action=maybe_recompile pc=0x0000000004a95028 method=java.awt.Container.getMouseEventTargetImpl(IIZLjava/awt/Container$EventTargetFilter;ZZ)Ljava/awt/Component; @ 64

Event: 83.704 Thread 0x000000001f1b0000 Uncommon trap: reason=unstable_if action=reinterpret pc=0x00000000042b2104 method=oracle.jdbc.proxy.ProxyFactory.proxyForCache(Ljava/lang/Object;Ljava/lang/Object;Ljava/util/Map;Ljava/lang/reflect/Method;)Ljava/lang/Object; @ 163

Classes redefined (0 events):

No events

Internal exceptions (10 events):

Event: 63.270 Thread 0x0000000018a19800 Exception <a 'java/security/PrivilegedActionException'> (0x00000000f2bc43f8) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jvm.cpp, line 1390]

Event: 63.274 Thread 0x0000000018a19800 Exception <a 'java/io/FileNotFoundException'> (0x00000000f2bc9c70) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jni.cpp, line 709]

Event: 63.275 Thread 0x0000000018a19800 Exception <a 'java/security/PrivilegedActionException'> (0x00000000f2bca768) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jvm.cpp, line 1390]

Event: 63.275 Thread 0x0000000018a19800 Exception <a 'java/io/FileNotFoundException'> (0x00000000f2bcba30) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jni.cpp, line 709]

Event: 63.275 Thread 0x0000000018a19800 Exception <a 'java/security/PrivilegedActionException'> (0x00000000f2bcc518) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jvm.cpp, line 1390]

Event: 63.278 Thread 0x0000000018a19800 Exception <a 'java/io/FileNotFoundException'> (0x00000000f2bcdd38) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jni.cpp, line 709]

Event: 63.278 Thread 0x0000000018a19800 Exception <a 'java/security/PrivilegedActionException'> (0x00000000f2bce828) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jvm.cpp, line 1390]

Event: 63.279 Thread 0x0000000018a19800 Exception <a 'java/io/FileNotFoundException'> (0x00000000f2bcfb08) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jni.cpp, line 709]

Event: 63.279 Thread 0x0000000018a19800 Exception <a 'java/security/PrivilegedActionException'> (0x00000000f2bd0630) thrown at [C:\re\workspace\8-2-build-windows-amd64-cygwin\jdk8u152\9742\hotspot\src\share\vm\prims\jvm.cpp, line 1390]

Event: 68.699 Thread 0x000000001f1b0000 Implicit null exception at 0x000000000633ed43 to 0x00000000063401d9

Events (10 events):

Event: 83.704 Thread 0x000000001f1b0000 Uncommon trap: trap_request=0xffffff65 fr.pc=0x00000000042b2104

Event: 83.704 Thread 0x000000001f1b0000 DEOPT PACKING pc=0x00000000042b2104 sp=0x0000000028fae630

Event: 83.704 Thread 0x000000001f1b0000 DEOPT UNPACKING pc=0x00000000038b582a sp=0x0000000028fae618 mode 2

Event: 83.704 loading class oracle/jdbc/OraclePreparedStatement

Event: 83.704 loading class oracle/jdbc/OraclePreparedStatement done

Event: 83.885 Executing VM operation: RevokeBias

Event: 83.885 Executing VM operation: RevokeBias done

Event: 85.548 Executing VM operation: RevokeBias

Event: 85.548 Executing VM operation: RevokeBias done

Event: 85.548 Thread 0x000000001fa8a800 Thread exited: 0x000000001fa8a800

Glen Conway

I am still on WIndows 10 (1709), but will try upgrading to 1803 and let you know the results.

Glen Conway

OK, after upgrading to Windows 10 (1803), there seems to be no problem under SQL Developer 18.1, on either jdk-9.0.4 or jdk-1.8.0_161.  So try upgrading the Java JDK and update the SetJavaHome line in C:\Users\<your_userid>|AppData\Roaming\sqldeveloper\18.1.0\product.conf.

If that does not work, then maybe you can be more specific about what things you have done in a session where SQL Developer closes suddenly.

Edit:

And are you running SQL Developer under Cygwin?  The PrivilgeActionException and FileNotFoundException messages would seem to indicate that is the case.

Leo Hung

I am not running SQL Developer under Cygwin. I just following Jeff suggested that run sqldeveloper.exe by CMD windows.

I am tried jre-1.8.0.161 & Jre-1.8.0.171 also has the same result. The SQL developer still will close suddenly.

The following sample steps that it will close suddenly.

  1. open SQL Developer
  2. connect to 127.0.0.1 (Oracle 11i Express)
  3. scroll down the Connections panel by mouse wheel
  4. expend Other Users folder tree
  5. scroll down the connections panel by mouse wheel
  6. the SQL developer will close suddenly.

If I didn't scroll with mouse wheel in connections panel, I can use the SQL developer quite a long time. But it still will close suddenly around 10-15 minutes.

I am thinking to restore the Windows to 1709 if I have no solution for this.

Glen Conway
Answer

OK, sorry about my misunderstanding of the Cygwin reference.  Anyway, as you mentioned in a reply to Jeff, whether running Java from a GitHub workspace or the bundled server JRE, you still see SQL Developer crash.  I do not have the same problem with the mouse wheel running the scenario you mention in my environment. 

The crash report points to a problem in the Windows native code (C++)

# Problematic frame:

# C  0x0000000059bb65b5

so you could check if this has already been reported as a Java bug.  Reverting to Windows 10 (1709) is a possible workaround, but you might want to try updating your device drivers first -- the mouse and video drivers, for example.  Another possibility is checking your Tools -> Preferences -> Environment -> Look and Feel setting and see whether both Oracle and Windows exhibit the same problem.

Good luck!

Marked as Answer by Leo Hung · Sep 27 2020
thatJeffSmith-Oracle

Java itself is crashing.

I don't see anything in the log to indicate why. Normally I've seen this in the past due to a video driver not playing nice - and it would be fixed by updating that.

Leo Hung

BINGO!! after I install the updated display driver (Model: AMD R7 370), my SQL developer is working fine!!!

Many thanks to Glen & Jeff helping me to solve my problem.

1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 13 2018
Added on May 9 2018
10 comments
2,876 views