Hi all,
I am still getting this using 1.2.128. Should I try with the latest release
build ? Please let me know if you require further details.
2010-mars-31 07:56:55 [JCLLoggerAdapter - WARN] SQL Error: 50000, SQLState:
HY000
2010-mars-31 07:56:55 [JCLLoggerAdapter - ERROR] General error:
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
select emailaddre0_.identifier as identifier3_, emailaddre0_.changeType as
changeType3_, emailaddre0_.updatedOn as updatedOn3_,
emailaddre0_.CONTACTIDENTIFIER as CONTACTI7_3_, emailaddre0_.label as label3_,
emailaddre0_.type as type3_, emailaddre0_.value as value3_ from EmailAddresses
emailaddre0_ where emailaddre0_.updatedOn>? and emailaddre0_.changeType<>?
[50000-128]
2010-mars-31 07:56:55 [CentralAddressBook - FATAL] Unable to Fetch. TX roll'd
back.
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.SyncService.fetchRecords(SyncService.java:203)
at
com.j2anywhere.addressbookserver.CentralAddressBook.fetchRecords(CentralAddressBook.java:79)
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:465)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
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:2235)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
... 30 more
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
select emailaddre0_.identifier as identifier3_, emailaddre0_.changeType as
changeType3_, emailaddre0_.updatedOn as updatedOn3_,
emailaddre0_.CONTACTIDENTIFIER as CONTACTI7_3_, emailaddre0_.label as label3_,
emailaddre0_.type as type3_, emailaddre0_.value as value3_ from EmailAddresses
emailaddre0_ where emailaddre0_.updatedOn>? and emailaddre0_.changeType<>?
[50000-128]
at org.h2.message.Message.getSQLException(Message.java:110)
at org.h2.message.Message.convert(Message.java:287)
at org.h2.message.Message.convert(Message.java:248)
at org.h2.command.Command.executeQuery(Command.java:134)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:283)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Thread.java:637)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:310)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:103)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:55)
at org.h2.index.IndexCursor.next(IndexCursor.java:184)
at org.h2.table.TableFilter.next(TableFilter.java:279)
at org.h2.command.dml.Select.queryFlat(Select.java:491)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:558)
at org.h2.command.dml.Query.query(Query.java:243)
at org.h2.command.CommandContainer.query(CommandContainer.java:81)
at org.h2.command.Command.executeQuery(Command.java:132)
... 3 more
at org.h2.engine.SessionRemote.done(SessionRemote.java:522)
at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:158)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:98)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
... 38 more
2010-mars-31 08:25:41 [JCLLoggerAdapter - WARN] SQL Error: 50000, SQLState:
HY000
2010-mars-31 08:25:41 [JCLLoggerAdapter - ERROR] General error:
"java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
select emailaddre0_.identifier as identifier3_, emailaddre0_.changeType as
changeType3_, emailaddre0_.updatedOn as updatedOn3_,
emailaddre0_.CONTACTIDENTIFIER as CONTACTI7_3_, emailaddre0_.label as label3_,
emailaddre0_.type as type3_, emailaddre0_.value as value3_ from EmailAddresses
emailaddre0_ where emailaddre0_.updatedOn>? and emailaddre0_.changeType<>?
[50000-128]
2010-mars-31 08:25:41 [CentralAddressBook - FATAL] Unable to Fetch. TX roll'd
back.
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.SyncService.fetchRecords(SyncService.java:203)
at
com.j2anywhere.addressbookserver.CentralAddressBook.fetchRecords(CentralAddressBook.java:79)
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:465)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
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:2235)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
... 30 more
Caused by: org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException"; SQL statement:
select emailaddre0_.identifier as identifier3_, emailaddre0_.changeType as
changeType3_, emailaddre0_.updatedOn as updatedOn3_,
emailaddre0_.CONTACTIDENTIFIER as CONTACTI7_3_, emailaddre0_.label as label3_,
emailaddre0_.type as type3_, emailaddre0_.value as value3_ from EmailAddresses
emailaddre0_ where emailaddre0_.updatedOn>? and emailaddre0_.changeType<>?
[50000-128]
at org.h2.message.Message.getSQLException(Message.java:110)
at org.h2.message.Message.convert(Message.java:287)
at org.h2.message.Message.convert(Message.java:248)
at org.h2.command.Command.executeQuery(Command.java:134)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:283)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
at java.lang.Thread.run(Thread.java:637)
Caused by: java.lang.ArrayIndexOutOfBoundsException
at org.h2.engine.SessionRemote.done(SessionRemote.java:522)
at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:158)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:98)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
... 38 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.
