0001690: BTree insert of mismatched value

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001690

[Resin]

minor

always

04-16-07 05:10

06-05-07 16:40

Reporter

sam

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.2

Product Version

3.1.0

Product Build

Summary

0001690: BTree insert of mismatched value

Description

(snapshot 2007-04-16)

Error occurred when persisting a new bean that has an int primary key marked with @Id, using the built-in Resin database.

[08:07:51.522] Caused by: java.sql.SQLException: BTree insert of mismatched value
[08:07:51.522] at com.caucho.db.index.BTree.insertLeafBlock(BTree.java:457)
[08:07:51.522] at com.caucho.db.index.BTree.insertValue(BTree.java:418)
[08:07:51.522] at com.caucho.db.index.BTree.insert(BTree.java:370)
[08:07:51.522] at com.caucho.db.index.BTree.insert(BTree.java:329)
[08:07:51.522] at com.caucho.db.table.IntColumn.setIndex(IntColumn.java:283)
[08:07:51.522] at com.caucho.db.table.Table.insertRow(Table.java:775)
[08:07:51.522] at com.caucho.db.table.Table.insert(Table.java:707)
[08:07:51.522] at com.caucho.db.sql.InsertQuery.execute(InsertQuery.java:115)
[08:07:51.522] at com.caucho.db.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:345)
[08:07:51.522] at com.caucho.db.jdbc.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:313)
[08:07:51.522] at com.caucho.sql.UserPreparedStatement.executeUpdate(UserPreparedStatement.java:98)
[08:07:51.522] at example.Category.__caucho_create(Category.java)
[08:07:51.522] at com.caucho.amber.manager.AmberConnection.createInternal(AmberConnection.java:2685)
[08:07:51.522] at com.caucho.amber.manager.AmberConnection.createInternal(AmberConnection.java:2643)
[08:07:51.522] at com.caucho.amber.manager.AmberConnection.persistInternal(AmberConnection.java:2864)
[08:07:51.522] at com.caucho.amber.manager.AmberConnection.persist(AmberConnection.java:283)
[08:07:51.522] ... 25 more

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0001850) sam 04-16-07 05:47	The problem is corrected if @GeneratedValue is added to the primary key field. The database tables are being created by Amber.

(0001855) ferg 04-17-07 20:01	This would need to be reported against 3.1.1.

(0001856) sam 04-18-07 11:12	fixed incorrect version

(0002015) ferg 06-05-07 16:40	jpa/0u0k

Issue History
Date Modified	Username	Field	Change
04-16-07 05:10	sam	New Issue
04-16-07 05:47	sam	Note Added: 0001850
04-17-07 20:01	ferg	Note Added: 0001855
04-17-07 20:01	ferg	Assigned To	=> ferg
04-17-07 20:01	ferg	Status	new => closed
04-18-07 11:11	sam	version	3.0.22 => 3.1.0
04-18-07 11:12	sam	Note Added: 0001856
04-18-07 11:12	sam	Status	closed => assigned
04-18-07 11:13	sam	Assigned To	ferg => sam
04-18-07 11:13	sam	Assigned To	sam =>
06-05-07 16:40	ferg	Note Added: 0002015
06-05-07 16:40	ferg	Assigned To	=> ferg
06-05-07 16:40	ferg	Status	assigned => closed
06-05-07 16:40	ferg	Resolution	open => fixed
06-05-07 16:40	ferg	Fixed in Version	=> 3.1.2

Mantis 1.0.0rc3[^]

36 total queries executed.
30 unique queries executed.