manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: [VOTE] Release Apache ManifoldCF 1.5, RC7
Date Thu, 06 Feb 2014 14:25:47 GMT
Hi Erlend,

Your "SELECT * FROM repohistory WHERE owner='Web' AND
starttime>1391691978799 ORDER BY starttime DESC,id DESC LIMIT 21" query is
not returning any document ingest records either.  It looks like there has
been no indexing after the start time you specified.

So I conclude that simple history is working fine, but since it is only
returning indexing results within the last hour by default it is confusing
you.  I also think it is likely that documents are getting skipped because
you've crawled this set before with the same job and many of the documents
have not changed.

Karl



On Thu, Feb 6, 2014 at 9:19 AM, Erlend GarĂ¥sen <e.f.garasen@usit.uio.no>wrote:

> On 06.02.14 14:46, Karl Wright wrote:
>
>> You want to put this in properties.xml:
>>
>> <property name="org.apache.manifoldcf.db" value="DEBUG"/>
>>
>
> Thanks.
>
> This is a simplified query, the one which is generated by only selecting
> the document ingest activity. No results from pgAdmin:
> SELECT id AS id,activitytype AS activity,starttime AS
> starttime,(endtime-starttime) AS elapsedtime,resultcode AS
> resultcode,resultdesc AS resultdesc,datasize AS bytes,entityid AS
> identifier FROM repohistory WHERE owner='Web' AND activitytype IN('document
> ingest (Solr)') AND starttime>1391691978799 ORDER BY starttime DESC,id DESC
> LIMIT 21
>
> I changed the query to the follwing, but still no results:
> SELECT id AS id,activitytype AS activity,starttime AS
> starttime,(endtime-starttime) AS elapsedtime,resultcode AS
> resultcode,resultdesc AS resultdesc,datasize AS bytes,entityid AS
> identifier FROM repohistory WHERE owner='Web' AND activitytype like
> lower('%Solr%') AND starttime>1391691978799 ORDER BY starttime DESC,id DESC
> LIMIT 21
>
> Here you can see all the records without filtering:
> SELECT * FROM repohistory WHERE owner='Web' AND starttime>1391691978799
> ORDER BY starttime DESC,id DESC LIMIT 21:
>
> ===>
> 21451;1391696150567;1391696110456;1391696069204;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=U";"Web";"fetch";"200";""
> 23521;1391696171301;1391696152500;1391696037774;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=O";"Web";"fetch";"200";""
> 25106;1391696152607;1391696152549;1391696028769;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=E";"Web";"fetch";"200";""
> 19611;1391696022219;1391696011288;1391695908824;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=Y";"Web";"fetch";"200";""
> 22560;1391696079440;1391696032220;1391695860158;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=I";"Web";"fetch";"200";""
> 46622;1391696133425;1391696110491;1391695857156;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=L";"Web";"fetch";"200";""
> 12955;1391695998071;1391695946382;1391695835524;"http://www.ibsen.uio.no/
> sakprosainnledninger.xhtml";"Web";"fetch";"200";""
> 18520;1391696106010;1391696079479;1391695832522;"h
> ttp://www.ibsen.uio.no/omhis.xhtml";"Web";"fetch";"200";""
> 24575;1391696028767;1391696011261;1391695829521;"http://www.ibsen.uio.no/
> sakprosakronologi.xhtml";"Web";"fetch";"200";""
> 10984;1391696028766;1391696011263;1391695826519;"http://www.ibsen.uio.no/
> tidslinje.xhtml";"Web";"fetch";"200";""
> 19612;1391696246952;1391696191497;1391695823518;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=AE";"Web";"fetch";"200";""
> 36785;1391696087593;1391696079534;1391695817514;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=P";"Web";"fetch";"200";""
> 12863;1391695908818;1391695902124;1391695814513;"http://www.ibsen.uio.no/
> variasjangre.xhtml";"Web";"fetch";"200";""
> 17979;1391696157502;1391696152529;1391695808509;"http://www.ibsen.uio.no/
> medarbeideroversikt.xhtml";"Web";"fetch";"200";""
> 39381;1391696044353;1391696032298;1391695802506;"http://www.ibsen.uio.no/
> brevmottakere.xhtml?bokstav=K";"Web";"fetch";"200";""
> 11154;1391696238768;1391696191522;1391695799504;"http://www.ibsen.uio.no/
> kontakt.xhtml";"Web";"fetch";"200";""
> 31284;1391695857150;1391695852029;1391695793499;"h
> ttp://www.ibsen.uio.no/errata.xhtml";"Web";"fetch";"200";""
> 11230;1391696028766;1391696011262;1391695787497;"http://www.ibsen.uio.no/
> variainnledninger.xhtml";"Web";"fetch";"200";""
> 11227;1391696028765;1391696011264;1391695784495;"http://www.ibsen.uio.no/
> diktsamlinger.xhtml";"Web";"fetch";"200";""
> 12726;1391695929276;1391695902084;1391695781493;"http://www.ibsen.uio.no/
> diktinnledninger.xhtml";"Web";"fetch";"200";""
> 11424;1391695939675;1391695902057;1391695775488;"http://www.ibsen.uio.no/
> sakprosasjangre.xhtml";"Web";"fetch";"200";""
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message