Project

General

Profile

Task #8128

Correct invalid formatIDs in production

Added by Dave Vieglais over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
High
Assignee:
-
Category:
-
Target version:
Start date:
2017-07-11
Due date:
% Done:

100%

Milestone:
None
Product Version:
*
Story Points:
Sprint:

Description

Format IDs that contain a "+" were incorrectly represented in the format list as containing a space " " instead of the "+" character.

Need to locate these and update their format ID.

Affected FormatIDs are:

image/svg xml - > image/svg+xml
application/rdf xml -> application/rdf+xml
application/vnd.google-earth.kml xml -> application/vnd.google-earth.kml+xml


Related issues

Related to Infrastructure - Task #8121: Fix MIME type and formatId for KML files Closed 2017-06-30

History

#1 Updated by Dave Vieglais over 6 years ago

  • Related to Task #8121: Fix MIME type and formatId for KML files added

#2 Updated by Dave Vieglais over 6 years ago

Searching for invalid format IDs:

#3 Updated by Jing Tao over 6 years ago

\set AUTOCOMMIT off

update systemmetadata set object_format='application/vnd.google-earth.kml+xml' where guid='urn:uuid:6bc8602e-0245-4e56-b4ad-9e1b658135f6';
update systemmetadata set object_format='application/vnd.google-earth.kml+xml' where guid='urn:uuid:9ca11179-040e-49ca-9b5d-3ff42237df3e';
update systemmetadata set object_format='application/vnd.google-earth.kml+xml' where guid='urn:uuid:33038dfd-632e-4863-b66b-f5817fe2127c';
update systemmetadata set object_format='application/vnd.google-earth.kml+xml' where guid='urn:uuid:e46ec8ec-d453-46de-8b2a-0359eab32d27';
update systemmetadata set object_format='application/vnd.google-earth.kml+xml' where guid='urn:uuid:f4196f3f-dfb5-4b45-a446-1a75314a733a';

commit;

#4 Updated by Jing Tao over 6 years ago

After update the systemmetadata table on three cns, we need to evict them from hazelcast. Then read system metadata from a browser. The reading action will prompt the reindex SOLR.

#5 Updated by Jing Tao over 6 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

I checked the three db and found we did have the 5 objects which had the wrong format id.

After updated the db on three cns, I evicted them from the hazelcast memory.
Then those objects' systemmetadta were read from a browser.

Now, we can find this link hit zero.
https://cn.dataone.org/cn/v1/query/solr/?start=0&rows=10&fl=id%2Ctitle%2CformatId&q=formatId%3A%22application%2Fvnd.google%5C-earth.kml%20xml%22

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)