Issue 12051

Identifiers in LIVE registry are corrupt

12051
Reporter: trobertson
Assignee: kbraak
Type: Bug
Summary: Identifiers in LIVE registry are corrupt
Priority: Critical
Resolution: Fixed
Status: Closed
Created: 2012-10-22 11:10:54.985
Updated: 2013-12-16 17:50:32.34
Resolved: 2012-12-05 14:05:49.756
        
Description: LIVE_REG> select source, count(*) from identifier group by 1;
+-------------+----------+
| source      | count(*) |
+-------------+----------+
| NULL        |      336 |
|             |       98 |
| GBIF_PORTAL |    12269 |
+-------------+----------+

This is seriously problematic.  Without knowing where an identifier originates, they cannot be used with confidence.

]]>
    
Attachment drop_source_from_identifier.patch


Author: trobertson@gbif.org
Created: 2012-10-22 11:17:53.039
Updated: 2012-10-22 11:17:53.039
        
Please note, there is an identifier_type column also
Is the source simply deprecated?
    


Author: mdoering@gbif.org
Comment: consider dropping source column from the identifier table
Created: 2012-11-05 15:45:02.162
Updated: 2012-11-05 15:45:02.162


Author: kbraak@gbif.org
Comment: I will wait until the Registry project builds in Jenkins before committing. The attached patch drops the source column adding a changeset to the liquibase master, updates the agents.xml, mapping, model, and test.
Created: 2012-11-15 18:00:06.866
Updated: 2012-11-15 18:00:06.866


Author: kbraak@gbif.org
Comment: I committed the patch in http://code.google.com/p/gbif-registry/source/detail?r=3344
Created: 2012-11-19 16:09:40.272
Updated: 2012-11-19 16:09:40.272


Author: kbraak@gbif.org
Created: 2012-11-21 11:33:45.645
Updated: 2012-11-21 11:33:45.645
        
I need to make sure that the dataset search is working, and that any other services pointing at registry_staging are ok.

Also outstanding, is to update the live registry and registry_dev dbs.. at least registry has live WS used by the Super HIT.
    


Author: kbraak@gbif.org
Created: 2012-12-05 14:05:49.792
Updated: 2012-12-05 14:05:49.792
        
The registry and registry_dev databases were updated.

The gbrds and gbrdsdev web apps were updated - thanks [~jcuadra@gbif.org]

The registry ws pointing to registry and registry_dev were updated.

Closing issue.