Return-Path: Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: (qmail 61379 invoked from network); 6 May 2010 15:06:13 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 6 May 2010 15:06:13 -0000 Received: (qmail 85496 invoked by uid 500); 6 May 2010 15:06:13 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 85461 invoked by uid 500); 6 May 2010 15:06:13 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 85454 invoked by uid 99); 6 May 2010 15:06:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 May 2010 15:06:13 +0000 X-ASF-Spam-Status: No, hits=-1397.1 required=10.0 tests=ALL_TRUSTED,AWL X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 May 2010 15:06:11 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o46F5okn014112 for ; Thu, 6 May 2010 15:05:51 GMT Message-ID: <14405289.11841273158350867.JavaMail.jira@thor> Date: Thu, 6 May 2010 11:05:50 -0400 (EDT) From: "Marcel Reutegger (JIRA)" To: dev@jackrabbit.apache.org Subject: [jira] Resolved: (JCR-2610) Quering returns java.lang.IndexOutOfBoundsException: bitIndex < 0: -1 In-Reply-To: <16642958.8701271675092206.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/JCR-2610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marcel Reutegger resolved JCR-2610. ----------------------------------- Fix Version/s: 2.0.0 Resolution: Duplicate This is probably caused by an inconsistency in the index. Please run a consistency check on the index. See also: http://jackrabbit.apache.org/frequently-asked-questions.html -> "How do I force a consistency check on the search index?" Issue JCR-2427 improved the handling and now the exception is not thrown anymore. Resolving this as a duplicate. > 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 > Fix For: 2.0.0 > > > Configs: > Storage for large binaries: DbDataStore > PersistenceManager: MySqlPersistenceManager with > 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.(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.(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.