Project

General

Profile

Bug #3055

Fix these PIDS on Metacat

Added by Robert Waltz about 8 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Ben Leinfelder
Category:
Support Operations
Start date:
2012-07-09
Due date:
% Done:

100%

Milestone:
CCI-1.0.2
Product Version:
*
Story Points:
Sprint:

Description

esa.100.2
esa.101.2
esa.103.1
judithk.1041.1
knb-lter-cdr.8001.123
knb-lter-cdr.8172.123
knb-lter-cdr.17026.123
knb-lter-cdr.18107.123
knb-lter-cdr.18108.123
knb-lter-cdr.25066.123
knb-lter-cdr.26026.123
knb-lter-cdr.32001.123
knb-lter-cdr.36001.123
knb-lter-cdr.36108.123
knb-lter-cdr.36172.123
knb-lter-cdr.42001.123
knb-lter-cdr.42172.123
knb-lter-cdr.45001.123
knb-lter-cdr.45172.123
knb-lter-cdr.48001.123
knb-lter-cdr.48026.123
knb-lter-cdr.48172.123
knb-lter-cdr.49001.123
knb-lter-cdr.49111.123
knb-lter-cdr.49172.123
knb-lter-cdr.56001.123
knb-lter-cdr.56026.123
knb-lter-cdr.56111.123
knb-lter-cdr.56172.123
knb-lter-cdr.59111.123
knb-lter-cdr.59172.123
knb-lter-cdr.63001.123
knb-lter-cdr.63172.123
knb-lter-cdr.64026.123
knb-lter-cdr.64066.123
knb-lter-cdr.64079.123
knb-lter-cdr.64108.123
knb-lter-cdr.64248.123
knb-lter-cdr.69141.123
knb-lter-cdr.70001.123
knb-lter-cdr.70026.123
knb-lter-cdr.70111.123
knb-lter-cdr.70172.123
knb-lter-cdr.70248.123
knb-lter-cdr.76001.123
knb-lter-cdr.76026.123
knb-lter-cdr.76172.123
knb-lter-cdr.82244.123
knb-lter-cdr.82245.123
knb-lter-cdr.82249.123
knb-lter-cdr.91026.123
knb-lter-cdr.96026.123
knb-lter-cdr.101065.123
knb-lter-cdr.104026.123
knb-lter-cdr.111084.123
knb-lter-cdr.146080.123
knb-lter-cdr.155080.123
knb-lter-cdr.156080.123
knb-lter-cdr.157001.123
knb-lter-cdr.157172.123
knb-lter-cdr.159199.123
knb-lter-cdr.160199.123
knb-lter-cdr.161199.123
knb-lter-cdr.165199.123
knb-lter-cdr.166219.123
knb-lter-cdr.167234.123
knb-lter-cdr.168238.123
knb-lter-cdr.169234.123
knb-lter-cdr.171238.123
knb-lter-cdr.172234.123
knb-lter-cdr.175238.123
knb-lter-cdr.176268.123
knb-lter-cdr.177001.123
knb-lter-cdr.178169.123
knb-lter-cdr.179169.123
knb2003.18.17
knb2003.189.1
nceas.988.1
nikkis.162.1
peggym.1099.45
peggym.1102.8
peggym.1108.22
peggym.1108.47
resourceMap_judithk.22.3
resourceMap_judithk.40.26
resourceMap_judithk.44.9
resourceMap_judithk.45.11
resourceMap_judithk.154.1
resourceMap_judithk.293.4
resourceMap_judithk.691.2
resourceMap_judithk.718.6
resourceMap_judithk.739.4
resourceMap_judithk.739.16
resourceMap_judithk.766.11
resourceMap_judithk.766.18
resourceMap_judithk.766.24
resourceMap_judithk.766.31
resourceMap_judithk.820.5
resourceMap_judithk.1030.6
resourceMap_judithk.1067.6
resourceMap_judithk.1068.8
resourceMap_judithk.1068.14
resourceMap_judithk.1082.2
resourceMap_nikkis.34.17
resourceMap_nikkis.43.13
resourceMap_nikkis.76.19
resourceMap_nikkis.142.5
resourceMap_peggym.1099.25

delete_production_CN.sql (2.01 KB) Ben Leinfelder, 2012-07-10 22:27

History

#1 Updated by Robert Waltz about 8 years ago

  • Assignee changed from Robert Waltz to Ben Leinfelder

#2 Updated by Ben Leinfelder about 8 years ago

I propose using this custom function to delete the objects we want to remove and re-replicate between CNs.
https://code.ecoinformatics.org/code/metacat/trunk/src/delete_all_by_pid.sql

I'm writing a bit of SQL to feed this script the list of PIDs...

#3 Updated by Ben Leinfelder about 8 years ago

  • File delete_production_CN.sql added

#4 Updated by Ben Leinfelder about 8 years ago

rather than deleting the entries, I just added the missing guid->local id mappings.

#5 Updated by Ben Leinfelder about 8 years ago

  • File deleted (delete_production_CN.sql)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 14.8 MB)