Project

General

Profile

Actions

Bug #6035

closed

The system metadata table in a Metacat was messed up with the value of archived

Added by Jing Tao about 11 years ago. Updated about 11 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Start date:
07/10/2013
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:

Description

In the mn-demo-4.test.dataone.org, I queried the systemmetadata table and got:

metacat=> select count(*) from systemmetadata where obsoleted_by is not null and archived=false;
count
-------
4644
(1 row)

You see, there are 4644 documents which are not archived but have the obsoleted_by value. This is a contradiction.

Also, the xml_documents and xml_revisions table are messed up:

metacat=> select count(*) from xml_documents;
count
-------
4998
(1 row)

metacat=> select count(*) from xml_revisions;
count
-------
0

We need figure out why the metacat has this funny result.

Actions

Also available in: Atom PDF