Bug #33495 Error Insert data in version 5.1.20

• Submitted: 24 Dec 2007 3:17
• Modified: 24 Dec 2007 4:29
• Reporter: hieu ngoc
• Status: Duplicate
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[24 Dec 2007 3:17] hieu ngoc

Description:
MySQL version 5.1.20 + hibernate 3.2 + spring framework
When I try to insert data into DB, the following error appear:
> > org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update
> > returned unexpected row count from update [0]; actual row count: 9;
> > expected: 1.
=> Is this bug or I have something wrong?????

If I use MySQL version 5.1.19 or 5.1.22 instead of 5.1.20, the problem disappear. 
What is happening?

How to repeat:
MySQL version 5.1.20 + hibernate 3.2 + spring framework
When I try to insert data into DB, the following error appear:
> > org.hibernate.jdbc.BatchedTooManyRowsAffectedException: Batch update
> > returned unexpected row count from update [0]; actual row count: 9;
> > expected: 1.
=> Is this bug or I have something wrong?????

If I use MySQL version 5.1.19 or 5.1.22 instead of 5.1.20, the problem disappear. 
What is happening?

[24 Dec 2007 4:29] Mark Matthews

This is due to server Bug#29692, which has already been fixed (in 5.1.21), which is why you only see this with 5.1.20.