Menu

#171 NumberFormatException

N/A
open
nobody
None
5
2016-12-26
2013-07-23
No

Try run :
java -jar ./schemaSpy_5.0.0.jar -t mysql -o /var/doc/feedlog -host xxx -db feedlog -u xxx -p xxx -dp /var/lib/mysql-connector-java-5.1.25/mysql-connector-java-5.1.25-bin.jar -loglevel finest
and get such output

12:42:31.367 INFO: SchemaAnalyzer.analyze - Starting schema analysis
12:42:31.459 CONFIG: ConnectionURLBuilder.<init> - connectionURL: jdbc:mysql://xxx/feedlog
12:42:31.460 INFO: SchemaAnalyzer.getConnection - Using database properties:
12:42:31.460 INFO: SchemaAnalyzer.getConnection - [./schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mysql.properties
12:42:32.223 INFO: SchemaAnalyzer.analyze - Connected to MySQL - 5.5.30-30.2-log
12:42:32.224 INFO: SchemaAnalyzer.analyze - Gathering schema details
java.lang.NumberFormatException: For input string: "3454549518"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:495)
at java.lang.Integer.parseInt(Integer.java:527)
at net.sourceforge.schemaspy.model.Database.getBasicTableMeta(Database.java:366)
at net.sourceforge.schemaspy.model.Database.initTables(Database.java:232)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:71)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:211)
at net.sourceforge.schemaspy.Main.main(Main.java:42)

as i understand problem is here:
info about table
TABLE_CATALOG: def
TABLE_SCHEMA: feedlog
TABLE_NAME: feed_tick
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Compressed
TABLE_ROWS: 3445555420
AVG_ROW_LENGTH: 37
DATA_LENGTH: 130093678592
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 98954641408
DATA_FREE: 2097152
AUTO_INCREMENT: 12108766586
CREATE_TIME: 2013-04-28 20:30:02
UPDATE_TIME: NULL
CHECK_TIME: NULL
TABLE_COLLATION: latin1_swedish_ci
CHECKSUM: NULL
CREATE_OPTIONS: row_format=COMPRESSED
TABLE_COMMENT: Feed

i try run with -norows but id did not help

Discussion

  • Olof Mattsson

    Olof Mattsson - 2014-11-25

    We are trying to use schemaSpy but are running into this problem as well. We have a lot of tables with more than 2,147,483,647 rows in them and on all schemaSpy failes.
    Did a quick look at the code and it looks like the getRows only handles int and that is not enough here.
    Hopefully this issue will get some attention or we will need to look elsewhere. I'm not a developer and it's most likely that I will not get internal resources to fix this.

    Please fix this since then schemaSpy will be able to solve a lot of our problems.

     
  • Rafal Kasa

    Rafal Kasa - 2016-12-26

    Hi

    I confirm this bug, and it will be fixed in next version of SchemaSpy.
    I created releated issue to this topic on github https://github.com/schemaspy/schemaspy/issues/23

     

Log in to post a comment.