https://redmine.dataone.org/https://redmine.dataone.org/favicon.ico2014-09-02T21:42:33ZDataONE TasksInfrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=210772014-09-02T21:42:33ZRobert Waltz
<ul><li><strong>Target version</strong> changed from <i>2014.12-Block.2.2</i> to <i>Release Backlog</i></li></ul> Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=215202014-09-24T18:09:50ZDave Vieglaisdave.vieglais@gmail.com
<ul><li><strong>Target version</strong> changed from <i>Release Backlog</i> to <i>Maintenance Backlog</i></li></ul> Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288182017-04-27T15:31:48ZDave Vieglaisdave.vieglais@gmail.com
<ul><li><strong>Tracker</strong> changed from <i>Task</i> to <i>Bug</i></li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>Urgent</i></li><li><strong>Assignee</strong> set to <i>Jing Tao</i></li><li><strong>Category</strong> set to <i>d1_cn_service</i></li></ul><p>This old issue is now a significant problem with the switch of type serializers as operations that touch these pids causes a system failure exception on the CN.</p>
<p>These identifiers must be deleted from the CN or otherwise altered to prevent failures.</p>
Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288192017-04-27T15:40:49ZChris Jonescjones@nceas.ucsb.edu
<ul></ul><p>For @doi:10.5063/AA/Virginia Perez.2.1@, we should just make the change since this is a KNB object. </p>
Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288212017-04-27T17:43:26ZDave Vieglaisdave.vieglais@gmail.com
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-5 priority-high3 closed" href="/issues/8085">Bug #8085</a>: listObjects fails at 338940</i> added</li></ul> Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288222017-04-27T17:43:57ZDave Vieglaisdave.vieglais@gmail.com
<ul></ul><p>Full list of bad identifiers in production:</p>
<p>metacat=> select guid, origin_member_node, date_uploaded, date_modified from systemmetadata where guid like '% %';<br>
guid | origin_member_node | date_uploaded | date_modified<br>
----------------------------------------------------+--------------------+---------------------+-------------------------<br>
judith kruger.4.1 | urn:node:SANPARKS | 2011-09-28 00:00:00 | 2012-06-15 02:39:52.308<br>
Lin Cheng-Jung.1.1 | urn:node:TFRI | 2007-01-05 00:00:00 | 2013-06-17 03:31:55.862<br>
Lin Cheng-Jung.1.2 | urn:node:TFRI | 2007-01-05 00:00:00 | 2013-06-17 03:31:55.466<br>
doi:10.6085/AA/ SHLX00_XXXITV2XLSR03_20111128.40.1 | urn:node:PISCO | 2012-02-16 00:00:00 | 2013-03-29 14:39:52.449<br>
judith kruger.5.1 | urn:node:SANPARKS | 2011-09-28 00:00:00 | 2012-06-15 02:39:55.134<br>
judith botha.1.1 | urn:node:SANPARKS | 2011-09-30 00:00:00 | 2012-06-15 02:40:49.835<br>
judith botha.2.1 | urn:node:SANPARKS | 2011-09-30 00:00:00 | 2012-06-15 02:39:53.41<br>
judith kruger.1.1 | urn:node:SANPARKS | 2011-09-28 00:00:00 | 2012-06-15 02:41:07.343<br>
resourceMap_Lin Cheng-Jung.1.2 | urn:node:TFRI | 2007-01-05 00:00:00 | 2013-06-17 19:40:01.512<br>
resourceMap_Lin Cheng-Jung.1.1 | urn:node:TFRI | 2007-01-05 00:00:00 | 2013-06-17 19:40:00.466<br>
resourceMap_Lin Cheng-Jung.1.3 | urn:node:TFRI | 2007-01-05 00:00:00 | 2013-06-17 19:40:00.486<br>
judith kruger.3.1 | urn:node:SANPARKS | 2011-09-28 00:00:00 | 2012-06-15 02:39:56.427<br>
judith kruger.2.1 | urn:node:SANPARKS | 2011-09-28 00:00:00 | 2012-06-15 02:42:04.45<br>
Lin Cheng-Jung.1.3 | urn:node:TFRI | 2007-01-05 00:00:00 | 2013-06-17 03:31:54.946<br>
doi:10.5063/AA/Virginia Perez.2.1 | urn:node:KNB | 2002-10-05 23:00:00 | 2015-01-06 02:23:28.37<br>
(15 rows)</p>
Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288262017-05-01T19:40:05ZDave Vieglaisdave.vieglais@gmail.com
<ul></ul><p>Decided to take the approach of trapping the error in a try block, and trying again with a query that excludes any pids with spaces in them.</p>
<p>This will mean the bad identifiers will never show in list objects.</p>
<p>Potential issue - how to ensure paging consistency after skipping a PID?</p>
Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288272017-05-01T19:41:48ZDave Vieglaisdave.vieglais@gmail.com
<ul><li><strong>Target version</strong> changed from <i>Maintenance Backlog</i> to <i>CCI-2.3.4</i></li></ul> Infrastructure - Bug #4674: Ask Judith, Mike and Virgina Perez.2.1 to obsolete those pids which contain the white spaces.https://redmine.dataone.org/issues/4674?journal_id=288422017-05-04T18:01:15ZJing Taotao@nceas.ucsb.edu
<ul><li><strong>Target version</strong> changed from <i>CCI-2.3.4</i> to <i>CCI-2.4.0</i></li></ul>