This has recurred to day and it happens with a query of the form:
*select count(subquery) from <#ri> where $a $b $c*
Executing "subquery" on its own works (and returns 2 rows).
Also, the same count query works on our almost identical UAT server and has
been running repeatedly since December.
Is there a Mulgara list / support channel which might help on this?
The exact queries are:
*FAILS:* *select count(select $subject $title $type *
*from <#ri> *
*where $subject <http://quakestudies.canterbury.ac.nz#isPartOf>
<info:fedora/qsr-object:296> and $subject <
http://purl.org/dc/elements/1.1/type> $type *
*and $subject <http://purl.org/dc/elements/1.1/title> $title and $subject <
http://purl.org/dc/elements/1.1/type> 'part' *
*and (($subject <http://quakestudies.canterbury.ac.nz#needEffectiveRole>
$rolepid and ($rolepid <http://quakestudies.canterbury.ac.nz#hasMemberUser>
<info:fedora/anon> *
*or $rolepid <http://purl.org/dc/elements/1.1/title> 'Public')))) *
from <#ri> where $a $b $c
*WORKS:* *select $subject $title $type *
*from <#ri> *
*where $subject <http://quakestudies.canterbury.ac.nz#isPartOf>
<info:fedora/qsr-object:296> and $subject <
http://purl.org/dc/elements/1.1/type> $type *
*and $subject <http://purl.org/dc/elements/1.1/title> $title and $subject <
http://purl.org/dc/elements/1.1/type> 'part' *
*and (($subject <http://quakestudies.canterbury.ac.nz#needEffectiveRole>
$rolepid and ($rolepid <http://quakestudies.canterbury.ac.nz#hasMemberUser>
<info:fedora/anon> *
*or $rolepid <http://purl.org/dc/elements/1.1/title> 'Public')))*
Logs are as below. All suggestions appreciated. Also, I have a copy of the
resourceIndex folder before I restarted the server (which cleared the
problem).
--
Richard
On 13 December 2012 14:20, Rich d'Rich <rich.d.r...@gmail.com> wrote:
> Thanks. I've rebuilt the RI and put some better logging on, so might have
> more of an idea what's going on if this recurs. No sign of a similar issue
> in Mulgara's release notes.
>
>
> On 12 December 2012 05:27, Benjamin Armintor <armin...@gmail.com> wrote:
>
>> Rich-
>> If this is something Mulgara can be configured for, then you can
>> probably push that config through Fedora. It's also *possible* that this
>> is a bug in Mulgara: The release notes (http://mulgara.org/release.html)
>> might give some guidance there. I honestly can't remember the API
>> compatibility for Mulgara across the last few releases, but it's had 8 or 9
>> since the one FCRepo 3.5 is packaged with. You might want to test dropping
>> a more modern library into the webapp (if you can reproduce the problem).
>>
>> - Ben
>>
>>
>> On Mon, Dec 10, 2012 at 4:29 PM, Rich d'Rich <rich.d.r...@gmail.com>wrote:
>>
>>> We've got an unusual problem in production which has just started to
>>> happen.
>>>
>>> Occasionally, we'll get risearch requests failing with error 500 and the
>>> log below. After this has happened once, it happens every time we make the
>>> same query until we restart tomcat, which restores normal operation. Which
>>> suggests that the query we are sending is valid.
>>>
>>> I'm wondering if this is due to Mulgara caching the query state
>>> incorrectly so any further textually identical queries trigger the bug? Any
>>> suggestions - can I turn off query caching?
>>>
>>> Log:
>>> ERROR 2012-12-11 09:31:24.075 [http-8080-9] (RISearchServlet) Unexpected
>>> error servicing API-A request
>>> org.trippi.TrippiException: Transaction error
>>> at
>>> org.trippi.impl.mulgara.MulgaraTupleIterator.<init>(MulgaraTupleIterator.java:27)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> at
>>> org.trippi.impl.mulgara.MulgaraSession.query(MulgaraSession.java:157)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> at
>>> org.trippi.impl.base.ConcurrentTriplestoreReader.findTuples(Unknown Source)
>>> [trippi-core-1.5.4.jar:na]
>>> at
>>> org.fcrepo.server.resourceIndex.ResourceIndexImpl.findTuples(ResourceIndexImpl.java:280)
>>> [fcrepo-server-3.5.jar:na]
>>> at
>>> org.fcrepo.server.resourceIndex.ResourceIndexModule.findTuples(ResourceIndexModule.java:312)
>>> [fcrepo-server-3.5.jar:na]
>>> at org.trippi.server.TrippiServer.find(Unknown Source)
>>> [trippi-core-1.5.4.jar:na]
>>> at org.trippi.server.http.TrippiServlet.doFind(Unknown Source)
>>> [trippi-core-1.5.4.jar:na]
>>> at org.trippi.server.http.TrippiServlet.doGet(Unknown Source)
>>> [trippi-core-1.5.4.jar:na]
>>> at
>>> org.fcrepo.server.access.RISearchServlet.doGet(RISearchServlet.java:101)
>>> [fcrepo-server-3.5.jar:na]
>>> at org.trippi.server.http.TrippiServlet.doGet(Unknown Source)
>>> [trippi-core-1.5.4.jar:na]
>>> at org.trippi.server.http.TrippiServlet.doPost(Unknown Source)
>>> [trippi-core-1.5.4.jar:na]
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>>> [servlet-api.jar:na]
>>> [ tomcat stuff ]
>>>
>>> Caused by: org.mulgara.query.TuplesException: Transaction error
>>> at
>>> org.mulgara.resolver.MulgaraInternalTransaction.execute(MulgaraInternalTransaction.java:657)
>>> [mulgara-core-2.1.4.jar:na]
>>> at
>>> org.mulgara.resolver.TransactionalAnswer.getObject(TransactionalAnswer.java:86)
>>> [mulgara-core-2.1.4.jar:na]
>>> at org.trippi.impl.mulgara.RowGroup.initialize(RowGroup.java:45)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> at org.trippi.impl.mulgara.RowGroup.<init>(RowGroup.java:33)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> at
>>> org.trippi.impl.mulgara.CollapsedAnswer.initialize(CollapsedAnswer.java:74)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> at
>>> org.trippi.impl.mulgara.CollapsedAnswer.<init>(CollapsedAnswer.java:58)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> at
>>> org.trippi.impl.mulgara.MulgaraTupleIterator.<init>(MulgaraTupleIterator.java:24)
>>> [trippi-mulgara-1.5.4.jar:na]
>>> ... 35 common frames omitted
>>>
>>> Caused by: org.mulgara.query.MulgaraTransactionException: Transaction
>>> rollback triggered
>>> at
>>> org.mulgara.resolver.MulgaraInternalTransaction.implicitRollback(MulgaraInternalTransaction.java:516)
>>> [mulgara-core-2.1.4.jar:na]
>>> at
>>> org.mulgara.resolver.MulgaraInternalTransaction.execute(MulgaraInternalTransaction.java:652)
>>> [mulgara-core-2.1.4.jar:na]
>>> ... 41 common frames omitted
>>>
>>> Caused by: *org.mulgara.query.TuplesException: No such variable $k0 in
>>> tuples [] *(class org.mulgara.store.tuples.UnconstrainedTuples)
>>> at
>>> org.mulgara.store.tuples.AbstractTuples.getColumnIndex(AbstractTuples.java:363)
>>> [mulgara-core-2.1.4.jar:na]
>>> at
>>> org.mulgara.resolver.GlobalizedAnswer.getColumnIndex(GlobalizedAnswer.java:141)
>>> [mulgara-core-2.1.4.jar:na]
>>> at
>>> org.mulgara.resolver.SubqueryAnswer.getObject(SubqueryAnswer.java:199)
>>> [mulgara-core-2.1.4.jar:na]
>>> at
>>> org.mulgara.resolver.TransactionalAnswer$1.execute(TransactionalAnswer.java:88)
>>> [mulgara-core-2.1.4.jar:na]
>>> at
>>> org.mulgara.resolver.MulgaraInternalTransaction.execute(MulgaraInternalTransaction.java:649)
>>> [mulgara-core-2.1.4.jar:na]
>>> ... 41 common frames omitted
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
>>> Remotely access PCs and mobile devices and provide instant support
>>> Improve your efficiency, and focus on delivering more value-add services
>>> Discover what IT Professionals Know. Rescue delivers
>>> http://p.sf.net/sfu/logmein_12329d2d
>>> _______________________________________________
>>> Fedora-commons-users mailing list
>>> Fedora-commons-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
>> Remotely access PCs and mobile devices and provide instant support
>> Improve your efficiency, and focus on delivering more value-add services
>> Discover what IT Professionals Know. Rescue delivers
>> http://p.sf.net/sfu/logmein_12329d2d
>> _______________________________________________
>> Fedora-commons-users mailing list
>> Fedora-commons-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
>>
>>
>
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
_______________________________________________
Fedora-commons-users mailing list
Fedora-commons-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
