[
https://issues.apache.org/jira/browse/JCR-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jukka Zitting updated JCR-2610:
-------------------------------
Fix Version/s: (was: 2.0.0)
> Quering returns java.lang.IndexOutOfBoundsException: bitIndex < 0: -1
> ---------------------------------------------------------------------
>
> Key: JCR-2610
> URL: https://issues.apache.org/jira/browse/JCR-2610
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: query
> Affects Versions: 1.6.0, 1.6.1
> Environment: Magnolia version: 4.2.3
> Jackrabbit version: 1.6.0 (also 1.6.1)
> Lucene core: 2.4.1
> OS: Linux CentOS 5.4 x64
> JAVA: 1.6 (sun jvm)
> MySQL connector: mysql-connector-java-5.1.11-bin.jar
> Database: MySQL 5.1
> DB running on: Windows Server 2008 Standard x64
> The database holds aprox 30 GB of document data at this moment.
> Reporter: Ana Osman
>
> Configs:
> Storage for large binaries: DbDataStore
> PersistenceManager: MySqlPersistenceManager with<param
> name="externalBLOBs" value="false" />
> The problem is that a lot of queries return the error shown in the attached
> file (jcr.txt).
> For example this query does not work:
> SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR
> jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND
> year<='2010' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%'
> But this one does:
> SELECT * FROM nt:base WHERE jcr:path LIKE
> '/wsDocumentList/Board-of-Directors/%' (only "jcr:path" clause)
> In this particular case this query works too:
> SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR
> jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND
> (type='ppt' or type='doc' or type='pdf' or type='jpg') AND year<'2010' AND
> jcr:path LIKE '/wsDocumentList/Board-of-Directors/%'
> But in the case listed below, adding the "type" clauses still causes the
> error.
> We tried recreating the indexes, but that had no effect.
> Also we exported the content (in this case the "Board-of-Directors" folder -
> aprox 165 MB) and imported it in another instance of Magnolia and everything
> works very well.
> This new instance runs on the same machine as the production one and uses the
> same MySQL database (different schemas of course).
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> DEBUG com.worldsteel.magnolia.models.WSTGroupByDocumentListModel 16.04.2010
> 11:06:11 -- QueryString: SELECT * FROM nt:base WHERE (jcr:primaryType =
> 'mgnl:contentNode' OR jcr:primaryType = 'mgnl:content') AND name <>
> 'description_files' AND (type='doc' or type='pdf') AND jcr:path LIKE
> '/wsDocumentList/Publications-Reports/Meeting-Reports/%' ORDER BY date desc ,
> title asc
> ERROR info.magnolia.cms.util.QueryUtil 16.04.2010 11:06:11 -- can't execute
> query [SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR
> jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND
> (type='doc' or type='pdf') AND jcr:path LIKE
> '/wsDocumentList/Publications-Reports/Meeting-Reports/%' ORDER BY date desc ,
> title asc], will return empty collection
> java.lang.IndexOutOfBoundsException: bitIndex < 0: -1
> at java.util.BitSet.get(BitSet.java:441)
> at
> org.apache.jackrabbit.core.query.lucene.DescendantSelfAxisQuery$DescendantSelfAxisScorer.isValid(DescendantSelfAxisQuery.java:557)
> at
> org.apache.jackrabbit.core.query.lucene.DescendantSelfAxisQuery$DescendantSelfAxisScorer.next(DescendantSelfAxisQuery.java:461)
> at org.apache.lucene.search.Scorer.score(Scorer.java:57)
> at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:136)
> at org.apache.lucene.search.Searcher.search(Searcher.java:126)
> at org.apache.lucene.search.Searcher.search(Searcher.java:105)
> at
> org.apache.jackrabbit.core.query.lucene.SortedLuceneQueryHits.getHits(SortedLuceneQueryHits.java:156)
> at
> org.apache.jackrabbit.core.query.lucene.SortedLuceneQueryHits.<init>(SortedLuceneQueryHits.java:117)
> at
> org.apache.jackrabbit.core.query.lucene.JackrabbitIndexSearcher.evaluate(JackrabbitIndexSearcher.java:108)
> at
> org.apache.jackrabbit.core.query.lucene.JackrabbitIndexSearcher.execute(JackrabbitIndexSearcher.java:84)
> at
> org.apache.jackrabbit.core.query.lucene.SearchIndex.executeQuery(SearchIndex.java:760)
> at
> org.apache.jackrabbit.core.query.lucene.SingleColumnQueryResult.executeQuery(SingleColumnQueryResult.java:66)
> at
> org.apache.jackrabbit.core.query.lucene.QueryResultImpl.getResults(QueryResultImpl.java:298)
> at
> org.apache.jackrabbit.core.query.lucene.SingleColumnQueryResult.<init>(SingleColumnQueryResult.java:58)
> at
> org.apache.jackrabbit.core.query.lucene.QueryImpl.execute(QueryImpl.java:131)
> at
> org.apache.jackrabbit.core.query.QueryImpl.execute(QueryImpl.java:177)
> at info.magnolia.cms.core.search.QueryImpl.execute(QueryImpl.java:73)
> at
> info.magnolia.cms.util.QueryUtil.exceptionThrowingQuery(QueryUtil.java:87)
> at info.magnolia.cms.util.QueryUtil.query(QueryUtil.java:101)
> at
> com.worldsteel.magnolia.models.WSTGroupByDocumentListModel.getDocuments(WSTGroupByDocumentListModel.java:217)
> at sun.reflect.GeneratedMethodAccessor1510.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:840)
> at
> freemarker.ext.beans.BeanModel.invokeThroughDescriptor(BeanModel.java:276)
> at freemarker.ext.beans.BeanModel.get(BeanModel.java:183)
> at freemarker.core.Dot._getAsTemplateModel(Dot.java:76)
> at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
> at freemarker.core.Assignment.accept(Assignment.java:90)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.MixedContent.accept(MixedContent.java:92)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.Environment.process(Environment.java:189)
> at freemarker.template.Template.process(Template.java:237)
> at
> info.magnolia.freemarker.FreemarkerHelper.render(FreemarkerHelper.java:132)
> at
> info.magnolia.module.templating.paragraphs.FreemarkerParagraphRenderer.onRender(FreemarkerParagraphRenderer.java:92)
> at
> info.magnolia.module.templating.AbstractRenderer.render(AbstractRenderer.java:83)
> at
> info.magnolia.module.templating.paragraphs.AbstractParagraphRenderer.render(AbstractParagraphRenderer.java:64)
> at
> info.magnolia.module.templating.ParagraphRenderingFacade.render(ParagraphRenderingFacade.java:111)
> at
> info.magnolia.module.templating.ParagraphRenderingFacade.render(ParagraphRenderingFacade.java:89)
> at info.magnolia.cms.taglibs.Include.doEndTag(Include.java:202)
> at
> freemarker.ext.jsp.TagTransformModel$TagWriter.endEvaluation(TagTransformModel.java:431)
> at
> freemarker.ext.jsp.TagTransformModel$TagWriter.afterBody(TagTransformModel.java:407)
> at freemarker.core.Environment.visit(Environment.java:300)
> at freemarker.core.UnifiedCall.accept(UnifiedCall.java:130)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.Environment.visit(Environment.java:298)
> at freemarker.core.UnifiedCall.accept(UnifiedCall.java:130)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.MixedContent.accept(MixedContent.java:92)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.Environment.include(Environment.java:1482)
> at freemarker.core.Include.accept(Include.java:169)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.MixedContent.accept(MixedContent.java:92)
> at freemarker.core.Environment.visit(Environment.java:209)
> at freemarker.core.Environment.process(Environment.java:189)
> at freemarker.template.Template.process(Template.java:237)
> at
> info.magnolia.freemarker.FreemarkerHelper.render(FreemarkerHelper.java:132)
> at
> info.magnolia.module.templating.renderers.FreemarkerTemplateRenderer.onRender(FreemarkerTemplateRenderer.java:74)
> at
> info.magnolia.module.templating.AbstractRenderer.render(AbstractRenderer.java:83)
> at
> info.magnolia.module.templatingkit.renderers.STKTemplateRenderer.render(STKTemplateRenderer.java:90)
> at
> info.magnolia.module.templating.renderers.AbstractTemplateRenderer.renderTemplate(AbstractTemplateRenderer.java:76)
> at
> info.magnolia.module.templating.RenderingFilter.doFilter(RenderingFilter.java:93)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.BackwardCompatibilityFilter.doFilter(BackwardCompatibilityFilter.java:72)
> at
> info.magnolia.cms.filters.OncePerRequestAbstractMgnlFilter.doFilter(OncePerRequestAbstractMgnlFilter.java:62)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.InterceptFilter.doFilter(InterceptFilter.java:121)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.AggregatorFilter.doFilter(AggregatorFilter.java:103)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.security.BaseSecurityFilter.doFilter(BaseSecurityFilter.java:61)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.RepositoryMappingFilter.doFilter(RepositoryMappingFilter.java:90)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.CompositeFilter.doFilter(CompositeFilter.java:64)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:76)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.CompositeFilter.doFilter(CompositeFilter.java:64)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.VirtualUriFilter.doFilter(VirtualUriFilter.java:115)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.i18n.I18nContentSupportFilter.doFilter(I18nContentSupportFilter.java:75)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.module.cache.filter.GZipFilter.doFilter(GZipFilter.java:83)
> at
> info.magnolia.cms.filters.OncePerRequestAbstractMgnlFilter.doFilter(OncePerRequestAbstractMgnlFilter.java:62)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:84)
> at
> info.magnolia.cms.filters.CosMultipartRequestFilter.doFilter(CosMultipartRequestFilter.java:87)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.security.BaseSecurityFilter.doFilter(BaseSecurityFilter.java:61)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.security.LogoutFilter.doFilter(LogoutFilter.java:89)
> at
> info.magnolia.cms.filters.OncePerRequestAbstractMgnlFilter.doFilter(OncePerRequestAbstractMgnlFilter.java:62)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.security.auth.login.LoginFilter.doFilter(LoginFilter.java:84)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.ContentTypeFilter.doFilter(ContentTypeFilter.java:84)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> com.worldsteel.magnolia.commands.SharepointImportFilter.doFilter(SharepointImportFilter.java:142)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> com.worldsteel.magnolia.synchro.SynchroAuthorizationFilter.doFilter(SynchroAuthorizationFilter.java:123)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.ContextFilter.doFilter(ContextFilter.java:87)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlFilterChain.doFilter(MgnlFilterChain.java:82)
> at
> info.magnolia.cms.filters.CompositeFilter.doFilter(CompositeFilter.java:64)
> at
> info.magnolia.cms.filters.AbstractMgnlFilter.doFilter(AbstractMgnlFilter.java:70)
> at
> info.magnolia.cms.filters.MgnlMainFilter.doFilter(MgnlMainFilter.java:96)
> at
> info.magnolia.cms.filters.MgnlMainFilter.doFilter(MgnlMainFilter.java:199)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 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.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.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:619)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
