Bug#471646: libmysql-java: strange SQL Exceptions with Version "5.1.5+dfsg-2: all"

[Michael Koch]

On Wed, Mar 19, 2008 at 10:40:59AM +0100, bjoern.thorwirth at uni-duisburg-essen.de wrote:
> Package: libmysql-java
> Version: 5.1.5+dfsg-2
> Severity: important
> 
> *** Please type your report below this line ***
> I'm using the OpenMMS software packet. It's a rdb management
>  system for crystal protein structures. With the reported
> version of libmysql-java i got the following execption:
> Load Started Wed Mar 19 10:26:51 CET 2008
> Loading PDB_ID: 3b9c
>     Read time: 1.514 s.
> 
> ********** LOAD ENTRY FAILED **********
>   SQL Exception in DBLoader.loadEntries()
>   while loading Entry PDB_ID=3b9c
>   Exception Description: java.sql.BatchUpdateException: Data truncation:
> Out of range value adjusted for column 'occupancy_esd' at row 1
>     SQL Message:  Data truncation: Out of range value adjusted for
> column 'occupancy_esd' at row 1  SQL State:  01004  SQL ErrorCode: 0
>   Stack Trace
> java.sql.BatchUpdateException: Data truncation: Out of range value
> adjusted for column 'occupancy_esd' at row 1
>         at
> com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1669)
>         at
> com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085)
>         at
> org.rcsb.openmms.dbinsert.InsertEntry.insert_ATOM_SITE(InsertEntry.java:2821)
>         at
> org.rcsb.openmms.dbinsert.InsertEntry.insertEntryData(InsertEntry.java:766)
>         at
> org.rcsb.openmms.apps.rdb.InsertEntryFinal.buildAndInsertEntry(InsertEntryFinal.java:156)
>         at
> org.rcsb.openmms.apps.rdb.DBLoader.insertSingleEntry(DBLoader.java:462)
>         at
> org.rcsb.openmms.apps.rdb.DBLoader.processSingleEntry(DBLoader.java:391)
>         at
> org.rcsb.openmms.apps.rdb.DBLoader.loadSingleEntry(DBLoader.java:265)
>         at
> org.rcsb.openmms.apps.rdb.DBLoader.loadEntries(DBLoader.java:184)
>         at
> org.rcsb.openmms.apps.rdb.PanelSet$LoadManifestButtonObserver$1.construct(PanelSet.java:482)
>         at
> org.rcsb.openmms.apps.rdb.SwingWorker$2.run(SwingWorker.java:111)
>         at java.lang.Thread.run(Thread.java:595)
> 
> ********** end of exception report **********
> **********************************************************
> 
> There is no excpetion with Version: "5.0.4+dfsg-2: all" .
> May be its note worthy that i had the same problem former, when i
> updated first time from version 3.x to 5.x. A downgrade fixed that problem
> that
> time , too. It's strange, that the problem now occures again.

Can you please create a smaller testcase just involving a test app using
libmysql-java and a database? That would be of great help to track that
down.


Cheers,
Michael