Project

General

Profile

Actions

Bug #4356

closed

knb website query result shows old version of a document

Added by Jing Tao about 15 years ago. Updated about 13 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Category:
metacat
Target version:
Start date:
08/31/2009
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
4356

Description

Oliver Soong wrote:

I dropped a note about this on IRC, and Matt suggested you two might
be the ones to hear about it. �If I search on KNB for Kruger, I can
turn up judithk.40.35, but if I adjust the URL to ask for
docid=judithk.40, I get judithk.40.40. �The package was just recently
replicated, so that may be part of the issue, but at the moment,
things seem to be out of sync. �I don't know if this is expected
(search index is slightly out of date?) or whether this represents a
more serious issue.

Oliver

Hi, Mike:

I think i found the problem. I queried the xml_queryresult table by "select * from xml_queryresult where docid like 'judithk.40';" and get something
like:

judithk.40 |
<docid>judithk.40.35</docid><docname>eml</docname><doctype>eml://ecoinformatics.org/eml-2.1.0</doctype><createdate>2004-07-20</createdate><updatedate>200
9-05-29</updatedate><param name="dataset/title">Kruger National Park ecological aerial survey data (1998-2007)</param><param
name="creator/individualName/surName">Kruger</param><param name="creator/organizationName">SANParks</param><param name="keyword">Ungulate
population</param><param name="keyword">Aerial survey</param><param name="keyword">Distance methodology</param><param name="keyword">SANParks, South
Africa</param><param name="keyword">Kruger National Park, South Africa</param><param name="keyword">Kruger National Park</param>

You see, the judithk.40.35 is stored in the xml_queryresult table. I think there was a mechanism to delete the cached item when a document was updated.
It seems this mechanism was broken.

It was possible to delete some records in xml_queryresult table. But I am not sure if metacat still works this way. If this is the case, we can delete
the records for judithk.40 then i think the search will work.

I will file a bug report for this issue.

Thanks,

Jing

Actions

Also available in: Atom PDF