Unable to start SQLDeveloper on 32-bit Linux

tsangsir

On 32-bit Linux, I was unable to start recent versions SQLDeveloper (e.g., 21.2.1). It displayed the splash screen than crash. Is SQLDeveloper supported on 32-bit Linux?

System Details - 

OS: Arch Linux 32

Kernel: 5.15.2/arch1-1.0

Java Version: openjdk 11.0.12 (also fail to start on jdk 8)

SQLDevelopr: 21.2.1

Main Error message:

[29.405s][warning][os,thread] Failed to start thread - pthread_create failed (EAGAIN) for attributes: stacksize: 102400k, guardsize: 0k, detached.

100MB stacksize seems very big to me. But I don't know whether it is for a single thread, or all threads together? My hard limit is unlimited anyway. 

(The machine is not able to access internet so it will be a bit inconvenient to post a full stack. I want to see if anyone know have experience first.)

User_H3J7U

ide.conf:

# The options for 32-bit Java VM's
Add32VMOption -Xms128M
Add32VMOption -Xmx800M

sqldeveloper.conf:

AddVMOption -Xss100m

Try to set -Xms256M, -Xmx1280M if you have enough RAM.

Default limit of process memory on 32bit platform is 1.7GB.

cormaco

Make sure you are using a 32bit Java version.

tsangsir

Are you serious? Do you mean 64-bit Java can display a splash screen on 32-bit OS?

thatJeffSmith-Oracle

I'm pretty sure Wlwe ship some 64bit jars (JavaFX), I seriously doubt we support 32 bit at all in 2021.

cormaco

https://community.oracle.com/tech/developers/discussion/comment/16816891#Comment_16816891

I overlooked the part about the splash screen

tsangsir

https://community.oracle.com/tech/developers/discussion/comment/16816893#Comment_16816893

The download page or release note did not mention anything about word size requirement (only certification based on OS and Java version)

And there is separate Win64 and Win32+64 downloads.

User_H3J7U

ide.conf:

# The options for 32-bit Java VM's
Add32VMOption -Xms128M
Add32VMOption -Xmx800M

sqldeveloper.conf:

AddVMOption -Xss100m

Try to set -Xms256M, -Xmx1280M if you have enough RAM.

Default limit of process memory on 32bit platform is 1.7GB.

B.Delmée

The last version i have been able to use in 32bit mode is 19.4.

That is on windows, using the Azul OpenJDK - YMMV, not an officially supported combo, obviously.

tsangsir

https://community.oracle.com/tech/developers/discussion/comment/16816996#Comment_16816996

You are right. I modified -Xss all over different config files, but not sqldeveloper.conf. When I change the line to the following, SQLDeveloper could start, though very slooooooow on an old netbook, understandably.

sqldeveloper.conf:

AddVMOption -Xss1m

(Yes, lower the limit from 100m to 1m)

@thatJeffSmith-Oracle

I got error concerning JavaFX when starting SQLDeveloper, but as long as I can open a SQL Worksheet, I have no concern (yet).