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

[Anonymous]

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

[John Currier]

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

John

[Anonymous]

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]

The big factor in regards to a mortgage loan modification is definitely the fact that you can use it to prevent a foreclosures from taking place. Anytime an individual is applicable for any modification the foreclosures course of action that particular is within must be stopped. This really is hence the particular person may possibly have an simpler time with waiting to ascertain when the relation to financing may be changed. Basically because the foreclosures course of action will possibly be stopped all through the borrowed funds modification procedure does not necessarily mean a thief will must usually do not be billed with monthly obligations.
http://fsienergy.com/strumenu.html