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.
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)
Your OS is much newer than your SQLDev (and probably Java).
Try upgrading to 18.1 and Java 9
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?
Start SQLDev from the bin directory from a cmd window.
Then when SQLDev borks, check the cmd window for a Java stack dump
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
I am still on WIndows 10 (1709), but will try upgrading to 1803 and let you know the results.
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.
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.
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.
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!
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.
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.