#173 SchemaSpy hangs on Writing/graphing summary

N/A
open
nobody
None
5
2013-09-05
2013-09-05
P Fudd
No

Hello!

I'm analyzing an SQL server database, and this command line gets me 99% of the way there:
java -jar schemaSpy_5.0.0.jar -t jtds -host 1.2.3.4 -port 1433 -db 'my_database_name' -u myusername -p mypassword -o schemaspy -s myschema -loglevel finest

However, the process hangs at this point:
16:31:50.657 INFO: SchemaAnalyzer.analyze - Gathered schema details in 3 seconds
16:31:50.657 INFO: SchemaAnalyzer.analyze - Writing/graphing summary

According to strace, the process is in some sort of infinite loop:
15261 futex(0x7fc56006e728, FUTEX_WAKE_PRIVATE, 1) = 0
15261 futex(0x7fc56006e754, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, {1378424433, 532987000}, ffffffff) = -1 ETIMEDOUT (Connection timed out)
15261 futex(0x7fc56006e728, FUTEX_WAKE_PRIVATE, 1) = 0
15261 futex(0x7fc56006e754, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, {1378424433, 543376000}, ffffffff) = -1 ETIMEDOUT (Connection timed out)
15261 futex(0x7fc56006e728, FUTEX_WAKE_PRIVATE, 1) = 0
15261 futex(0x7fc56006e754, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, {1378424433, 553738000}, ffffffff) = -1 ETIMEDOUT (Connection timed out)
15261 futex(0x7fc56006e728, FUTEX_WAKE_PRIVATE, 1) = 0

Another possible source of difficulty is this exec line that I found:
15272 execve("/usr/bin/dot", ["dot", "-Tpng:"], [/ 66 vars /] <unfinished ...="">
I'm not sure if it's probing for the various png formats, or if the format name was mangled; it may be unrelated to the bug.

In the 'schemaspy' output directory, the following files are created (find . -type f):
./images/tabRight.gif
./images/background.gif
./images/tabLeft.gif
./diagrams/summary/relationships.real.compact.dot
./jquery.js
./schemaSpy.js
The single dot file is empty. :-(

I'm using Ubuntu 12.04.3 LTS, with java version 1.6.0_27:
# java -version
java version "1.6.0_27"
OpenJDK Runtime Environment (IcedTea6 1.12.6) (6b27-1.12.6-1ubuntu0.12.04.2)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

I've got jtds-1.2.jar and jtds-1.3.1.jar, but only using the 1.2 version.

The database has 152 tables, which adds up to 886 columns. It has over 90GB of data in it, but hopefully that doesn't affect things.

What can I do to make this work?

Thanks!

Discussion