#141 java.lang.OutOfMemoryError: unable to create new native thre

open
John Currier
5
2011-10-28
2011-10-28
Anonymous
No

Here's the original command line, with sensitive data omitted. I've specified the schema I want because this is the one that causes the problem. None of the other schemas exhibit this problem:

java -jar schemaSpy_5.0.0.jar -t pgsql -db XXXX -u XXXX -p XXXX -host XXXX -dp /usr/share/java/postgresql-jdbc-9.0.801.jar -schemas "sde" -o outputDir
Analyzing schemas:
sde
Analyzing sde
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Gathering schema details......Exception in thread "main" java.lang.OutOfMemoryError: unable to create new native thread
at java.lang.Thread.start0(Native Method)
at java.lang.Thread.start(Thread.java:640)
at net.sourceforge.schemaspy.model.Database$ThreadedTableCreator.create(Database.java:1068)
at net.sourceforge.schemaspy.model.Database.initTables(Database.java:259)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:71)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:211)
at net.sourceforge.schemaspy.Main.main(Main.java:42)
...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Failed to execute this process (rc 1): java -Doneofmultipleschemas=true -jar schemaSpy_5.0.0.jar -ahic -dp "/usr/share/java/postgresql-jdbc-9.0.801.jar" -css "schemaSpy.css" -charset "ISO-8859-1" -font "Helvetica" -fontsize "11" -t "pgsql" -renderer "" -p "XXXX" -u "XXXX" -db "XXXX" -host "XXXX" -loglevel "warning" -sqlFormatter "net.sourceforge.schemaspy.view.DefaultSqlFormatter" -i ".*" -I "" -x "[^.]" -X "[^.]" -dbthreads "2147483647" -maxdet "300" -s sde -o outputDir/sde

I'm going to take a wild stab in the dark...perhaps this has something to do with: -dbthreads "2147483647" ? That's a lot of threads!

This schema has some pretty wild tables, some with as many as 600 columns. I have a feeling this might be causing the problem

(Disclaimer: I did not design this database, I simply inherited it. This is why I need a visual representation of the schema.)

Thoughts?

Daniel

Discussion

  • John Currier
    John Currier
    2011-11-01

    I'm not sure why I have that unbounded. Have you tried limiting it to something more reasonable (like -dbthreads 10)?

    John

     

  • Anonymous
    2011-11-04

    Hi John,

    I didn't realize that parameter would pass down from the command line. I simply added -dbthreads to my command line per your suggestion and it worked.

    Thanks!

     

  • Anonymous
    2011-11-04

    -dbthreads 10, that is