Ralph, sorry i've been outside the while for a bit !
yes, the query returns the correct items from the dspace instance until you
get the 404. I've tried also with resultSetTTL=0... i think you can easily
replicate the same scenario, we dont have any customizations, just dspace
1.7 and SRW.
this is an example, i've received this message after a 404 message (note
that i correctly receive the number of items: 3):
A Project of OCLC Research <http://www.oclc.org/research>
[image: OCLC] <http://www.oclc.org/default.htm>
Links:<< Back to Search <http://10.0.102.11:8280/SRW/search/DSpace?>
DiagnosticsIdentifier:info:srw/diagnostic/1/1Meaning:General System Error
Details:Cannot get a connection, pool error Timeout waiting for idle object
Identifier:info:srw/diagnostic/1/1Meaning:General System ErrorDetails:Cannot
get a connection, pool error Timeout waiting for idle objectIdentifier:
info:srw/diagnostic/1/1Meaning:General System ErrorDetails:Cannot get a
connection, pool error Timeout waiting for idle objectIdentifier:
info:srw/diagnostic/1/1Meaning:General System ErrorDetails:Cannot get a
connection, pool error Timeout waiting for idle objectResults for Search:
dc.creator = "smith"
Records found: 3
Next
Record(s)>><http://10.0.102.11:8280/SRW/search/DSpace?operation=searchRetrieve&query=dc.creator%20=%20%22smith%22&maximumRecords=10&resultSetTTL=0&recordSchema=info:srw/schema/1/dc-v1.1&sortKeys=&recordPacking=xml&startRecord=1>
Record: 1 of 3
Schema: Dublin Core
Record: 2 of 3
Schema: Dublin Core
Record: 3 of 3
Schema: Dublin Core
Next
Record(s)>><http://10.0.102.11:8280/SRW/search/DSpace?operation=searchRetrieve&query=dc.creator%20=%20%22smith%22&maximumRecords=10&resultSetTTL=0&recordSchema=info:srw/schema/1/dc-v1.1&sortKeys=&recordPacking=xml&startRecord=1>
if i can be more helpful let me know,
Kociscky
On 22 March 2011 11:42, LeVan,Ralph <le...@oclc.org> wrote:
> Kocisky, does that search actually return records when it doesn't return
> the 404 response?
>
> The root problem is that the search opens a connection to the DSpace
> database and SRU caches that connection for the life of the search
> result. Typically, those result sets are cleared from the cache after a
> configurable period of idleness. That configuration happen through the
> specification of a default value in the database configuration file, but
> can be overridden in the request through the resultSetTTL parameter
> (which I note you still have set to 300 seconds in the request you have
> shared.)
>
> I have spotted a path in my code where the result set would not be freed
> if no records had be found as the result of the query.
>
> So, does that search for creator=smith actually find documents?
>
> Ralph
>
> > -----Original Message-----
> > From: Kocisky [mailto:koci...@autistici.org]
> > Sent: Monday, March 21, 2011 4:04 PM
> > To: dspace-tech@lists.sourceforge.net
> > Subject: [Dspace-tech] SRW Dspace 1.7 Cannot get a connection
> > pool(resultSetTTL)
> >
> > Hi all,
> >
> > I've been trying the SRW module
> > (http://code.google.com/p/oclcsrwdspacelucene/) with dspace 1.7 and
> > i've being facing a problem when I repetitively make the same query:
> >
> > http://10.0.102.1:8080/SRW/search/?query=dc.creator+%3D+%22smith%22&ve
> > rsion=1.1&operation=searchRetrieve&recordSchema=info%3Asrw%2Fschema
> > %2F1%2Fdc-
> > v1.1&maximumRecords=10&startRecord=1&resultSetTTL=300&recordPacking=
> > xml&recordXPath=&sortKeys=
> >
> > i will get:
> >
> > 404: Document not found (No searchRetrieveResponse)
> > OCLC SRW/SRU Server
> >
> > after 3 minutes or so it will restart working. With some extra
> > debugging (thanks to Ralph):
> >
> > ORG.oclc.os.SRW.HouseKeeping=DEBUG
> > ORG.oclc.os.SRW.DSpaceLucene.LuceneQueryResult=DEBUG
> >
> > log4j.logger.ORG.oclc.os.SRW.HouseKeeping=DEBUG
> > log4j.logger.ORG.oclc.os.SRW.DSpaceLucene.LuceneQueryResult=DEBUG
> >
> > i will get the following exception in dspace.cfg:
> >
> > 2011-03-10 16:15:33,978 DEBUG ORG.oclc.os.SRW.SRWServlet @ exit
> > processMethodRequest
> > 2011-03-10 16:15:33,978 DEBUG ORG.oclc.os.SRW.SRWServlet @ Exit:
> > doGet()
> > 2011-03-10 16:15:34,318 ERROR
> > ORG.oclc.os.SRW.DSpaceLucene.SRWLuceneDatabase @
> > java.lang.InstantiationException: Cannot get a connection, pool error
> > Timeout waiting for idle object
> > java.lang.InstantiationException: Cannot get a connection, pool error
> > Timeout waiting for idle object
> > at
> > ORG.oclc.os.SRW.DSpaceLucene.LuceneQueryResult.<init>(LuceneQueryRes
> > ult.java:113)
> > at
> > ORG.oclc.os.SRW.DSpaceLucene.SRWLuceneDatabase.getQueryResult(SRW
> > LuceneDatabase.java:209)
> > at ORG.oclc.os.SRW.SRWDatabase.doRequest(SRWDatabase.java:598)
> > at
> >
> gov.loc.www.zing.srw.srw_bindings.SRWSoapBindingImpl.searchRetrieveOpera
> > tion(SRWSoapBindingImpl.java:138)
> > at
> >
> gov.loc.www.zing.srw.srw_bindings.SRWSoapBindingSkeleton.searchRetrieveO
> > peration(SRWSoapBindingSkeleton.java:68)
> > at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
> I
> > mpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:597)
> > at
> >
> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java
> :3
> > 97)
> > at
> >
> org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja
> v
> > a:186)
> > at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323
> )
> >
> > i've been suggested to try with resultSetTTL=0 in the URL and the
> > configuration, but i didn't see any improvements, does anybody
> > faced/resolved the same issue?
> > thanks
> >
> > Kocisky
> >
> >
> ------------------------------------------------------------------------
> ------
> > Colocation vs. Managed Hosting
> > A question and answer guide to determining the best fit
> > for your organization - today and in the future.
> > http://p.sf.net/sfu/internap-sfd2d
> > _______________________________________________
> > DSpace-tech mailing list
> > DSpace-tech@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
