schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.58k stars 200 forks source link

GraphViz 9.0 relation rendering #1433

Closed gquintana closed 5 months ago

gquintana commented 5 months ago

Description

With SchemaCrawler and GraphViz 9.0.0 the relations between tables (the lines with tables) are not properly rendered.

See relations between user_entity_profile table and user_entity/profile tables public

Downgrading to GraphViz 8.1.0 solves the issue

How to Reproduce

  1. Use SchemaCrawler 16.21 with GraphViz 9.0.0
  2. Generate schema diagram with command schemacrawler --url jdbc:postgresql://... --user ... --password ... --command schema --output-file public.png --info-level standard --schemas '(.+\.)?public'

Relevant log output

No response

SchemaCrawler Version

16.21

Java Version

11

Operating System and Version

Windows 10

Relational Database System and Version

PostgreSQL

JDBC Driver and Version

Provided by SchemaCrawler

sualeh commented 5 months ago

@gquintana I am unable to reproduce the error on Windows with Graphviz 9.0.0. Since you can get it working with an older version of Graphviz, I will not be able to solve your problem. You will have to file a bug with the Graphviz development team.

Please could you send me the Graphviz DOT file that you can generate like this? You can attach the file to this issue.

schemacrawler --url jdbc:postgresql://... --user ... --password ... --command schema --output-format scdot --output-file public.dot --info-level standard --schemas '(.+\.)?public'

gquintana commented 5 months ago

@sualeh Thanks public-schema.zip The above archive contains the .dot file along with two .png files one rendered on GraphViz 8.1.0 and the other one rendered on GraphViz 9.0.0 I used Scoop to install both version on my Windows machine

GraphViz 9.0.0 is broken on Windows: https://gitlab.com/graphviz/graphviz/-/issues/2490

sualeh commented 5 months ago

@gquintana Thanks for the DOT file. I cannot reproduce on my Windows 11 system with Graphviz 9.0.0. This may be an issue with Graphviz on Windows 10.