Graphviz error now breaking schemaspy db generation

install graphviz mac
graphviz jar
graphviz gitlab
graphviz cygwin
graphviz executable
how to install graphviz
install graphviz linux
installing dot

I have been using Schemaspy(v5.0) to diagram mySQL(v5.7.11) using Graphviz via Homebrew on my Mac (El Capitan). A recent update to Graphviz(v2.40.1) apparently has broken Schemaspy's ability to generate the relational diagrams.

Writing/graphing summary.....org.schemaspy.util.Dot$DotFailure: 'dot -Tpng:gd 
/Tools/docs/data/project/diagrams/summary/relationships.real.compact.dot 
-o/Tools/docs/data/project/diagrams/summary/relationships.real.compact.png 
-Tcmapx' 
failed with return code 139

To solve this issue, I have tried:

  • uninstall/reinstall graphviz
  • downgrade Graphviz(v2.38 - it was the only version I could find and homebrew didn't have any older versions either) but it hosed my install
  • attempted to run on a colleague's computer with same results
  • tried the new beta version of schemaspy(v6.0-beta3)
  • searched graphviz forums (page crashed), stackoverflow, and general google search.

Looking to figure out how to get this working again.


[Edit] I didn't find a solution to why SchemaSpy/Graphviz stopped working (or wtf "code 139" meant), but I did use a workaround.

  • Install Docker
  • Get mnuessler/schemaspy or similar from hub.docker.com
  • open a volume to your host - it will be used in the docker command
  • run the command below

docker run -it --rm -v /docs/data:/data mnuessler/schemaspy -hq -t mysql -host localhost -u root -p root -db things -o /data/leads

where -v is the volume you opened on your host and -o /data/... is where the output will show up after the run

Specifying the renderer · Issue #33 · schemaspy/schemaspy · GitHub, By default SchemaSpy expects the dot executable to be in the PATH environment variable. Use this option to explicitly specify where Graphviz is installed. $ java -version java version "1.8.0_181" $ dot -V dot - graphviz version 2.40.1 (20161225.0304) $ java -jar schemaSpy_5.0.0.jar -t pgsql -db dbname -host localhost -dp postgresql-42.2.5.jar -noschema -u user -o . In my case, I am able to manually generate images from the dot files generated by schemaspy (even after the errors are reported).

Working fix on High Sierra for this:

brew uninstall graphviz

After that run:

brew install graphviz --with-librsvg --with-pango

Source:https://github.com/schemaspy/schemaspy/issues/33/#issuecomment-355091538

Graphviz error now breaking schemaspy db generation, Thank you for taking up maintenance of the SchemaSpy project. /graphviz-​error-now-breaking-schemaspy-db-generation/42018558#  I downloaded the schemaSpy_5.0.0.jar from sourceforge. I have also downloaded and installed graphviz-2.28.0.msi from the graphviz.org website (Graphviz program folder is "C:\Program Files\Graphviz 2.28"). When I run schemaSpy, it is generating the schema details for the database-schema selected, except the relationship diagram.

IF you are on macOs HighSierra the correct call is without the renderer and (re)install Graphviz with:

brew reinstall graphviz --with-librsvg --with-pango

SchemaSpy / Bugs / #194 Blank relationships tab -- net.sourceforge , I have been using Schemaspy(v5.0) to diagram mySQL(v5.7.11) using Graphviz via Homebrew on my Mac (El Capitan). A recent update to Graphviz(v2.40.1)  Dismiss Join GitHub today. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.

I tried the above methods, but it wasn't working for me.

Running on mojave, I wasn't able to get the brew installation to work (due to missing pango libraries). Maybe this will be updated in the future, but at the time of this writing, I had to switch to the Macports installation and this worked for me.

Also running schemaspy 6.0.0, and Graphviz 2.40.1.

SchemaSpy Activity, Using schemaspy on a postgresql database with 104 tables. /graphviz-error-​now-breaking-schemaspy-db-generation/42018558#42018558. @rafal: I have the same issue. Im on a Mac OSX Sierra - and do have graphviz installed via homebrew. dot - graphviz version 2.40.1 (20161225.0304) I tried with both the version of schemaSpy that is publicly released (v5.0.0) and the release candidate (v6.0.0-rc1) jars - both have the same issue.

Update for this question. Homebrew recently made changes to adding of options when installing a package....they don't allow it anymore. :)

https://brew.sh/2019/02/02/homebrew-2.0.0/

The suggestion was to use brew edit graphviz and add the desired arguments there. I'm trying that now.

[PDF] SchemaSpy Documentation, I want to use SchemaSpy, but I my database is used heavily 24/7 and the DBA Latest snapshot release of schemaspy doesn't require GraphViz -error-now-​breaking-schemaspy-db-generation/42018558#42018558 This  Brand Management Campaign Management Digital Asset Management Email Marketing Lead Generation Marketing graphviz-error-now-breaking-schemaspy-db-generation

SchemaSpy, It's also designed to help resolve the obtuse errors that a database sometimes gives related to Now has option to use embedded viz.js (no need for Graphviz) -vizjs version) will default to generating either higher or lower quality images. It can contain wast amount of properties so we will break it down. Graphviz error now breaking schemaspy db generation By default SchemaSpy expects the dot executable to be in the PATH environment variable. Use this option to explicitly specify where Graphviz is installed.

It's also designed to help resolve the obtuse errors that a database sometimes SchemaSpy uses the dot executable from Graphviz to generate Now the graphical representation of relationships [-nohtml] Skip generation of html report. It can contain wast amount of properties so we will break it down. Teams. Q&A for Work. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information.

It lets you click through the hierarchy of database tables via child and parent errors that a database sometimes gives related to failures due to constraints. SchemaSpy uses the dot executable from Graphviz to generate graphical Now the graphical representation of relationships is a fundamental feature of the tool. If you use Firefox or Liferea or Banshee you will have an SQLite database to inspect. There are popular DB admin tools in Ubuntu like TOra, but they lack a decent diagram generator. If we can extract the schema from the DB, it should be straightforward to pass this off to GraphViz.

Comments
  • I installed using homebrew, which places the app in the $PATH, and everything was working just fine until the last Graphviz update. To check: $ dot -V dot - graphviz version 2.40.1 (20161225.0304) thanks for the response
  • Additional update - I added the brew path to the schemaspy script: -gv "/usr/local/Cellar/graphviz/2.40.1/" and got the same error messages. I'll keep at it - thanks anyhow!
  • This issue happen also for other SchemaSpy user. I try to find where is the bug and try to fix it as soon as possible. Please verify status of this issue on Github github.com/schemaspy/schemaspy/issues/33
  • It will be work by using -renderer :quartz tested on Mac OS El Capitan with graphviz version 2.40.1 (20161225.0304)
  • Gave the green check for the above comment thanks all for reviewing
  • thanks for the heads up - I'll look into it