JVM bug with H2 in 
-------------------

                 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

Reply via email to