[
https://jira.nuxeo.org/browse/NXP-6146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume updated NXP-6146:
-----------------------------------
Summary: JVM bug with H2 in h2.util.StringUtils.quoteRemarkSQL (was: JVM
bug with H2 in )
This is a Sun JVM bug in at least 1.6.0_18 and 1.6.0_20, see
http://www.mailinglistarchive.com/html/[email protected]/2010-07/msg00089.html
Upgrading the JVM to 1.6.0_21 is supposed to fix the problem.
> JVM bug with H2 in h2.util.StringUtils.quoteRemarkSQL
> -----------------------------------------------------
>
> Key: NXP-6146
> URL: https://jira.nuxeo.org/browse/NXP-6146
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Search / Query
> Affects Versions: 5.4
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
>
> Sometimes the following stack trace occurs when doing a query:
> Exception: org.h2.jdbc.JdbcSQLException. message: General error:
> java.lang.StringIndexOutOfBoundsException: String index out of range: -1; SQL
> statement:
> SELECT ... (big select statement) ... [50000-114]
> at org.h2.message.Message.getSQLException(Message.java:105)
> at org.h2.message.Message.convert(Message.java:277)
> at org.h2.command.Parser.prepareCommand(Parser.java:254)
> at org.h2.engine.Session.prepareLocal(Session.java:409)
> at org.h2.engine.Session.prepareCommand(Session.java:370)
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1044)
> at
> org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
> at
> org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:580)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.query(JDBCMapper.java:656)
> ... 166 more
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> java.lang.StringIndexOutOfBoundsException. message: String index out of
> range: -1
> at java.lang.String.substring(String.java:1937)
> at java.lang.String.substring(String.java:1904)
> at org.h2.util.StringUtils.quoteRemarkSQL(StringUtils.java:792)
> at org.h2.table.TableFilter.getPlanSQL(TableFilter.java:530)
> at org.h2.command.dml.Select.getPlanSQL(Select.java:869)
> at org.h2.command.dml.SelectUnion.getPlanSQL(SelectUnion.java:316)
> at org.h2.index.ViewIndex.<init>(ViewIndex.java:61)
> at org.h2.table.TableView.getBestPlanItem(TableView.java:145)
> at org.h2.table.TableView.getScanIndex(TableView.java:259)
> at org.h2.table.TableFilter.getBestPlanItem(TableFilter.java:126)
> at org.h2.table.Plan.calculateCost(Plan.java:109)
> at org.h2.command.dml.Optimizer.testPlan(Optimizer.java:180)
> at org.h2.command.dml.Optimizer.calculateBestPlan(Optimizer.java:84)
> at org.h2.command.dml.Optimizer.optimize(Optimizer.java:233)
> at org.h2.command.dml.Select.preparePlan(Select.java:805)
> at org.h2.command.dml.Select.prepare(Select.java:738)
> at org.h2.command.Parser.prepareCommand(Parser.java:235)
> ... 172 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
