I haven't been able to reproduce this. Hopefully the stack trace and the query
shed some light on the underlying cause of this issue.
Regards
Alex
On 13 Jan 2010, at 18:35, Alexander Hartner wrote:
> I am getting a similar error using H2, version: 1.2.126 (2009-12-18). I can't
> rule out database corruption due to power issues / system crashes.
>
> 2010-Jan-13 18:27:03 [CentralAddressBook - FATAL] Contact ID criteria : IN
> ('585F7196-10F8-4ED8-8948-839B2653EBDE')
> 2010-Jan-13 18:27:04 [JCLLoggerAdapter - WARN] SQL Error: 50000, SQLState:
> HY000
> 2010-Jan-13 18:27:04 [JCLLoggerAdapter - ERROR] General error:
> "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
> select event0_.identifier as col_0_0_ from Events event0_ inner join
> Calendars calendar1_ on event0_.calendar_identifier=calendar1_.identifier
> where calendar1_.identifier in ('44536898-CC73-4518-9AAB-A0FED43FD528' ,
> '98A8EC8D-DD9E-4A39-889C-15A5310FAD0B' ,
> '8BD16B5E-CE05-4915-A925-E447D507A662' ,
> '7BF6CA5F-3A47-42EF-8AD9-7CABB74DE9DE' ,
> 'C8297C51-0CEC-4C84-816E-AD566A955CC9' ,
> '8BC8F011-1A80-4A1A-9653-F41424EB590D' ,
> 'B6DB7ED4-C948-48BB-8205-2CBC5A252CA8' ,
> 'C97C0A13-02F9-4ADB-BC8E-6DCBD1730CA3' ,
> 'B51C43E9-28D5-41F4-918D-184C7C0C6793' ,
> 'F911F55F-2737-4A94-B5E5-24972FE02892' ,
> 'F2A4EE0B-71F8-444D-A379-FFC26EDF574A') [50000-126]
> 2010-Jan-13 18:27:04 [CentralAddressBook - FATAL]
> GetAvailableEventOrTaskIdentifiersInCalendars failed
> javax.persistence.PersistenceException:
> org.hibernate.exception.GenericJDBCException: could not execute query
> at
> org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
> at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
> at
> com.j2anywhere.addressbookserver.CentralAddressBook.getAvailableEventOrTaskIdentifiersInCalendars(CentralAddressBook.java:470)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at com.sun.xml.ws.server.PeptTie._invoke(PeptTie.java:58)
> at
> com.sun.xml.ws.protocol.soap.server.SOAPMessageDispatcher.invokeEndpoint(SOAPMessageDispatcher.java:278)
> at
> com.sun.xml.ws.protocol.soap.server.SOAPMessageDispatcher$SoapInvoker.invoke(SOAPMessageDispatcher.java:586)
> at
> com.sun.xml.ws.protocol.soap.server.SOAPMessageDispatcher.receive(SOAPMessageDispatcher.java:141)
> at com.sun.xml.ws.server.Tie.handle(Tie.java:88)
> at
> com.sun.xml.ws.transport.http.servlet.WSServletDelegate.handle(WSServletDelegate.java:333)
> at
> com.sun.xml.ws.transport.http.servlet.WSServletDelegate.doPost(WSServletDelegate.java:288)
> at
> com.sun.xml.ws.transport.http.servlet.WSServlet.doPost(WSServlet.java:77)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> at java.lang.Thread.run(Thread.java:637)
> Caused by: org.hibernate.exception.GenericJDBCException: could not execute
> query
> at
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> at org.hibernate.loader.Loader.doList(Loader.java:2231)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
> at org.hibernate.loader.Loader.list(Loader.java:2120)
> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
> at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
> ... 28 more
>
>
>
> On 12 Jan 2010, at 10:24, Steve McLeod wrote:
>
>> Using databases created with 1.2.124 in a desktop app, I'm
>> occasionally getting error reports from users with this exception:
>>
>> org.h2.jdbc.JdbcSQLException: General error:
>> "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
>> select sum(takeinbigblinds) as takeinbigblinds from PlayerSummary f
>> where f.isHero=true and f.isplaymoney=? and f.istournament=? and
>> f.dayid>=? and f.dayid<? and f.tableSize=? and f.gametypeid=? and
>> buyin=? [50000-124]
>> at org.h2.message.Message.getSQLException(Message.java:111)
>> at org.h2.message.Message.convert(Message.java:288)
>> at org.h2.message.Message.convert(Message.java:249)
>> at org.h2.command.Command.executeQueryLocal(Command.java:144)
>> at org.h2.command.Command.executeQuery(Command.java:123)
>> at org.h2.jdbc.JdbcPreparedStatement.executeQuery
>> (JdbcPreparedStatement.java:98)
>> at org.springframework.jdbc.core.JdbcTemplate
>> $1.doInPreparedStatement(JdbcTemplate.java:648)
>> at org.springframework.jdbc.core.JdbcTemplate.execute
>> (JdbcTemplate.java:591)
>> ... 11 more
>> Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
>> at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:310)
>> at org.h2.index.PageDataLeaf.getRow(PageDataLeaf.java:427)
>> at org.h2.index.PageDataNode.getRow(PageDataNode.java:284)
>> at org.h2.index.PageDataNode.getRow(PageDataNode.java:284)
>> at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:377)
>> at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:366)
>> at org.h2.table.TableData.getRow(TableData.java:116)
>> at org.h2.index.PageBtreeIndex.getRow(PageBtreeIndex.java:284)
>> at org.h2.index.PageBtreeCursor.get(PageBtreeCursor.java:46)
>> at org.h2.index.IndexCursor.get(IndexCursor.java:146)
>> at org.h2.table.TableFilter.getValue(TableFilter.java:650)
>> at org.h2.expression.ExpressionColumn.getValue
>> (ExpressionColumn.java:168)
>> at org.h2.expression.Comparison.getValue(Comparison.java:215)
>> at org.h2.expression.ConditionAndOr.getValue
>> (ConditionAndOr.java:86)
>> at org.h2.expression.Expression.getBooleanValue(Expression.java:
>> 188)
>> at org.h2.command.dml.Select.queryGroup(Select.java:309)
>> at org.h2.command.dml.Select.queryWithoutCache(Select.java:551)
>> at org.h2.command.dml.Query.query(Query.java:236)
>> at org.h2.command.CommandContainer.query(CommandContainer.java:
>> 82)
>> at org.h2.command.Command.executeQueryLocal(Command.java:142)
>> ... 15 more
>>
>> I'm unable to reproduce, but in at least one case I know this was
>> preceded by a user's MacBook running out of power.
>>
>> The database url is:
>> jdbc:h2:~/
>> database;DATABASE_EVENT_LISTENER='com.barbarysoftware.pokercopilot.database.DatabaseListener';MAX_LENGTH_INPLACE_LOB=65536;COMPRESS_LOB=DEFLATE;CACHE_SIZE=65536
>>
>> Any suggestions?
>>
>> Thanks
>>
>> Steve
>> --
>> 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.
>>
>>
>
--
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.
