Graphviz Issue Tracker
Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0002309graphvizDotpublic2013-07-22 11:322014-06-11 17:17
Reportermikeyjamjams 
Assigned To 
PrioritynormalSeverityimportantReproducibilityalways
StatusnewResolutionopen 
PlatformWindowsOS7OS VersionService Pack 1
Summary0002309: Dot.exe freezes when using SchemasSpy 5.0.0 and force-metadata-jdbc-driver-2.2
DescriptionI am currently using SchemasSpy, the force-metadata-jbdc-driver, and Graphviz to draw ERD diagrams for a series of custom objects in Salesforce.com. When I launch SchemaSpy through the command prompt, the dot.exe application occasionally freezes when trying to draw 1-degree and 2-degree relationship diagrams and output them as PNG files.

What's interesting is that dot.exe freezes on the same objects every time I run SchemaSpy. Furthermore, I can kill dot.exe within the task manager, and SchemaSpy and Graphviz will continue drawing the remaining diagrams, unless it gets held up on another object, upon which I must kill dot.exe in the task manager once again.

After SchemaSpy finishes running, any object that caused dot.exe to freeze will not have any diagrams saved.

Killing dot.exe does generate an error message, which I've listed below. Also, regarding the objects that cause dot.exe to free, they are simple in nature and consist of a simple parent/child relationship. There are no self references or anything that I could see causing an infinite loop to crash dot.exe. Finally, these same objects are successfully drawn in the overall summary ERD diagram that draws the relationships between every object in Salesforce, so I'm not sure why the diagrams would fail when focusing on the objects individually.
Steps To ReproduceLaunch SchemasSpy from the command prompt:
java -cp schemaSpy_5.0.0.jar;force-metadata-jdbc-driver-2.2.jar net.sourceforge.schemaspy.Main -t force -u myusername -p mypassword -font Arial -fontsize 8 -hq -norows -o doc -db na14 -desc "Extracted from na14 on Force.com"
Additional InformationHere is the error message I receive whenever I use the task manager to kill the dot.exe file

Using database properties:
  [schemaSpy_5.0.0.jar]\force.properties
ForceMetaDataDriver: Filter [exclusionNames=[user], inclusionNames=[], keepCusto
m=true, keepStandard=false]
Gathering schema details................(10sec)
Writing/graphing summary............(1sec)
Writing/diagramming details......net.sourceforge.schemaspy.util.Dot$DotFailure:
'dot -Tpng:cairo doc3\diagrams\Candidate__c.1degree.dot -odoc3\diagrams\Candidat
e__c.1degree.png -Tcmapx' failed with return code 1
.......net.sourceforge.schemaspy.util.Dot$DotFailure: 'dot -Tpng:cairo doc3\diag
rams\Position__c.1degree.dot -odoc3\diagrams\Position__c.1degree.png -Tcmapx' fa
iled with return code 1
(20sec)
Wrote relationship details of 13 tables/views to directory 'doc3' in 32 seconds.

View the results by opening doc3\index.html
TagsNo tags attached.
AUXILLARY-FILES
DATE-FIXED
FIX-COMMENT
FORMER-ID
INPUT-FILE
OUTPUT-FILE
STATUS-COMMENT
VERSIONgraphviz-2.31
Attached Filesdot file icon Candidate__c.1degree.dot [^] (6,764 bytes) 2013-07-22 11:49
dot file icon Candidate__c.2degrees.dot [^] (7,938 bytes) 2013-07-22 11:50

- Relationships

-  Notes
User avatar (0000392)
ellson (administrator)
2013-07-22 11:47

Is there some way you can preserve that input file to dot and attach it to this report?


      doc3\diagrams\Candidate__c.1degree.dot
User avatar (0000393)
mikeyjamjams (reporter)
2013-07-22 11:50

Hi ellson. I've attached both .dot files that should have corresponding .PNG files created.
User avatar (0000394)
ellson (administrator)
2013-07-22 12:01

I can process these files without error using:
    dot - graphviz version 2.31.0 (20130719.1336)
on Fedora, so it sounds like either a recent fix, or a Windows issue.

We had another report last week that turned out to have been fixed recently.

Could you try updating to the latest nightly snapshot from:
    http://www.graphviz.org/ [^]
User avatar (0000395)
mikeyjamjams (reporter)
2013-07-22 12:27

I downloaded and extracted graphviz-2.31.20130722.zip. I reran SchemaSpy but the dot.exe got help up again on my Candidate object in Salesforce. I compared the new Candidate dot files with the old ones, but they were the same.
User avatar (0000396)
mikeyjamjams (reporter)
2013-07-22 13:56

I've also attempted to install the latest snapshot MSI file instead of the Zip file, but the dot.exe freezing still occurred.
User avatar (0000755)
erg (administrator)
2014-06-11 17:17

I somehow missed this bug or it slipped my mind. In any case, we have gone from 2.31 to 2.38, and I have no trouble running 2.38 dot on either of your files in a Windows environment. If possible, please try upgrading again. And make sure SchemaSpy is picking up the newest version. Sometimes applications get set to an older version.

- Issue History
Date Modified Username Field Change
2013-07-22 11:32 mikeyjamjams New Issue
2013-07-22 11:47 ellson Note Added: 0000392
2013-07-22 11:49 mikeyjamjams File Added: Candidate__c.1degree.dot
2013-07-22 11:50 mikeyjamjams File Added: Candidate__c.2degrees.dot
2013-07-22 11:50 mikeyjamjams Note Added: 0000393
2013-07-22 12:01 ellson Note Added: 0000394
2013-07-22 12:27 mikeyjamjams Note Added: 0000395
2013-07-22 13:56 mikeyjamjams Note Added: 0000396
2014-06-11 17:17 erg Note Added: 0000755


MantisBT 1.2.5[^]
Copyright © 2000 - 2011 MantisBT Group
Powered by Mantis Bugtracker