MySQL Data Truncation: Out of range value in Performance test

Posted by Khaledez on Stack Overflow See other posts from Stack Overflow or by Khaledez
Published on 2011-11-17T09:47:15Z Indexed on 2011/11/17 9:51 UTC
Read the original article Hit count: 170

Filed under:
|
|

on a test for Java-MySQL-Restlet application, I write to database at 4reqs/second for 120 seconds.

In this write I insert a row that has foreign key which has the same value for all rows, and this exception occurs:

Could not recover transaction. Original exception follows. com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'idPxxx' at row 1

Only 5% of requests fails to this exceptions, others works.

Regards

© Stack Overflow or respective owner

Related posts about java

Related posts about mysql