Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

Bugs: MySQLDataException

Bottom of Page

1 to 5 of 5

  1.  
    • CommentAuthorandrewh
    • CommentTimeFeb 10th 2009
     
    Hi,

    First time fireup of the system, the following pops up, running version 1.0.1 (free edition) on Windows XP.

    Connection is via an ssh tunnel if that matters, server details:

    Server version: 4.0.24_Debian-10-log
    Protocol version: 10
    Client characterset: latin1
    Server characterset: latin1
    TCP port: 3306
    Uptime: 490 days 5 hours 58 min 16 sec

    Threads: 145 Questions: 62563880961 Slow queries: 2831017 Opens: 8707055 Flush tables: 4 Open tables: 1024 Queries per second avg: 1477.044


    An unexpected error has occured.
    Try restarting the application. Error details:

    com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.2260857675E10' in column '1' is outside valid range for the datatype INTEGER
    • CommentAuthorandrewh
    • CommentTimeFeb 10th 2009
     
    More information (just found the log dir :-))

    2009-02-11 08:27:41,798 ERROR [AWT-EventQueue-0] Catch.all - Uncaught exception on [Logger Daemon]: '1.2260857675E10' in column '1' is outside valid range for the datatype INTEGER. - query: SHOW PROCESSLIST /*jp 186110425*/
    eE: '1.2260857675E10' in column '1' is outside valid range for the datatype INTEGER. - query: SHOW PROCESSLIST /*jp 186110425*/
    at bY.a(SourceFile:331)
    at av.a(SourceFile:360)
    at av.a(SourceFile:351)
    at av.a(SourceFile:275)
    at aV.d(SourceFile:255)
    at aV.run(SourceFile:178)
    at java.lang.Thread.run(Unknown Source)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.2260857675E10'
    in column '1' is outside valid range for the datatype INTEGER.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
    rce)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:999)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    at com.mysql.jdbc.ResultSetImpl.throwRangeException(ResultSetImpl.java:7
    872)
    at com.mysql.jdbc.ResultSetImpl.parseIntAsDouble(ResultSetImpl.java:7114
    )
    at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2666)
    at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
    at dT.a(SourceFile:34)
    at cb.a(SourceFile:254)
    at bY.a(SourceFile:329)
    ... 6 more
  3.  
    Jet Profiler for MySQL erroneously uses 32-bit signed integers for thread ids instead of longs. Your server has been up for so long and served so many connections that the counter has gone past an int! Uptime: 490 days 5 hours 58 min 16 sec - Impressive. You should be able to confirm this by issuing

    SHOW PROCESSLIST;

    and checking the highest Id, it will be greater than 2147483647.

    Thanks for spotting this bug. It should be fixed and out in the next release, hopefully within the next couple of days. I'll notify you when it's out.
    • CommentAuthorandrewh
    • CommentTimeFeb 11th 2009
     
    Yep.


    | 12302920963 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL |

    At the average transaction rate we would have hit the 31bit limit in about 18 days from startup :-)

    Thanks for the prompt reply, I look forward to the next release so I can give your software a whirl.
  5.  
    Finally, this bug has been fixed. You should now be able to profile your busy database.

    By the way, are you sure about the 18 days?

    mysql> select 0x7fffffff / (1.2260857675E10 / 490);
    +--------------------------------------+
    | 0x7fffffff / (1.2260857675E10 / 490) |
    +--------------------------------------+
    | 85.823277206421 |
    +--------------------------------------+

1 to 5 of 5

  1.