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
Affects Versions: 1.6.1, 1.6.0
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.
