Hi,
I have a few questions:
- The database URL?
- With which version of H2 was this database created?
You can find it out using:
select * from information_schema.settings where name='CREATE_BUILD'
- Did you use multiple connections?
- Do you use any settings or special features (for example, the setting
LOG=0, or two phase commit, linked tables, cache settings)?
- Is the application multi-threaded?
- What operating system, file system, and virtual machine
(java -version) do you use?
- How big is the database (file sizes)?
- Is the database usually closed normally, or is process terminated
forcefully or the computer switched off?
- Are there any other exceptions (maybe in the .trace.db file)?
Could you send them please?
- Do you still have any .trace.db files, and if yes could you send them?
- Could you send the .h2.db file where this exception occurs?
Regards,
Thomas
On Sun, Oct 4, 2009 at 4:41 PM, Steve McLeod <[email protected]> wrote:
>
> Hm, I deleted my database and tried again. No joy. Seems to be
> sporadic.
>
> On Oct 4, 4:36 pm, Steve McLeod <[email protected]> wrote:
>> I just gave 1.2.120 a trial in my application. It zoomed along at
>> first, faster than previous versions. But then this exception came...
>>
>> org.h2.jdbc.JdbcSQLException: General error:
>> java.lang.ClassCastException: org.h2.index.PageDataLeaf cannot be cast
>> to org.h2.index.PageBtree; SQL statement:
>> insert into gameplayersummary (gameid, playerid, playername,
>> seatnumber, stakelevelid, positionid, tournamentid, buyin, casinoid,
>> gametypeid, tableid, tablename, dayid, isplaymoney, istournament,
>> isHero, startTime, tableSize, takeInCents, showdowntakeInCents,
>> nonshowdowntakeInCents, takeInBigBlinds, downcard1, downcard2, flop1,
>> flop2, flop3, turn, river, handType, numPlayersSittingIn, timesseen,
>> flopseen, vpip, preflopraised, postflopbet, postflopcalled,
>> postflopfolded, postflopraised, postflopBetOrRaised,
>> postFlopCallFoldBetOrRaise,blindStealAttempt,
>> blindStealAttemptOpportunity, checkRaised, checkRaisedOpportunity,
>> wentToShowdown, wonAtShowdown, wonWithoutShowdown, threeBetPreflop,
>> threeBetPreflopOpportunity,blindStealDefenseOpportunityOnBigBlind,
>> calledPreflopRaise,
>> calledPreflopRaiseOpportunity,continuationBetPreflop,
>> continuationBetPreflopOpportunity,foldedToBlindStealOnBigBlind,foldedToContinuationBet,
>> foldedToContinuationBetOpportunity,foldedToPreflopThreeBet,
>> foldedToPreflopThreeBetOpportunity) values
>> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>> ?, ?, ?, ?, ?, ?, ?,
>> 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>> ?, ?, ?, ?)
>> [50000-120]
>> at org.h2.message.Message.getSQLException(Message.java:106)
>> at org.h2.message.Message.convert(Message.java:283)
>> at org.h2.table.TableData.addRow(TableData.java:151)
>> at org.h2.command.dml.Insert.update(Insert.java:100)
>> at org.h2.command.CommandContainer.update(CommandContainer.java:72)
>> at org.h2.command.Command.executeUpdate(Command.java:208)
>> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal
>> (JdbcPreparedStatement.java:139)
>> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate
>> (JdbcPreparedStatement.java:128)
>> at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement
>> (JdbcTemplate.java:798)
>> at org.springframework.jdbc.core.JdbcTemplate.execute
>> (JdbcTemplate.java:591)
>> ... 20 more
>> Caused by: java.lang.ClassCastException: org.h2.index.PageDataLeaf
>> cannot be cast to org.h2.index.PageBtree
>> at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:129)
>> at org.h2.index.PageBtreeNode.getRowCount(PageBtreeNode.java:350)
>> at org.h2.index.PageBtreeNode.getRowCount(PageBtreeNode.java:351)
>> at org.h2.index.PageBtreeNode.init(PageBtreeNode.java:267)
>> at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:97)
>> at org.h2.table.TableData.addRow(TableData.java:132)
>> ... 27 more
>>
>> I'll see if it is reproducible.
>>
>> Regards,
>>
>> Steve McLeod
>>
>> On Oct 4, 4:27 pm, Thomas Mueller <[email protected]>
>> wrote:
>>
>> > Hello,
>>
>> > A new version of H2 is available athttp://www.h2database.com
>> > (you may have to click 'Refresh').
>>
>> > Changes and new functionality:
>> > - This is a beta version.
>> > - New databases are now stored in a new file format.
>> > Existing databases are kept in the old file format.
>> > - Databases created by this version can not be opened with older versions.
>> > - In version 1.2, the following system properties are enabled by default:
>> > h2.pageStore, h2.nullConcatIsNull, h2.optimizeInList.
>> > - PostgreSQL compatibility: function LASTVAL() as an alias for IDENTITY().
>> > - Linked tables now support default values when inserting, updating or
>> > merging.
>> > - Possibility to set a vendor id in Constants.java.
>> > - Allow writing to linked tables in readonly databases.
>>
>> > Bugfixes:
>> > - Issue 125: Renaming primary keys was not persistent. Fixed.
>> > - Issue 124: Hibernate schema validation failed for decimal/numeric
>> > columns.
>> > - Bugfixes in the page store.
>>
>> > For details, see the 'Change Log'
>> > athttp://www.h2database.com/html/changelog.html
>>
>> > For future plans, see the 'Roadmap' page
>> > athttp://www.h2database.com/html/roadmap.html
>>
>> > P.S. If you reply to this message please use a different subject.
>>
>> > Have fun,
>> > Thomas
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
