Thanks again. Here is what i did hoping to replicate the issue:
[b]Stopped the production server on which the issue is being seen. Took a dump
of magnolia db[/b]
[b]Restored the production magnolia db to Test instance magnolia db[/b]
[b]Ran the magnolia application.[/b]
[b]APPLICATION CAME UP FINE. EVEN the PAGE that's having the problem came up
fine.[/b]
I didn't stop at that. Did more:
[b]Logged in to magnolia account as authorized user on the production box where
we are seeing the issue[/b]
[b]Went to Tools-->JCR Queries and ran the following query under the Query
option[/b]
[code]SELECT * from nt:base WHERE jcr:path LIKE '/news/%/%/newsContent' ORDER
BY articledate DESC[/code]
Results:
[b]On one production box where this was NOT the problem, it executed in about
930ms. It fetched 109 nodes. I also saw that it took 2263ms on one attempt.
However, this server seems to work fine.[/b]
[b]On the Test box which is now using magnolia db of the production server
having the issue, the query executed in about 150ms. Again it fetched 109
nodes, confirming that data is not issue. I am also able to view this page on
test instance[/b]
[b]On the production box which is having the issue, trying to run the query
from Tools-->JCR Queries gave following log[/b]
[code]ERROR 2012-12-19 12:34:29,009 [http-8080-Processor113]
info.magnolia.cms.servlets.MVCServletHandlerImpl: can't call command: query
java.lang.ArrayIndexOutOfBoundsException: -1
at
org.apache.jackrabbit.core.query.lucene.CachingMultiIndexReader.getParentDocId(CachingMultiIndexReader.java:104)
at
org.apache.jackrabbit.core.query.lucene.CachingMultiIndexReader.getParents(CachingMultiIndexReader.java:89)
at
org.apache.jackrabbit.core.query.lucene.JackrabbitIndexReader.getParents(JackrabbitIndexReader.java:86)
at
org.apache.jackrabbit.core.query.lucene.DescendantSelfAxisQuery$DescendantSelfAxisScorer.getParents(DescendantSelfAxisQuery.java:604)
at
org.apache.jackrabbit.core.query.lucene.DescendantSelfAxisQuery$DescendantSelfAxisScorer.isValid(DescendantSelfAxisQuery.java:566)
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.jackrabbit.core.query.lucene.ChildAxisQuery$ChildAxisScorer.calculateChildren(ChildAxisQuery.java:453)
at
org.apache.jackrabbit.core.query.lucene.ChildAxisQuery$ChildAxisScorer.next(ChildAxisQuery.java:394)
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:89)
at
info.magnolia.cms.util.QueryUtil.exceptionThrowingQuery(QueryUtil.java:78)
at
info.magnolia.module.admininterface.pages.JCRUtilsPage.query(JCRUtilsPage.java:91)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[/code]
[b]Jan, i don't think it's an issue with sessions as we took the production box
with this issue out of rotation. So the remaining production servers are
handling this page. That means more traffic, more session. But still no issue
noticed on these boxes. Also the settings are identical for all production
boxes.[/b]
I want to know how else i can try to reproduce the issue on test instance. I am
now going to try and create lot of sessions hitting this page on TEST instance
and see if this will reproduce it.
But do tell me what else i need to try. What could be the issue here. What i am
missing.
--
Context is everything:
http://forum.magnolia-cms.com/forum/thread.html?threadId=ce0c2684-7e76-4084-a120-65bd493a2f32
----------------------------------------------------------------
For list details, see http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
