select * from information_schema.settings where name='CREATE_BUILD' returns CREATE_BUILD = 120
database url: jdbc:h2:/Users/steve/Library/Application Support/Poker Copilot/database/ pokercopilot;DATABASE_EVENT_LISTENER='com.barbarysoftware.pokercopilot.database.DatabaseListener';MAX_LENGTH_INPLACE_LOB=65536;COMPRESS_LOB=DEFLATE;LOG=2 I use the H2 connection pool, and obtain connections from that as needed: DataSource datasource = JdbcConnectionPool.create(url, username, password); However all my database queries execute in one thread, and therefore do not run concurrently. I use LOG=2. The application is very multi-threaded. But queries are single- threaded. OS=Mac OS X 6.1 File system=Mac OS Extended (Journaled) JVM=Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode) The database is hundreds of Megabytes in size. With all test data loaded it would be some Gigabytes. The database is usually terminated gracefully, via the SHUTDOWN command. But this problem is happening before I try to shutdown. I can send the entire compressed database, including trace.db. Where shall I send it to? Regards, Steve McLeod On Oct 4, 4:47 pm, Thomas Mueller <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
