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 <[email protected]>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";"" > >
