#174 SchemaSpy Spy or dot.exe never finishes (hangs) when Writing/diagramming details

N/A
open
nobody
5
2014-02-22
2013-11-08
No

I am trying to use SchemaSpy with Oracle Databases. When a database is small everything goes perfectly. When I am using a bigger database it hangs at "Writing/diagramming details". Here is the output of the execution: (the *** are because I can't show any info of the database)

The output is:
D:\graphical represantation>java -jar schemaSpy_5.0.0.jar -dp D:\oracle\product\ 10.2.0\client_1\jdbc\lib\ojdbc14.jar -db s1 -o schemaOutputes -u es
-p
-schemas ES -hq -noviews -norows -noimplied -loglevel severe
Analyzing schemas:
E
S
Analyzing E
*S
Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/ora.properties
Gathering schema details........................................................
................................................................................
................................................................................
..................(18sec)
Writing/graphing summary............(16sec)
Writing/diagramming details.....................................

If I look in the Task Manager I can see dot.exe running (50% of CPU, that's a full CPU in a dual core) and 8.296K memory. The dot.exe can't be killed easily. The network is not used (probably the SchemaSpy gathered all the info it wanted).

If I ommit the "-noimplied" parameter, the programm still hangs in the "Writing/diagramming details" but a little bit earlier (just four dots).

Discussion

  • Charalampos Gkikas

    I think the problem is the dot.exe. It happens on tables that reference or being referenced a lot. I think it tries to compute a NP-complete problem of arranging the arrows.

     
  • Bryan Webb

    Bryan Webb - 2014-01-07

    I have the same issue on an oracle db with approx 3000 tables
    would really like to use schemaspy.

     
  • Bryan Webb

    Bryan Webb - 2014-01-07

    i changes the jvm settings to -Xms512M
    still hung

     
  • Gary

    Gary - 2014-01-08

    I have the same issue and upon some detailed analysis found problem is related to default image format cannot accomodate that large content.
    Schemaspy presumes and sends png file names to dot.exe in net.sourceforge.schemaspy.view.HtmlOrphansPage, net.sourceforge.schemaspy.view.HtmlRelationshipsPage and net.sourceforge.schemaspy.view.HtmlTableDiagrammer

    There is option to change the format and renderer to net.sourceforge.schemaspy.util.Dot which I tried to change to cairo to request dot.exe to generate diagrams in svg format but because the file name including extension is hard coded in write method of the above classes output image is corrupt. If i change extension to svg i can see images.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks